com.triactive.jdo.store
Class OracleAdapter

java.lang.Object
  com.triactive.jdo.store.DatabaseAdapter
      com.triactive.jdo.store.OracleAdapter

class OracleAdapter

extends DatabaseAdapter

Provides methods for adapting SQL language elements to the Oracle database.

Author:

Mike Martin

See Also:

DatabaseAdapter

Field Summary

Fields inherited from class com.triactive.jdo.store.DatabaseAdapter

databaseMajorVersion, databaseMinorVersion, databaseProductName, databaseProductVersion, identifierQuoteString, keywords, maxColumnNameLength, maxConstraintNameLength, maxIndexNameLength, maxTableNameLength, storesLowerCaseIdentifiers, storesUpperCaseIdentifiers, typeMappings, typesByTypeNumber

Constructor Summary

OracleAdapter(java.sql.DatabaseMetaData metadata)
Constructs an Oracle adapter based on the given JDBC metadata.

Method Summary

protected void	createTypeInfo(java.sql.DatabaseMetaData metadata) Creates TypeInfo objects for all of the data types and indexes them in the typesByTypeNumber map by their JDBC data type number.
java.lang.String	getDropTableStatement(BaseTable table) Returns the appropriate SQL to drop the given table.
Mapping	getMapping(ClassBaseTable table, int relativeFieldNumber)
ColumnMapping	getMapping(Column col)
java.lang.String	getSchemaName(java.sql.Connection conn)
java.lang.String	getVendorID()
boolean	isEmbeddedType(java.lang.Class c)
NumericExpression	lengthMethod(CharacterExpression str) Returns the appropriate SQL expression for the JDOQL String.length() method.
QueryStatement	newQueryStatement(Table table)
QueryStatement	newQueryStatement(Table table, SQLIdentifier rangeVar)
TableExpression	newTableExpression(QueryStatement qs, Table table, SQLIdentifier rangeVar) Returns a new TableExpression object appropriate for this DBMS.
CharacterExpression	substringMethod(CharacterExpression str, NumericExpression begin) Returns the appropriate SQL expression for the JDOQL String.substring(str,begin) method.
CharacterExpression	substringMethod(CharacterExpression str, NumericExpression begin, NumericExpression end) Returns the appropriate SQL expression for the JDOQL String.substring(str,begin,end) method.
boolean	supportsBooleanComparison()

Methods inherited from class com.triactive.jdo.store.DatabaseAdapter

closeConnection, createIndexesBeforeForeignKeys, getAddCandidateKeyStatement, getAddForeignKeyStatement, getAddPrimaryKeyStatement, getConnection, getCreateIndexStatement, getCreateTableStatement, getDropViewStatement, getIdentifierQuoteString, getInstance, getMapping, getMappingClass, getMaxColumnNameLength, getMaxConstraintNameLength, getMaxIndexNameLength, getMaxTableNameLength, getSQLState, getTypeInfo, getTypeInfo, getUnlimitedLengthPrecisionValue, includeOrderByColumnsInSelect, isSQLKeyword, newColumnInfo, newDataStoreException, newForeignKeyInfo, newTypeInfo, parseKeywordList, storesLowerCaseIdentifiers, storesUpperCaseIdentifiers, supportsAlterTableDropConstraint, supportsDeferredConstraints, supportsNullsInCandidateKeys, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleAdapter

public OracleAdapter(java.sql.DatabaseMetaData metadata)

Constructs an Oracle adapter based on the given JDBC metadata.

Parameters:

metadata - the database metadata.

Method Detail

getVendorID

public java.lang.String getVendorID()

Overrides:

getVendorID in class DatabaseAdapter

createTypeInfo

protected void createTypeInfo(java.sql.DatabaseMetaData metadata)
                       throws java.sql.SQLException

Description copied from class: DatabaseAdapter

Creates TypeInfo objects for all of the data types and indexes them in the typesByTypeNumber map by their JDBC data type number.

Overrides:

createTypeInfo in class DatabaseAdapter

