org.gvsig.fmap.dal.store.oracle

Class OracleHelper

java.lang.Object

org.gvsig.tools.dispose.impl.AbstractDisposable

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

org.gvsig.fmap.dal.store.oracle.OracleHelper

All Implemented Interfaces:

org.gvsig.fmap.dal.resource.spi.ResourceConsumer, org.gvsig.tools.dispose.Disposable

public class OracleHelper
extends org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Oracle helper

Author:

vsanjaime

Field Summary

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

defaultSchema, geomManager, isOpen, name, params, user

Constructor Summary

Constructors

Constructor and Description
OracleHelper(org.gvsig.fmap.dal.store.jdbc.JDBCHelperUser consumer, OracleConnectionParameters params) Constructor

Method Summary

Methods

Modifier and Type	Method and Description
boolean	allowAutomaticValues()
protected org.gvsig.fmap.dal.feature.EditableFeatureAttributeDescriptor	createAttributeFromJDBC(org.gvsig.fmap.dal.feature.EditableFeatureType fType, java.sql.Connection conn, java.sql.ResultSetMetaData rsMetadata, int colIndex)
java.lang.Object	doConnectionAction(org.gvsig.fmap.dal.store.jdbc.ConnectionAction action) Executes an atomic action that uses an DB Connection.
protected void	doDispose()
java.lang.String	escapeFieldName(java.lang.String field)
protected org.gvsig.fmap.dal.feature.EditableFeatureAttributeDescriptor	getAttributeFromJDBC(org.gvsig.fmap.dal.feature.EditableFeatureType fType, java.sql.Connection conn, java.sql.ResultSetMetaData rsMetadata, int colIndex)
protected java.lang.String	getDefaultSchema(java.sql.Connection conn) Get default schema name
static java.lang.Throwable	getFirstCause(java.lang.Throwable ex)
org.gvsig.fmap.geom.primitive.Envelope	getFullEnvelopeOfField(org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters storeParams, java.lang.String geometryAttrName, org.gvsig.fmap.geom.primitive.Envelope limit) get full envelope of geometry field
org.gvsig.fmap.geom.Geometry	getGeometry(byte[] buffer)
protected java.lang.String	getIdentifierQuoteString()
int	getOraGeomDimensions(int geometrySubType) Get oracle geometry dimension
java.lang.String	getOraGeomType(int geometryType, int geometrySubType) Get Oracle geometry type
java.lang.String	getOraTableSrid(OracleStoreParameters params, java.lang.String geo_field)
java.lang.String	getSqlColumnTypeDescription(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr) get geometry column name "SDO_GEOMETRY"
java.lang.String	getSqlFieldDescription(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr) get sql with fields description
java.lang.String	getSqlFieldName(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attribute)
java.util.List<java.lang.String>	getSqlGeometryFieldAdd(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr, java.lang.String table, java.lang.String schema) Add oracle geometry field and add spatial index
java.lang.String	getSqlUpdateMetadata(OracleStoreParameters params, java.lang.String ora_srid, java.awt.geom.Rectangle2D bbox, int dim, boolean withsrid) UTility method to get the SQL sentence needed to update the geographic metadata table with a new bounding box and SRS
org.cresques.cts.IProjection	getViewProjection()
protected void	initializeResource() Initialize resource
void	loadFeatureType(org.gvsig.fmap.dal.feature.EditableFeatureType featureType, org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters storeParams)
void	loadFeatureType(org.gvsig.fmap.dal.feature.EditableFeatureType featureType, org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters storeParams, java.lang.String sql, java.lang.String schema, java.lang.String table)
protected void	loadSRS_and_shapeType(java.sql.Connection conn, java.sql.ResultSetMetaData rs_Metadata, org.gvsig.fmap.dal.feature.EditableFeatureType featureType, java.lang.String baseSchema, java.lang.String baseTable) Fill featureType geometry attributes with ShapeType information stored in the table USER_SDO_GEOMETRY_METADATA
void	setViewProjection(org.cresques.cts.IProjection p)
boolean	supportOffset()
boolean	supportsUnion()

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

close, closeResourceRequested, compoundLimitAndOffset, dalValueToJDBC, getAdditionalSqlToCreate, getConnection, getDefaltFieldValueString, getPksFrom, getPksFromInformationSchema, getProviderSRID, getProviderSRID, getResource, isOpen, isReservedWord, loadFeatureType, open, resourceChanged, setResource, stringJoin, stringJoin, supportsGeometry

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

Constructor Detail

OracleHelper

public OracleHelper(org.gvsig.fmap.dal.store.jdbc.JDBCHelperUser consumer,
            OracleConnectionParameters params)
             throws org.gvsig.fmap.dal.exception.InitializeException

Constructor

Parameters:

consumer -

params -

Throws:

org.gvsig.fmap.dal.exception.InitializeException

Method Detail

allowAutomaticValues

public boolean allowAutomaticValues()

Overrides:

allowAutomaticValues in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

createAttributeFromJDBC

protected org.gvsig.fmap.dal.feature.EditableFeatureAttributeDescriptor createAttributeFromJDBC(org.gvsig.fmap.dal.feature.EditableFeatureType fType,
                                                                                    java.sql.Connection conn,
                                                                                    java.sql.ResultSetMetaData rsMetadata,
                                                                                    int colIndex)
                                                                                         throws java.sql.SQLException

Overrides:

createAttributeFromJDBC in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Throws:

java.sql.SQLException

doConnectionAction

public java.lang.Object doConnectionAction(org.gvsig.fmap.dal.store.jdbc.ConnectionAction action)
                                    throws java.lang.Exception

Executes an atomic action that uses an DB Connection.
This methos prepares a connection and close it at the end of execution of action.
if action is an instance of TransactionalAction the action will be execute inside of a DB transaction.

Overrides:

doConnectionAction in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Parameters:

action -

Throws:

java.lang.Exception

doDispose

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

Overrides:

doDispose in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Throws:

org.gvsig.tools.exception.BaseException

escapeFieldName

public java.lang.String escapeFieldName(java.lang.String field)

Overrides:

escapeFieldName in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

getAttributeFromJDBC

protected org.gvsig.fmap.dal.feature.EditableFeatureAttributeDescriptor getAttributeFromJDBC(org.gvsig.fmap.dal.feature.EditableFeatureType fType,
                                                                                 java.sql.Connection conn,
                                                                                 java.sql.ResultSetMetaData rsMetadata,
                                                                                 int colIndex)
                                                                                      throws org.gvsig.fmap.dal.store.jdbc.exception.JDBCException

Overrides:

getAttributeFromJDBC in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Throws:

org.gvsig.fmap.dal.store.jdbc.exception.JDBCException

getDefaultSchema

protected java.lang.String getDefaultSchema(java.sql.Connection conn)
                                     throws org.gvsig.fmap.dal.store.jdbc.exception.JDBCException

Get default schema name

Overrides:

getDefaultSchema in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Parameters:

conn -

Returns:

Throws:

org.gvsig.fmap.dal.store.jdbc.exception.JDBCException

getFirstCause

public static java.lang.Throwable getFirstCause(java.lang.Throwable ex)

getFullEnvelopeOfField

public org.gvsig.fmap.geom.primitive.Envelope getFullEnvelopeOfField(org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters storeParams,
                                                            java.lang.String geometryAttrName,
                                                            org.gvsig.fmap.geom.primitive.Envelope limit)
                                                              throws org.gvsig.fmap.dal.exception.DataException

get full envelope of geometry field

Overrides:

getFullEnvelopeOfField in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Throws:

org.gvsig.fmap.dal.exception.DataException

getGeometry

public org.gvsig.fmap.geom.Geometry getGeometry(byte[] buffer)
                                         throws org.gvsig.tools.exception.BaseException

Overrides:

getGeometry in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Throws:

org.gvsig.tools.exception.BaseException

getIdentifierQuoteString

protected java.lang.String getIdentifierQuoteString()

Overrides:

getIdentifierQuoteString in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

getOraGeomDimensions

public int getOraGeomDimensions(int geometrySubType)

