/*
|
* JtsWrapper.java
|
*
|
* Allows transparent usage of JTS Geometry classes via PostgreSQL JDBC driver
|
* connected to a PostGIS enabled PostgreSQL server.
|
*
|
* (C) 2005 Markus Schaber, markus.schaber@logix-tt.com
|
*
|
* This library is free software; you can redistribute it and/or modify it under
|
* the terms of the GNU Lesser General Public License as published by the Free
|
* Software Foundation, either version 2.1 of the License.
|
*
|
* This library 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 Lesser General Public License for more
|
* details.
|
*
|
* You should have received a copy of the GNU Lesser General Public License
|
* along with this library; if not, write to the Free Software Foundation, Inc.,
|
* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA or visit the web at
|
* http://www.gnu.org.
|
*
|
* $Id$
|
*/
|
|
package com.ximple.eofms.util.postjts;
|
|
import java.sql.Connection;
|
import java.sql.SQLException;
|
import java.util.Properties;
|
import java.util.logging.Level;
|
import java.util.logging.Logger;
|
|
import org.postgresql.Driver;
|
import org.postgresql.PGConnection;
|
|
/**
|
* DriverWrapper
|
* <p/>
|
* Wraps the PostGreSQL Driver to add the JTS/PostGIS Object Classes.
|
* <p/>
|
* This method currently works with J2EE DataSource implementations, and with
|
* DriverManager framework.
|
* <p/>
|
* Simply replace the "jdbc:postgresql:" with a "jdbc:postgres_jts:" in the jdbc
|
* URL.
|
* <p/>
|
* When using the drivermanager, you need to initialize JtsWrapper instead of
|
* (or in addition to) org.postgresql.Driver. When using a J2EE DataSource
|
* implementation, set the driver class property in the datasource config, the
|
* following works for jboss:
|
* <p/>
|
* <driver-class>org.postgis.jts.PostGisWrapper</driver-class>
|
*
|
* @author markus.schaber@logix-tt.com
|
*/
|
public class JtsWrapper extends Driver
|
{
|
|
protected static final Logger logger = Logger.getLogger("org.postgis.DriverWrapper");
|
|
private static final String POSTGRES_PROTOCOL = "jdbc:postgresql:";
|
private static final String POSTGIS_PROTOCOL = "jdbc:postgres_jts:";
|
public static final String REVISION = "$Revision: 2570 $";
|
|
public JtsWrapper()
|
{
|
super();
|
}
|
|
static
|
{
|
try
|
{
|
// Try to register ourself to the DriverManager
|
java.sql.DriverManager.registerDriver(new JtsWrapper());
|
} catch (SQLException e)
|
{
|
logger.log(Level.WARNING, "Error registering PostgreSQL Jts Wrapper Driver", e);
|
}
|
}
|
|
/**
|
* Creates a postgresql connection, and then adds the JTS GIS data types to
|
* it calling addpgtypes()
|
*
|
* @param url the URL of the database to connect to
|
* @param info a list of arbitrary tag/value pairs as connection arguments
|
* @return a connection to the URL or null if it isnt us
|
* @throws SQLException if a database access error occurs
|
* @see java.sql.Driver#connect
|
* @see org.postgresql.Driver
|
*/
|
public java.sql.Connection connect(String url, Properties info) throws SQLException
|
{
|
url = mangleURL(url);
|
Connection result = super.connect(url, info);
|
addGISTypes((PGConnection) result);
|
return result;
|
}
|
|
/**
|
* adds the JTS/PostGIS Data types to a PG Connection.
|
*
|
* @param pgconn postgres connection
|
* @throws SQLException error
|
*/
|
public static void addGISTypes(PGConnection pgconn) throws SQLException
|
{
|
pgconn.addDataType("geometry", JtsGeometry.class);
|
}
|
|
/**
|
* Mangles the PostGIS URL to return the original PostGreSQL URL
|
* @param url url
|
* @return string
|
* @throws java.sql.SQLException erroe
|
*/
|
public static String mangleURL(String url) throws SQLException
|
{
|
if (url.startsWith(POSTGIS_PROTOCOL))
|
{
|
return POSTGRES_PROTOCOL + url.substring(POSTGIS_PROTOCOL.length());
|
} else
|
{
|
throw new SQLException("Unknown protocol or subprotocol in url " + url);
|
}
|
}
|
|
/**
|
* Check whether the driver thinks he can handle the given URL.
|
*
|
* @param url the URL of the driver
|
* @return true if this driver accepts the given URL
|
* @throws SQLException Passed through from the underlying PostgreSQL
|
* driver, should not happen.
|
* @see java.sql.Driver#acceptsURL
|
*/
|
public boolean acceptsURL(String url) throws SQLException
|
{
|
try
|
{
|
url = mangleURL(url);
|
} catch (SQLException e)
|
{
|
return false;
|
}
|
return super.acceptsURL(url);
|
}
|
|
/**
|
* Gets the underlying drivers major version number
|
*
|
* @return the drivers major version number
|
*/
|
|
public int getMajorVersion()
|
{
|
return super.getMajorVersion();
|
}
|
|
/**
|
* Get the underlying drivers minor version number
|
*
|
* @return the drivers minor version number
|
*/
|
public int getMinorVersion()
|
{
|
return super.getMinorVersion();
|
}
|
|
/**
|
* Returns our own CVS version plus postgres Version
|
* @return version
|
*/
|
public static String getVersion()
|
{
|
return "JtsGisWrapper " + REVISION + ", wrapping " + Driver.getVersion();
|
}
|
}
|
