org.gvsig.fmap.dal.store.oracle

Class OracleStoreProvider

java.lang.Object

org.gvsig.tools.dispose.impl.AbstractDisposable

org.gvsig.fmap.dal.feature.spi.AbstractFeatureStoreProvider

org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

org.gvsig.fmap.dal.store.oracle.OracleStoreProvider

All Implemented Interfaces:

org.gvsig.fmap.dal.DataStoreProvider, org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider, org.gvsig.fmap.dal.resource.spi.ResourceConsumer, org.gvsig.fmap.dal.store.jdbc.JDBCHelperUser, org.gvsig.tools.dispose.Disposable, org.gvsig.tools.dynobject.DynObject

public class OracleStoreProvider
extends org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

Oracle Provider

Author:

vsanjaime

Nested Class Summary

Nested classes/interfaces inherited from class org.gvsig.fmap.dal.feature.spi.AbstractFeatureStoreProvider

org.gvsig.fmap.dal.feature.spi.AbstractFeatureStoreProvider.FeatureProviderNotFoundException

Nested classes/interfaces inherited from interface org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider

org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider.FeatureTypeChanged

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	DESCRIPTION
static org.slf4j.Logger	logger
static java.lang.String	METADATA_DEFINITION_NAME
static java.lang.String	NAME

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

appendModeAttributes, appendModeSql

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

directSQLMode, helper

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	OracleStoreProvider(org.gvsig.fmap.dal.DataStoreParameters params, org.gvsig.fmap.dal.spi.DataStoreProviderServices storeServices) Constructor when cannot create metada in constrution time.
protected	OracleStoreProvider(org.gvsig.fmap.dal.DataStoreParameters params, org.gvsig.fmap.dal.spi.DataStoreProviderServices storeServices, org.gvsig.tools.dynobject.DynObject metadata) Default Constructor.
	OracleStoreProvider(OracleStoreParameters params, org.gvsig.fmap.dal.spi.DataStoreProviderServices storeServices)

Method Summary

Methods

Modifier and Type	Method and Description
protected void	addToListFeatureValues(org.gvsig.fmap.dal.feature.spi.FeatureProvider featureProvider, org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attrOfList, org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr, java.util.List values)
boolean	allowAutomaticValues()
protected boolean	booleanAppendWhere(java.lang.StringBuilder sql, java.lang.String filter)
boolean	canWriteGeometry(int geometryType, int geometrySubtype)
protected void	closeResulset(java.sql.ResultSet rs)
java.lang.String	compoundSelect(org.gvsig.fmap.dal.feature.FeatureType type, java.lang.String filter, java.lang.String order, long limit, long offset)
protected org.gvsig.fmap.dal.store.jdbc.JDBCHelper	createHelper()
java.lang.Object	createNewOID()
protected java.sql.ResultSet	createNewResultSet(java.lang.String sql, java.lang.Object[] values, int fetchSize)
org.gvsig.fmap.dal.feature.spi.FeatureSetProvider	createSet(org.gvsig.fmap.dal.feature.FeatureQuery query, org.gvsig.fmap.dal.feature.FeatureType featureType)
protected void	executeRemovePreparedStatement(java.sql.Connection conn, java.lang.String sql, java.util.List<org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor> attributes, java.util.Iterator<org.gvsig.fmap.dal.feature.spi.FeatureReferenceProviderServices> featureReferences)
protected java.lang.String	fixFilter(java.lang.String filter)
protected org.gvsig.tools.dataTypes.DataTypesManager	getDataTypesManager()
org.gvsig.fmap.dal.DataServerExplorer	getExplorer()
java.lang.String	getName()
int	getOIDType()
protected OracleHelper	getOraHelper()
protected java.lang.String	getSqlStatementAddField(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr, java.util.List additionalStatement)
protected java.util.List<java.lang.String>	getSqlStatementAlterField(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attrOrg, org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attrTrg, java.util.List additionalStatement)
protected java.lang.String	getSqlStatementDropField(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr, java.util.List additionalStatement)
boolean	hasGeometrySupport()
protected org.gvsig.fmap.dal.feature.spi.FeatureProvider	internalGetFeatureProviderByReference(org.gvsig.fmap.dal.feature.spi.FeatureReferenceProviderServices reference, org.gvsig.fmap.dal.feature.FeatureType featureType)
void	loadFeatureProvider(org.gvsig.fmap.dal.feature.spi.FeatureProvider data, int resultsetID) Load data form a resulset.
protected void	loadFeatureProviderValue(org.gvsig.fmap.dal.feature.spi.FeatureProvider data, java.sql.ResultSet rs, org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr)
void	open()
protected void	performUpdates(java.sql.Connection conn, java.util.Iterator<org.gvsig.fmap.dal.feature.spi.FeatureProvider> updateds, java.util.List<org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor> pkAttributes)
protected void	prepareSQLAndAttributeListForInsert(java.lang.StringBuilder sqlb, java.util.List<org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor> attributes)

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

