|
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
Class which allows the creation of SQL dynamically, in a database agnostic fashion. Subclass for the nuances of different data stores.
Constructor Summary | |
DBDictionary()
|
Method Summary | |
protected void |
appendSelectRange(SQLBuffer buf,
long start,
long end)
If this dictionary can select ranges, use this method to append the range SQL. |
protected String |
appendSize(Column col,
String typeName)
Helper method to add size properties to the specified type. |
void |
assertSupport(boolean feature,
String property)
Assert that the given dictionary flag is true. |
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. |
protected String |
convertSchemaCase(String objectName)
Convert the specified schema name to a name that the database will be able to understand. |
Connection |
decorate(Connection conn)
Decorate the given connection if needed. |
void |
endConfiguration()
Invoked upon completion of bean property configuration for this object. |
String[] |
getAddColumnSQL(Column column)
Return a series of SQL statements to add the given column to its table. |
String[] |
getAddForeignKeySQL(ForeignKey fk)
Return a series of SQL statements to add the given foreign key to its table. |
String[] |
getAddPrimaryKeySQL(PrimaryKey pk)
Return a series of SQL statements to add the given primary key to its table. |
Array |
getArray(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
InputStream |
getAsciiStream(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
BigDecimal |
getBigDecimal(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
BigInteger |
getBigInteger(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
InputStream |
getBinaryStream(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
Blob |
getBlob(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
Object |
getBlobObject(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
boolean |
getBoolean(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
byte |
getByte(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
byte[] |
getBytes(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
protected String |
getCatalogNameForMetadata(String catalogName)
Returns the catalog name that will be used for obtaining information from DatabaseMetaData . |
char |
getChar(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
Reader |
getCharacterStream(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
Clob |
getClob(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
String |
getClobString(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
protected String |
getColumnNameForMetadata(String columnName)
Returns the column name that will be used for obtaining information from DatabaseMetaData . |
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[] |
getCreateIndexSQL(Index index)
Return a series of SQL statements to create the given index. |
String[] |
getCreateTableSQL(Table table)
Return a series of SQL statements to create the given table, complete with columns. |
Date |
getDate(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
Date |
getDate(ResultSet rs,
int column,
Calendar cal)
Convert the specified column of the SQL ResultSet to the proper java type. |
protected String |
getDeclareColumnSQL(Column col,
boolean alter)
Return the declaration SQL for the given column. |
double |
getDouble(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
String[] |
getDropColumnSQL(Column column)
Return a series of SQL statements to drop the given column from its table. |
String[] |
getDropForeignKeySQL(ForeignKey fk)
Return a series of SQL statements to drop the given foreign key from its table. |
String[] |
getDropIndexSQL(Index index)
Return a series of SQL statements to drop the given index. |
String[] |
getDropPrimaryKeySQL(PrimaryKey pk)
Return a series of SQL statements to drop the given primary key from its table. |
String[] |
getDropTableSQL(Table table)
Return a series of SQL statements to drop the given table. |
float |
getFloat(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
protected String |
getForeignKeyConstraintSQL(ForeignKey fk)
Return the declaration SQL for the given foreign key, or null if it is not supported. |
protected SQLBuffer |
getFrom(Select sel,
boolean forUpdate)
Return the portion of the select statement between the FROM keyword and the WHERE keyword. |
protected SQLBuffer |
getFromSelect(Select sel,
boolean forUpdate)
Return the FROM clause for a select that selects from a tmp table created by an inner select. |
String |
getFullName(Index index)
Returns the full name of the index, including the schema (delimited by the result of catalogSeparator ). |
String |
getFullName(Table table,
boolean logical)
Returns the full name of the table, including the schema (delimited by '.' if logical , else catalogSeparator ). |
long |
getGeneratedKey(Column col,
Connection conn)
Return the last inserted auto increment value for the given column. |
protected String |
getGeneratedKeySequenceName(Column col)
Return the sequence name used by databases for the given autoincrement 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. |
int |
getInt(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
int |
getJDBCType(int metaTypeCode,
boolean lob)
Return the preferred Types constant for the given
JDBCTypes constant. |
Locale |
getLocale(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
long |
getLong(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
Number |
getNumber(ResultSet rs,
int column)
Returns the specified column value as an unknown numeric type; we try from the most generic to the least generic. |
Object |
getObject(ResultSet rs,
int column,
Map map)
Convert the specified column of the SQL ResultSet to the proper java type. |
int |
getPreferredType(int type)
Return the preferred Types type for the given one. |
protected String |
getPrimaryKeyConstraintSQL(PrimaryKey pk)
Return the declaration SQL for the given primary key. |
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 PrimaryKey[] |
getPrimaryKeysFromBestRowIdentifier(DatabaseMetaData meta,
String catalog,
String schemaName,
String tableName,
Connection conn)
Reflect on the schema to find primary keys for the given table pattern. |
protected PrimaryKey[] |
getPrimaryKeysFromGetPrimaryKeys(DatabaseMetaData meta,
String catalog,
String schemaName,
String tableName,
Connection conn)
Reflect on the schema to find primary keys for the given table pattern. |
Ref |
getRef(ResultSet rs,
int column,
Map map)
Convert the specified column of the SQL ResultSet to the proper java type. |
protected String |
getSchemaNameForMetadata(String schemaName)
Returns the schema name that will be used for obtaining information from DatabaseMetaData . |
protected SQLBuffer |
getSelects(Select sel,
boolean distinctIdentifiers,
boolean forUpdate)
Return the portion of the select statement between the SELECT keyword and the FROM keyword. |
short |
getShort(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
String |
getString(ResultSet rs,
int column)
Convert the specified column of the SQL ResultSet to the proper java type. |
protected String |
getTableNameForMetadata(String tableName)
Returns the table name that will be used for obtaining information from DatabaseMetaData . |
Table[] |
getTables(DatabaseMetaData meta,
String catalog,
String schemaName,
String tableName,
Connection conn)
Reflect on the schema to find tables matching the given name pattern. |
Time |
getTime(ResultSet rs,
int column,
Calendar cal)
Convert the specified column of the SQL ResultSet to the proper java type. |
Timestamp |
getTimestamp(ResultSet rs,
int column,
Calendar cal)
Convert the specified column of the SQL ResultSet to the proper java type. |
protected String |
getTypeName(Column col)
Return the preferred database type name for the given column's type from Types . |
String |
getValidColumnName(String name,
Table table)
Make any necessary changes to the given column name to make it valid for the current DB. |
String |
getValidForeignKeyName(String name,
Table table,
Table toTable)
Make any necessary changes to the given foreign key name to make it valid for the current DB. |
String |
getValidIndexName(String name,
Table table)
Make any necessary changes to the given index name to make it valid for the current DB. |
String |
getValidPrimaryKeyName(String name,
Table table)
Make any necessary changes to the given primary key name to make it valid for the current DB. |
String |
getValidTableName(String name,
Schema schema)
Make any necessary changes to the given table name to make it valid for the current DB. |
protected SQLBuffer |
getWhere(Select sel,
boolean forUpdate)
Return the WHERE portion of the select statement, or null if no where conditions. |
void |
indexOf(SQLBuffer buf,
FilterValue str,
FilterValue find,
FilterValue start)
Invoke this database's indexOf function. |
boolean |
isSystemIndex(String name,
Table table)
This method is used to filter system indexes from database metadata. |
boolean |
isSystemTable(String name,
String schema,
boolean targetSchema)
This method is used to filter system tables from database metadata. |
protected String |
makeNameValid(String name,
NameSet set,
int maxLen)
Shortens the given name to the given maximum length, then checks that it is not a reserved word. |
protected Column |
newColumn(ResultSet colMeta)
Create a new column from the information in the schema metadata. |
JDOException |
newDataStoreException(String msg,
SQLException[] causes,
Object failed)
Return a new JDO exception that wraps causes . |
protected ForeignKey |
newForeignKey(ResultSet fkMeta)
Create a new foreign key from the information in the schema metadata. |
protected Index |
newIndex(ResultSet idxMeta)
Create a new index from the information in the schema metadata. |
protected PrimaryKey |
newPrimaryKey(ResultSet pkMeta)
Create a new primary key from the information in the schema metadata. |
protected Table |
newTable(ResultSet tableMeta)
Create a new table from the information in the schema metadata. |
void |
refSchemaComponents(Table table)
Increment the reference count of any table components that this dictionary adds that are not used by mappings. |
ClassMapping |
replaceMapping(ClassMapping mapping)
Replace the given mapping with one suited to this database, or return the original if no replacement is needed. |
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 |
setArray(PreparedStatement stmnt,
int idx,
Array val)
Deprecated. |
void |
setArray(PreparedStatement stmnt,
int idx,
Array val,
Column col)
Set the given value as a parameter to the statement. |
void |
setAsciiStream(PreparedStatement stmnt,
int idx,
InputStream val,
int length)
Deprecated. |
void |
setAsciiStream(PreparedStatement stmnt,
int idx,
InputStream val,
int length,
Column col)
Set the given value as a parameter to the statement. |
void |
setBigDecimal(PreparedStatement stmnt,
int idx,
BigDecimal val)
Deprecated. |
void |
setBigDecimal(PreparedStatement stmnt,
int idx,
BigDecimal val,
Column col)
Set the given value as a parameter to the statement. |
void |
setBigInteger(PreparedStatement stmnt,
int idx,
BigInteger val)
Deprecated. |
void |
setBigInteger(PreparedStatement stmnt,
int idx,
BigInteger val,
Column col)
Set the given value as a parameter to the statement. |
void |
setBinaryStream(PreparedStatement stmnt,
int idx,
InputStream val,
int length)
Deprecated. |
void |
setBinaryStream(PreparedStatement stmnt,
int idx,
InputStream val,
int length,
Column col)
Set the given value as a parameter to the statement. |
void |
setBlob(PreparedStatement stmnt,
int idx,
Blob val)
Deprecated. |
void |
setBlob(PreparedStatement stmnt,
int idx,
Blob val,
Column col)
Set the given value as a parameter to the statement. |
void |
setBlobObject(PreparedStatement stmnt,
int idx,
Object val)
Deprecated. |
void |
setBlobObject(PreparedStatement stmnt,
int idx,
Object val,
Column col)
Set the given value as a parameter to the statement. |
void |
setBoolean(PreparedStatement stmnt,
int idx,
boolean val)
Deprecated. |
void |
setBoolean(PreparedStatement stmnt,
int idx,
boolean val,
Column col)
Set the given value as a parameter to the statement. |
void |
setByte(PreparedStatement stmnt,
int idx,
byte val)
Deprecated. |
void |
setByte(PreparedStatement stmnt,
int idx,
byte val,
Column col)
Set the given value as a parameter to the statement. |
void |
setBytes(PreparedStatement stmnt,
int idx,
byte[] val)
Deprecated. |
void |
setBytes(PreparedStatement stmnt,
int idx,
byte[] val,
Column col)
Set the given value as a parameter to the statement. |
void |
setChar(PreparedStatement stmnt,
int idx,
char val)
Deprecated. |
void |
setChar(PreparedStatement stmnt,
int idx,
char val,
Column col)
Set the given value as a parameter to the statement. |
void |
setCharacterStream(PreparedStatement stmnt,
int idx,
Reader val,
int length)
Deprecated. |
void |
setCharacterStream(PreparedStatement stmnt,
int idx,
Reader val,
int length,
Column col)
Set the given value as a parameter to the statement. |
void |
setClob(PreparedStatement stmnt,
int idx,
Clob val)
Deprecated. |
void |
setClob(PreparedStatement stmnt,
int idx,
Clob val,
Column col)
Set the given value as a parameter to the statement. |
void |
setClobString(PreparedStatement stmnt,
int idx,
String val)
Deprecated. |
void |
setClobString(PreparedStatement stmnt,
int idx,
String val,
Column col)
Set the given value as a parameter to the statement. |
void |
setConfiguration(Configuration conf)
Invoked prior to setting bean properties. |
void |
setDate(PreparedStatement stmnt,
int idx,
Date val)
Deprecated. |
void |
setDate(PreparedStatement stmnt,
int idx,
Date val,
Calendar cal)
Deprecated. |
void |
setDate(PreparedStatement stmnt,
int idx,
Date val,
Calendar cal,
Column col)
Set the given value as a parameter to the statement. |
void |
setDate(PreparedStatement stmnt,
int idx,
Date val,
Column col)
Set the given value as a parameter to the statement. |
void |
setDouble(PreparedStatement stmnt,
int idx,
double val)
Deprecated. |
void |
setDouble(PreparedStatement stmnt,
int idx,
double val,
Column col)
Set the given value as a parameter to the statement. |
void |
setFloat(PreparedStatement stmnt,
int idx,
float val)
Deprecated. |
void |
setFloat(PreparedStatement stmnt,
int idx,
float val,
Column col)
Set the given value as a parameter to the statement. |
void |
setInt(PreparedStatement stmnt,
int idx,
int val)
Deprecated. |
void |
setInt(PreparedStatement stmnt,
int idx,
int val,
Column col)
Set the given value as a parameter to the statement. |
void |
setJoinSyntax(String syntax)
Set the name of the join syntax to use: sql92, traditional, database |
void |
setLocale(PreparedStatement stmnt,
int idx,
Locale val)
Deprecated. |
void |
setLocale(PreparedStatement stmnt,
int idx,
Locale val,
Column col)
Set the given value as a parameter to the statement. |
void |
setLong(PreparedStatement stmnt,
int idx,
long val)
Deprecated. |
void |
setLong(PreparedStatement stmnt,
int idx,
long val,
Column col)
Set the given value as a parameter to the statement. |
void |
setNull(PreparedStatement stmnt,
int idx,
int colType)
Deprecated. |
void |
setNull(PreparedStatement stmnt,
int idx,
int colType,
Column col)
Set the given value as a parameters to the statement. |
void |
setObject(PreparedStatement stmnt,
int idx,
Object val,
int colType)
Deprecated. |
void |
setObject(PreparedStatement stmnt,
int idx,
Object val,
int colType,
Column col)
Set the given value as a parameters to the statement. |
void |
setRef(PreparedStatement stmnt,
int idx,
Ref val)
Deprecated. |
void |
setRef(PreparedStatement stmnt,
int idx,
Ref val,
Column col)
Set the given value as a parameter to the statement. |
void |
setShort(PreparedStatement stmnt,
int idx,
short val)
Deprecated. |
void |
setShort(PreparedStatement stmnt,
int idx,
short val,
Column col)
Set the given value as a parameter to the statement. |
void |
setString(PreparedStatement stmnt,
int idx,
String val)
Deprecated. |
void |
setString(PreparedStatement stmnt,
int idx,
String val,
Column col)
Set the given value as a parameter to the statement. |
void |
setTime(PreparedStatement stmnt,
int idx,
Time val,
Calendar cal)
Deprecated. |
void |
setTime(PreparedStatement stmnt,
int idx,
Time val,
Calendar cal,
Column col)
Set the given value as a parameter to the statement. |
void |
setTimestamp(PreparedStatement stmnt,
int idx,
Timestamp val,
Calendar cal)
Deprecated. |
void |
setTimestamp(PreparedStatement stmnt,
int idx,
Timestamp val,
Calendar cal,
Column col)
Set the given value as a parameter to the statement. |
void |
setUnknown(PreparedStatement stmnt,
int idx,
Object val)
Deprecated. |
void |
setUnknown(PreparedStatement stmnt,
int idx,
Object val,
Column col)
Set a completely unknown parameter into a prepared statement. |
void |
startConfiguration()
Invoked before bean property configuration is begun on this object. |
protected void |
storageWarning(Object orig,
Object converted)
Warn that a particular value could not be stored precisely. |
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. |
boolean |
supportsRandomAccessResultSet(Select sel,
boolean forUpdate)
Return false if the given select requires a forward-only result set. |
SQLBuffer |
toNativeJoin(Join join)
Use the given join instance to create SQL joining its tables in the database's native syntax. |
SQLBuffer |
toSelect(Select sel,
boolean forUpdate)
Create a SELECT statement in the proper join syntax for the given instance. |
SQLBuffer |
toSelect(SQLBuffer selects,
SQLBuffer from,
SQLBuffer where,
SQLBuffer group,
SQLBuffer having,
SQLBuffer order,
boolean distinct,
boolean forUpdate,
long start,
long end)
Combine the given components into a SELECT statement. |
SQLBuffer |
toSelectCount(Select sel)
Create a SELECT COUNT statement in the proper join syntax for the given instance. |
SQLBuffer |
toSQL92Join(Join join,
boolean forUpdate,
boolean first)
Use the given join instance to create SQL joining its tables in the SQL92 style. |
SQLBuffer |
toTraditionalJoin(Join join)
Use the given join instance to create SQL joining its tables in the traditional style. |
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_OTHER
public static final String VENDOR_DATADIRECT
public static final String SCHEMA_CASE_UPPER
public static final String SCHEMA_CASE_LOWER
public static final String SCHEMA_CASE_PRESERVE
public static final String CONS_NAME_BEFORE
public static final String CONS_NAME_MID
public static final String CONS_NAME_AFTER
protected static final int RANGE_POST_SELECT
protected static final int RANGE_PRE_DISTINCT
protected static final int RANGE_POST_DISTINCT
protected static final int NANO
protected static final int MICRO
protected static final int MILLI
protected static final int CENTI
protected static final int DECI
protected static final int SEC
public String platform
public String driverVendor
public String catalogSeparator
public boolean createPrimaryKeys
public String constraintNameMode
public int maxTableNameLength
public int maxColumnNameLength
public int maxPrimaryKeyNameLength
public int maxForeignKeyNameLength
public int maxIndexNameLength
public int maxAutoIncrementNameLength
public int maxIndexesPerTable
public boolean supportsForeignKeys
public boolean supportsDeferredConstraints
public boolean supportsRestrictDeleteAction
public boolean supportsCascadeDeleteAction
public boolean supportsNullDeleteAction
public boolean supportsDefaultDeleteAction
public boolean supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithDropColumn
public String reservedWords
public String systemSchemas
public String systemTables
public String schemaCase
public String validationSQL
public String initializationSQL
public int joinSyntax
public String outerJoinClause
public String innerJoinClause
public String crossJoinClause
public boolean requiresConditionForCrossJoin
public String forUpdateClause
public String tableForUpdateClause
public String toLowerCaseFunction
public String toUpperCaseFunction
public String stringLengthFunction
public String substringFunctionName
public String distinctCountColumnSeparator
public boolean supportsSelectForUpdate
public boolean supportsLockingWithDistinctClause
public boolean supportsLockingWithMultipleTables
public boolean supportsLockingWithOrderClause
public boolean supportsLockingWithOuterJoin
public boolean supportsLockingWithInnerJoin
public boolean supportsLockingWithSelectRange
public boolean supportsQueryTimeout
public boolean simulateLocking
public boolean supportsSubselect
public boolean supportsHaving
public boolean supportsSelectStartIndex
public boolean supportsSelectEndIndex
public int rangePosition
public boolean requiresAliasForSubselect
public int batchLimit
public int batchParameterLimit
public boolean supportsUpdateCountsForBatch
public boolean supportsTotalCountsForBatch
public boolean supportsMultipleNontransactionalResultSets
public boolean storageLimitationsFatal
public boolean storeLargeNumbersAsStrings
public boolean storeCharsAsNumbers
public boolean useGetBytesForBlobs
public boolean useSetBytesForBlobs
public boolean useGetObjectForBlobs
public boolean useGetStringForClobs
public boolean useSetStringForClobs
public int datePrecision
public int maxCharacterFieldLength
public String arrayTypeName
public String bigintTypeName
public String binaryTypeName
public String bitTypeName
public String blobTypeName
public String booleanTypeName
public String charTypeName
public String clobTypeName
public String dateTypeName
public String decimalTypeName
public String distinctTypeName
public String doubleTypeName
public String floatTypeName
public String integerTypeName
public String javaObjectTypeName
public String longVarbinaryTypeName
public String longVarcharTypeName
public String nullTypeName
public String numericTypeName
public String otherTypeName
public String realTypeName
public String refTypeName
public String smallintTypeName
public String structTypeName
public String timeTypeName
public String timestampTypeName
public String tinyintTypeName
public String varbinaryTypeName
public String varcharTypeName
public boolean useSchemaName
public String defaultSchemaName
public String tableTypes
public boolean supportsSchemaForGetTables
public boolean supportsSchemaForGetColumns
public boolean supportsNullTableForGetColumns
public boolean supportsNullTableForGetPrimaryKeys
public boolean supportsNullTableForGetIndexInfo
public boolean supportsNullTableForGetImportedKeys
public boolean useGetBestRowIdentifierForPrimaryKeys
public boolean requiresAutoCommitForMetadata
public String autoIncrementClause
public String autoIncrementTypeName
public boolean supportsAutoIncrement
public String lastGeneratedKeyQuery
protected JDBCConfiguration conf
protected Log log
protected boolean connected
protected final Set reservedWordSet
protected final Set systemSchemaSet
protected final Set systemTableSet
protected final Set fixedSizeTypeNameSet
Constructor Detail |
public DBDictionary()
Method Detail |
public void connectedConfiguration(Connection conn) throws SQLException
super.connectedConfiguration
.public Array getArray(ResultSet rs, int column) throws SQLException
public InputStream getAsciiStream(ResultSet rs, int column) throws SQLException
public BigDecimal getBigDecimal(ResultSet rs, int column) throws SQLException
public Number getNumber(ResultSet rs, int column) throws SQLException
public BigInteger getBigInteger(ResultSet rs, int column) throws SQLException
public InputStream getBinaryStream(ResultSet rs, int column) throws SQLException
public Blob getBlob(ResultSet rs, int column) throws SQLException
public Object getBlobObject(ResultSet rs, int column) throws SQLException
public boolean getBoolean(ResultSet rs, int column) throws SQLException
public byte getByte(ResultSet rs, int column) throws SQLException
public byte[] getBytes(ResultSet rs, int column) throws SQLException
public char getChar(ResultSet rs, int column) throws SQLException
public Reader getCharacterStream(ResultSet rs, int column) throws SQLException
public Clob getClob(ResultSet rs, int column) throws SQLException
public String getClobString(ResultSet rs, int column) throws SQLException
public Date getDate(ResultSet rs, int column) throws SQLException
Timestamp
by default.public Date getDate(ResultSet rs, int column, Calendar cal) throws SQLException
public double getDouble(ResultSet rs, int column) throws SQLException
public float getFloat(ResultSet rs, int column) throws SQLException
public int getInt(ResultSet rs, int column) throws SQLException
public Locale getLocale(ResultSet rs, int column) throws SQLException
public long getLong(ResultSet rs, int column) throws SQLException
public Object getObject(ResultSet rs, int column, Map map) throws SQLException
public Ref getRef(ResultSet rs, int column, Map map) throws SQLException
public short getShort(ResultSet rs, int column) throws SQLException
public String getString(ResultSet rs, int column) throws SQLException
public Time getTime(ResultSet rs, int column, Calendar cal) throws SQLException
public Timestamp getTimestamp(ResultSet rs, int column, Calendar cal) throws SQLException
public void setArray(PreparedStatement stmnt, int idx, Array val) throws SQLException
public void setArray(PreparedStatement stmnt, int idx, Array val, Column col) throws SQLException
public void setAsciiStream(PreparedStatement stmnt, int idx, InputStream val, int length) throws SQLException
public void setAsciiStream(PreparedStatement stmnt, int idx, InputStream val, int length, Column col) throws SQLException
public void setBigDecimal(PreparedStatement stmnt, int idx, BigDecimal val) throws SQLException
public void setBigDecimal(PreparedStatement stmnt, int idx, BigDecimal val, Column col) throws SQLException
public void setBigInteger(PreparedStatement stmnt, int idx, BigInteger val) throws SQLException
public void setBigInteger(PreparedStatement stmnt, int idx, BigInteger val, Column col) throws SQLException
public void setBinaryStream(PreparedStatement stmnt, int idx, InputStream val, int length) throws SQLException
public void setBinaryStream(PreparedStatement stmnt, int idx, InputStream val, int length, Column col) throws SQLException
public void setBlob(PreparedStatement stmnt, int idx, Blob val) throws SQLException
public void setBlob(PreparedStatement stmnt, int idx, Blob val, Column col) throws SQLException
public void setBlobObject(PreparedStatement stmnt, int idx, Object val) throws SQLException
public void setBlobObject(PreparedStatement stmnt, int idx, Object val, Column col) throws SQLException
serialize(java.lang.Object)
method to serialize the value.public byte[] serialize(Object val) throws SQLException
public void setBoolean(PreparedStatement stmnt, int idx, boolean val) throws SQLException
public void setBoolean(PreparedStatement stmnt, int idx, boolean val, Column col) throws SQLException
public void setByte(PreparedStatement stmnt, int idx, byte val) throws SQLException
public void setByte(PreparedStatement stmnt, int idx, byte val, Column col) throws SQLException
public void setBytes(PreparedStatement stmnt, int idx, byte[] val) throws SQLException
public void setBytes(PreparedStatement stmnt, int idx, byte[] val, Column col) throws SQLException
public void setChar(PreparedStatement stmnt, int idx, char val) throws SQLException
public void setChar(PreparedStatement stmnt, int idx, char val, Column col) throws SQLException
public void setCharacterStream(PreparedStatement stmnt, int idx, Reader val, int length) throws SQLException
public void setCharacterStream(PreparedStatement stmnt, int idx, Reader val, int length, Column col) throws SQLException
public void setClob(PreparedStatement stmnt, int idx, Clob val) throws SQLException
public void setClob(PreparedStatement stmnt, int idx, Clob val, Column col) throws SQLException
public void setClobString(PreparedStatement stmnt, int idx, String val) throws SQLException
public void setClobString(PreparedStatement stmnt, int idx, String val, Column col) throws SQLException
public void setDate(PreparedStatement stmnt, int idx, Date val) throws SQLException
public void setDate(PreparedStatement stmnt, int idx, Date val, Column col) throws SQLException
Timestamp
by default.public void setDate(PreparedStatement stmnt, int idx, Date val, Calendar cal) throws SQLException
public void setDate(PreparedStatement stmnt, int idx, Date val, Calendar cal, Column col) throws SQLException
public void setDouble(PreparedStatement stmnt, int idx, double val) throws SQLException
public void setDouble(PreparedStatement stmnt, int idx, double val, Column col) throws SQLException
public void setFloat(PreparedStatement stmnt, int idx, float val) throws SQLException
public void setFloat(PreparedStatement stmnt, int idx, float val, Column col) throws SQLException
public void setInt(PreparedStatement stmnt, int idx, int val) throws SQLException
public void setInt(PreparedStatement stmnt, int idx, int val, Column col) throws SQLException
public void setLong(PreparedStatement stmnt, int idx, long val) throws SQLException
public void setLong(PreparedStatement stmnt, int idx, long val, Column col) throws SQLException
public void setLocale(PreparedStatement stmnt, int idx, Locale val) throws SQLException
public void setLocale(PreparedStatement stmnt, int idx, Locale val, Column col) throws SQLException
public void setNull(PreparedStatement stmnt, int idx, int colType) throws SQLException
public void setNull(PreparedStatement stmnt, int idx, int colType, Column col) throws SQLException
Types
.public void setObject(PreparedStatement stmnt, int idx, Object val, int colType) throws SQLException
public void setObject(PreparedStatement stmnt, int idx, Object val, int colType, Column col) throws SQLException
Types
.public void setRef(PreparedStatement stmnt, int idx, Ref val) throws SQLException
public void setRef(PreparedStatement stmnt, int idx, Ref val, Column col) throws SQLException
public void setShort(PreparedStatement stmnt, int idx, short val) throws SQLException
public void setShort(PreparedStatement stmnt, int idx, short val, Column col) throws SQLException
public void setString(PreparedStatement stmnt, int idx, String val) throws SQLException
public void setString(PreparedStatement stmnt, int idx, String val, Column col) throws SQLException
public void setTime(PreparedStatement stmnt, int idx, Time val, Calendar cal) throws SQLException
public void setTime(PreparedStatement stmnt, int idx, Time val, Calendar cal, Column col) throws SQLException
public void setTimestamp(PreparedStatement stmnt, int idx, Timestamp val, Calendar cal) throws SQLException
public void setTimestamp(PreparedStatement stmnt, int idx, Timestamp val, Calendar cal, Column col) throws SQLException
public void setUnknown(PreparedStatement stmnt, int idx, Object val) throws SQLException
public void setUnknown(PreparedStatement stmnt, int idx, Object val, Column col) throws SQLException
protected void storageWarning(Object orig, Object converted)
public int getJDBCType(int metaTypeCode, boolean lob)
Types
constant for the given
JDBCTypes
constant.public int getPreferredType(int type)
Types
type for the given one. Returns
the given type by default.protected String getTypeName(Column col)
Types
.protected String appendSize(Column col, String typeName)
fixedSizeTypeNameSet
).public boolean canBatch(Column col)
public void setJoinSyntax(String syntax)
public SQLBuffer toSelectCount(Select sel)
public SQLBuffer toSelect(Select sel, boolean forUpdate)
protected SQLBuffer getFrom(Select sel, boolean forUpdate)
protected SQLBuffer getFromSelect(Select sel, boolean forUpdate)
protected SQLBuffer getWhere(Select sel, boolean forUpdate)
public SQLBuffer toTraditionalJoin(Join join)
public SQLBuffer toSQL92Join(Join join, boolean forUpdate, boolean first)
public SQLBuffer toNativeJoin(Join join)
public boolean canOuterJoin(int syntax, ForeignKey fk)
public SQLBuffer toSelect(SQLBuffer selects, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end)
protected void appendSelectRange(SQLBuffer buf, long start, long end)
protected SQLBuffer getSelects(Select sel, boolean distinctIdentifiers, boolean forUpdate)
public boolean supportsLocking(Select sel)
public boolean supportsRandomAccessResultSet(Select sel, boolean forUpdate)
public void assertSupport(boolean feature, String property)
public void substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
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 indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
buf
- the SQL buffer to write the indexOf invocation tostr
- a query value representing the target stringsearch
- a query value representing the search stringstart
- a query value representing the start index, or null
to start at the beginningpublic void refSchemaComponents(Table table)
public String getFullName(Table table, boolean logical)
logical
, else catalogSeparator
).public String getFullName(Index index)
catalogSeparator
).public String getValidTableName(String name, Schema schema)
public String getValidColumnName(String name, Table table)
public String getValidPrimaryKeyName(String name, Table table)
public String getValidForeignKeyName(String name, Table table, Table toTable)
public String getValidIndexName(String name, Table table)
protected String makeNameValid(String name, NameSet set, int maxLen)
public String[] getCreateTableSQL(Table table)
public String[] getDropTableSQL(Table table)
DROP TABLE <table name>
by default.public String[] getCreateIndexSQL(Index index)
CREATE [UNIQUE] INDEX <index name> ON <table name>
(<col list>)
by default.public String[] getDropIndexSQL(Index index)
DROP INDEX <index name>
by default.public String[] getAddColumnSQL(Column column)
DBMetaData
is checked for support automatically. Returns
ALTER TABLE <table name> ADD (<col dec>)
by default.public String[] getDropColumnSQL(Column column)
DBMetaData
is checked for support automatically. Returns
ALTER TABLE <table name> DROP COLUMN <col name>
by default.public String[] getAddPrimaryKeySQL(PrimaryKey pk)
ALTER TABLE <table name> ADD
<pk cons sql >
by default.public String[] getDropPrimaryKeySQL(PrimaryKey pk)
ALTER TABLE <table name> DROP CONSTRAINT
<pk name>
by default.public String[] getAddForeignKeySQL(ForeignKey fk)
ALTER TABLE <table name> ADD
<fk cons sql >
by default.public String[] getDropForeignKeySQL(ForeignKey fk)
ALTER TABLE <table name> DROP CONSTRAINT
<fk name>
by default.protected String getDeclareColumnSQL(Column col, boolean alter)
getCreateTableSQL(kodo.jdbc.schema.Table)
and
getAddColumnSQL(kodo.jdbc.schema.Column)
.protected String getPrimaryKeyConstraintSQL(PrimaryKey pk)
getCreateTableSQL(kodo.jdbc.schema.Table)
and
getAddPrimaryKeySQL(kodo.jdbc.schema.PrimaryKey)
. Returns
CONSTRAINT <pk name> PRIMARY KEY (<col list>)
by default.protected String getForeignKeyConstraintSQL(ForeignKey fk)
getAddForeignKeySQL(kodo.jdbc.schema.ForeignKey)
. Returns
CONSTRAINT <cons name> FOREIGN KEY (<col list>)
REFERENCES <foreign table> (<col list>)
[ON DELETE <action>]
by default.public boolean isSystemTable(String name, String schema, boolean targetSchema)
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 JDO schemaspublic boolean isSystemIndex(String name, Table table)
name
- the index nametable
- the index tablepublic Table[] getTables(DatabaseMetaData meta, String catalog, String schemaName, String tableName, Connection conn) throws SQLException
protected Table newTable(ResultSet tableMeta) throws SQLException
public Column[] getColumns(DatabaseMetaData meta, String catalog, String schemaName, String tableName, String columnName, Connection conn) throws SQLException
protected Column newColumn(ResultSet colMeta) throws SQLException
public PrimaryKey[] getPrimaryKeys(DatabaseMetaData meta, String catalog, String schemaName, String tableName, Connection conn) throws SQLException
protected PrimaryKey[] getPrimaryKeysFromGetPrimaryKeys(DatabaseMetaData meta, String catalog, String schemaName, String tableName, Connection conn) throws SQLException
protected PrimaryKey newPrimaryKey(ResultSet pkMeta) throws SQLException
protected PrimaryKey[] getPrimaryKeysFromBestRowIdentifier(DatabaseMetaData meta, String catalog, String schemaName, String tableName, Connection conn) throws SQLException
public Index[] getIndexInfo(DatabaseMetaData meta, String catalog, String schemaName, String tableName, boolean unique, boolean approx, Connection conn) throws SQLException
protected Index newIndex(ResultSet idxMeta) throws SQLException
public ForeignKey[] getImportedKeys(DatabaseMetaData meta, String catalog, String schemaName, String tableName, Connection conn) throws SQLException
protected ForeignKey newForeignKey(ResultSet fkMeta) throws SQLException
protected String getTableNameForMetadata(String tableName)
DatabaseMetaData
.protected String getSchemaNameForMetadata(String schemaName)
DatabaseMetaData
.protected String getCatalogNameForMetadata(String catalogName)
DatabaseMetaData
.protected String getColumnNameForMetadata(String columnName)
DatabaseMetaData
.protected String convertSchemaCase(String objectName)
public long getGeneratedKey(Column col, Connection conn) throws SQLException
lastGeneratedKeyQuery
is null.protected String getGeneratedKeySequenceName(Column col)
public ClassMapping replaceMapping(ClassMapping mapping)
public FieldMapping replaceMapping(FieldMapping mapping)
public MappingFactory replaceMappingFactory(MappingFactory factory)
public SchemaFactory replaceSchemaFactory(SchemaFactory factory)
public void setConfiguration(Configuration conf)
Configurable
setConfiguration
in interface Configurable
public void startConfiguration()
Configurable
startConfiguration
in interface Configurable
public void endConfiguration()
Configurable
endConfiguration
in interface Configurable
public Connection decorate(Connection conn) throws SQLException
initializationSQL
that has been set for the dictionary but
does not decoreate the connection.decorate
in interface ConnectionDecorator
public JDOException newDataStoreException(String msg, SQLException[] causes, Object failed)
causes
.
However, the details of exactly what type of exception is returned can
be determined by the implementation. This may take into account
DB-specific exception information in causes
.
|
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 |