|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.triactive.jdo.store.DatabaseAdapter
com.triactive.jdo.store.OracleAdapter
class OracleAdapter
Provides methods for adapting SQL language elements to the Oracle database.
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 java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
---|
public OracleAdapter(java.sql.DatabaseMetaData metadata)
metadata
- the database metadata.Method Detail |
---|
public java.lang.String getVendorID()
getVendorID
in class DatabaseAdapter
protected void createTypeInfo(java.sql.DatabaseMetaData metadata) throws java.sql.SQLException
DatabaseAdapter
createTypeInfo
in class DatabaseAdapter
java.sql.SQLException
public Mapping getMapping(ClassBaseTable table, int relativeFieldNumber)
getMapping
in class DatabaseAdapter
public ColumnMapping getMapping(Column col)
getMapping
in class DatabaseAdapter
public boolean isEmbeddedType(java.lang.Class c)
isEmbeddedType
in class DatabaseAdapter
public java.lang.String getSchemaName(java.sql.Connection conn) throws java.sql.SQLException
getSchemaName
in class DatabaseAdapter
java.sql.SQLException
public boolean supportsBooleanComparison()
supportsBooleanComparison
in class DatabaseAdapter
public QueryStatement newQueryStatement(Table table)
newQueryStatement
in class DatabaseAdapter
public QueryStatement newQueryStatement(Table table, SQLIdentifier rangeVar)
newQueryStatement
in class DatabaseAdapter
public TableExpression newTableExpression(QueryStatement qs, Table table, SQLIdentifier rangeVar)
DatabaseAdapter
newTableExpression
in class DatabaseAdapter
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.public java.lang.String getDropTableStatement(BaseTable table)
DatabaseAdapter
DROP TABLE FOO CASCADE
getDropTableStatement
in class DatabaseAdapter
table
- The table to drop.
public NumericExpression lengthMethod(CharacterExpression str)
DatabaseAdapter
CHAR_LENGTH(str)
lengthMethod
in class DatabaseAdapter
str
- The argument to the length() method.
public CharacterExpression substringMethod(CharacterExpression str, NumericExpression begin)
DatabaseAdapter
Note that the value of begin is base 0 (Java-style), while most SQL string functions use base 1.SUBSTRING(str FROM begin)
substringMethod
in class DatabaseAdapter
str
- The first argument to the substring() method.begin
- The second argument to the substring() method.
public CharacterExpression substringMethod(CharacterExpression str, NumericExpression begin, NumericExpression end)
DatabaseAdapter
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.SUBSTRING(str FROM begin FOR len)
substringMethod
in class DatabaseAdapter
str
- The first argument to the substring() method.begin
- The second argument to the substring() method.end
- The third argument to the substring() method.
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |