com.scooterframework.orm.sqldataexpress.vendor
Class OracleDBAdapter

java.lang.Object
  com.scooterframework.orm.sqldataexpress.vendor.DBAdapter
      com.scooterframework.orm.sqldataexpress.vendor.OracleDBAdapter

public class OracleDBAdapter
extends DBAdapter

OracleDBAdapter class applies to Oracle database.

Field Summary

Fields inherited from class com.scooterframework.orm.sqldataexpress.vendor.DBAdapter

IGNORE, USE_LOGIN_USER_ID_AS_SCHEMA

Constructor Summary

OracleDBAdapter()

Method Summary

java.lang.String[]	getCatalogAndSchema(java.lang.String connName) Returns both catalog and schema of a connection.
java.lang.String	getExpandedTableName(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) Oracle does not use catalog.
java.lang.Object	getObjectFromResultSetByType(java.sql.ResultSet rs, java.lang.String javaClassType, int sqlDataType, int index)
java.lang.Object	getObjectFromStatementByType(java.sql.CallableStatement cstmt, java.lang.String javaClassType, int sqlDataType, int index)
java.lang.String	getOneRowSelectSQL(java.lang.String catalog, java.lang.String schema, java.lang.String table) Returns a SQL SELECT query which retrieves only one record from a table.
protected java.lang.String	getOracleSchema(java.lang.String connName)
java.lang.String	preparePaginationSql(java.lang.String selectSql, java.util.Map<java.lang.String,java.lang.Object> inputs, java.util.Map<java.lang.String,java.lang.String> outputFilters) Returns a SQL query for pagination.
boolean	vendorSpecificSetObject(java.sql.PreparedStatement pstmt, java.lang.Object obj, Parameter p, java.util.Map<java.lang.String,java.lang.Object> inputs)

Methods inherited from class com.scooterframework.orm.sqldataexpress.vendor.DBAdapter

canChangeTableNameCase, dotCount, getBlobData, getClobData, getExpandedTableName, getExpandedTableName, getInputStream, getLoginPassword, getLoginUserId, getOneRowSelectSQL, getRetrieveAllSQL, getRetrieveAllSQL, getTotalCountSQL, getTotalCountSQL, getType, isEmpty, resolveCatalogAndSchemaAndTable, resolveCatalogAndSchemaAndTable, resolveCatalogAndSchemaAndTable, resolveCatalogAndSchemaAndTableFromTableName, useLoginAsSchema

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleDBAdapter

public OracleDBAdapter()

Method Detail

getCatalogAndSchema

public java.lang.String[] getCatalogAndSchema(java.lang.String connName)

Description copied from class: DBAdapter

Returns both catalog and schema of a connection.

Specified by:

getCatalogAndSchema in class DBAdapter

Parameters:

connName - database connection name

Returns:

a string array containing catalog and schema

getOracleSchema

protected java.lang.String getOracleSchema(java.lang.String connName)

getExpandedTableName

public java.lang.String getExpandedTableName(java.lang.String catalog,
                                             java.lang.String schema,
                                             java.lang.String tableName)

Oracle does not use catalog. Therefore it is ignored.

Overrides:

getExpandedTableName in class DBAdapter

Parameters:

catalog - catalog name

schema - schema name

tableName - table name

Returns:

an expanded table name

getOneRowSelectSQL

public java.lang.String getOneRowSelectSQL(java.lang.String catalog,
                                           java.lang.String schema,
                                           java.lang.String table)

Description copied from class: DBAdapter

Returns a SQL SELECT query which retrieves only one record from a table. This query is used for retrieving meta data of the underlining table.

Specified by:

getOneRowSelectSQL in class DBAdapter

Parameters:

catalog - catalog name

schema - schema name

table - table name

Returns:

a SELECT query string

preparePaginationSql

public java.lang.String preparePaginationSql(java.lang.String selectSql,
                                             java.util.Map<java.lang.String,java.lang.Object> inputs,
                                             java.util.Map<java.lang.String,java.lang.String> outputFilters)

Description copied from class: DBAdapter

Returns a SQL query for pagination. This method converts a generic SQL query statement to a SQL query for pagination.

Specified by:

preparePaginationSql in class DBAdapter

Parameters:

selectSql - the original SQL statement

inputs - inputs

outputFilters - outputFilters

Returns:

a SQL query for pagination

getObjectFromResultSetByType

public java.lang.Object getObjectFromResultSetByType(java.sql.ResultSet rs,
                                                     java.lang.String javaClassType,
                                                     int sqlDataType,
                                                     int index)
                                              throws java.sql.SQLException

Overrides:

getObjectFromResultSetByType in class DBAdapter

Throws:

java.sql.SQLException

getObjectFromStatementByType

public java.lang.Object getObjectFromStatementByType(java.sql.CallableStatement cstmt,
                                                     java.lang.String javaClassType,
                                                     int sqlDataType,
                                                     int index)
                                              throws java.sql.SQLException

Overrides:

getObjectFromStatementByType in class DBAdapter

Throws:

java.sql.SQLException

vendorSpecificSetObject

public boolean vendorSpecificSetObject(java.sql.PreparedStatement pstmt,
                                       java.lang.Object obj,
                                       Parameter p,
                                       java.util.Map<java.lang.String,java.lang.Object> inputs)
                                throws java.lang.Exception

Overrides:

vendorSpecificSetObject in class DBAdapter

Throws:

java.lang.Exception