Get oracle geometry dimension

Parameters:

geometrySubType -

Returns:

getOraGeomType

public java.lang.String getOraGeomType(int geometryType,
                              int geometrySubType)

Get Oracle geometry type

Parameters:

geometryType -

geometrySubType -

Returns:

getOraTableSrid

public java.lang.String getOraTableSrid(OracleStoreParameters params,
                               java.lang.String geo_field)

getSqlColumnTypeDescription

public java.lang.String getSqlColumnTypeDescription(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr)

get geometry column name "SDO_GEOMETRY"

Overrides:

getSqlColumnTypeDescription in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Parameters:

attr -

Returns:

getSqlFieldDescription

public java.lang.String getSqlFieldDescription(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr)
                                        throws org.gvsig.fmap.dal.exception.DataException

get sql with fields description

Overrides:

getSqlFieldDescription in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Parameters:

attr -

Returns:

Throws:

org.gvsig.fmap.dal.exception.DataException

getSqlFieldName

public java.lang.String getSqlFieldName(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attribute)

Overrides:

getSqlFieldName in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

getSqlGeometryFieldAdd

public java.util.List<java.lang.String> getSqlGeometryFieldAdd(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr,
                                                      java.lang.String table,
                                                      java.lang.String schema)

Add oracle geometry field and add spatial index

Parameters:

attr -

table -

schema -

Returns:

getSqlUpdateMetadata

public java.lang.String getSqlUpdateMetadata(OracleStoreParameters params,
                                    java.lang.String ora_srid,
                                    java.awt.geom.Rectangle2D bbox,
                                    int dim,
                                    boolean withsrid)

UTility method to get the SQL sentence needed to update the geographic metadata table with a new bounding box and SRS

Parameters:

tName - table name

ora_srid - new SRS

bbox - new bounding box

dim - geometries dimension

withsrid - False if the SRS is set to NULL. True otherwise.

Returns:

the SQL sentence to perform the update

getViewProjection

public org.cresques.cts.IProjection getViewProjection()

initializeResource

protected void initializeResource()
                           throws org.gvsig.fmap.dal.exception.InitializeException

Initialize resource

Overrides:

initializeResource in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Throws:

org.gvsig.fmap.dal.exception.InitializeException

loadFeatureType

public void loadFeatureType(org.gvsig.fmap.dal.feature.EditableFeatureType featureType,
                   org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters storeParams)
                     throws org.gvsig.fmap.dal.exception.DataException

Overrides:

loadFeatureType in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Throws:

org.gvsig.fmap.dal.exception.DataException

loadFeatureType

public void loadFeatureType(org.gvsig.fmap.dal.feature.EditableFeatureType featureType,
                   org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters storeParams,
                   java.lang.String sql,
                   java.lang.String schema,
                   java.lang.String table)
                     throws org.gvsig.fmap.dal.exception.DataException

Overrides:

loadFeatureType in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Throws:

org.gvsig.fmap.dal.exception.DataException

loadSRS_and_shapeType

protected void loadSRS_and_shapeType(java.sql.Connection conn,
                         java.sql.ResultSetMetaData rs_Metadata,
                         org.gvsig.fmap.dal.feature.EditableFeatureType featureType,
                         java.lang.String baseSchema,
                         java.lang.String baseTable)
                              throws org.gvsig.fmap.dal.store.jdbc.exception.JDBCException

Fill featureType geometry attributes with ShapeType information stored in the table USER_SDO_GEOMETRY_METADATA

Overrides:

loadSRS_and_shapeType in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

Parameters:

conn -

rsMetadata -

featureType -

Throws:

org.gvsig.fmap.dal.exception.ReadException

org.gvsig.fmap.dal.store.jdbc.exception.JDBCException

setViewProjection

public void setViewProjection(org.cresques.cts.IProjection p)

supportOffset

public boolean supportOffset()

Overrides:

supportOffset in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper

supportsUnion

public boolean supportsUnion()

Overrides:

supportsUnion in class org.gvsig.fmap.dal.store.jdbc.JDBCHelper