Package 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, org.gvsig.fmap.dal.resource.spi.ResourceConsumer, org.gvsig.fmap.dal.store.jdbc2.JDBCHelper, org.gvsig.tools.dispose.Disposable

public class PostgreSQLHelper
extends org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

Field Summary

Fields

Modifier and Type	Field	Description
static final String	POSTGRESQL_JDBC_DRIVER
static final 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	Description
PostgreSQLHelper(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters)
PostgreSQLHelper(PostgreSQLConnectionParameters connectionParameters, org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider connectionProvider)	Constructor for use only for testing purposes.

Method Summary

Modifier and Type	Method	Description
boolean	allowAutomaticValues()
boolean	canWriteGeometry(int geometryType, int geometrySubtype)
org.gvsig.fmap.dal.store.jdbc.JDBCNewStoreParameters	createNewStoreParameters()
org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters	createOpenStoreParameters()
org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters	createServerExplorerParameters()
org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase	createSQLBuilder()
protected void	doDispose()
void	fetchFeature(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature, ResultSet rs, org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor[] columns, String[] extraValueNames)
org.gvsig.fmap.dal.store.jdbc2.JDBCConnection	getConnection()
PostgreSQLConnectionParameters	getConnectionParameters()
String	getConnectionURL()
static String	getConnectionURL(String host, Integer port, String db, boolean useSSL)
static String	getConnectionURL(PostgreSQLConnectionParameters params)
org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType	getGeometrySupportType()
org.gvsig.fmap.dal.store.jdbc2.OperationsFactory	getOperations()
String	getProviderName()
String	getQuoteForIdentifiers()
String	getQuoteForStrings()
protected String	getResourceType()
boolean	hasSpatialFunctions()
boolean	supportOffsetInSelect()

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 Details

POSTGRESQL_JDBC_DRIVER

public static final 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 Details

PostgreSQLHelper

public PostgreSQLHelper(PostgreSQLConnectionParameters connectionParameters,
 org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider connectionProvider)

Constructor for use only for testing purposes.

Parameters:

connectionParameters -

connectionProvider -

PostgreSQLHelper

public PostgreSQLHelper(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters)

Method Details

getConnectionURL

public static String getConnectionURL(PostgreSQLConnectionParameters params)

getConnectionURL

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

doDispose

protected void doDispose()
                  throws org.gvsig.tools.exception.BaseException

Overrides:

doDispose in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

Throws:

org.gvsig.tools.exception.BaseException

getConnection

public org.gvsig.fmap.dal.store.jdbc2.JDBCConnection getConnection()
                                                            throws org.gvsig.fmap.dal.resource.exception.AccessResourceException

Specified by:

getConnection in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getConnection in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

Throws:

org.gvsig.fmap.dal.resource.exception.AccessResourceException

getConnectionParameters

public PostgreSQLConnectionParameters getConnectionParameters()

Specified by:

getConnectionParameters in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getConnectionParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getConnectionURL

public String getConnectionURL()

Specified by:

getConnectionURL in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getConnectionURL in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getResourceType

protected String getResourceType()

Overrides:

getResourceType in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getProviderName

public String getProviderName()

Specified by:

getProviderName in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getProviderName in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

createSQLBuilder

public org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase createSQLBuilder()

Specified by:

createSQLBuilder in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

createSQLBuilder in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getOperations

public org.gvsig.fmap.dal.store.jdbc2.OperationsFactory getOperations()

Specified by:

getOperations in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getOperations in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getGeometrySupportType

public org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType getGeometrySupportType()

Specified by:

getGeometrySupportType in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getGeometrySupportType in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

hasSpatialFunctions

public boolean hasSpatialFunctions()

Specified by:

hasSpatialFunctions in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

hasSpatialFunctions in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

canWriteGeometry

public boolean canWriteGeometry(int geometryType,
 int geometrySubtype)

Specified by:

canWriteGeometry in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

canWriteGeometry in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getQuoteForIdentifiers

public String getQuoteForIdentifiers()

Specified by:

getQuoteForIdentifiers in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getQuoteForIdentifiers in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

allowAutomaticValues

public boolean allowAutomaticValues()

Specified by:

allowAutomaticValues in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

allowAutomaticValues in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

supportOffsetInSelect

public boolean supportOffsetInSelect()

Specified by:

supportOffsetInSelect in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

supportOffsetInSelect in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getQuoteForStrings

public String getQuoteForStrings()

Specified by:

getQuoteForStrings in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getQuoteForStrings in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

createNewStoreParameters

public org.gvsig.fmap.dal.store.jdbc.JDBCNewStoreParameters createNewStoreParameters()

Specified by:

createNewStoreParameters in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

createNewStoreParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

createOpenStoreParameters

public org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters createOpenStoreParameters()

Specified by:

createOpenStoreParameters in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

createOpenStoreParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

createServerExplorerParameters

public org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters createServerExplorerParameters()

Specified by:

createServerExplorerParameters in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

createServerExplorerParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

fetchFeature

public void fetchFeature(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature,
 ResultSet rs,
 org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor[] columns,
 String[] extraValueNames)
                  throws org.gvsig.fmap.dal.exception.DataException

Specified by:

fetchFeature in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

fetchFeature in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

Throws:

org.gvsig.fmap.dal.exception.DataException