public class OracleHelper
extends org.gvsig.fmap.dal.store.jdbc.JDBCHelper
| Constructor and Description |
|---|
OracleHelper(org.gvsig.fmap.dal.store.jdbc.JDBCHelperUser consumer,
OracleConnectionParameters params)
Constructor
|
| 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() |
close, closeResourceRequested, compoundLimitAndOffset, dalValueToJDBC, getAdditionalSqlToCreate, getConnection, getDefaltFieldValueString, getPksFrom, getPksFromInformationSchema, getProviderSRID, getProviderSRID, getResource, isOpen, isReservedWord, loadFeatureType, open, resourceChanged, setResource, stringJoin, stringJoin, supportsGeometrypublic OracleHelper(org.gvsig.fmap.dal.store.jdbc.JDBCHelperUser consumer,
OracleConnectionParameters params)
throws org.gvsig.fmap.dal.exception.InitializeException
consumer - params - org.gvsig.fmap.dal.exception.InitializeExceptionpublic boolean allowAutomaticValues()
allowAutomaticValues in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperprotected 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
createAttributeFromJDBC in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperjava.sql.SQLExceptionpublic java.lang.Object doConnectionAction(org.gvsig.fmap.dal.store.jdbc.ConnectionAction action)
throws java.lang.Exception
action is an instance of TransactionalAction the
action will be execute inside of a DB transaction.doConnectionAction in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperaction - java.lang.Exceptionprotected void doDispose()
throws org.gvsig.tools.exception.BaseException
doDispose in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperorg.gvsig.tools.exception.BaseExceptionpublic java.lang.String escapeFieldName(java.lang.String field)
escapeFieldName in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperprotected 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
getAttributeFromJDBC in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperorg.gvsig.fmap.dal.store.jdbc.exception.JDBCExceptionprotected java.lang.String getDefaultSchema(java.sql.Connection conn)
throws org.gvsig.fmap.dal.store.jdbc.exception.JDBCException
getDefaultSchema in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperconn - org.gvsig.fmap.dal.store.jdbc.exception.JDBCExceptionpublic static java.lang.Throwable getFirstCause(java.lang.Throwable ex)
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
getFullEnvelopeOfField in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperorg.gvsig.fmap.dal.exception.DataExceptionpublic org.gvsig.fmap.geom.Geometry getGeometry(byte[] buffer)
throws org.gvsig.tools.exception.BaseException
getGeometry in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperorg.gvsig.tools.exception.BaseExceptionprotected java.lang.String getIdentifierQuoteString()
getIdentifierQuoteString in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperpublic int getOraGeomDimensions(int geometrySubType)
geometrySubType - public java.lang.String getOraGeomType(int geometryType,
int geometrySubType)
geometryType - geometrySubType - public java.lang.String getOraTableSrid(OracleStoreParameters params, java.lang.String geo_field)
public java.lang.String getSqlColumnTypeDescription(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr)
getSqlColumnTypeDescription in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperattr - public java.lang.String getSqlFieldDescription(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr)
throws org.gvsig.fmap.dal.exception.DataException
getSqlFieldDescription in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperattr - org.gvsig.fmap.dal.exception.DataExceptionpublic java.lang.String getSqlFieldName(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attribute)
getSqlFieldName in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperpublic java.util.List<java.lang.String> getSqlGeometryFieldAdd(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr,
java.lang.String table,
java.lang.String schema)
attr - table - schema - public java.lang.String getSqlUpdateMetadata(OracleStoreParameters params, java.lang.String ora_srid, java.awt.geom.Rectangle2D bbox, int dim, boolean withsrid)
tName - table nameora_srid - new SRSbbox - new bounding boxdim - geometries dimensionwithsrid - False if the SRS is set to NULL. True otherwise.public org.cresques.cts.IProjection getViewProjection()
protected void initializeResource()
throws org.gvsig.fmap.dal.exception.InitializeException
initializeResource in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperorg.gvsig.fmap.dal.exception.InitializeExceptionpublic void loadFeatureType(org.gvsig.fmap.dal.feature.EditableFeatureType featureType,
org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters storeParams)
throws org.gvsig.fmap.dal.exception.DataException
loadFeatureType in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperorg.gvsig.fmap.dal.exception.DataExceptionpublic 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
loadFeatureType in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperorg.gvsig.fmap.dal.exception.DataExceptionprotected 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
featureType geometry attributes with ShapeType
information stored in the table USER_SDO_GEOMETRY_METADATAloadSRS_and_shapeType in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperconn - rsMetadata - featureType - org.gvsig.fmap.dal.exception.ReadExceptionorg.gvsig.fmap.dal.store.jdbc.exception.JDBCExceptionpublic void setViewProjection(org.cresques.cts.IProjection p)
public boolean supportOffset()
supportOffset in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperpublic boolean supportsUnion()
supportsUnion in class org.gvsig.fmap.dal.store.jdbc.JDBCHelperCopyright © 2013 gvSIG Association. All Rights Reserved.