Application: gvSIG desktop » gvSIG projections

 * Connection to the EPSG database in HSQL database engine format using JDBC.

 * The EPSG database can be downloaded from <A

 * HREF="http://www.epsg.org">http://www.epsg.org</A>. The SQL scripts (modified

 * for the HSQL syntax as <A HREF="doc-files/HSQL.html">explained here</A>) are

 * bundled into this plugin. The database version is given in the

 * of the

 * {@linkplain org.opengis.referencing.AuthorityFactory#getAuthority authority}.

 * The SQL scripts are executed the first time a connection is required. The

 * database is then created as cached tables ({@code HSQL.properties} and

 * {@code HSQL.data} files) in a temporary directory. Future connections to the

 * EPSG database while reuse the cached tables, if available. Otherwise, the

 * scripts will be executed again in order to recreate them.

    // 20090518 cmartinez: Use a different tmp dir for each geotools instance

    private static File tmpDir = null;

    private static final Logger logger = LoggerFactory.getLogger(HSQLDataSource.class);

                if (path.length() == 0 || path.charAt(0) != '/') {

                if (url.charAt(url.length() - 1) != '/') {

    private File getGtTmpDir() {

        if (tmpDir == null) {

            tmpDir = new File(CrsFactory.getDataBaseFolder(), "temp-" + getProcessId());

            Runtime.getRuntime().addShutdownHook(new cleanOnShutdown(this));

        }

        return tmpDir;

        String fallback = "time" + System.currentTimeMillis();

            return "pid" + Long.toString(Long.parseLong(jvmName.substring(0, index)));

    public static class cleanOnShutdown extends Thread {

        private HSQLDataSource ds;

        public cleanOnShutdown(HSQLDataSource ds) {

            this.ds = ds;

        }

        public void run() {

            this.shutdown();

            this.delete();

        }

        private void delete() {

            File folder = HSQLDataSource.tmpDir;

            if (folder == null) {

                return;

            }

            try {

                logger.info("Deleting CRS temporary database folder (" + folder.getAbsolutePath() + ").");

                FileUtils.deleteDirectory(folder);

            } catch (IOException e) {

                logger.error("Can't delete CRS temporary database folder (" + folder + ".", e);

            }

        }

        private void shutdown() {

            try {

                logger.info("Shutdown the data-base.");

                Connection connection = this.ds.getConnection(false);

                final Statement statement = connection.createStatement();

                statement.execute("SHUTDOWN");

                statement.close();

                connection.close();

            } catch (Exception ex) {

                logger.error("Can't shutdown the database.", ex);

            }

        }

     * Returns the priority for this data source. This priority is set to a

     * lower value than the {@linkplain AccessDataSource}'s one in order to give

     * the priority to the Access-backed database, if presents. Priorities are

     * set that way because:

     * <li>The MS-Access format is the primary EPSG database format.</li>

     * <li>If a user downloads the MS-Access database himself, he probably wants

     * to use it.</li>

     * Returns {@code true} if the database contains data. This method returns

     * {@code false} if an empty EPSG database has been automatically created by

     * HSQL and not yet populated.

                null, null, "EPSG_%", new String[]{"TABLE"});

     * Opens a connection to the database. If the cached tables are not

     * available, they will be created now from the SQL scripts bundled in this

     * plugin.

        return getConnection(true);

    }

    public Connection getConnection(boolean initialize) throws SQLException {

        if (database == null || database.trim().length() == 0) {

        if (!initialize) {

            return connection;

        }

            logger.info("Creating temporary cached EPSG database in '" + getGtTmpDir().getAbsolutePath() + "'.");

                FileInputStream sqlInputStream = new FileInputStream(new File(CrsFactory.getDataBaseFolder(), "EPSG.sql"));

                        sqlInputStream, "ISO-8859-1"));

                while ((line = in.readLine()) != null) {

                            final boolean hasMore = (line.charAt(length - 1) == ',');

                                insertStatement.setLength(insertStatement.length() - 1);

                SQLException e = new SQLException("Can't read the SQL script.");

     * Open a connection and creates an

     * {@linkplain FactoryUsingSQL EPSG factory} for it.

     * @param factories The low-level factories to use for CRS creation.

            throws SQLFeatureNotSupportedException {

        // TODO Auto-generated method stub

        return null;

        // TODO Auto-generated method stub

        return false;

        // TODO Auto-generated method stub

        return null;