| gvSIG desktop 1

    public static boolean createEmptyTable(

    		DBLayerDefinition lyr_def,

    		IConnection the_conn,

    		Rectangle2D rect) {

            String srid_epsg = lyr_def.getSRID_EPSG();

            boolean with_srid = true;

            String _ora_srid = "NULL";

            try {

				_ora_srid = OracleSpatialDriver.epsgSridToOracleSrid(srid_epsg);

			} catch (Exception e1) {

				logger.error("Unknown EPSG code: " + srid_epsg);

				with_srid = false;

			}

            String _sql_rem_meta = OracleSpatialDriver.getRemoveMetadataSql(lyr_def);

            String _sql_drop = OracleSpatialDriver.getDropTableSql(lyr_def);

            String _sql_creation = OracleSpatialDriver.getTableCreationSql(lyr_def);

            String _sql_index = OracleSpatialDriver.getIndexCreationSql(lyr_def);

            String _sql_meta = OracleSpatialDriver.getMetadataUpdateSql(

            		lyr_def.getUser(),

            		lyr_def.getTableName(),

            		_ora_srid, rect, 2, with_srid);

            boolean removed = true;

            try {

                java.sql.PreparedStatement ps =

                	((ConnectionJDBC) the_conn).getConnection().prepareStatement(_sql_drop);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.info("Table did not exist: " + lyr_def.getTableName());

                removed = false;

            }

            if (removed) {

                logger.info("Table existed and was deleted: " + lyr_def.getTableName());

            }

            try {

                java.sql.PreparedStatement ps = ((ConnectionJDBC) the_conn).getConnection().prepareStatement(_sql_creation);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.error("Error while executing SQL for table creation: " +

                    ex.getMessage(), ex);

                return false;

            }

            try {

                java.sql.PreparedStatement ps = ((ConnectionJDBC)the_conn).getConnection().prepareStatement(_sql_rem_meta);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.error("Error while executing SQL for metadata removal: " +

                    ex.getMessage(), ex);

            }

            try {

                java.sql.PreparedStatement ps = ((ConnectionJDBC)the_conn).getConnection().prepareStatement(_sql_meta);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.error(

                    "Error while executing SQL for metadata insertion: " +

                    ex.getMessage(), ex);

                return false;

            }

            try {

                java.sql.PreparedStatement ps = ((ConnectionJDBC)the_conn).getConnection().prepareStatement(_sql_index);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.error("Error while executing SQL for index creation: " +

                    ex.getMessage(), ex);

                return false;

            }

            return true;

    }