org.gvsig.postgresql.dal

Class PostgreSQLHelper

java.lang.Object

org.gvsig.tools.dispose.impl.AbstractDisposable

org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

org.gvsig.postgresql.dal.PostgreSQLHelper

All Implemented Interfaces:

AutoCloseable, ResourceConsumer, JDBCHelper, Disposable

public class PostgreSQLHelper
extends JDBCHelperBase

Field Summary

Fields

Modifier and Type	Field and Description
static String	POSTGRESQL_JDBC_DRIVER

Fields inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

operationsFactory, srss

Constructor Summary

Constructors

Constructor and Description
PostgreSQLHelper(JDBCConnectionParameters connectionParameters)

Method Summary

Modifier and Type	Method and Description
boolean	allowAutomaticValues() Indica si la BBDD soporta valores automaticos, tipo serial.
boolean	canWriteGeometry(int geometryType, int geometrySubtype) Indica si podemos escribir el tipo de geometria indicado.
JDBCNewStoreParameters	createNewStoreParameters()
JDBCStoreParameters	createOpenStoreParameters()
JDBCServerExplorerParameters	createServerExplorerParameters()
JDBCSQLBuilderBase	createSQLBuilder() Devuelbe un SQLBuilder adaptado al proveedor.
Connection	getConnection()
PostgreSQLConnectionParameters	getConnectionParameters()
String	getConnectionURL()
static String	getConnectionURL(PostgreSQLConnectionParameters params)
static String	getConnectionURL(String host, Integer port, String db)
ExpressionBuilder.GeometrySupportType	getGeometrySupportType() Indica como deben ser guardadas las geometrias en la BBDD.
OperationsFactory	getOperations()
String	getProviderName() Return the name of the driver.
String	getQuoteForIdentifiers() Devueble las comillas que han de usaese para los identificadores.
String	getQuoteForStrings() Devueble las comillas que han de usaese en las constantes de cadena.
protected String	getResourceType()
String	getSourceId(JDBCStoreParameters parameters)
boolean	hasSpatialFunctions() Indica si la BBDD tiene soporte espacial.
void	setPreparedStatementParameters(PreparedStatement st, JDBCSQLBuilderBase sqlbuilder, FeatureType type, FeatureProvider feature)
boolean	supportOffsetInSelect() Indica si la BBDD soporta el uso de OFFSET en la sentencia select.

Methods inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

close, closeConnection, closeResourceRequested, createFeature, createProvider, createServerExplorer, doDispose, fetchFeature, fetchFeature, getConnectionWritable, getDatabaseCodeFromProyection, getGeometryFromColumn, getGeometryFromColumn, getGeometryManager, getProjectionFromDatabaseCode, getProjectionFromSRSId, getResource, getResulSetControler, getSourceId, getSRSCode, initialize, initializeResource, resourceChanged, useSubquery

Methods inherited from class org.gvsig.tools.dispose.impl.AbstractDisposable

dispose, dispose

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

dispose

Field Detail

POSTGRESQL_JDBC_DRIVER

public static final String POSTGRESQL_JDBC_DRIVER

See Also:

Constant Field Values

Constructor Detail

PostgreSQLHelper

public PostgreSQLHelper(JDBCConnectionParameters connectionParameters)

Method Detail

getConnectionURL

public static String getConnectionURL(PostgreSQLConnectionParameters params)

getConnectionURL

public static String getConnectionURL(String host,
                                      Integer port,
                                      String db)

getConnection

public Connection getConnection()
                         throws AccessResourceException

Specified by:

getConnection in interface JDBCHelper

Overrides:

getConnection in class JDBCHelperBase

Throws:

AccessResourceException

getConnectionParameters

public PostgreSQLConnectionParameters getConnectionParameters()

Specified by:

getConnectionParameters in interface JDBCHelper

Overrides:

getConnectionParameters in class JDBCHelperBase

getConnectionURL

public String getConnectionURL()

Specified by:

getConnectionURL in interface JDBCHelper

Overrides:

getConnectionURL in class JDBCHelperBase

getResourceType

protected String getResourceType()

Overrides:

getResourceType in class JDBCHelperBase

getProviderName

public String getProviderName()

Description copied from interface: JDBCHelper

