org.deegree_impl.io
Class PostgisDBAccess

java.lang.Object
  org.deegree_impl.io.DBAccess
      org.deegree_impl.io.PostgisDBAccess

public class PostgisDBAccess

extends DBAccess

Version:

$Revision: 1.9 $

Author:

Jeronimo Wanhoff, Andreas Poth

Field Summary

Fields inherited from class org.deegree_impl.io.DBAccess

con

Constructor Summary

PostgisDBAccess(java.sql.Connection con)
constructor

PostgisDBAccess(java.sql.Connection con, boolean autoCommit)
constructor

PostgisDBAccess(java.lang.String driver, java.lang.String logon, java.util.Properties properties)

PostgisDBAccess(java.lang.String driver, java.lang.String logon, java.util.Properties properties, boolean autoCommit)

PostgisDBAccess(java.lang.String driver, java.lang.String logon, java.lang.String user, java.lang.String password)

PostgisDBAccess(java.lang.String driver, java.lang.String logon, java.lang.String user, java.lang.String password, boolean autoCommit)

Method Summary

protected java.lang.String	mapTypes(int type)
java.lang.Object	performQuery(java.lang.String query, int startFeature, int maxFeatures) performs a query against a postgis database. the returned object is an instance of org.deegree.model.table.Table
private java.sql.PreparedStatement	reformatStatement(java.lang.String query)

Methods inherited from class org.deegree_impl.io.DBAccess

commit, escape, executeStatement, getColumnTypes, getColumnTypesAsInt, getConnection, getDataBaseVendor, kill, performInsert, performInsert, performQuery, performTableQuery, performTableQuery, performUpdate, rollback, setAutoCommit

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PostgisDBAccess

public PostgisDBAccess(java.sql.Connection con)

constructor

Parameters:

con - connection to a PostGIS database

PostgisDBAccess

public PostgisDBAccess(java.sql.Connection con,
                       boolean autoCommit)
                throws java.sql.SQLException

constructor

Parameters:

con - connection to a postgis database with spatial extension.

PostgisDBAccess

public PostgisDBAccess(java.lang.String driver,
                       java.lang.String logon,
                       java.lang.String user,
                       java.lang.String password)
                throws java.sql.SQLException,
                       java.lang.Exception

Parameters:

driver - jdbc driver

logon - address of the database (additional parameters)

user -

password -

Throws:

java.sql.SQLException

java.lang.Exception

PostgisDBAccess

public PostgisDBAccess(java.lang.String driver,
                       java.lang.String logon,
                       java.util.Properties properties)
                throws java.sql.SQLException,
                       java.lang.Exception

Parameters:

driver - jdbc driver

logon - address of the database (additional parameters)

properties - additional parameters

Throws:

java.sql.SQLException

java.lang.Exception

PostgisDBAccess

public PostgisDBAccess(java.lang.String driver,
                       java.lang.String logon,
                       java.lang.String user,
                       java.lang.String password,
                       boolean autoCommit)
                throws java.sql.SQLException,
                       java.lang.Exception

Parameters:

driver - jdbc driver

logon - address of the database (additional parameters)

user -

password -

autoCommit -

Throws:

java.sql.SQLException

java.lang.Exception

PostgisDBAccess

public PostgisDBAccess(java.lang.String driver,
                       java.lang.String logon,
                       java.util.Properties properties,
                       boolean autoCommit)
                throws java.sql.SQLException,
                       java.lang.Exception

Parameters:

driver - jdbc driver

logon - address of the database (additional parameters)

properties - additional parameters

autoCommit -

Throws:

java.sql.SQLException

java.lang.Exception

Method Detail

performQuery

public java.lang.Object performQuery(java.lang.String query,
                                     int startFeature,
                                     int maxFeatures)
                              throws java.sql.SQLException,
                                     TableException,
                                     GM_Exception

performs a query against a postgis database. the returned object is an instance of org.deegree.model.table.Table

Overrides:

performQuery in class DBAccess

Parameters:

query - sql query expression

startFeature - index of the first feature (row) to return

maxFeatures - maximum number of returned features (rows)

Returns:

Throws:

java.sql.SQLException

TableException

GM_Exception

mapTypes

protected java.lang.String mapTypes(int type)

Overrides:

mapTypes in class DBAccess

Parameters:

type -

Returns:

reformatStatement

private java.sql.PreparedStatement reformatStatement(java.lang.String query)
                                              throws java.sql.SQLException

Parameters:

query -

Returns:

Throws:

java.sql.SQLException