File	Doc	Category	Size	Date	Package
InterbaseDialect.java	API Doc	Hibernate 3.2.5	3149	Wed Aug 03 18:29:32 BST 2005	org.hibernate.dialect

InterbaseDialect

• java.lang.Object
  • Dialect

Fields Summary

Constructors Summary

public InterbaseDialect() super(); registerColumnType( Types.BIT, "smallint" ); registerColumnType( Types.BIGINT, "numeric(18,0)" ); registerColumnType( Types.SMALLINT, "smallint" ); registerColumnType( Types.TINYINT, "smallint" ); registerColumnType( Types.INTEGER, "integer" ); registerColumnType( Types.CHAR, "char(1)" ); registerColumnType( Types.VARCHAR, "varchar($l)" ); registerColumnType( Types.FLOAT, "float" ); registerColumnType( Types.DOUBLE, "double precision" ); registerColumnType( Types.DATE, "date" ); registerColumnType( Types.TIME, "time" ); registerColumnType( Types.TIMESTAMP, "timestamp" ); registerColumnType( Types.VARBINARY, "blob" ); registerColumnType( Types.NUMERIC, "numeric($p,$s)" ); registerColumnType( Types.BLOB, "blob" ); registerColumnType( Types.CLOB, "blob sub_type 1" ); registerFunction( "concat", new VarArgsSQLFunction( Hibernate.STRING, "(","||",")" ) ); getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE, NO_BATCH);

Methods Summary
public boolean	bindLimitParametersFirst() return false;
public boolean	bindLimitParametersInReverseOrder() return false;
public java.lang.String	getAddColumnString() return "add";
public java.lang.String	getCreateSequenceString(java.lang.String sequenceName) return "create generator " + sequenceName;
public java.lang.String	getCurrentTimestampCallString() // TODO : not sure which (either?) is correct, could not find docs on how to do this. // did find various blogs and forums mentioning that select CURRENT_TIMESTAMP // does not work... return "{?= call CURRENT_TIMESTAMP }"; // return "select CURRENT_TIMESTAMP from RDB$DATABASE";
public java.lang.String	getDropSequenceString(java.lang.String sequenceName) return "delete from RDB$GENERATORS where RDB$GENERATOR_NAME = '" + sequenceName.toUpperCase() + "'";
public java.lang.String	getForUpdateString() return " with lock";
public java.lang.String	getForUpdateString(java.lang.String aliases) return " for update of " + aliases + " with lock";
public java.lang.String	getLimitString(java.lang.String sql, boolean hasOffset) return new StringBuffer( sql.length()+15 ) .append(sql) .append(hasOffset ? " rows ? to ?" : " rows ?") .toString();
public java.lang.String	getQuerySequencesString() return "select RDB$GENERATOR_NAME from RDB$GENERATORS";
public java.lang.String	getSelectSequenceNextValString(java.lang.String sequenceName) return "gen_id( " + sequenceName + ", 1 )";
public java.lang.String	getSequenceNextValString(java.lang.String sequenceName) return "select " + getSelectSequenceNextValString( sequenceName ) + " from RDB$DATABASE";
public boolean	isCurrentTimestampSelectStringCallable() return true;
public boolean	supportsLimit() return true;
public boolean	supportsSequences() return true;