addToListFeatureValues, allowWrite, append, appendToSQLPreparedPkWhereClause, beginAppend, endAppend, executeUpdatePreparedStatement, getPerformChangesAction, performChanges, performDeletes, performInserts, performUpdateTable, prepareAttributeForInsert, prepareAttributeForUpdate, supportsAppendMode

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

appendWhere, checksResulsets, close, closeDone, closeResource, closeResourceRequested, closeResulset, compoundCountSelect, createResultSet, createResultSet, doDispose, forceCloseAllResultSet, forceCloseResultSet, getCount, getDynValue, getEnvelope, getFeatureCount, getFullName, getHelper, getIsNullExpression, getJDBCParameters, getProviderName, getResource, getResultSet, getSourceId, getTimeToResulSetZombie, initFeatureType, internalGetFeatureProviderByReference, isDirectSQLMode, opendDone, openResulsetCount, resetCount, resourceChanged, resulsetNext, setTimeToResulSetZombie

Methods inherited from class org.gvsig.fmap.dal.feature.spi.AbstractFeatureStoreProvider

clear, createFeatureLocks, createFeatureProvider, createFeatureSelection, createResource, delegate, getChilds, getDynClass, getFeatureProviderByReference, getFeatureProviderByReference, getFeatureStore, getInterval, getParameters, getRetrievedFeaturesLimit, getStoreServices, getTimes, getTimes, hasDynValue, hasRetrievedFeaturesLimit, implement, invokeDynMethod, invokeDynMethod, isKnownEnvelope, isLocksSupported, refresh, setDynValue, setMetadata

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

Methods inherited from interface org.gvsig.tools.dispose.Disposable

dispose

Field Detail

DESCRIPTION

public static java.lang.String DESCRIPTION

logger

public static final org.slf4j.Logger logger

METADATA_DEFINITION_NAME

public static final java.lang.String METADATA_DEFINITION_NAME

NAME

public static java.lang.String NAME

Constructor Detail

OracleStoreProvider

protected OracleStoreProvider(org.gvsig.fmap.dal.DataStoreParameters params,
                   org.gvsig.fmap.dal.spi.DataStoreProviderServices storeServices)
                       throws org.gvsig.fmap.dal.exception.InitializeException

Constructor when cannot create metada in constrution time.

Note: Don't use it if not is necesary. Set metada as soon as posible by AbstractFeatureStoreProvider.setMetadata(DynObject)

Parameters:

params -

storeServices -

Throws:

org.gvsig.fmap.dal.exception.InitializeException

OracleStoreProvider

protected OracleStoreProvider(org.gvsig.fmap.dal.DataStoreParameters params,
                   org.gvsig.fmap.dal.spi.DataStoreProviderServices storeServices,
                   org.gvsig.tools.dynobject.DynObject metadata)
                       throws org.gvsig.fmap.dal.exception.InitializeException

Default Constructor.

Parameters:

params -

storeServices -

metadata -