Return the name of the driver. By default rerturn "JDBC".

Specified by:

getProviderName in interface JDBCHelper

Overrides:

getProviderName in class JDBCHelperBase

Returns:

createSQLBuilder

public JDBCSQLBuilderBase createSQLBuilder()

Description copied from interface: JDBCHelper

Devuelbe un SQLBuilder adaptado al proveedor. Por ejemplo, uno especifico para PostgreSQL, MySQL, Oracle, MSSQLServer...

Specified by:

createSQLBuilder in interface JDBCHelper

Overrides:

createSQLBuilder in class JDBCHelperBase

Returns:

getOperations

public OperationsFactory getOperations()

Specified by:

getOperations in interface JDBCHelper

Overrides:

getOperations in class JDBCHelperBase

getGeometrySupportType

public ExpressionBuilder.GeometrySupportType getGeometrySupportType()

Description copied from interface: JDBCHelper

Indica como deben ser guardadas las geometrias en la BBDD. Pueden guardarse en WKT, WKB o EWKB.

Specified by:

getGeometrySupportType in interface JDBCHelper

Overrides:

getGeometrySupportType in class JDBCHelperBase

Returns:

hasSpatialFunctions

public boolean hasSpatialFunctions()

Description copied from interface: JDBCHelper

Indica si la BBDD tiene soporte espacial.

Specified by:

hasSpatialFunctions in interface JDBCHelper

Overrides:

hasSpatialFunctions in class JDBCHelperBase

Returns:

canWriteGeometry

public boolean canWriteGeometry(int geometryType,
                                int geometrySubtype)

Description copied from interface: JDBCHelper

Indica si podemos escribir el tipo de geometria indicado.

Specified by:

canWriteGeometry in interface JDBCHelper

Overrides:

canWriteGeometry in class JDBCHelperBase

Returns:

getQuoteForIdentifiers

public String getQuoteForIdentifiers()

Description copied from interface: JDBCHelper

Devueble las comillas que han de usaese para los identificadores.

Specified by:

getQuoteForIdentifiers in interface JDBCHelper

Overrides:

getQuoteForIdentifiers in class JDBCHelperBase

Returns:

allowAutomaticValues

public boolean allowAutomaticValues()

Description copied from interface: JDBCHelper

Indica si la BBDD soporta valores automaticos, tipo serial.

Specified by:

allowAutomaticValues in interface JDBCHelper

Overrides:

allowAutomaticValues in class JDBCHelperBase

Returns:

supportOffsetInSelect

public boolean supportOffsetInSelect()

Description copied from interface: JDBCHelper

Indica si la BBDD soporta el uso de OFFSET en la sentencia select.

Specified by:

supportOffsetInSelect in interface JDBCHelper

Overrides:

supportOffsetInSelect in class JDBCHelperBase

Returns:

getQuoteForStrings

public String getQuoteForStrings()

Description copied from interface: JDBCHelper

Devueble las comillas que han de usaese en las constantes de cadena.

Specified by:

getQuoteForStrings in interface JDBCHelper

Overrides:

getQuoteForStrings in class JDBCHelperBase

Returns:

getSourceId

public String getSourceId(JDBCStoreParameters parameters)

Specified by:

getSourceId in interface JDBCHelper

Overrides:

getSourceId in class JDBCHelperBase

createNewStoreParameters

public JDBCNewStoreParameters createNewStoreParameters()

Specified by:

createNewStoreParameters in interface JDBCHelper

Overrides:

createNewStoreParameters in class JDBCHelperBase

createOpenStoreParameters

public JDBCStoreParameters createOpenStoreParameters()

Specified by:

createOpenStoreParameters in interface JDBCHelper

Overrides:

createOpenStoreParameters in class JDBCHelperBase

createServerExplorerParameters

public JDBCServerExplorerParameters createServerExplorerParameters()

Specified by:

createServerExplorerParameters in interface JDBCHelper

Overrides:

createServerExplorerParameters in class JDBCHelperBase

setPreparedStatementParameters

public void setPreparedStatementParameters(PreparedStatement st,
                                           JDBCSQLBuilderBase sqlbuilder,
                                           FeatureType type,
                                           FeatureProvider feature)