org.gvsig.fmap.dal.store.postgresql

Class PostgreSQLHelper

java.lang.Object

org.gvsig.tools.dispose.impl.AbstractDisposable

org.gvsig.fmap.dal.store.jdbc.JDBCHelper

org.gvsig.fmap.dal.store.postgresql.PostgreSQLHelper

All Implemented Interfaces:

ResourceConsumer, Disposable

public class PostgreSQLHelper
extends JDBCHelper

Nested Class Summary

Nested classes/interfaces inherited from class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

JDBCHelper.DalValueToJDBCException

Field Summary

Fields inherited from class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

defaultSchema, geomManager, isOpen, name, params, user

Method Summary

Methods

Modifier and Type	Method and Description
boolean	allowAutomaticValues()
protected EditableFeatureAttributeDescriptor	createAttributeFromJDBC(EditableFeatureType type, Connection conn, ResultSetMetaData rsMetadata, int colIndex)
protected EditableFeatureAttributeDescriptor	createAttributeFromJDBCNativeType(EditableFeatureType fType, ResultSetMetaData rsMetadata, int colIndex)
Object	dalValueToJDBC(FeatureAttributeDescriptor attributeDescriptor, Object value)
String	escapeFieldName(String field)
List	getAdditionalSqlToCreate(NewDataStoreParameters ndsp, FeatureType fType)
protected EditableFeatureAttributeDescriptor	getAttributeFromJDBC(EditableFeatureType fType, Connection conn, ResultSetMetaData rsMetadata, int colIndex)
protected Properties	getBeforePostgis13Properties()
protected String	getCreateIndexStatement(JDBCNewStoreParameters params, FeatureAttributeDescriptor attr)
protected String	getDefaultSchema(Connection conn)
Envelope	getFullEnvelopeOfField(JDBCStoreParameters storeParams, String geometryAttrName, Envelope limit) Override if provider has geometry support
String	getFunctionName(String newFuncName)
int	getPostgisGeomDimensions(int geometrySubType)
String	getPostgisGeomType(int geometryType, int geometrySubType)
int	getProviderSRID(IProjection srs)
int	getProviderSRID(String srs)
String	getSqlColumnTypeDescription(FeatureAttributeDescriptor attr)
String	getSqlFieldDescription(FeatureAttributeDescriptor attr)
String	getSqlFieldName(FeatureAttributeDescriptor attribute)
List<String>	getSqlGeometyFieldAdd(FeatureAttributeDescriptor attr, String table, String schema)
protected void	initializeResource()
protected void	loadSRS_and_shapeType(Connection conn, ResultSetMetaData rsMetadata, EditableFeatureType featureType, String baseSchema, String baseTable) Fill featureType geometry attributes with SRS and ShapeType information stored in the table GEOMETRY_COLUMNS
boolean	supportOffset()
protected boolean	supportsGeometry() Inform that provider has supports for geometry store and operations natively
boolean	supportsUnion()

Methods inherited from class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

close, closeConnection, closeResourceRequested, coerce, compoundLimitAndOffset, createGrantStatements, createGrantStatements, createGrantStatements, doConnectionAction, doDispose, execute, execute, execute, executeQuery, executeQuery, executeUpdate, getConnection, getDefaltFieldValueString, getDefaultFieldValueString, getGeometry, getIdentifierQuoteString, getPksFrom, getPksFromInformationSchema, getResource, isOpen, isReservedWord, loadFeatureType, loadFeatureType, loadFeatureType, open, resourceChanged, setResource, stringJoin, stringJoin

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

Method Detail

initializeResource

protected void initializeResource()
                           throws InitializeException

Overrides:

initializeResource in class JDBCHelper

Throws:

InitializeException

getDefaultSchema

protected String getDefaultSchema(Connection conn)
                           throws JDBCException

Overrides:

getDefaultSchema in class JDBCHelper

Throws:

JDBCException

getFullEnvelopeOfField

public Envelope getFullEnvelopeOfField(JDBCStoreParameters storeParams,
                              String geometryAttrName,
                              Envelope limit)
                                throws DataException

Description copied from class: JDBCHelper

Override if provider has geometry support

Overrides:

getFullEnvelopeOfField in class JDBCHelper

Returns:

