| gvSIG desktop 1

/* gvSIG. Geographic Information System of the Valencian Government

 *

 * Copyright (C) 2007-2008 Infrastructures and Transports Department

 * of the Valencian Government (CIT)

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 */

/*

 * AUTHORS (In addition to CIT):

 * 2009 Prodevelop S.L. main development

 */

package org.gvsig.fmap.dal.store.oracle;

import java.sql.Connection;

import java.sql.SQLException;

import java.text.MessageFormat;

import javax.sql.DataSource;

import oracle.jdbc.pool.OracleDataSource;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.exception.InitializeException;

import org.gvsig.fmap.dal.resource.exception.AccessResourceException;

import org.gvsig.fmap.dal.store.jdbc.JDBCResource;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

public class OracleResource extends JDBCResource {

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

        public final static String NAME = "OracleResource";

        public static final String DESCRIPTION = "Oracle Connection";

        private Connection conn = null;

        /**

         * 

         * @param parameters

         * @throws InitializeException

         */

        public OracleResource(OracleResourceParameters parameters)

                        throws InitializeException {

                super(parameters);

        }

        /**

         * 

         */

        public String getName() throws AccessResourceException {

                OracleResourceParameters params = (OracleResourceParameters) this

                                .getParameters();

                return MessageFormat.format("OracleResource({0},{1})", new Object[] {

                                params.getUrl(), params.getUser() });

        }

        /**

 * 

 */

        protected DataSource createDataSource() {

                OracleDataSource ods = null;

                try {

                        ods = new OracleDataSource();

                } catch (SQLException e) {

                        logger.error("While creating OracleDataSource: " + e.getMessage());

                        return null;

                }

                OracleResourceParameters jdbcParams =

                        (OracleResourceParameters) getParameters();

                // ods.setDriverClassName(jdbcParams.getJDBCDriverClassName());

                ods.setPortNumber(jdbcParams.getPort().intValue());

                ods.setUser(jdbcParams.getUser());

                ods.setPassword(jdbcParams.getPassword());

                ods.setURL(jdbcParams.getUrl());

                ods.setDatabaseName(jdbcParams.getDBName());

                // ods.setLoginTimeout(30000); 

                ods.setLoginTimeout(20);

                return ods;

        }

        public static int CONN__COUNT = 0;

        protected synchronized Object getTheConnection() throws DataException {

                if (conn == null) {

                        conn = (Connection) super.getTheConnection();

                        CONN__COUNT++;

                        if (CONN__COUNT > 5) {

                                logger.info("ORACLE CONN_COUNT +- = " + CONN__COUNT);

                        }

                }

                return conn;

                /*

                try {

                        Object conn = this.dataSource.getConnection();

                        debugPoolStatus("getTheConnection");

                        return conn;

                } catch (SQLException e) {

                        throw new JDBCSQLException(e);

                }

                */

        }

        protected void connectToDB() throws DataException {

                if (dataSource == null) {

                        dataSource = createDataSource();

                }

                // FIXME Set Pool parameters:

                /*

                dataSource.setMaxActive(maxActive);

                dataSource.setMaxIdle(maxActive);

                dataSource.setMaxOpenPreparedStatements(maxActive);

                dataSource.setMaxWait(maxActive);

                dataSource.setInitialSize(initialSize);

                dataSource.setDefaultReadOnly(defaultReadOnly);

                dataSource.setDefaultTransactionIsolation(defaultTransactionIsolation);

                dataSource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);

                dataSource.setMinIdle(minIdle);

                dataSource.setTestOnBorrow(testOnBorrow);

                dataSource.setTestOnReturn(testOnReturn);

                dataSource.setTestWhileIdle(testOnReturn);

                dataSource

                                .setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);

                dataSource.setAccessToUnderlyingConnectionAllowed(allow);

                dataSource.setLoginTimeout(seconds);

                dataSource.setLogWriter(out);

                */

                // this.dataSource = dataSource;

        }

}