gvSIG data provider for Oracle

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package org.gvsig.oracle.dal;

import java.io.IOException;

import java.io.InputStream;

import java.sql.Connection;

import java.util.Objects;

import java.util.Properties;

import org.gvsig.fmap.dal.store.jdbc2.JDBCHelper;

import org.gvsig.fmap.dal.store.jdbc2.spi.SRSSolverBase;

/**

 *

 * @author fdiaz

 */

public class OracleSRSSolver extends SRSSolverBase{

    private static Properties translations;

    public OracleSRSSolver(JDBCHelper helper) {

        super(helper);

    }

    @Override

    protected Object searchDatabaseCode(Connection connection, String applicationAbbrev) {

        try {

            String[] s = applicationAbbrev.split(":");

            String code_s = s[1].trim();

            try {

                int code_i = Integer.parseInt(code_s);

                return code_i;

            } catch(NumberFormatException e) {

            }

            return 0;

        } catch (Throwable ex) {

            throw new RuntimeException("Problems searching database code from '"+applicationAbbrev+"'.",ex);

        }

    }

    @Override

    protected String searchApplicationAbbrev(Connection connection, Integer databaseCode) {

        try {

            String s = Objects.toString(databaseCode,"0");

            String trans = getTranslations().getProperty(s, null);

            if(trans == null){

                return null;

            }

            return "EPSG:" + trans;

        } catch (Throwable ex) {

            throw new RuntimeException("Problems searching application abbrev from '"+databaseCode+"'.",ex);

        }

    }    

    private Properties getTranslations() {

        if (translations == null) {

            InputStream inStream = this.getClass().getClassLoader().getResourceAsStream("/srids/oracle2epsg.properties");

            if (inStream != null) {

                translations = new Properties();

                try {

                    translations.load(inStream);

                } catch (IOException ex) {

                    logger.warn("Can't load srid translations", ex);

                }

            }

        }

        return translations;

    }

}