|
SolarMetric Kodo JDO 3.3.5 generated on August 31 2005 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--kodo.jdbc.sql.DBDictionary | +--kodo.jdbc.sql.OracleDictionary
Dictionary for Oracle.
Field Summary | |
String |
autoIncrementSequenceName
The global sequence name to use for autoincrement simulation. |
int |
maxEmbeddedBlobSize
The maximum size (in bytes) of blobs that can be embedded in an insert/update prepared statement by the Oracle JDBC driver. |
int |
maxEmbeddedClobSize
The maximum size (in characters) of clobs that can be embedded in an insert/update prepared statement by the Oracle JDBC driver. |
boolean |
useTriggersForAutoIncrement
If true, then simulate auto-increment in Oracle by using a trigger that inserts a sequence value into the primary key value when a row is inserted. |
static String |
VENDOR_DATADIRECT_31
|
static String |
VENDOR_ORACLE
|
static String |
VENDOR_ORACLE_92
|
Constructor Summary | |
OracleDictionary()
|
Method Summary | |
boolean |
canBatch(Column col)
Returns type if the specified column can be included in batch statements. |
boolean |
canOuterJoin(int syntax,
ForeignKey fk)
Returns if the given foreign key can be eagerly loaded using other joins. |
void |
connectedConfiguration(Connection conn)
This method is called when the dictionary first sees any connection. |
void |
endConfiguration()
Invoked upon completion of bean property configuration for this object. |
protected String |
getAutoIncrementSequenceName(Column col)
Returns the name of the sequence that should be used for simulating auto-increment behavior. |
protected String |
getAutoIncrementTriggerName(Column col)
Returns the name of the trigger that should be used for simulating auto-increment behavior. |
String |
getClobString(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
Column[] |
getColumns(DatabaseMetaData meta,
String catalog,
String schemaName,
String tableName,
String columnName,
Connection conn)
Reflect on the schema to find columns matching the given table and column patterns. |
String[] |
getCreateTableSQL(Table table)
Return a series of SQL statements to create the given table, complete with columns. |
long |
getGeneratedKey(Column col,
Connection conn)
Return the last inserted auto increment value for the given column. |
ForeignKey[] |
getImportedKeys(DatabaseMetaData meta,
String catalog,
String schemaName,
String tableName,
Connection conn)
Reflect on the schema to return foreign keys imported by the given table pattern. |
Index[] |
getIndexInfo(DatabaseMetaData meta,
String catalog,
String schemaName,
String tableName,
boolean unique,
boolean approx,
Connection conn)
Reflect on the schema to find indexes matching the given table pattern. |
PrimaryKey[] |
getPrimaryKeys(DatabaseMetaData meta,
String catalog,
String schemaName,
String tableName,
Connection conn)
Reflect on the schema to find primary keys for the given table pattern. |
protected SQLBuffer |
getSelects(Select sel,
boolean distinctIdentifiers,
boolean forUpdate)
Return the portion of the select statement between the SELECT keyword and the FROM keyword. |
Timestamp |
getTimestamp(ResultSet rs,
int column,
Calendar cal)
Convert the specified column of the SQL ResultSet to the proper java type. |
void |
putBytes(Object blob,
byte[] data)
Invoke the oracle-specific putBytes method on the given
BLOB object. |
void |
putString(Object clob,
String data)
Invoke the oracle-specific putString method on the given
CLOB object. |
FieldMapping |
replaceMapping(FieldMapping mapping)
Replace the given mapping with one suited to this database, or return the original if no replacement is needed. |
MappingFactory |
replaceMappingFactory(MappingFactory factory)
Replace the given factory with one suited to this database, or return the original if no replacement is needed. |
SchemaFactory |
replaceSchemaFactory(SchemaFactory factory)
Replace the given factory with one suited to this database, or return the original if no replacement is needed. |
byte[] |
serialize(Object val)
Return the serialized bytes for the given object. |
void |
setNull(PreparedStatement stmnt,
int idx,
int colType,
Column col)
Set the given value as a parameters to the statement. |
void |
setString(PreparedStatement stmnt,
int idx,
String val,
Column col)
Set the given value as a parameter to the statement. |
void |
substring(SQLBuffer buf,
FilterValue str,
FilterValue start,
FilterValue end)
Invoke this database's substring function. |
boolean |
supportsLocking(Select sel)
Returns true if a "FOR UPDATE" clause can be used for the specified Select object. |
SQLBuffer |
toNativeJoin(Join join)
Use the given join instance to create SQL joining its tables in the database's native syntax. |
SQLBuffer |
toSelect(SQLBuffer select,
SQLBuffer tables,
SQLBuffer where,
SQLBuffer group,
SQLBuffer having,
SQLBuffer order,
boolean distinct,
boolean forUpdate,
long start,
long end)
Combine the given components into a SELECT statement. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static final String VENDOR_ORACLE
public static final String VENDOR_ORACLE_92
public static final String VENDOR_DATADIRECT_31
public int maxEmbeddedBlobSize
public int maxEmbeddedClobSize
public boolean useTriggersForAutoIncrement
public String autoIncrementSequenceName
Constructor Detail |
public OracleDictionary()
Method Detail |
public void endConfiguration()
Configurable
endConfiguration
in class DBDictionary
public void connectedConfiguration(Connection conn) throws SQLException
DBDictionary
super.connectedConfiguration
.connectedConfiguration
in class DBDictionary
public boolean canBatch(Column col)
DBDictionary
canBatch
in class DBDictionary
public boolean supportsLocking(Select sel)
DBDictionary
supportsLocking
in class DBDictionary
protected SQLBuffer getSelects(Select sel, boolean distinctIdentifiers, boolean forUpdate)
DBDictionary
getSelects
in class DBDictionary
public boolean canOuterJoin(int syntax, ForeignKey fk)
DBDictionary
canOuterJoin
in class DBDictionary
public SQLBuffer toNativeJoin(Join join)
DBDictionary
toNativeJoin
in class DBDictionary
public SQLBuffer toSelect(SQLBuffer select, SQLBuffer tables, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end)
DBDictionary
toSelect
in class DBDictionary
public void substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
DBDictionary
substring
in class DBDictionary
kodo.jdbc.sql.DBDictionary
buf
- the SQL buffer to write the substring invocation tostr
- a query value representing the target stringstart
- a query value representing the start indexend
- a query value representing the end index, or null
for nonepublic void setString(PreparedStatement stmnt, int idx, String val, Column col) throws SQLException
DBDictionary
setString
in class DBDictionary
public void setNull(PreparedStatement stmnt, int idx, int colType, Column col) throws SQLException
DBDictionary
Types
.setNull
in class DBDictionary
public byte[] serialize(Object val) throws SQLException
DBDictionary
serialize
in class DBDictionary
public String getClobString(ResultSet rs, int column) throws SQLException
DBDictionary
getClobString
in class DBDictionary
public Timestamp getTimestamp(ResultSet rs, int column, Calendar cal) throws SQLException
DBDictionary
getTimestamp
in class DBDictionary
public Column[] getColumns(DatabaseMetaData meta, String catalog, String schemaName, String tableName, String columnName, Connection conn) throws SQLException
DBDictionary
getColumns
in class DBDictionary
public PrimaryKey[] getPrimaryKeys(DatabaseMetaData meta, String catalog, String schemaName, String tableName, Connection conn) throws SQLException
DBDictionary
getPrimaryKeys
in class DBDictionary
public Index[] getIndexInfo(DatabaseMetaData meta, String catalog, String schemaName, String tableName, boolean unique, boolean approx, Connection conn) throws SQLException
DBDictionary
getIndexInfo
in class DBDictionary
public ForeignKey[] getImportedKeys(DatabaseMetaData meta, String catalog, String schemaName, String tableName, Connection conn) throws SQLException
DBDictionary
getImportedKeys
in class DBDictionary
public FieldMapping replaceMapping(FieldMapping mapping)
DBDictionary
replaceMapping
in class DBDictionary
public MappingFactory replaceMappingFactory(MappingFactory factory)
DBDictionary
replaceMappingFactory
in class DBDictionary
public SchemaFactory replaceSchemaFactory(SchemaFactory factory)
DBDictionary
replaceSchemaFactory
in class DBDictionary
public String[] getCreateTableSQL(Table table)
DBDictionary
getCreateTableSQL
in class DBDictionary
public long getGeneratedKey(Column col, Connection conn) throws SQLException
DBDictionary
DBDictionary.lastGeneratedKeyQuery
is null.getGeneratedKey
in class DBDictionary
protected String getAutoIncrementSequenceName(Column col)
autoIncrementSequenceName
, or else will be "SEQ_[table name]".protected String getAutoIncrementTriggerName(Column col)
public void putBytes(Object blob, byte[] data) throws SQLException
putBytes
method on the given
BLOB object. Uses reflection in case the blob is wrapped in another
vendor-specific class; for example Weblogic wraps oracle thin driver
lobs in its own interfaces with the same methods.public void putString(Object clob, String data) throws SQLException
putString
method on the given
CLOB object. Uses reflection in case the clob is wrapped in another
vendor-specific class; for example Weblogic wraps oracle thin driver
lobs in its own interfaces with the same methods.
|
SolarMetric Kodo JDO 3.3.5 generated on August 31 2005 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |