org.melati.poem.dbms
Class HsqldbText

java.lang.Object
  org.melati.poem.dbms.AnsiStandard
      org.melati.poem.dbms.Hsqldb
          org.melati.poem.dbms.HsqldbText

All Implemented Interfaces:

Dbms

public class HsqldbText
extends Hsqldb

Use CSV tables as backing store. NOTE 2010/10/24 I could not get this working due to problems with prepaed statements.

Since:

23 Sep 2008

Author:

timp

Field Summary

Fields inherited from class org.melati.poem.dbms.Hsqldb

hsqldbTextHack

Fields inherited from class org.melati.poem.dbms.AnsiStandard

schema

Constructor Summary

HsqldbText()

Method Summary

boolean	canDropColumns() Whether this DBMS can drop columns.
String	createTableTypeQualifierSql(Table table) The default is to keep everything in memory, this allows for the db to be written to the disk.
String	tableInitialisationSql(Table table)

Methods inherited from class org.melati.poem.dbms.Hsqldb

canRepresent, caseInsensitiveRegExpSQL, getBinarySqlDefinition, getForeignKeyDefinition, getJdbcMetadataName, getLongSqlDefinition, getStringSqlDefinition, melatiName, shutdown, unreservedName

Methods inherited from class org.melati.poem.dbms.AnsiStandard

alterColumnNotNullableSQL, booleanTrueExpression, canBeIndexed, canStoreBlobs, createTableOptionsSql, createTableSql, defaultPoemTypeOfColumnMetaData, exceptionForUpdate, exceptionForUpdate, getConnection, getDriverClassName, getDriverLoaded, getFixedPtSqlDefinition, getIndexLength, getPrimaryKeyDefinition, getQuotedName, getQuotedValue, getSchema, getSqlDefaultValue, getSqlDefinition, givesCapabilitySQL, loadDriver, preparedStatementPlaceholder, selectLimit, setDriverClassName, setDriverLoaded, sqlBooleanValueOfRaw, toString, unloadDriver

Methods inherited from class java.lang.Object

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

Constructor Detail

HsqldbText

public HsqldbText()

Method Detail

canDropColumns

public boolean canDropColumns()

Whether this DBMS can drop columns.

Specified by:

canDropColumns in interface Dbms

Overrides:

canDropColumns in class AnsiStandard

Returns:

true if we can

See Also:

Dbms.canDropColumns()

createTableTypeQualifierSql

public String createTableTypeQualifierSql(Table table)

The default is to keep everything in memory, this allows for the db to be written to the disk. The default is to keep everything in memory, this allows for the db to be written to the disk. Allow Hsqldb to have a different create table syntax. Should have trailing space if not empty String

Specified by:

createTableTypeQualifierSql in interface Dbms

Overrides:

createTableTypeQualifierSql in class Hsqldb

See Also:

org.melati.poem.dbms.Dbms#createTableSql(), org.melati.poem.dbms.AnsiStandard#createTableSql()

tableInitialisationSql

public String tableInitialisationSql(Table table)

Specified by:

tableInitialisationSql in interface Dbms

Overrides:

tableInitialisationSql in class AnsiStandard

Returns:

SQL to be run after creation or null

See Also:

AnsiStandard.tableInitialisationSql(org.melati.poem.Table)