Throws:

org.gvsig.fmap.dal.exception.InitializeException

OracleStoreProvider

public OracleStoreProvider(OracleStoreParameters params,
                   org.gvsig.fmap.dal.spi.DataStoreProviderServices storeServices)
                    throws org.gvsig.fmap.dal.exception.InitializeException

Throws:

org.gvsig.fmap.dal.exception.InitializeException

Method Detail

addToListFeatureValues

protected void addToListFeatureValues(org.gvsig.fmap.dal.feature.spi.FeatureProvider featureProvider,
                          org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attrOfList,
                          org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr,
                          java.util.List values)
                               throws org.gvsig.fmap.dal.exception.DataException

Overrides:

addToListFeatureValues in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

Throws:

org.gvsig.fmap.dal.exception.DataException

allowAutomaticValues

public boolean allowAutomaticValues()

Specified by:

allowAutomaticValues in interface org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider

Overrides:

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

booleanAppendWhere

protected boolean booleanAppendWhere(java.lang.StringBuilder sql,
                         java.lang.String filter)

canWriteGeometry

public boolean canWriteGeometry(int geometryType,
                       int geometrySubtype)
                         throws org.gvsig.fmap.dal.exception.DataException

Specified by:

canWriteGeometry in interface org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider

Overrides:

canWriteGeometry in class org.gvsig.fmap.dal.feature.spi.AbstractFeatureStoreProvider

Throws:

org.gvsig.fmap.dal.exception.DataException

closeResulset

protected void closeResulset(java.sql.ResultSet rs)
                      throws org.gvsig.fmap.dal.store.jdbc.exception.JDBCException,
                             org.gvsig.fmap.dal.resource.exception.ResourceExecuteException

Overrides:

closeResulset in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Throws:

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

org.gvsig.fmap.dal.resource.exception.ResourceExecuteException

compoundSelect

public java.lang.String compoundSelect(org.gvsig.fmap.dal.feature.FeatureType type,
                              java.lang.String filter,
                              java.lang.String order,
                              long limit,
                              long offset)
                                throws org.gvsig.fmap.dal.exception.DataException

Overrides:

compoundSelect in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Throws:

org.gvsig.fmap.dal.exception.DataException

createHelper

protected org.gvsig.fmap.dal.store.jdbc.JDBCHelper createHelper()
                                                         throws org.gvsig.fmap.dal.exception.InitializeException

Overrides:

createHelper in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Throws:

org.gvsig.fmap.dal.exception.InitializeException

createNewOID

public java.lang.Object createNewOID()

Specified by:

createNewOID in interface org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider

Overrides:

createNewOID in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

createNewResultSet

protected java.sql.ResultSet createNewResultSet(java.lang.String sql,
                                    java.lang.Object[] values,
                                    int fetchSize)
                                         throws org.gvsig.fmap.dal.exception.DataException

Overrides:

createNewResultSet in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Throws:

org.gvsig.fmap.dal.exception.DataException

createSet

public org.gvsig.fmap.dal.feature.spi.FeatureSetProvider createSet(org.gvsig.fmap.dal.feature.FeatureQuery query,
                                                          org.gvsig.fmap.dal.feature.FeatureType featureType)
                                                            throws org.gvsig.fmap.dal.exception.DataException

Specified by:

createSet in interface org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider

Overrides:

createSet in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Throws:

org.gvsig.fmap.dal.exception.DataException

executeRemovePreparedStatement

protected void executeRemovePreparedStatement(java.sql.Connection conn,
                                  java.lang.String sql,
                                  java.util.List<org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor> attributes,
                                  java.util.Iterator<org.gvsig.fmap.dal.feature.spi.FeatureReferenceProviderServices> featureReferences)
                                       throws org.gvsig.fmap.dal.exception.DataException

Overrides:

executeRemovePreparedStatement in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

Throws:

org.gvsig.fmap.dal.exception.DataException

fixFilter

protected java.lang.String fixFilter(java.lang.String filter)