Throws:

DataException

dalValueToJDBC

public Object dalValueToJDBC(FeatureAttributeDescriptor attributeDescriptor,
                    Object value)
                      throws WriteException

Overrides:

dalValueToJDBC in class JDBCHelper

Throws:

WriteException

supportsGeometry

protected boolean supportsGeometry()

Description copied from class: JDBCHelper

Inform that provider has supports for geometry store and operations natively

Overrides:

supportsGeometry in class JDBCHelper

Returns:

loadSRS_and_shapeType

protected void loadSRS_and_shapeType(Connection conn,
                         ResultSetMetaData rsMetadata,
                         EditableFeatureType featureType,
                         String baseSchema,
                         String baseTable)
                              throws JDBCException

Fill featureType geometry attributes with SRS and ShapeType information stored in the table GEOMETRY_COLUMNS

Overrides:

loadSRS_and_shapeType in class JDBCHelper

Parameters:

conn -

rsMetadata -

featureType -

Throws:

ReadException

JDBCException

getSqlColumnTypeDescription

public String getSqlColumnTypeDescription(FeatureAttributeDescriptor attr)

Overrides:

getSqlColumnTypeDescription in class JDBCHelper

getPostgisGeomDimensions

public int getPostgisGeomDimensions(int geometrySubType)

getPostgisGeomType

public String getPostgisGeomType(int geometryType,
                        int geometrySubType)

getProviderSRID

public int getProviderSRID(String srs)

Overrides:

getProviderSRID in class JDBCHelper

getProviderSRID

public int getProviderSRID(IProjection srs)

Overrides:

getProviderSRID in class JDBCHelper

getSqlGeometyFieldAdd

public List<String> getSqlGeometyFieldAdd(FeatureAttributeDescriptor attr,
                                 String table,
                                 String schema)

getSqlFieldName

public String getSqlFieldName(FeatureAttributeDescriptor attribute)

Overrides:

getSqlFieldName in class JDBCHelper

createAttributeFromJDBC

protected EditableFeatureAttributeDescriptor createAttributeFromJDBC(EditableFeatureType type,
                                                         Connection conn,
                                                         ResultSetMetaData rsMetadata,
                                                         int colIndex)
                                                              throws SQLException

Overrides:

createAttributeFromJDBC in class JDBCHelper

Throws:

SQLException

getAdditionalSqlToCreate

public List getAdditionalSqlToCreate(NewDataStoreParameters ndsp,
                            FeatureType fType)

Overrides:

getAdditionalSqlToCreate in class JDBCHelper

getCreateIndexStatement

protected String getCreateIndexStatement(JDBCNewStoreParameters params,
                             FeatureAttributeDescriptor attr)

getSqlFieldDescription

public String getSqlFieldDescription(FeatureAttributeDescriptor attr)
                              throws DataException

Overrides:

getSqlFieldDescription in class JDBCHelper

Throws:

DataException

allowAutomaticValues

public boolean allowAutomaticValues()

Overrides:

allowAutomaticValues in class JDBCHelper

supportOffset

public boolean supportOffset()

Overrides:

supportOffset in class JDBCHelper

supportsUnion

public boolean supportsUnion()

Overrides:

supportsUnion in class JDBCHelper

escapeFieldName

public String escapeFieldName(String field)

Overrides:

escapeFieldName in class JDBCHelper

createAttributeFromJDBCNativeType

protected EditableFeatureAttributeDescriptor createAttributeFromJDBCNativeType(EditableFeatureType fType,
                                                                   ResultSetMetaData rsMetadata,
                                                                   int colIndex)
                                                                        throws SQLException

Overrides:

createAttributeFromJDBCNativeType in class JDBCHelper

Throws:

SQLException

getFunctionName

public String getFunctionName(String newFuncName)

getBeforePostgis13Properties

protected Properties getBeforePostgis13Properties()

getAttributeFromJDBC

protected EditableFeatureAttributeDescriptor getAttributeFromJDBC(EditableFeatureType fType,
                                                      Connection conn,
                                                      ResultSetMetaData rsMetadata,
                                                      int colIndex)
                                                           throws JDBCException

Overrides:

getAttributeFromJDBC in class JDBCHelper

Throws:

JDBCException