com.sibvisions.rad.persist.jdbc
Class OracleDBAccess

java.lang.Object
  com.sibvisions.rad.persist.jdbc.DBAccess
      com.sibvisions.rad.persist.jdbc.OracleDBAccess

All Implemented Interfaces:

IDBAccess

public class OracleDBAccess
extends DBAccess

The OracleDBAccess is the implementation for Oracle databases.

See Also:

DBAccess

Field Summary

Fields inherited from class com.sibvisions.rad.persist.jdbc.DBAccess

logger, LONGNVARCHAR, NCHAR, NCLOB, NVARCHAR, SQLXML

Constructor Summary

OracleDBAccess()
Constructs a new OracleDBAccess Object.

Method Summary

String	getDatabaseSpecificLockStatement(String pWritebackTable, MetaData pMetaData, ICondition pPKFilter) Returns the database specific statement to lock the specified row in the database.
List<String[]>	getUKs(String pCatalog, String pSchema, String pTable) It's gets all columns for each Unique Key and return it.
Object[]	insertDatabaseSpecific(String pWritenbackTable, String pInsertStatement, MetaData pMetaData, Object[] pNewDataRow, String pDummyColumn) Returns the newly inserted row from an Database specific insert statement.
void	open() It opens the database and stores the Connection object.

Methods inherited from class com.sibvisions.rad.persist.jdbc.DBAccess

close, commit, delete, executeFunction, executeProcedure, executeUpdate, fetch, getAutomaticLinkColName, getColumnMetaData, getConnection, getDBAccess, getDBProperties, getDBProperty, getDriver, getFKs, getFromClause, getMaxTime, getPassword, getPK, getPreparedStatement, getQueryColumns, getSelectStatement, getUrl, getUsername, getWHEREClause, insert, insertAnsiSQL, isOpen, lockRow, quote, registerDBAccessClass, rollback, setColumnsToStore, setDBProperties, setDBProperty, setDriver, setFilterParameter, setMaxTime, setPassword, setQueryTimeOut, setUrl, setUsername, supportsGetGeneratedKeys, toString, update

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

OracleDBAccess

public OracleDBAccess()

Constructs a new OracleDBAccess Object.

Method Detail

getDatabaseSpecificLockStatement

public String getDatabaseSpecificLockStatement(String pWritebackTable,
                                               MetaData pMetaData,
                                               ICondition pPKFilter)
                                        throws DataSourceException

Returns the database specific statement to lock the specified row in the database.

Overrides:

getDatabaseSpecificLockStatement in class DBAccess

Parameters:

pWritebackTable - the table to use.

pMetaData - the MetaDataColumn array to use.

pPKFilter - the PK filter with the values to use.

Returns:

the database specific statement to lock the specified row in the database.

Throws:

DataSourceException - if some parts are missing for the statement

insertDatabaseSpecific

public Object[] insertDatabaseSpecific(String pWritenbackTable,
                                       String pInsertStatement,
                                       MetaData pMetaData,
                                       Object[] pNewDataRow,
                                       String pDummyColumn)
                                throws DataSourceException

Returns the newly inserted row from an Database specific insert statement.
Database specific derivations of DBAcces need to implement it database specific.

Overrides:

insertDatabaseSpecific in class DBAccess

Parameters:

pWritenbackTable - the table to use for the insert

pInsertStatement - the SQL Statement to use for the insert

pMetaData - the meta data to use.

pNewDataRow - the new row (Object[]) with the values to insert

pDummyColumn - null, if all writeable columns are null, but for a correct INSERT it have to be minimum one column to use in the syntax.

Returns:

the newly inserted row from an Oracle Database.

Throws:

DataSourceException - if an Exception occur during insert to the storage

open

public void open()
          throws DataSourceException

It opens the database and stores the Connection object.

Overrides:

open in class DBAccess

Throws:

DataSourceException - if the database couldn't opened

getUKs

public List<String[]> getUKs(String pCatalog,
                             String pSchema,
                             String pTable)
                      throws DataSourceException

It's gets all columns for each Unique Key and return it.

Overrides:

getUKs in class DBAccess

Parameters:

pCatalog - the catalog to use

pSchema - the schema to use

pTable - the table to use

Returns:

all columns for each Unique Key.

Throws:

DataSourceException - if an error occur during UK search process.