org.ujorm.orm.dialect

Class HsqldbDialect

java.lang.Object

org.ujorm.orm.SqlDialect

org.ujorm.orm.dialect.H2Dialect

org.ujorm.orm.dialect.HsqldbDialect

public class HsqldbDialect
extends H2Dialect

Hsqldb dialect (http://hsqldb.org)

Field Summary

Fields inherited from class org.ujorm.orm.SqlDialect

COMMON_SEQ_TABLE_KEY, DEFAULT_SCHEMA_SYMBOL, NEW_LINE_SEPARATOR, ormHandler

Constructor Summary

Constructors

Constructor and Description
HsqldbDialect()

Method Summary

Methods

Modifier and Type	Method and Description
String	getJdbcDriver() Returns a JDBC Driver
String	getJdbcUrl() Returns a default JDBC URL.
boolean	isMultiRowInsertSupported() Database HSQLDB does not supports the MultiRow INSERT.
Appendable	printComment(MetaColumn column, Appendable out) COMMENT is not supported in HSQLDB database
Appendable	printComment(MetaTable table, Appendable out) COMMENT is not supported in HSQLDB database
Appendable	printCreateSchema(String schema, Appendable out) Print SQL 'CREATE SCHEMA'
protected Appendable	printLockForSelect(Query query, Appendable out) Including 1.7.2, HSQLDB does not support table locking via SELECT FOR UPDATE.
Appendable	printNextSequence(String sequenceName, MetaTable table, Appendable out) Create a SQL script for the NEXT SEQUENCE from a native database sequencer
void	releaseSavepoint(Connection conn, Savepoint savepoint, boolean afterRollback) Perform the method: {@link Connection#releaseSavepoint(java.sql.Savepoint) ?

Methods inherited from class org.ujorm.orm.SqlDialect

createConnection, createJndiInitialContext, createSubQuery, escape, getAliasColumnName, getColumnType, getCriterionTemplate, getExtentedDialect, getKeywordSet, getNameProvider, getQuotedName, getSeqTableModel, isCatalog, isColumnLengthAllowed, isFilled, isInnerJoin, printAlterTableAddColumn, printAlterTableColumn, printCall, printColumnAlias, printColumnDeclaration, printCommit, printCriterion, printCriterionValue, printDefaultConstraint, printDefaultSchema, printDefaultValue, printDelete, printFKColumnsDeclaration, printForeignKey, printForeignKey, printFullTableName, printFullTableName, printIndex, printInsert, printInsert, printInsertBySelect, println, printOffset, printQuotedName, printQuotedNameAlways, printSelect, printSelectOrder, printSelectTable, printSelectTableBase, printSelectView, printSequenceCurrentValue, printSequenceDeleteById, printSequenceInit, printSequenceInitWithValues, printSequenceNextValue, printSequenceTable, printSequenceTableName, printSetMaxSequence, printTable, printTableAliasDefinition, printTableColumns, printUpdate, setHandler

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

HsqldbDialect

public HsqldbDialect()

Method Detail

getJdbcUrl

public String getJdbcUrl()

Returns a default JDBC URL.
For a PostgreSQL simulation use: jdbc:hsqldb:mem:db1;sql.syntax_pgs=true

Overrides:

getJdbcUrl in class H2Dialect

getJdbcDriver

public String getJdbcDriver()

Description copied from class: H2Dialect

Returns a JDBC Driver

Overrides:

getJdbcDriver in class H2Dialect

printCreateSchema

public Appendable printCreateSchema(String schema,
                           Appendable out)
                             throws IOException

Print SQL 'CREATE SCHEMA'

Overrides:

printCreateSchema in class SqlDialect

Throws:

IOException

printComment

public Appendable printComment(MetaTable table,
                      Appendable out)
                        throws IOException

COMMENT is not supported in HSQLDB database

Overrides:

printComment in class SqlDialect

Throws:

IOException

printComment

public Appendable printComment(MetaColumn column,
                      Appendable out)
                        throws IOException

COMMENT is not supported in HSQLDB database

Overrides:

printComment in class SqlDialect

Throws:

IOException

isMultiRowInsertSupported

public boolean isMultiRowInsertSupported()

Database HSQLDB does not supports the MultiRow INSERT.

Overrides:

isMultiRowInsertSupported in class SqlDialect

See Also:

Multi row insert

printLockForSelect

protected Appendable printLockForSelect(Query query,
                            Appendable out)
                                 throws IOException,
                                        UnsupportedOperationException

Including 1.7.2, HSQLDB does not support table locking via SELECT FOR UPDATE.
For more information see http://hsqldb.org.

Overrides:

printLockForSelect in class SqlDialect

Parameters:

query - The UJO query

Throws:

IOException

UnsupportedOperationException

printNextSequence

public Appendable printNextSequence(String sequenceName,
                           MetaTable table,
                           Appendable out)
                             throws IOException

Create a SQL script for the NEXT SEQUENCE from a native database sequencer

Overrides:

printNextSequence in class SqlDialect

Throws:

IOException

releaseSavepoint

public void releaseSavepoint(Connection conn,
                    Savepoint savepoint,
                    boolean afterRollback)
                      throws SQLException

Perform the method: {@link Connection#releaseSavepoint(java.sql.Savepoint) ?

Overrides:

releaseSavepoint in class SqlDialect

Parameters:

conn - Database Connection

savepoint - Required Savepoint

afterRollback - release is called after a rollback ?

Throws:

SQLException

See Also:

http://technet.microsoft.com/en-us/library/ms378791%28v=sql.110%29.aspx, Connection.releaseSavepoint(java.sql.Savepoint)