org.hibernate.dialect.HSQLDialect java code examples

registerColumnType( Types.BIGINT, "bigint" );
registerColumnType( Types.BINARY, "binary($l)" );
registerColumnType( Types.BIT, "bit" );
registerColumnType( Types.BOOLEAN, "boolean" );
registerColumnType( Types.CHAR, "char($l)" );
registerColumnType( Types.DATE, "date" );
registerColumnType( Types.DECIMAL, "decimal($p,$s)" );
registerColumnType( Types.DOUBLE, "double" );
registerColumnType( Types.FLOAT, "float" );
registerColumnType( Types.INTEGER, "integer" );
registerColumnType( Types.LONGVARBINARY, "longvarbinary" );
registerColumnType( Types.LONGVARCHAR, "longvarchar" );
registerColumnType( Types.SMALLINT, "smallint" );
registerColumnType( Types.TINYINT, "tinyint" );
registerColumnType( Types.TIME, "time" );
registerColumnType( Types.TIMESTAMP, "timestamp" );
registerColumnType( Types.VARCHAR, "varchar($l)" );
registerColumnType( Types.VARBINARY, "varbinary($l)" );
registerColumnType( Types.NCLOB, "clob" );
  registerColumnType( Types.NUMERIC, "numeric" );
  registerColumnType( Types.NUMERIC, "numeric($p,$s)" );
  registerColumnType( Types.BLOB, "longvarbinary" );
  registerColumnType( Types.CLOB, "longvarchar" );
  registerColumnType( Types.BLOB, "blob($l)" );

/**
 * Because of the overridden {@link #getCreateSequenceString(String)}, we must also override
 * {@link #getCreateSequenceString(String, int, int)} to prevent 2 instances of "start with".
 */
@Override
protected String getCreateSequenceString(String sequenceName, int initialValue, int incrementSize) throws MappingException {
  if ( supportsPooledSequences() ) {
    return "create sequence " + sequenceName + " start with " + initialValue + " increment by " + incrementSize;
  }
  throw new MappingException( getClass().getName() + " does not support pooled sequences" );
}

