| 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):

* 2008 IVER T.I   {{Task}}

*/

/**

 *

 */

package org.gvsig.fmap.data.feature.db.jdbc;

import java.sql.Connection;

import java.sql.SQLException;

import org.gvsig.fmap.data.CloseException;

import org.gvsig.fmap.data.DataException;

import org.gvsig.fmap.data.InitializeException;

import org.gvsig.fmap.data.OpenException;

import org.gvsig.fmap.data.ReadException;

import org.gvsig.fmap.data.Resource;

import org.gvsig.fmap.data.ResourceChangedException;

/**

 * @author jmvivo

 *

 */

public abstract class JDBCResource extends Resource {

        protected Connection connection = null;

        private String user;

        private String url;

        private String password;

        /* (non-Javadoc)

         * @see org.gvsig.fmap.data.Resource#doDispose()

         */

        protected void doDispose() throws DataException {

                Connection con =this.connection;

                this.connection =null;

                if (con != null){

                        try {

                                con.close();

                        } catch (SQLException e) {

                                throw new DataException("Dispose Error",e);

                        }

                }

        }

        /* (non-Javadoc)

         * @see org.gvsig.fmap.data.Resource#doOpen()

         */

        protected boolean doOpen() throws OpenException {

                try {

                        this.connection = this.createConnection();

                } catch (ReadException e) {

                        throw new OpenException(this.getName(),e);

                }

                this.setOpened();

                return true;

        }

        public JDBCResource(JDBCStoreParameters params){

                this.loadParamsData(params);

        }

        public JDBCResource(JDBCExplorerParameter params){

                this.loadParamsData(params);

        }

        /* (non-Javadoc)

         * @see org.gvsig.fmap.data.Resource#doClose()

         */

        protected boolean doClose() throws CloseException {

                try {

                        connection.close();

                } catch (java.sql.SQLException e) {

                        throw new CloseException(this.getName(),e);

                }

                return super.doClose();

        }

        /* (non-Javadoc)

         * @see org.gvsig.fmap.data.Resource#getName()

         */

        public String getName() {

                // TODO Auto-generated method stub

                return null;

        }

        protected void loadParamsData(JDBCStoreParameters params){

                this.url = params.getUrl();

                this.user = params.getUser();

                this.password = params.getPassw();

        }

        protected void loadParamsData(JDBCExplorerParameter params){

                this.url = params.getUrl();

                this.user = params.getUser();

                this.password = params.getPassw();

        }

        protected abstract Connection createConnection() throws ReadException;

        /* (non-Javadoc)

         * @see org.gvsig.fmap.data.Resource#description()

         */

        public String description() {

                return this.getName()+" JDBC Connection Resource: url='"+this.getUrl()+"' user='"+this.getUser()+"'";

        }

        /* (non-Javadoc)

         * @see org.gvsig.fmap.data.Resource#doChanged()

         */

        protected void doChanged() {

                // No Operation

        }

        /**

         * @return the password

         */

        public String getPassword() {

                return password;

        }

        /**

         * @param password the password to set

         * @throws InitializeException

         */

        public void setPassword(String password) throws InitializeException {

                if (inUse()){

                        throw new InitializeException("Resource in use",this.description());

                }

                this.password = password;

        }

        public boolean inUse() {

                return this.connection !=null;

        }

        /**

         * @return the url

         */

        public String getUrl() {

                return url;

        }

        /**

         * @param url the url to set

         * @throws InitializeException

         */

        public void setUrl(String url) throws InitializeException {

                if (inUse()){

                        throw new InitializeException("Resource in use",this.description());

                }

                this.url = url;

        }

        /**

         * @return the user

         */

        public String getUser() {

                return user;

        }

        /**

         * @param user the user to set

         * @throws InitializeException

         */

        public void setUser(String user) throws InitializeException {

                if (this.getRefencesCount() > 0){

                        throw new InitializeException("Resource in use",this.description());

                }

                this.user = user;

        }

        protected Connection getConnection() throws ReadException{

                this.checkOpen();

                return this.connection;

        }

        protected Connection getWriterConnection() throws ReadException{

                return this.createConnection();

        }

        /* (non-Javadoc)

         * @see org.gvsig.fmap.data.Resource#checkChanged()

         */

        protected void checkChanged() throws ResourceChangedException {

                // NO Operation

        }

        public boolean testConnection(){

                try{

                        this.open();

                } catch (OpenException e) {

                        return false;

                }

                return true;

        }

}