public class OracleDictionary extends DBDictionary
DBDictionary.SerializedData
Modifier and Type | Field and Description |
---|---|
java.lang.String |
autoAssignSequenceName
The global sequence name to use for autoassign simulation.
|
boolean |
openjpa3GeneratedKeyNames
Flag to use OpenJPA 0.3 style naming for auto assign sequence name and
trigger name for backwards compatibility.
|
static java.lang.String |
SELECT_HINT |
boolean |
useSetFormOfUseForUnicode
If true, then OpenJPA will attempt to use the special
OraclePreparedStatement.setFormOfUse method to
configure statements that it detects are operating on unicode fields.
|
boolean |
useTriggersForAutoAssign
If true, then simulate auto-assigned values in Oracle by
using a trigger that inserts a sequence value into the
primary key value when a row is inserted.
|
static java.lang.String |
VENDOR_ORACLE |
allowsAliasInBulkClause, arrayTypeName, autoAssignClause, autoAssignTypeName, batchLimit, bigintTypeName, binaryTypeName, bitLengthFunction, bitTypeName, blobBufferSize, blobTypeName, booleanTypeName, castFunction, catalogSeparator, CENTI, characterColumnSize, charTypeName, clobBufferSize, clobTypeName, closePoolSQL, concatenateDelimiter, concatenateFunction, conf, connected, CONS_NAME_AFTER, CONS_NAME_BEFORE, CONS_NAME_MID, constraintNameMode, createPrimaryKeys, crossJoinClause, currentDateFunction, currentTimeFunction, currentTimestampFunction, datePrecision, dateTypeName, DECI, decimalTypeName, delimitedCase, distinctCountColumnSeparator, distinctTypeName, doubleTypeName, driverVendor, dropTableSQL, fixedSizeTypeNames, fixedSizeTypeNameSet, floatTypeName, forUpdateClause, getStringVal, inClauseLimit, initializationSQL, innerJoinClause, integerTypeName, invalidColumnWordSet, isJDBC3, javaObjectTypeName, joinSyntax, lastGeneratedKeyQuery, leadingDelimiter, log, longVarbinaryTypeName, longVarcharTypeName, maxAutoAssignNameLength, maxColumnNameLength, maxConstraintNameLength, maxEmbeddedBlobSize, maxEmbeddedClobSize, maxIndexesPerTable, maxIndexNameLength, maxTableNameLength, MICRO, MILLI, NAME_ANY, NAME_SEQUENCE, NAME_TABLE, nameConcatenator, NANO, nativeSequenceType, nextSequenceQuery, NO_BATCH, nullTypeName, numericTypeName, otherTypeName, outerJoinClause, platform, RANGE_POST_DISTINCT, RANGE_POST_LOCK, RANGE_POST_SELECT, RANGE_PRE_DISTINCT, rangePosition, realTypeName, refTypeName, reportsSuccessNoInfoOnBatchUpdates, requiresAliasForSubselect, requiresAutoCommitForMetaData, requiresCastForComparisons, requiresCastForMathFunctions, requiresConditionForCrossJoin, requiresSearchStringEscapeForLike, requiresTargetForDelete, reservedWords, reservedWordSet, SCHEMA_CASE_LOWER, SCHEMA_CASE_PRESERVE, SCHEMA_CASE_UPPER, schemaCase, searchStringEscape, SEC, selectWords, selectWordSet, sequenceNameSQL, sequenceSchemaSQL, sequenceSQL, setStringRightTruncationOn, simulateLocking, smallintTypeName, sqlStateCodes, storageLimitationsFatal, storeCharsAsNumbers, storeLargeNumbersAsStrings, stringLengthFunction, structTypeName, substringFunctionName, supportsAlterTableWithAddColumn, supportsAlterTableWithDropColumn, supportsAutoAssign, supportsCascadeDeleteAction, supportsCascadeUpdateAction, supportsCaseConversionForLob, supportsComments, supportsCorrelatedSubselect, supportsDefaultDeleteAction, supportsDefaultUpdateAction, supportsDeferredConstraints, supportsDelimitedIdentifiers, supportsForeignKeys, supportsForeignKeysComposite, supportsGeneralCaseExpression, supportsGetGeneratedKeys, supportsHaving, supportsLockingWithDistinctClause, supportsLockingWithInnerJoin, supportsLockingWithMultipleTables, supportsLockingWithOrderClause, supportsLockingWithOuterJoin, supportsLockingWithSelectRange, supportsModOperator, supportsMultipleNontransactionalResultSets, supportsNullDeleteAction, supportsNullTableForGetColumns, supportsNullTableForGetImportedKeys, supportsNullTableForGetIndexInfo, supportsNullTableForGetPrimaryKeys, supportsNullUpdateAction, supportsParameterInSelect, supportsQueryTimeout, supportsRestrictDeleteAction, supportsRestrictUpdateAction, supportsSchemaForGetColumns, supportsSchemaForGetTables, supportsSelectEndIndex, supportsSelectForUpdate, supportsSelectFromFinalTable, supportsSelectStartIndex, supportsSimpleCaseExpression, supportsSubselect, supportsUniqueConstraints, supportsXMLColumn, systemSchemas, systemSchemaSet, systemTables, systemTableSet, tableForUpdateClause, tableTypes, timestampTypeName, timeTypeName, tinyintTypeName, toLowerCaseFunction, toUpperCaseFunction, trailingDelimiter, trimBothFunction, trimLeadingFunction, trimSchemaName, trimTrailingFunction, typeModifierSet, UNLIMITED, useGetBestRowIdentifierForPrimaryKeys, useGetBytesForBlobs, useGetObjectForBlobs, useGetStringForClobs, useSchemaName, useSetBytesForBlobs, useSetStringForClobs, useWildCardForCount, validationSQL, varbinaryTypeName, varcharTypeName, VENDOR_DATADIRECT, VENDOR_OTHER, xmlTypeEncoding, xmlTypeName
SYNTAX_DATABASE, SYNTAX_SQL92, SYNTAX_TRADITIONAL
Constructor and Description |
---|
OracleDictionary() |
Modifier and Type | Method and Description |
---|---|
void |
appendXmlComparison(SQLBuffer buf,
java.lang.String op,
FilterValue lhs,
FilterValue rhs,
boolean lhsxml,
boolean rhsxml)
If this dictionary supports XML type,
use this method to append xml predicate.
|
boolean |
canOuterJoin(int syntax,
ForeignKey fk)
Returns if the given foreign key can be eagerly loaded using other joins.
|
void |
connectedConfiguration(java.sql.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.
|
void |
ensureDriverVendor()
Ensure that the driver vendor has been set, and if not, set it now.
|
int |
getBatchUpdateCount(java.sql.PreparedStatement ps)
Return batched statements update success count
|
java.lang.String |
getClobString(java.sql.ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper
java type.
|
Column[] |
getColumns(java.sql.DatabaseMetaData meta,
DBIdentifier catalog,
DBIdentifier schemaName,
DBIdentifier tableName,
DBIdentifier columnName,
java.sql.Connection conn)
Reflect on the schema to find columns matching the given table and
column patterns.
|
Column[] |
getColumns(java.sql.DatabaseMetaData meta,
java.lang.String catalog,
java.lang.String schemaName,
java.lang.String tableName,
java.lang.String columnName,
java.sql.Connection conn)
Reflect on the schema to find columns matching the given table and
column patterns.
|
java.lang.String[] |
getCreateSequenceSQL(Sequence seq)
Return a series of SQL statements to create the given sequence.
|
java.lang.String[] |
getCreateTableSQL(Table table)
Return a series of SQL statements to create the given table, complete
with columns.
|
java.lang.Object |
getGeneratedKey(Column col,
java.sql.Connection conn)
Return the last generated value for the given column.
|
protected java.lang.String |
getGeneratedKeyTriggerName(Column col)
Trigger name for simulating auto-assign values on the given column.
|
ForeignKey[] |
getImportedKeys(java.sql.DatabaseMetaData meta,
DBIdentifier catalog,
DBIdentifier schemaName,
DBIdentifier tableName,
java.sql.Connection conn,
boolean partialKeys)
Reflect on the schema to return full foreign keys imported by the given
table pattern.
|
ForeignKey[] |
getImportedKeys(java.sql.DatabaseMetaData meta,
java.lang.String catalog,
java.lang.String schemaName,
java.lang.String tableName,
java.sql.Connection conn,
boolean partialKeys)
Reflect on the schema to return full foreign keys imported by the given
table pattern.
|
Index[] |
getIndexInfo(java.sql.DatabaseMetaData meta,
DBIdentifier catalog,
DBIdentifier schemaName,
DBIdentifier tableName,
boolean unique,
boolean approx,
java.sql.Connection conn)
Reflect on the schema to find indexes matching the given table pattern.
|
Index[] |
getIndexInfo(java.sql.DatabaseMetaData meta,
java.lang.String catalog,
java.lang.String schemaName,
java.lang.String tableName,
boolean unique,
boolean approx,
java.sql.Connection conn)
Reflect on the schema to find indexes matching the given table pattern.
|
int |
getJDBCType(int metaTypeCode,
boolean lob,
int precis,
int scale,
boolean xml)
|
java.lang.Object |
getObject(java.sql.ResultSet rs,
int column,
java.util.Map map)
Convert the specified column of the SQL ResultSet to the proper
java type.
|
protected java.lang.String |
getOpenJPA3GeneratedKeySequenceName(Column col)
Returns a OpenJPA 3-compatible name for an auto-assign sequence.
|
protected java.lang.String |
getOpenJPA3GeneratedKeyTriggerName(Column col)
Returns a OpenJPA 3-compatible name for an auto-assign trigger.
|
PrimaryKey[] |
getPrimaryKeys(java.sql.DatabaseMetaData meta,
DBIdentifier catalog,
DBIdentifier schemaName,
DBIdentifier tableName,
java.sql.Connection conn)
Reflect on the schema to find primary keys for the given table pattern.
|
PrimaryKey[] |
getPrimaryKeys(java.sql.DatabaseMetaData meta,
java.lang.String catalog,
java.lang.String schemaName,
java.lang.String tableName,
java.sql.Connection conn)
Reflect on the schema to find primary keys for the given table pattern.
|
java.lang.String |
getSelectOperation(JDBCFetchConfiguration fetch)
Check to see if we have set the
SELECT_HINT in the
fetch configuraiton, and if so, append the Orache hint after the
"SELECT" part of the query. |
protected SQLBuffer |
getSelects(Select sel,
boolean distinctIdentifiers,
boolean forUpdate)
Return the portion of the select statement between the SELECT keyword
and the FROM keyword.
|
protected java.lang.String |
getSequencesSQL(DBIdentifier schemaName,
DBIdentifier sequenceName) |
protected java.lang.String |
getSequencesSQL(java.lang.String schemaName,
java.lang.String sequenceName)
Return the SQL needed to select the list of sequences.
|
java.sql.Timestamp |
getTimestamp(java.sql.ResultSet rs,
int column,
java.util.Calendar cal)
Convert the specified column of the SQL ResultSet to the proper
java type.
|
void |
insertBlobForStreamingLoad(Row row,
Column col,
JDBCStore store,
java.lang.Object ob,
Select sel) |
void |
insertClobForStreamingLoad(Row row,
Column col,
java.lang.Object ob) |
boolean |
isFatalException(int subtype,
java.sql.SQLException ex)
Determine if the given SQL Exception is fatal or recoverable (such as a timeout).
|
boolean |
isSystemSequence(DBIdentifier name,
DBIdentifier schema,
boolean targetSchema)
This method is used to filter system sequences from database metadata.
|
boolean |
isSystemSequence(java.lang.String name,
java.lang.String schema,
boolean targetSchema)
This method is used to filter system sequences from database metadata.
|
void |
putBytes(java.sql.Blob blob,
byte[] data)
Invoke Oracle's
putBytes method on the given BLOB object. |
void |
putChars(java.sql.Clob clob,
char[] data)
Invoke Oracle's
putChars method on the given CLOB
object. |
void |
putString(java.sql.Clob clob,
java.lang.String data)
Invoke Oracle's
putString method on the given CLOB object. |
void |
setNull(java.sql.PreparedStatement stmnt,
int idx,
int colType,
Column col)
Set null as a parameter to the statement.
|
void |
setString(java.sql.PreparedStatement stmnt,
int idx,
java.lang.String val,
Column col)
Set the given value as a parameter to the statement.
|
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.
|
protected SQLBuffer |
toSelect(SQLBuffer select,
JDBCFetchConfiguration fetch,
SQLBuffer tables,
SQLBuffer where,
SQLBuffer group,
SQLBuffer having,
SQLBuffer order,
boolean distinct,
boolean forUpdate,
long start,
long end,
boolean subselect,
Select sel)
Combine the given components into a SELECT statement.
|
protected SQLBuffer |
toSelect(SQLBuffer select,
JDBCFetchConfiguration fetch,
SQLBuffer tables,
SQLBuffer where,
SQLBuffer group,
SQLBuffer having,
SQLBuffer order,
boolean distinct,
boolean forUpdate,
long start,
long end,
Select sel)
Combine the given components into a SELECT statement.
|
addCastAsType, addErrorCode, appendCast, appendLength, appendNumericCast, appendSelect, appendSelectRange, appendSize, appendUpdates, assertSupport, calculateValue, closeDataSource, combineForeignKey, comment, comparison, configureNamingRules, convertSchemaCase, convertSchemaCase, copy, copy, createIndexIfNecessary, createIndexIfNecessary, decorate, deleteStream, delimitAll, executeQuery, fromDBName, getAddColumnSQL, getAddForeignKeySQL, getAddPrimaryKeySQL, getArray, getAsciiStream, getBatchFetchSize, getBatchLimit, getBigDecimal, getBigInteger, getBinaryStream, getBlob, getBlobObject, getBoolean, getByte, getBytes, getCalendar, getCastFunction, getCastFunction, getCatalogNameForMetadata, getCatalogNameForMetadata, getChar, getCharacterStream, getClob, getColumnDBName, getColumnIdentifier, getColumnNameForMetadata, getColumnNameForMetadata, getConversionKey, getCreateIndexSQL, getDate, getDate, getDeclareColumnSQL, getDefaultIdentifierRule, getDefaultSchemaName, getDeleteTableContentsSQL, getDeleteTargets, getDelimitedCase, getDelimitIdentifiers, getDouble, getDropColumnSQL, getDropForeignKeySQL, getDropIndexSQL, getDropPrimaryKeySQL, getDropSequenceSQL, getDropTableSQL, getFloat, getForeignKeyConstraintSQL, getForUpdateClause, getFrom, getFromSelect, getFullIdentifier, getFullName, getFullName, getFullName, getGeneratedKeySequenceName, getIdentifierConcatenator, getIdentifierDelimiter, getIdentifierRule, getIdentifierRules, getImportedKeys, getImportedKeys, getInt, getInvalidColumnWordSet, getJDBCType, getJDBCType, getKey, getLeadingDelimiter, getLOBStream, getLocale, getLog, getLong, getNamingUtil, getNumber, getPlaceholderValueString, getPreferredType, getPrimaryKeyConstraintSQL, getPrimaryKeysFromBestRowIdentifier, getPrimaryKeysFromBestRowIdentifier, getPrimaryKeysFromGetPrimaryKeys, getPrimaryKeysFromGetPrimaryKeys, getRef, getSchemaCase, getSchemaNameForMetadata, getSchemaNameForMetadata, getSelectTableAliases, getSequence, getSequences, getSequences, getShort, getString, getSupportsDelimitedIdentifiers, getSupportsXMLColumn, getTableNameForMetadata, getTableNameForMetadata, getTables, getTables, getTime, getTrailingDelimiter, getTrimSchemaName, getTypeName, getTypeName, getUniqueConstraintSQL, getValidColumnName, getValidColumnName, getValidColumnName, getValidColumnName, getValidForeignKeyName, getValidForeignKeyName, getValidIndexName, getValidIndexName, getValidPrimaryKeyName, getValidSequenceName, getValidSequenceName, getValidTableName, getValidTableName, getValidUniqueName, getValidUniqueName, getVersionColumn, getVersionColumn, getWhere, getXMLTypeEncoding, handleWarning, indexOf, insertSize, isSelect, isSystemIndex, isSystemIndex, isSystemTable, isSystemTable, makeNameValid, makeNameValid, makeNameValid, makeNameValid, matchErrorState, mathFunction, needsToCreateIndex, newColumn, newForeignKey, newIndex, newPrimaryKey, newSequence, newStoreException, newTable, prepareStatement, refSchemaComponents, serialize, setArray, setAsciiStream, setBatchLimit, setBigDecimal, setBigInteger, setBinaryStream, setBlob, setBlobObject, setBoolean, setByte, setBytes, setCalendar, setChar, setCharacterStream, setClob, setClobString, setConfiguration, setDate, setDate, setDefaultSchemaName, setDelimitedCase, setDelimitIdentifiers, setDouble, setFloat, setInt, setJoinSyntax, setLeadingDelimiter, setLocale, setLong, setNumber, setObject, setQueryTimeout, setRef, setShort, setStatementQueryTimeout, setSupportsDelimitedIdentifiers, setSupportsXMLColumn, setTime, setTimeouts, setTimeouts, setTimestamp, setTrailingDelimiter, setTrimSchemaName, setTyped, setUnknown, setXMLTypeEncoding, shorten, startConfiguration, storageWarning, substring, supportsDeferredForeignKeyConstraints, supportsDeferredUniqueConstraints, supportsDeleteAction, supportsIsolationForUpdate, supportsRandomAccessResultSet, supportsUpdateAction, toBulkOperation, toDBName, toDBName, toDelete, toOperation, toOperation, toSelect, toSelect, toSelect, toSelectCount, toSQL92Join, toTraditionalJoin, toUpdate, updateBlob, updateClob, validateBatchProcess, validateDBSpecificBatchProcess
public static final java.lang.String SELECT_HINT
public static final java.lang.String VENDOR_ORACLE
public boolean useTriggersForAutoAssign
public java.lang.String autoAssignSequenceName
public boolean openjpa3GeneratedKeyNames
public boolean useSetFormOfUseForUnicode
public void endConfiguration()
Configurable
endConfiguration
in interface Configurable
endConfiguration
in class DBDictionary
public void connectedConfiguration(java.sql.Connection conn) throws java.sql.SQLException
DBDictionary
super.connectedConfiguration
.connectedConfiguration
in class DBDictionary
java.sql.SQLException
public void ensureDriverVendor()
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
protected SQLBuffer toSelect(SQLBuffer select, JDBCFetchConfiguration fetch, SQLBuffer tables, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end, boolean subselect, Select sel)
DBDictionary
toSelect
in class DBDictionary
protected SQLBuffer toSelect(SQLBuffer select, JDBCFetchConfiguration fetch, SQLBuffer tables, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end, Select sel)
DBDictionary
toSelect
in class DBDictionary
public java.lang.String getSelectOperation(JDBCFetchConfiguration fetch)
SELECT_HINT
in the
fetch configuraiton, and if so, append the Orache hint after the
"SELECT" part of the query.getSelectOperation
in class DBDictionary
public void setString(java.sql.PreparedStatement stmnt, int idx, java.lang.String val, Column col) throws java.sql.SQLException
DBDictionary
setString
in class DBDictionary
java.sql.SQLException
public void setNull(java.sql.PreparedStatement stmnt, int idx, int colType, Column col) throws java.sql.SQLException
DBDictionary
Types
.setNull
in class DBDictionary
java.sql.SQLException
public java.lang.String getClobString(java.sql.ResultSet rs, int column) throws java.sql.SQLException
DBDictionary
getClobString
in class DBDictionary
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.sql.ResultSet rs, int column, java.util.Calendar cal) throws java.sql.SQLException
DBDictionary
getTimestamp
in class DBDictionary
java.sql.SQLException
public java.lang.Object getObject(java.sql.ResultSet rs, int column, java.util.Map map) throws java.sql.SQLException
DBDictionary
getObject
in class DBDictionary
java.sql.SQLException
public Column[] getColumns(java.sql.DatabaseMetaData meta, java.lang.String catalog, java.lang.String schemaName, java.lang.String tableName, java.lang.String columnName, java.sql.Connection conn) throws java.sql.SQLException
DBDictionary
getColumns
in class DBDictionary
java.sql.SQLException
public Column[] getColumns(java.sql.DatabaseMetaData meta, DBIdentifier catalog, DBIdentifier schemaName, DBIdentifier tableName, DBIdentifier columnName, java.sql.Connection conn) throws java.sql.SQLException
DBDictionary
getColumns
in class DBDictionary
java.sql.SQLException
public PrimaryKey[] getPrimaryKeys(java.sql.DatabaseMetaData meta, java.lang.String catalog, java.lang.String schemaName, java.lang.String tableName, java.sql.Connection conn) throws java.sql.SQLException
DBDictionary
getPrimaryKeys
in class DBDictionary
java.sql.SQLException
public PrimaryKey[] getPrimaryKeys(java.sql.DatabaseMetaData meta, DBIdentifier catalog, DBIdentifier schemaName, DBIdentifier tableName, java.sql.Connection conn) throws java.sql.SQLException
DBDictionary
getPrimaryKeys
in class DBDictionary
java.sql.SQLException
public Index[] getIndexInfo(java.sql.DatabaseMetaData meta, java.lang.String catalog, java.lang.String schemaName, java.lang.String tableName, boolean unique, boolean approx, java.sql.Connection conn) throws java.sql.SQLException
DBDictionary
getIndexInfo
in class DBDictionary
java.sql.SQLException
public Index[] getIndexInfo(java.sql.DatabaseMetaData meta, DBIdentifier catalog, DBIdentifier schemaName, DBIdentifier tableName, boolean unique, boolean approx, java.sql.Connection conn) throws java.sql.SQLException
DBDictionary
getIndexInfo
in class DBDictionary
java.sql.SQLException
public ForeignKey[] getImportedKeys(java.sql.DatabaseMetaData meta, java.lang.String catalog, java.lang.String schemaName, java.lang.String tableName, java.sql.Connection conn, boolean partialKeys) throws java.sql.SQLException
DBDictionary
getImportedKeys
in class DBDictionary
java.sql.SQLException
public ForeignKey[] getImportedKeys(java.sql.DatabaseMetaData meta, DBIdentifier catalog, DBIdentifier schemaName, DBIdentifier tableName, java.sql.Connection conn, boolean partialKeys) throws java.sql.SQLException
DBDictionary
getImportedKeys
in class DBDictionary
java.sql.SQLException
public java.lang.String[] getCreateTableSQL(Table table)
DBDictionary
getCreateTableSQL
in class DBDictionary
public java.lang.String[] getCreateSequenceSQL(Sequence seq)
DBDictionary
CREATE SEQUENCE <sequence name>[ START WITH <start>]
[ INCREMENT BY <increment>]
by default.getCreateSequenceSQL
in class DBDictionary
public int getJDBCType(int metaTypeCode, boolean lob, int precis, int scale, boolean xml)
getJDBCType
in class DBDictionary
protected java.lang.String getSequencesSQL(java.lang.String schemaName, java.lang.String sequenceName)
DBDictionary
getSequencesSQL
in class DBDictionary
protected java.lang.String getSequencesSQL(DBIdentifier schemaName, DBIdentifier sequenceName)
getSequencesSQL
in class DBDictionary
public boolean isSystemSequence(java.lang.String name, java.lang.String schema, boolean targetSchema)
DBDictionary
isSystemSequence
in class DBDictionary
name
- the table nameschema
- the table schema; may be nulltargetSchema
- if true, then the given schema was listed by
the user as one of his schemaspublic boolean isSystemSequence(DBIdentifier name, DBIdentifier schema, boolean targetSchema)
DBDictionary
isSystemSequence
in class DBDictionary
name
- the table nameschema
- the table schema; may be nulltargetSchema
- if true, then the given schema was listed by
the user as one of his schemaspublic java.lang.Object getGeneratedKey(Column col, java.sql.Connection conn) throws java.sql.SQLException
DBDictionary
DBDictionary.lastGeneratedKeyQuery
is null.getGeneratedKey
in class DBDictionary
java.sql.SQLException
protected java.lang.String getGeneratedKeyTriggerName(Column col)
protected java.lang.String getOpenJPA3GeneratedKeySequenceName(Column col)
protected java.lang.String getOpenJPA3GeneratedKeyTriggerName(Column col)
public void putBytes(java.sql.Blob blob, byte[] data) throws java.sql.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.putBytes
in class DBDictionary
java.sql.SQLException
public void putString(java.sql.Clob clob, java.lang.String data) throws java.sql.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.putString
in class DBDictionary
java.sql.SQLException
public void putChars(java.sql.Clob clob, char[] data) throws java.sql.SQLException
putChars
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.putChars
in class DBDictionary
java.sql.SQLException
public void appendXmlComparison(SQLBuffer buf, java.lang.String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml)
appendXmlComparison
in class DBDictionary
buf
- the SQL buffer to write the comparisonop
- the comparison operation to performlhs
- the left hand side of the comparisonrhs
- the right hand side of the comparisonpublic void insertClobForStreamingLoad(Row row, Column col, java.lang.Object ob) throws java.sql.SQLException
insertClobForStreamingLoad
in class DBDictionary
java.sql.SQLException
public int getBatchUpdateCount(java.sql.PreparedStatement ps) throws java.sql.SQLException
DBDictionary
getBatchUpdateCount
in class DBDictionary
ps
- A PreparedStatementjava.sql.SQLException
public boolean isFatalException(int subtype, java.sql.SQLException ex)
DBDictionary
isFatalException
in class DBDictionary
subtype
- A constant indicating the category of error as defined in StoreException
.ex
- original SQL Exception as raised by the database driver.public void insertBlobForStreamingLoad(Row row, Column col, JDBCStore store, java.lang.Object ob, Select sel) throws java.sql.SQLException
insertBlobForStreamingLoad
in class DBDictionary
java.sql.SQLException