org.databene.platform.db
Class DatabaseDialect

java.lang.Object
  org.databene.platform.db.DatabaseDialect

Direct Known Subclasses:

DB2Dialect, DerbyDialect, FirebirdDialect, H2Dialect, HSQLDialect, OracleDialect, PostgreSQLDialect, SqlServerDialect, UnknownDialect

public abstract class DatabaseDialect
extends java.lang.Object

Provides abstractions of concepts that are implemented differently by different database vendors.

Since:

0.4.0

Author:

Volker Bergmann

Field Summary

protected boolean	quoteTableNames
protected boolean	sequenceSupported

Constructor Summary

DatabaseDialect(java.lang.String system, boolean quoteTableNames, boolean sequenceSupported, java.lang.String datePattern, java.lang.String timePattern)

Method Summary

void	createSequence(java.lang.String name, long initialValue, java.sql.Connection connection)
java.lang.String	formatTimestamp(java.sql.Timestamp timestamp)
java.lang.String	formatValue(java.lang.Object value)
java.lang.String	getSystem()
java.lang.String	insert(DBTable table, java.util.List<ColumnInfo> columnInfos)
boolean	isSequenceSupported()
java.lang.String[]	querySequences(java.sql.Connection connection)
java.lang.String	renderDropSequence(java.lang.String sequenceName)
java.lang.String	renderFetchSequenceValue(java.lang.String sequenceName)
void	setSequenceValue(java.lang.String sequenceName, long value, java.sql.Connection connection)
java.lang.String	update(DBTable table, java.lang.String[] pkColumnNames, java.util.List<ColumnInfo> columnInfos)

Methods inherited from class java.lang.Object

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

Field Detail

quoteTableNames

protected final boolean quoteTableNames

sequenceSupported

protected final boolean sequenceSupported

Constructor Detail

DatabaseDialect

public DatabaseDialect(java.lang.String system,
                       boolean quoteTableNames,
                       boolean sequenceSupported,
                       java.lang.String datePattern,
                       java.lang.String timePattern)

Method Detail

getSystem

public java.lang.String getSystem()

isSequenceSupported

public boolean isSequenceSupported()

querySequences

public java.lang.String[] querySequences(java.sql.Connection connection)
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

createSequence

public void createSequence(java.lang.String name,
                           long initialValue,
                           java.sql.Connection connection)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

renderFetchSequenceValue

public java.lang.String renderFetchSequenceValue(java.lang.String sequenceName)

setSequenceValue

public void setSequenceValue(java.lang.String sequenceName,
                             long value,
                             java.sql.Connection connection)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

renderDropSequence

public java.lang.String renderDropSequence(java.lang.String sequenceName)

insert

public java.lang.String insert(DBTable table,
                               java.util.List<ColumnInfo> columnInfos)

update

public java.lang.String update(DBTable table,
                               java.lang.String[] pkColumnNames,
                               java.util.List<ColumnInfo> columnInfos)

formatValue

public java.lang.String formatValue(java.lang.Object value)

formatTimestamp

public java.lang.String formatTimestamp(java.sql.Timestamp timestamp)