Throws:

java.sql.SQLException

getMapping

public Mapping getMapping(ClassBaseTable table,
                          int relativeFieldNumber)

Overrides:

getMapping in class DatabaseAdapter

getMapping

public ColumnMapping getMapping(Column col)

Overrides:

getMapping in class DatabaseAdapter

isEmbeddedType

public boolean isEmbeddedType(java.lang.Class c)

Overrides:

isEmbeddedType in class DatabaseAdapter

getSchemaName

public java.lang.String getSchemaName(java.sql.Connection conn)
                               throws java.sql.SQLException

Overrides:

getSchemaName in class DatabaseAdapter

Throws:

java.sql.SQLException

supportsBooleanComparison

public boolean supportsBooleanComparison()

Overrides:

supportsBooleanComparison in class DatabaseAdapter

newQueryStatement

public QueryStatement newQueryStatement(Table table)

Overrides:

newQueryStatement in class DatabaseAdapter

newQueryStatement

public QueryStatement newQueryStatement(Table table,
                                        SQLIdentifier rangeVar)

Overrides:

newQueryStatement in class DatabaseAdapter

newTableExpression

public TableExpression newTableExpression(QueryStatement qs,
                                          Table table,
                                          SQLIdentifier rangeVar)

Description copied from class: DatabaseAdapter

Returns a new TableExpression object appropriate for this DBMS. This should be an instance of one of the three built-in styles of table expression:

• TableExprAsJoins
• TableExprAsSubjoins
• TableExprAsSubquery

TableExprAsSubjoins is the default, which arguably produces the most readable SQL but doesn't work on all DBMS's. TableExprAsSubjoins should work anywhere, but may be less efficient.

Overrides:

newTableExpression in class DatabaseAdapter

Parameters:

qs - The query statement in which the table expression will be included.

table - The main table in the expression.

rangeVar - The SQL alias, or "range variable", to assign to the expression or to the main table.

getDropTableStatement

public java.lang.String getDropTableStatement(BaseTable table)

Description copied from class: DatabaseAdapter

Returns the appropriate SQL to drop the given table. It should return something like:

 DROP TABLE FOO CASCADE
 

Overrides:

getDropTableStatement in class DatabaseAdapter

Parameters:

table - The table to drop.

Returns:

The text of the SQL statement.

lengthMethod

public NumericExpression lengthMethod(CharacterExpression str)

Description copied from class: DatabaseAdapter

Returns the appropriate SQL expression for the JDOQL String.length() method. It should return something like:

 CHAR_LENGTH(str)
 

Overrides:

lengthMethod in class DatabaseAdapter

Parameters:

str - The argument to the length() method.

Returns:

The text of the SQL expression.

substringMethod

public CharacterExpression substringMethod(CharacterExpression str,
                                           NumericExpression begin)

Description copied from class: DatabaseAdapter

Returns the appropriate SQL expression for the JDOQL String.substring(str,begin) method. It should return something like:

 SUBSTRING(str FROM begin)
 

Note that the value of begin is base 0 (Java-style), while most SQL string functions use base 1.

Overrides:

substringMethod in class DatabaseAdapter

Parameters:

str - The first argument to the substring() method.

begin - The second argument to the substring() method.

Returns:

The text of the SQL expression.

substringMethod

public CharacterExpression substringMethod(CharacterExpression str,
                                           NumericExpression begin,
                                           NumericExpression end)

Description copied from class: DatabaseAdapter

Returns the appropriate SQL expression for the JDOQL String.substring(str,begin,end) method. It should return something like:

 SUBSTRING(str FROM begin FOR len)
 

Note that the value of begin is base 0 (Java-style), while most SQL string functions use base 1. Note also that an end position is given, while most SQL substring functions take a length.

Overrides:

substringMethod in class DatabaseAdapter

Parameters:

str - The first argument to the substring() method.

begin - The second argument to the substring() method.

end - The third argument to the substring() method.

Returns:

The text of the SQL expression.