Overrides:

fixFilter in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

getDataTypesManager

protected org.gvsig.tools.dataTypes.DataTypesManager getDataTypesManager()

getExplorer

public org.gvsig.fmap.dal.DataServerExplorer getExplorer()
                                                  throws org.gvsig.fmap.dal.exception.ReadException

Overrides:

getExplorer in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Throws:

org.gvsig.fmap.dal.exception.ReadException

getName

public java.lang.String getName()

Overrides:

getName in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

getOIDType

public int getOIDType()

Specified by:

getOIDType in interface org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider

Overrides:

getOIDType in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

getOraHelper

protected OracleHelper getOraHelper()

getSqlStatementAddField

protected java.lang.String getSqlStatementAddField(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr,
                                       java.util.List additionalStatement)
                                            throws org.gvsig.fmap.dal.exception.DataException

Overrides:

getSqlStatementAddField in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

Throws:

org.gvsig.fmap.dal.exception.DataException

getSqlStatementAlterField

protected java.util.List<java.lang.String> getSqlStatementAlterField(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attrOrg,
                                                         org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attrTrg,
                                                         java.util.List additionalStatement)
                                                              throws org.gvsig.fmap.dal.exception.DataException

Overrides:

getSqlStatementAlterField in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

Throws:

org.gvsig.fmap.dal.exception.DataException

getSqlStatementDropField

protected java.lang.String getSqlStatementDropField(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr,
                                        java.util.List additionalStatement)

Overrides:

getSqlStatementDropField in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

hasGeometrySupport

public boolean hasGeometrySupport()

Overrides:

hasGeometrySupport in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

internalGetFeatureProviderByReference

protected org.gvsig.fmap.dal.feature.spi.FeatureProvider internalGetFeatureProviderByReference(org.gvsig.fmap.dal.feature.spi.FeatureReferenceProviderServices reference,
                                                                                   org.gvsig.fmap.dal.feature.FeatureType featureType)
                                                                                        throws org.gvsig.fmap.dal.exception.DataException

Overrides:

internalGetFeatureProviderByReference in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Throws:

org.gvsig.fmap.dal.exception.DataException

loadFeatureProvider

public void loadFeatureProvider(org.gvsig.fmap.dal.feature.spi.FeatureProvider data,
                       int resultsetID)
                         throws org.gvsig.fmap.dal.exception.DataException

Load data form a resulset.
Note:
this method have to perform resouceBegin at the begining and resourceEnd at the end of execution.

Overrides:

loadFeatureProvider in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Parameters:

data -

resulsetID -

Throws:

org.gvsig.fmap.dal.exception.DataException

loadFeatureProviderValue

protected void loadFeatureProviderValue(org.gvsig.fmap.dal.feature.spi.FeatureProvider data,
                            java.sql.ResultSet rs,
                            org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor attr)
                                 throws org.gvsig.fmap.dal.exception.DataException

Overrides:

loadFeatureProviderValue in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Throws:

org.gvsig.fmap.dal.exception.DataException

open

public void open()
          throws org.gvsig.fmap.dal.exception.OpenException

Overrides:

open in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

Throws:

org.gvsig.fmap.dal.exception.OpenException

performUpdates

protected void performUpdates(java.sql.Connection conn,
                  java.util.Iterator<org.gvsig.fmap.dal.feature.spi.FeatureProvider> updateds,
                  java.util.List<org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor> pkAttributes)
                       throws org.gvsig.fmap.dal.exception.DataException

Overrides:

performUpdates in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

Throws:

org.gvsig.fmap.dal.exception.DataException

prepareSQLAndAttributeListForInsert

protected void prepareSQLAndAttributeListForInsert(java.lang.StringBuilder sqlb,
                                       java.util.List<org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor> attributes)
                                            throws org.gvsig.fmap.dal.exception.DataException

Overrides:

prepareSQLAndAttributeListForInsert in class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

Throws:

org.gvsig.fmap.dal.exception.DataException