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:

java.lang.AutoCloseable, ResourceConsumer, JDBCHelper, Disposable

public class PostgreSQLHelper
extends JDBCHelperBase

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	POSTGRESQL_JDBC_DRIVER
static boolean	USE_CONNECTIONS_POOL

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

LOGGER, operationsFactory, providerFeatureType, srssolver, transactionsHelper

Constructor Summary

Constructors

Constructor and Description
PostgreSQLHelper(JDBCConnectionParameters connectionParameters)
PostgreSQLHelper(PostgreSQLConnectionParameters connectionParameters, ConnectionProvider connectionProvider) Constructor for use only for testing purposes.

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() Devuelve un SQLBuilder adaptado al proveedor.
protected void	doDispose() Internal implementation for the AbstractDisposable.dispose() method, to be implemented by child classes.
void	fetchFeature(FeatureProvider feature, java.sql.ResultSet rs, FeatureAttributeDescriptor[] columns, java.lang.String[] extraValueNames)
JDBCConnection	getConnection()
PostgreSQLConnectionParameters	getConnectionParameters()
java.lang.String	getConnectionURL()
static java.lang.String	getConnectionURL(PostgreSQLConnectionParameters params)
static java.lang.String	getConnectionURL(java.lang.String host, java.lang.Integer port, java.lang.String db, boolean useSSL)
GeometryExpressionBuilderHelper.GeometrySupportType	getGeometrySupportType() Indica como deben ser guardadas las geometrias en la BBDD.
OperationsFactory	getOperations()
java.lang.String	getProviderName() Return the name of the driver.
java.lang.String	getQuoteForIdentifiers() Devuelve las comillas que han de usaese para los identificadores.
java.lang.String	getQuoteForStrings() Devuelve las comillas que han de usaese en las constantes de cadena.
protected java.lang.String	getResourceType()
boolean	hasSpatialFunctions() Indica si la BBDD tiene soporte espacial.
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

addTableToColumnReferences, addTableToColumnReferencesInSingleSelect, allowNestedOperations, close, closeResourceRequested, createFeature, createOpenStoreParameters, createProvider, createServerExplorer, expandCalculedColumns, fetchFeature, getConnectionProvider, getConnectionProviderKey, getConnectionProviderStatus, getConnectionWritable, getGeometryFromColumn, getGeometryFromColumn, getGeometryManager, getProviderFeatureType, getResource, getResulSetControler, getSourceId, getSourceId, getSRSSolver, getTableAndFeatureType, getTransaction, initialize, initializeResource, isClosed, isThreadSafe, processSpecialFunctions, replaceExistsFunction, replaceForeingValueFunction, resourceChanged, setProviderFeatureType, setTransaction, supportCaller, supportExpression, supportFilter, supportOrder, toString, 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, wait, wait, wait

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

dispose

Field Detail

POSTGRESQL_JDBC_DRIVER

public static final java.lang.String POSTGRESQL_JDBC_DRIVER

See Also:

Constant Field Values

USE_CONNECTIONS_POOL

public static final boolean USE_CONNECTIONS_POOL

See Also:

Constant Field Values

Constructor Detail

PostgreSQLHelper

public PostgreSQLHelper(PostgreSQLConnectionParameters connectionParameters,
                        ConnectionProvider connectionProvider)

Constructor for use only for testing purposes.

Parameters:

connectionParameters -

connectionProvider -

PostgreSQLHelper

public PostgreSQLHelper(JDBCConnectionParameters connectionParameters)

Method Detail

getConnectionURL

public static java.lang.String getConnectionURL(PostgreSQLConnectionParameters params)

getConnectionURL

public static java.lang.String getConnectionURL(java.lang.String host,
                                                java.lang.Integer port,
                                                java.lang.String db,
                                                boolean useSSL)

doDispose

protected void doDispose()
                  throws BaseException

Description copied from class: AbstractDisposable

Internal implementation for the AbstractDisposable.dispose() method, to be implemented by child classes.

Overrides:

doDispose in class JDBCHelperBase

Throws:

BaseException

See Also:

AbstractDisposable.dispose()

getConnection

public JDBCConnection 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 java.lang.String getConnectionURL()

Specified by:

getConnectionURL in interface JDBCHelper

Overrides:

getConnectionURL in class JDBCHelperBase

getResourceType

protected java.lang.String getResourceType()

Overrides:

getResourceType in class JDBCHelperBase

getProviderName

public java.lang.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

Devuelve 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 GeometryExpressionBuilderHelper.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 java.lang.String getQuoteForIdentifiers()

Description copied from interface: JDBCHelper

Devuelve 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 java.lang.String getQuoteForStrings()

Description copied from interface: JDBCHelper

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

Specified by:

getQuoteForStrings in interface JDBCHelper

Overrides:

getQuoteForStrings in class JDBCHelperBase

Returns:

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

fetchFeature

public void fetchFeature(FeatureProvider feature,
                         java.sql.ResultSet rs,
                         FeatureAttributeDescriptor[] columns,
                         java.lang.String[] extraValueNames)
                  throws DataException

Specified by:

fetchFeature in interface JDBCHelper

Overrides:

fetchFeature in class JDBCHelperBase

Throws:

DataException