formulaString = Template.renderWhereStringTemplate( formulaString, "$alias$", new HSQLDialect() );
formulaString = "(select " + formulaString + fromAndWhere + ")";
formulaString = StringHelper.replace(

registerColumnType( Types.BIGINT, "bigint" );
registerColumnType( Types.BINARY, "binary($l)" );
registerColumnType( Types.BIT, "bit" );
registerColumnType( Types.BOOLEAN, "boolean" );
registerColumnType( Types.CHAR, "char($l)" );
registerColumnType( Types.DATE, "date" );
registerColumnType( Types.DECIMAL, "decimal($p,$s)" );
registerColumnType( Types.DOUBLE, "double" );
registerColumnType( Types.FLOAT, "float" );
registerColumnType( Types.INTEGER, "integer" );
registerColumnType( Types.LONGVARBINARY, "longvarbinary" );
registerColumnType( Types.LONGVARCHAR, "longvarchar" );
registerColumnType( Types.SMALLINT, "smallint" );
registerColumnType( Types.TINYINT, "tinyint" );
registerColumnType( Types.TIME, "time" );
registerColumnType( Types.TIMESTAMP, "timestamp" );
registerColumnType( Types.VARCHAR, "varchar($l)" );
registerColumnType( Types.VARBINARY, "varbinary($l)" );
registerColumnType( Types.NCLOB, "clob" );
  registerColumnType( Types.NUMERIC, "numeric" );
  registerColumnType( Types.NUMERIC, "numeric($p,$s)" );
  registerColumnType( Types.BLOB, "longvarbinary" );
  registerColumnType( Types.CLOB, "longvarchar" );
  registerColumnType( Types.BLOB, "blob($l)" );

formulaString = Template.renderWhereStringTemplate( formulaString, "$alias$", new HSQLDialect() );
formulaString = "(select " + formulaString + fromAndWhere + ")";
formulaString = StringHelper.replace(

public HSQLDialect() {
  super();
  registerColumnType( Types.BIGINT, "bigint" );
  registerColumnType( Types.BINARY, "binary" );
  registerColumnType( Types.BIT, "bit" );
  registerColumnType( Types.CHAR, "char(1)" );
  registerColumnType( Types.DATE, "date" );
  registerColumnType( Types.DECIMAL, "decimal" );
  registerColumnType( Types.DOUBLE, "double" );
  registerColumnType( Types.FLOAT, "float" );
  registerColumnType( Types.INTEGER, "integer" );
  registerColumnType( Types.LONGVARBINARY, "longvarbinary" );
  registerColumnType( Types.LONGVARCHAR, "longvarchar" );
  registerColumnType( Types.SMALLINT, "smallint" );
  registerColumnType( Types.TINYINT, "tinyint" );
  registerColumnType( Types.TIME, "time" );
  registerColumnType( Types.TIMESTAMP, "timestamp" );
  registerColumnType( Types.VARCHAR, "varchar($l)" );
  registerColumnType( Types.VARBINARY, "varbinary($l)" );
  registerColumnType( Types.NUMERIC, "numeric" );
  registerColumnType( Types.BLOB, "longvarbinary" );
  registerColumnType( Types.CLOB, "longvarchar" );
  registerFunction( "ascii", new StandardSQLFunction( "ascii", Hibernate.INTEGER ) );
  registerFunction( "char", new StandardSQLFunction( "char", Hibernate.CHARACTER ) );
  registerFunction( "length", new StandardSQLFunction( "length", Hibernate.LONG ) );
  registerFunction( "lower", new StandardSQLFunction("lower") );
  registerFunction( "upper", new StandardSQLFunction("upper") );
  registerFunction( "lcase", new StandardSQLFunction("lcase") );

System.out.println(
 new HSQLDialect().getClass().getProtectionDomain().getCodeSource());

/**
 * Because of the overridden {@link #getCreateSequenceString(String)}, we must also override
 * {@link #getCreateSequenceString(String, int, int)} to prevent 2 instances of "start with".
 */
@Override
protected String getCreateSequenceString(String sequenceName, int initialValue, int incrementSize) throws MappingException {
  if ( supportsPooledSequences() ) {
    return "create sequence " + sequenceName + " start with " + initialValue + " increment by " + incrementSize;
  }
  throw new MappingException( getClass().getName() + " does not support pooled sequences" );
}

public HSQLDialect() {
  super();
  registerColumnType( Types.BIGINT, "bigint" );
  registerColumnType( Types.BINARY, "binary" );
  registerColumnType( Types.BIT, "bit" );
  registerColumnType( Types.CHAR, "char(1)" );
  registerColumnType( Types.DATE, "date" );
  registerColumnType( Types.DECIMAL, "decimal" );
  registerColumnType( Types.DOUBLE, "double" );
  registerColumnType( Types.FLOAT, "float" );
  registerColumnType( Types.INTEGER, "integer" );
  registerColumnType( Types.LONGVARBINARY, "longvarbinary" );
  registerColumnType( Types.LONGVARCHAR, "longvarchar" );
  registerColumnType( Types.SMALLINT, "smallint" );
  registerColumnType( Types.TINYINT, "tinyint" );
  registerColumnType( Types.TIME, "time" );
  registerColumnType( Types.TIMESTAMP, "timestamp" );
  registerColumnType( Types.VARCHAR, "varchar($l)" );
  registerColumnType( Types.VARBINARY, "varbinary($l)" );
  registerColumnType( Types.NUMERIC, "numeric" );
  registerColumnType( Types.BLOB, "longvarbinary" );
  registerColumnType( Types.CLOB, "longvarchar" );
  registerFunction( "ascii", new StandardSQLFunction( "ascii", Hibernate.INTEGER ) );
  registerFunction( "char", new StandardSQLFunction( "char", Hibernate.CHARACTER ) );
  registerFunction( "length", new StandardSQLFunction( "length", Hibernate.LONG ) );
  registerFunction( "lower", new StandardSQLFunction( "lower" ) );
  registerFunction( "upper", new StandardSQLFunction( "upper" ) );
  registerFunction( "lcase", new StandardSQLFunction( "lcase" ) );

return new HSQLDialect();

registerColumnType( Types.BIGINT, "bigint" );
registerColumnType( Types.BINARY, "binary($l)" );
registerColumnType( Types.BIT, "bit" );
registerColumnType( Types.BOOLEAN, "boolean" );
registerColumnType( Types.CHAR, "char($l)" );
registerColumnType( Types.DATE, "date" );
registerColumnType( Types.DECIMAL, "decimal($p,$s)" );
registerColumnType( Types.DOUBLE, "double" );
registerColumnType( Types.FLOAT, "float" );
registerColumnType( Types.INTEGER, "integer" );
registerColumnType( Types.LONGVARBINARY, "longvarbinary" );
registerColumnType( Types.LONGVARCHAR, "longvarchar" );
registerColumnType( Types.SMALLINT, "smallint" );
registerColumnType( Types.TINYINT, "tinyint" );
registerColumnType( Types.TIME, "time" );
registerColumnType( Types.TIMESTAMP, "timestamp" );
registerColumnType( Types.VARCHAR, "varchar($l)" );
registerColumnType( Types.VARBINARY, "varbinary($l)" );
  registerColumnType( Types.NUMERIC, "numeric" );
  registerColumnType( Types.NUMERIC, "numeric($p,$s)" );
  registerColumnType( Types.BLOB, "longvarbinary" );
  registerColumnType( Types.CLOB, "longvarchar" );
  registerColumnType( Types.BLOB, "blob" );
  registerColumnType( Types.CLOB, "clob" );

return new HSQLDialect();

registerColumnType( Types.BIGINT, "bigint" );
registerColumnType( Types.BINARY, "binary($l)" );
registerColumnType( Types.BIT, "bit" );
registerColumnType( Types.BOOLEAN, "boolean" );
registerColumnType( Types.CHAR, "char($l)" );
registerColumnType( Types.DATE, "date" );
registerColumnType( Types.DECIMAL, "decimal($p,$s)" );
registerColumnType( Types.DOUBLE, "double" );
registerColumnType( Types.FLOAT, "float" );
registerColumnType( Types.INTEGER, "integer" );
registerColumnType( Types.LONGVARBINARY, "longvarbinary" );
registerColumnType( Types.LONGVARCHAR, "longvarchar" );
registerColumnType( Types.SMALLINT, "smallint" );
registerColumnType( Types.TINYINT, "tinyint" );
registerColumnType( Types.TIME, "time" );
registerColumnType( Types.TIMESTAMP, "timestamp" );
registerColumnType( Types.VARCHAR, "varchar($l)" );
registerColumnType( Types.VARBINARY, "varbinary($l)" );
  registerColumnType( Types.NUMERIC, "numeric" );
  registerColumnType( Types.NUMERIC, "numeric($p,$s)" );
  registerColumnType( Types.BLOB, "longvarbinary" );
  registerColumnType( Types.CLOB, "longvarchar" );
  registerColumnType( Types.BLOB, "blob" );
  registerColumnType( Types.CLOB, "clob" );

formulaString = Template.renderWhereStringTemplate( formulaString, "$alias$", new HSQLDialect() );
formulaString = "(select " + formulaString + fromAndWhere + ")";
formulaString = StringHelper.replace(

formulaString = Template.renderWhereStringTemplate( formulaString, "$alias$", new HSQLDialect() );
formulaString = "(select " + formulaString + fromAndWhere + ")";
formulaString = StringHelper.replace(

formulaString = Template.renderWhereStringTemplate( formulaString, "$alias$", new HSQLDialect() );
formulaString = "(select " +  formulaString + fromAndWhere + ")";
formulaString = StringHelper.replace(

formulaString = Template.renderWhereStringTemplate( formulaString, "$alias$", new HSQLDialect() );
formulaString = "(select " + formulaString + fromAndWhere + ")";
formulaString = StringHelper.replace(

Javadoc

An SQL dialect compatible with HSQLDB (HyperSQL).

Note this version supports HSQLDB version 1.8 and higher, only.

Enhancements to version 3.5.0 GA to provide basic support for both HSQLDB 1.8.x and 2.x Does not works with Hibernate 3.2 - 3.4 without alteration.

Most used methods

Popular in Java

Running tasks concurrently on multiple threads
addToBackStack (FragmentTransaction)
orElseThrow (Optional)
Return the contained value, if present, otherwise throw an exception to be created by the provided s
getApplicationContext (Context)
Path (java.nio.file)
DecimalFormat (java.text)
A concrete subclass of NumberFormat that formats decimal numbers. It has a variety of features desig
BitSet (java.util)
The BitSet class implements abit array [http://en.wikipedia.org/wiki/Bit_array]. Each element is eit
Executors (java.util.concurrent)
Factory and utility methods for Executor, ExecutorService, ScheduledExecutorService, ThreadFactory,
Filter (javax.servlet)
A filter is an object that performs filtering tasks on either the request to a resource (a servlet o
Options (org.apache.commons.cli)
Main entry-point into the library. Options represents a collection of Option objects, which describ
Top 12 Jupyter Notebook Extensions

How to useHSQLDialect in org.hibernate.dialect

Best Java code snippets using org.hibernate.dialect.HSQLDialect (Showing top 17 results out of 315)

How to use
HSQLDialect
in
org.hibernate.dialect