| java.lang.Object com.versant.core.jdbc.sql.SqlDriver com.versant.core.jdbc.sql.InformixSESqlDriver
InformixSESqlDriver | public class InformixSESqlDriver extends SqlDriver (Code) | | A driver for Informix SE using the ifxjdbc JDBC driver.
|
Method Summary | |
protected void | addPrimaryKeyConstraint(JdbcTable t, CharBuf s) Add the primary key constraint in isolation. | protected void | addSequenceColumn(JdbcTable t, JdbcColumn c, CharBuf s, boolean comments) | protected void | appendAddNewColumn(JdbcTable t, JdbcColumn c, CharBuf s, boolean comments) Append a column that needs to be added. | protected void | appendCreateColumn(JdbcTable t, JdbcColumn c, CharBuf s, boolean comments) Append the part of a create table statement for a column. | protected void | appendDropColumn(TableDiff tableDiff, JdbcColumn c, CharBuf s, boolean comments) Append a column that needs to be added. | protected void | appendDropIndex(CharBuf s, JdbcTable t, JdbcIndex idx, boolean comments) Generate a 'drop index' statement for idx. | protected void | appendModifyColumn(TableDiff tableDiff, ColumnDiff diff, CharBuf s, boolean comments) Append a column that needs to be added. | protected void | appendRefDropConstraint(CharBuf s, JdbcConstraint c, boolean comments) Append an 'drop constraint' statement for c. | protected void | dropPrimaryKeyConstraint(JdbcTable t, CharBuf s) Drop the primary key constraint in isolation. | protected void | dropSequenceColumn(JdbcTable t, JdbcColumn c, CharBuf s, boolean comments) | public Object | getAutoIncColumnValue(JdbcTable classTable, Connection con, Statement stat) Retrieve the value of the autoinc or serial column for a row just
inserted using stat on con. | public String | getConnectionInitSQL() Get default SQL used to init a connection or null if none required. | public String | getConnectionValidateSQL() Get default SQL to test a connection or null if none available. | public HashMap | getDBSchema(Connection con, ControlParams params) Get the JdbcTable from the database for the given database connection and table name. | public HashMap | getJavaTypeMappings() Get the default field mappings for this driver. | public String | getName() | public char[] | getSelectForUpdate() Get whatever needs to be appended to a SELECT statement to lock the
rows if this makes sense for the database. | protected JdbcTypeMapping | getTypeMapping(int jdbcType) Get the default type mapping for the supplied JDBC type code from
java.sql.Types or null if the type is not supported. | public boolean | isAutoIncSupported() | public boolean | isInsertBatchingSupported() | public boolean | isLikeStupid() Does the LIKE operator only support literal string and column
arguments (e.g. | public boolean | isOptimizeExistsUnderOrToOuterJoin() | public boolean | isPreparedStatementPoolingOK() | public boolean | isPutOrderColsInSelect() | public boolean | isScrollableResultSetSupported() | public boolean | isSetTransactionIsolationLevelSupported() | public boolean | isUpdateBatchingSupported() | public boolean | isUseIndexesForOrderCols() Should indexes be used for columns in the order by list that are
also in the select list? This is used for databases that will not
order by a column that is duplicated in the select list (e.g. | protected boolean | isValidSchemaTable(String tableName) | protected boolean | useZeroScale(JdbcColumn c) |
InformixSESqlDriver | public InformixSESqlDriver()(Code) | | |
addPrimaryKeyConstraint | protected void addPrimaryKeyConstraint(JdbcTable t, CharBuf s)(Code) | | Add the primary key constraint in isolation.
|
appendCreateColumn | protected void appendCreateColumn(JdbcTable t, JdbcColumn c, CharBuf s, boolean comments)(Code) | | Append the part of a create table statement for a column.
|
appendModifyColumn | protected void appendModifyColumn(TableDiff tableDiff, ColumnDiff diff, CharBuf s, boolean comments)(Code) | | Append a column that needs to be added.
|
appendRefDropConstraint | protected void appendRefDropConstraint(CharBuf s, JdbcConstraint c, boolean comments)(Code) | | Append an 'drop constraint' statement for c.
|
dropPrimaryKeyConstraint | protected void dropPrimaryKeyConstraint(JdbcTable t, CharBuf s)(Code) | | Drop the primary key constraint in isolation.
|
getConnectionInitSQL | public String getConnectionInitSQL()(Code) | | Get default SQL used to init a connection or null if none required.
|
getConnectionValidateSQL | public String getConnectionValidateSQL()(Code) | | Get default SQL to test a connection or null if none available. This
must be a query that returns at least one row.
|
getJavaTypeMappings | public HashMap getJavaTypeMappings()(Code) | | Get the default field mappings for this driver. These map java classes
to column properties. Subclasses should override this, call super() and
replace mappings as needed.
|
getSelectForUpdate | public char[] getSelectForUpdate()(Code) | | Get whatever needs to be appended to a SELECT statement to lock the
rows if this makes sense for the database. This must have a leading
space if not empty.
|
getTypeMapping | protected JdbcTypeMapping getTypeMapping(int jdbcType)(Code) | | Get the default type mapping for the supplied JDBC type code from
java.sql.Types or null if the type is not supported. There is no
need to set the database or jdbcType on the mapping as this is done
after this call returns. Subclasses should override this and to
customize type mappings.
|
isAutoIncSupported | public boolean isAutoIncSupported()(Code) | | Does this database support autoincrement or serial columns?
|
isInsertBatchingSupported | public boolean isInsertBatchingSupported()(Code) | | Does the JDBC driver support statement batching?
|
isLikeStupid | public boolean isLikeStupid()(Code) | | Does the LIKE operator only support literal string and column
arguments (e.g. Informix)?
|
isOptimizeExistsUnderOrToOuterJoin | public boolean isOptimizeExistsUnderOrToOuterJoin()(Code) | | Is it ok to convert simple 'exists (select ...)' clauses under an
'or' into outer joins?
|
isPreparedStatementPoolingOK | public boolean isPreparedStatementPoolingOK()(Code) | | Should PreparedStatement batching be used for this database and
JDBC driver?
|
isPutOrderColsInSelect | public boolean isPutOrderColsInSelect()(Code) | | Must columns used in an order by statement appear in the select list?
|
isScrollableResultSetSupported | public boolean isScrollableResultSetSupported()(Code) | | Does the JDBC driver support scrollable result sets?
|
isSetTransactionIsolationLevelSupported | public boolean isSetTransactionIsolationLevelSupported()(Code) | | Can the tx isolation level be set on this database?
|
isUpdateBatchingSupported | public boolean isUpdateBatchingSupported()(Code) | | Does the JDBC driver support statement batching for updates?
|
isUseIndexesForOrderCols | public boolean isUseIndexesForOrderCols()(Code) | | Should indexes be used for columns in the order by list that are
also in the select list? This is used for databases that will not
order by a column that is duplicated in the select list (e.g. Oracle).
|
isValidSchemaTable | protected boolean isValidSchemaTable(String tableName)(Code) | | |
Methods inherited from com.versant.core.jdbc.sql.SqlDriver | protected void add(HashMap ans, JdbcJavaTypeMapping m)(Code)(Java Doc) protected void addPrimaryKeyConstraint(JdbcTable t, CharBuf s)(Code)(Java Doc) protected void appendAddNewColumn(JdbcTable t, JdbcColumn c, CharBuf s, boolean comments)(Code)(Java Doc) protected void appendColumnNameList(JdbcColumn[] cols, CharBuf s)(Code)(Java Doc) protected void appendColumnType(JdbcColumn c, CharBuf s)(Code)(Java Doc) protected void appendColumnType(JdbcColumn c, CharBuf s, boolean useZeroScale)(Code)(Java Doc) protected void appendCreateColumn(JdbcTable t, JdbcColumn c, CharBuf s, boolean comments)(Code)(Java Doc) protected void appendCreateColumnAutoInc(JdbcTable t, JdbcColumn c, CharBuf s)(Code)(Java Doc) protected void appendCreateColumnNulls(JdbcTable t, JdbcColumn c, CharBuf s)(Code)(Java Doc) protected void appendCreateIndex(CharBuf s, JdbcTable t, JdbcIndex idx, boolean comments)(Code)(Java Doc) protected void appendDropColumn(TableDiff tableDiff, JdbcColumn c, CharBuf s, boolean comments)(Code)(Java Doc) protected void appendDropIndex(CharBuf s, JdbcTable t, JdbcIndex idx, boolean comments)(Code)(Java Doc) protected void appendIndexesInCreateTable(JdbcTable t, CharBuf s)(Code)(Java Doc) protected void appendModifyColumn(TableDiff tableDiff, ColumnDiff diff, CharBuf s, boolean comments)(Code)(Java Doc) protected void appendPrimaryKeyConstraint(JdbcTable t, CharBuf s)(Code)(Java Doc) protected void appendRefConstraint(CharBuf s, JdbcConstraint c)(Code)(Java Doc) protected void appendRefDropConstraint(CharBuf s, JdbcConstraint c, boolean comments)(Code)(Java Doc) public void appendSqlColumn(JdbcColumn col, String alias, CharBuf s)(Code)(Java Doc) public void appendSqlFrom(JdbcTable table, String alias, CharBuf s)(Code)(Java Doc) public void appendSqlFromJoin(JdbcTable table, String alias, SqlExp exp, boolean outer, CharBuf s)(Code)(Java Doc) public void appendSqlJoin(String leftAlias, JdbcColumn left, String rightAlias, JdbcColumn right, boolean outer, CharBuf s)(Code)(Java Doc) public void appendSqlLiteral(int type, String value, CharBuf s)(Code)(Java Doc) protected void appendTableType(JdbcTable t, CharBuf s)(Code)(Java Doc) public void appendWhereParam(CharBuf s, JdbcColumn c)(Code)(Java Doc) public boolean checkDDL(ArrayList tables, Connection con, PrintWriter errors, PrintWriter fix, ControlParams params) throws SQLException(Code)(Java Doc) public boolean checkDDLForStartup(ArrayList tables, Connection con, PrintWriter out, PrintWriter fix, ControlParams params) throws SQLException(Code)(Java Doc) public boolean checkLenght(JdbcColumn ourCol, JdbcColumn dbCol)(Code)(Java Doc) public boolean checkNulls(JdbcColumn ourCol, JdbcColumn dbCol)(Code)(Java Doc) public boolean checkScale(JdbcColumn ourCol, JdbcColumn dbCol)(Code)(Java Doc) protected boolean checkTable(JdbcTable t, Statement stat, PrintWriter out)(Code)(Java Doc) public boolean checkType(JdbcColumn ourCol, JdbcColumn dbCol)(Code)(Java Doc) public void cleanupForGetQueryPlan(Connection con)(Code)(Java Doc) public String comment(String msg)(Code)(Java Doc) protected DefaultJdbcNameGenerator createDefaultJdbcNameGenerator()(Code)(Java Doc) public static Driver createJdbcDriver(String name, ClassLoader cl)(Code)(Java Doc) public JdbcNameGenerator createJdbcNameGenerator()(Code)(Java Doc) public static SqlDriver createSqlDriver(String name, Driver jdbcDriver)(Code)(Java Doc) public void customizeForServer(Connection con) throws SQLException(Code)(Java Doc) public static RuntimeException defaultMapException(Throwable cause, String message, boolean isFatal)(Code)(Java Doc) protected void dropPrimaryKeyConstraint(JdbcTable t, CharBuf s)(Code)(Java Doc) public void dropTable(Connection con, String table) throws SQLException(Code)(Java Doc) protected void dropTable(Connection con, String table, Statement stat) throws SQLException(Code)(Java Doc) public void enableIdentityInsert(Connection con, String table, boolean on) throws SQLException(Code)(Java Doc) public void fillDatabaseMetaData(ArrayList tables, HashMap dbMap)(Code)(Java Doc) public void fixAllNames(HashMap nameMap)(Code)(Java Doc) protected void fixColumnsNonDirect(TableDiff tableDiff, PrintWriter out)(Code)(Java Doc) protected void fixConstraintsForNonDirectColumns(TableDiff tableDiff, PrintWriter out, boolean drop)(Code)(Java Doc) protected void fixCoulumns(TableDiff tableDiff, PrintWriter out)(Code)(Java Doc) protected void fixIndexForNonDirectColumns(TableDiff tableDiff, PrintWriter out, boolean drop)(Code)(Java Doc) public void generateConstraints(JdbcTable t, Statement stat, PrintWriter out, boolean comments) throws SQLException(Code)(Java Doc) public void generateCreateIndexes(JdbcTable t, Statement stat, PrintWriter out, boolean comments) throws SQLException(Code)(Java Doc) public void generateCreateTable(JdbcTable t, Statement stat, PrintWriter out, boolean comments) throws SQLException(Code)(Java Doc) public void generateDDL(ArrayList tables, Connection con, PrintWriter out, boolean comments)(Code)(Java Doc) public int getAggregateTypeCode(int aggType, int currentTypeCode)(Code)(Java Doc) public String getAliasPrepend()(Code)(Java Doc) public Object getAutoIncColumnValue(JdbcTable classTable, Connection con, Statement stat) throws SQLException(Code)(Java Doc) public String getAutoIncPostInsertSQLSuffix(JdbcTable classTable)(Code)(Java Doc) protected String getCatalog(Connection con) throws SQLException(Code)(Java Doc) protected ColumnDiff getColumnDiffForName(TableDiff tableDiff, String name)(Code)(Java Doc) public String getConnectionInitSQL()(Code)(Java Doc) public String getConnectionValidateSQL()(Code)(Java Doc) protected ConstraintDiff getConstraintDiffForName(TableDiff tableDiff, String name, boolean db)(Code)(Java Doc) public HashMap getDBSchema(Connection con, ControlParams params) throws SQLException(Code)(Java Doc) public HashMap getDatabaseMetaData(ArrayList tables, Connection con) throws SQLException(Code)(Java Doc) protected String getDefaultForType(JdbcColumn ourCol)(Code)(Java Doc) public int getDefaultPsCacheMax()(Code)(Java Doc) protected String getDefaultValueComment()(Code)(Java Doc) public static String getDriverFromURL(String url)(Code)(Java Doc) protected IndexDiff getIndexDiffForName(TableDiff tableDiff, String name, boolean db)(Code)(Java Doc) public HashMap getJavaTypeMappings()(Code)(Java Doc) public int getMajorVersion()(Code)(Java Doc) public int getMaxInOperands()(Code)(Java Doc) public int getMinorVersion()(Code)(Java Doc) public String getMinorVersionPatchLevel()(Code)(Java Doc) abstract public String getName()(Code)(Java Doc) public static String getNameFromURL(String url)(Code)(Java Doc) public String getQueryPlan(Connection con, PreparedStatement ps)(Code)(Java Doc) public String getRunCommand()(Code)(Java Doc) protected String getSchema(Connection con)(Code)(Java Doc) public char[] getSelectForUpdate()(Code)(Java Doc) public String getSqlBinaryOp(int op)(Code)(Java Doc) public String getSqlParamString(int jdbcType)(Code)(Java Doc) public char[] getSqlParamStringChars(int jdbcType)(Code)(Java Doc) public String getSqlUnaryFunctionName(int func)(Code)(Java Doc) public ArrayList getTableNames(Connection con) throws SQLException(Code)(Java Doc) protected String getTempColumnName(JdbcTable table)(Code)(Java Doc) protected String getTempTableName(JdbcTable table, int lenght)(Code)(Java Doc) protected JdbcTypeMapping getTypeMapping(int jdbcType)(Code)(Java Doc) final public JdbcTypeMapping[] getTypeMappings()(Code)(Java Doc) protected String getTypeName(int jdbcType)(Code)(Java Doc) public String getVersion()(Code)(Java Doc) protected void init(Driver jdbcDriver)(Code)(Java Doc) boolean isAddSequenceColumn(JdbcColumn addColumn)(Code)(Java Doc) public boolean isAnsiJoinSyntax()(Code)(Java Doc) public boolean isAutoIncSupported()(Code)(Java Doc) public boolean isBatchingSupportedForJdbcType(int jdbcType)(Code)(Java Doc) public boolean isClearBatchRequired()(Code)(Java Doc) public boolean isCommentSupported()(Code)(Java Doc) public boolean isConvertExistsToDistinctJoin()(Code)(Java Doc) public boolean isConvertExistsToJoins(int type)(Code)(Java Doc) public boolean isCustomizeForServerRequired()(Code)(Java Doc) boolean isDirectAddColumnSupported(JdbcColumn ourCol)(Code)(Java Doc) boolean isDirectDropColumnSupported()(Code)(Java Doc) boolean isDirectLenghtColumnChangesSupported(JdbcColumn ourCol, JdbcColumn dbCol)(Code)(Java Doc) boolean isDirectNullColumnChangesSupported()(Code)(Java Doc) boolean isDirectScaleColumnChangesSupported(JdbcColumn ourCol, JdbcColumn dbCol)(Code)(Java Doc) boolean isDirectTypeColumnChangesSupported(JdbcColumn ourCol, JdbcColumn dbCol)(Code)(Java Doc) boolean isDropConstraintsForDropTableSupported()(Code)(Java Doc) boolean isDropPrimaryKeySupported()(Code)(Java Doc) boolean isDropSequenceColumn(TableDiff tableDiff, JdbcColumn dropColumn)(Code)(Java Doc) public boolean isDuplicateKey(Throwable e)(Code)(Java Doc) public boolean isExtraParens()(Code)(Java Doc) public boolean isFetchSizeSupported()(Code)(Java Doc) public boolean isHandleDuplicateKey()(Code)(Java Doc) public boolean isHandleLockTimeout()(Code)(Java Doc) public boolean isInsertBatchingSupported()(Code)(Java Doc) public boolean isLikeStupid()(Code)(Java Doc) public boolean isLockTimeout(Throwable e)(Code)(Java Doc) public boolean isNullForeignKeyOk()(Code)(Java Doc) public boolean isOptimizeExistsUnderOrToOuterJoin()(Code)(Java Doc) public boolean isOracleStoreProcs()(Code)(Java Doc) public boolean isPreparedStatementPoolingOK()(Code)(Java Doc) public boolean isPutOrderColsInSelect()(Code)(Java Doc) public boolean isScrollableResultSetSupported()(Code)(Java Doc) public boolean isSelectForUpdateAppendTable()(Code)(Java Doc) public boolean isSelectForUpdateWithAggregateOk()(Code)(Java Doc) public boolean isSelectForUpdateWithDistinctOk()(Code)(Java Doc) public boolean isSetTransactionIsolationLevelSupported()(Code)(Java Doc) public boolean isSubQueryJoinMayUseOuterQueryCols()(Code)(Java Doc) public boolean isUpdateBatchingSupported()(Code)(Java Doc) public boolean isUseIndexesForOrderCols()(Code)(Java Doc) protected boolean isValidSchemaTable(String tableName)(Code)(Java Doc) public RuntimeException mapException(Throwable cause, String message, boolean isFatal)(Code)(Java Doc) public static RuntimeException mapException(SqlDriver sqlDriver, Throwable cause, String message)(Code)(Java Doc) public static RuntimeException mapException(SqlDriver sqlDriver, Throwable cause, String message, boolean isFatal)(Code)(Java Doc) protected String pad(int i)(Code)(Java Doc) public String prepareForGetQueryPlan(Connection con, String sql)(Code)(Java Doc) protected void print(PrintWriter out, String sql)(Code)(Java Doc) public boolean putOrderColsInGroupBy()(Code)(Java Doc) protected void reportFixes(ArrayList diffList, PrintWriter out) throws SQLException(Code)(Java Doc) public void setAllTableAndViewNames(Connection con) throws SQLException(Code)(Java Doc) protected String shrinkName(String name, int maxlen)(Code)(Java Doc) public String toSqlLiteral(double d)(Code)(Java Doc) public String toSqlLiteral(long l)(Code)(Java Doc) public String toSqlLiteral(String s)(Code)(Java Doc) public String toSqlLiteral(boolean b)(Code)(Java Doc) public void updateClassForPostInsertKeyGen(ClassMetaData cmd, JdbcMappingResolver mappingResolver)(Code)(Java Doc) public boolean useColAliasForAddedCols()(Code)(Java Doc) public boolean useColumnIndexForGroupBy()(Code)(Java Doc) protected boolean useZeroScale(JdbcColumn c)(Code)(Java Doc)
|
|
|