Package org.gvsig.oracle.dal

Class OracleHelper

java.lang.Object

org.gvsig.tools.dispose.impl.AbstractDisposable

org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

org.gvsig.oracle.dal.OracleHelper

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 OracleHelper
extends org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	OracleHelper.OracleConnectionProvider

Field Summary

Fields

Modifier and Type	Field	Description
static final String	ORACLE_JDBC_DRIVER

Fields inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

LOGGER, operationsFactory, providerFeatureType, srssolver, transactionsHelper

Constructor Summary

Constructors

Constructor	Description
OracleHelper(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters)
OracleHelper(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters, org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider theConnectionProvider)	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.JDBCStoreParameters	createOpenStoreParameters(org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters parameters)
org.gvsig.fmap.dal.store.jdbc2.JDBCStoreProvider	createProvider(org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters parameters, org.gvsig.fmap.dal.spi.DataStoreProviderServices providerServices)
org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters	createServerExplorerParameters()
OracleSQLBuilder	createSQLBuilder()
org.gvsig.fmap.dal.store.jdbc2.JDBCConnection	getConnection()
OracleConnectionParameters	getConnectionParameters()
org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider	getConnectionProvider()
String	getConnectionProviderStatus()
String	getConnectionURL()
static String	getConnectionURL(String host, Integer port, String db, String mode)
static String	getConnectionURL(OracleConnectionParameters params)
org.gvsig.fmap.geom.Geometry	getGeometryFromColumn(ResultSet rs, int index)
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()
protected void	replaceExistsFunction(org.gvsig.fmap.dal.SQLBuilder sqlbuilder, org.gvsig.fmap.dal.feature.FeatureType type, List<String> extra_column_names)
boolean	supportOffsetInSelect()

Methods inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

addTableToColumnReferences, addTableToColumnReferencesInSingleSelect, allowNestedOperations, close, closeResourceRequested, createFeature, createServerExplorer, doDispose, expandCalculedColumns, fetchFeature, fetchFeature, getConnectionProviderKey, getConnectionWritable, getGeometryFromColumn, getGeometryManager, getProviderFeatureType, getResource, getResulSetControler, getSourceId, getSourceId, getSRSSolver, getTableAndFeatureType, getTransaction, initialize, initializeResource, isClosed, isThreadSafe, processSpecialFunctions, 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

ORACLE_JDBC_DRIVER

public static final String ORACLE_JDBC_DRIVER

See Also:

• Constant Field Values

Constructor Details

OracleHelper

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

OracleHelper

public OracleHelper(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters,
 org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider theConnectionProvider)

Constructor for use only for testing purposes.

Parameters:

connectionParameters -

theConnectionProvider -

Method Details

getConnectionURL

public static String getConnectionURL(OracleConnectionParameters params)

getConnectionURL

public static String getConnectionURL(String host,
 Integer port,
 String db,
 String mode)

getConnectionProvider

public org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider getConnectionProvider()

Overrides:

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

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 OracleConnectionParameters 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 OracleSQLBuilder 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

getGeometryFromColumn

public org.gvsig.fmap.geom.Geometry getGeometryFromColumn(ResultSet rs,
 int index)
                                                   throws org.gvsig.fmap.dal.exception.DataException

Specified by:

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

Overrides:

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

Throws:

org.gvsig.fmap.dal.exception.DataException

replaceExistsFunction

protected void replaceExistsFunction(org.gvsig.fmap.dal.SQLBuilder sqlbuilder,
 org.gvsig.fmap.dal.feature.FeatureType type,
 List<String> extra_column_names)

Overrides:

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

createOpenStoreParameters

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

Specified by:

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

Overrides:

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

createProvider

public org.gvsig.fmap.dal.store.jdbc2.JDBCStoreProvider createProvider(org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters parameters,
 org.gvsig.fmap.dal.spi.DataStoreProviderServices providerServices)
                                                                throws org.gvsig.fmap.dal.exception.InitializeException

Specified by:

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

Overrides:

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

Throws:

org.gvsig.fmap.dal.exception.InitializeException

getConnectionProviderStatus

public String getConnectionProviderStatus()

Specified by:

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

Overrides:

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