de.must.dataobj

Class DerbyDialect

java.lang.Object

de.must.dataobj.SqlDialect

de.must.dataobj.DerbyDialect

public class DerbyDialect
extends SqlDialect

Handles the specific Derby SQL dialect. Inconveniences: - Queries are case sensitive (similar to Oracle, which can already be handled via WhereCondition class) - Exception during multiple select threads with same connection: java.sql.SQLException: Es können keine weiteren java.sql.Clob/java.sql.Blob-Methoden aufgerufen werden, nachdem die free()-Methode aufgerufen oder nachdem die Blob/Clob-Transaktion ausgeführt oder wiederholt (Rollback) wurde. -> constraint to give each thread it's one connection? Client/server usage: jdbc:derby://localhost:1527/dbName;create=true org.apache.derby.jdbc.ClientDriver Embedded usage: jdbc:derby:dbName;create=true org.apache.derby.jdbc.EmbeddedDriver See also http://db.apache.org/derby/papers/DerbyTut/ns_intro.html For usage from other PC, "derbyrun.jar server start -h 192.168.0.2" is mandatory (192.168.0.2 = sample IP address)

See Also:

DataObject

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	BOOLEAN_FALSE_STRING
static java.lang.String	BOOLEAN_TRUE_STRING

Fields inherited from class de.must.dataobj.SqlDialect

BOOLEAN_FALSE_INT, BOOLEAN_TRUE_INT, dataObject, timestampFormat

Constructor Summary

Constructors

Constructor and Description
DerbyDialect()

Method Summary

Modifier and Type	Method and Description
protected void	extendCreateStatement(java.lang.StringBuilder createStatement, AbstractAttribute attribute)
protected void	extendInsertStatementWithValues(int i, java.sql.PreparedStatement statementForInsertion, java.util.HashMap<java.lang.String,java.lang.Object> original, java.util.HashMap<java.lang.String,java.lang.Object> workedOn, java.lang.String columnName, int columnType, int columnScale, java.lang.String columnNameOfRecordingDate, java.lang.String columnNameOfRecordingUser, java.lang.String recordingUser)
protected int	extendUpdatePhrase(int countUpdateColumns, java.lang.StringBuilder updateStatement, java.util.HashMap<java.lang.String,java.lang.Object> original, java.util.HashMap<java.lang.String,java.lang.Object> workedOn, java.lang.String columnName, int columnType, int columnScale)
static java.lang.String	getDbExpression(java.sql.Date sqlDate)
static java.lang.String	getDbExpression(java.sql.Timestamp timeStamp) Returns the database specific expression of the timestamp as specified.
java.lang.String	getSqlCompareString(java.sql.Date date) Returns the specific variant how date values are compared.
java.lang.String	getSqlCompareString(DateString dateString) Returns the specific variant how date values are compared.
java.lang.String	getWhereConditionFragementForExactDateComparison(java.lang.String columnName, java.sql.Date date) Returns the compare fragment for exact date comparison regardless their time parts in where conditions.
boolean	getWorkedOnBoolean(java.lang.String columnName, java.util.HashMap<java.lang.String,java.lang.Object> workedOn) Returns the value of a column as boolean in a worked on state - it might already been modified and differ from the original value.
protected void	initColumn(java.util.HashMap<java.lang.String,java.lang.Object> original, java.util.HashMap<java.lang.String,java.lang.Object> workedOn, java.lang.String columnName, int columnType, int columnScale)
protected void	loadColumn(java.sql.ResultSet rs, java.util.HashMap<java.lang.String,java.lang.Object> original, java.util.HashMap<java.lang.String,java.lang.Object> workedOn, java.lang.String columnName, int columnType, int columnScale)
java.lang.String	unifyColumnName(java.lang.String columnName) Unifies the column name.
java.lang.String	unifyTableName(java.lang.String tableName) Unifies the table name.

Methods inherited from class de.must.dataobj.SqlDialect

compress, extendToLength, fillInsertStatementWithValues, getBoolean, getCreateStatement, getCreateStatement, getCreateStatement, getIntDateValue, getLimitationFragment, getRowBoolean, getRowBoolean, getRowDate, getRowDate, getRowDouble, getRowDouble, getRowFloat, getRowFloat, getRowInt, getRowInt, getRowLong, getRowLong, getRowString, getRowString, getRowTime, getRowTime, getRowTimestamp, getSqlCompareString, getSqlCompareString, getSQLFormat, getUpdatePhrase, initRow, isKnownAsBoolean, isPartOfUniqueIndex, loadRow, setAttributes, setBoolean, setDataObject, sqlSecure, supportsForeignKey, supportsPrimaryKey, transformStringWhenSaving

Methods inherited from class java.lang.Object

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

Field Detail

BOOLEAN_TRUE_STRING

public static final java.lang.String BOOLEAN_TRUE_STRING

See Also:

Constant Field Values

BOOLEAN_FALSE_STRING

public static final java.lang.String BOOLEAN_FALSE_STRING

See Also:

Constant Field Values

Constructor Detail

DerbyDialect

public DerbyDialect()

Method Detail

initColumn

protected void initColumn(java.util.HashMap<java.lang.String,java.lang.Object> original,
                          java.util.HashMap<java.lang.String,java.lang.Object> workedOn,
                          java.lang.String columnName,
                          int columnType,
                          int columnScale)

Overrides:

initColumn in class SqlDialect

loadColumn

protected void loadColumn(java.sql.ResultSet rs,
                          java.util.HashMap<java.lang.String,java.lang.Object> original,
                          java.util.HashMap<java.lang.String,java.lang.Object> workedOn,
                          java.lang.String columnName,
                          int columnType,
                          int columnScale)

Overrides:

loadColumn in class SqlDialect

extendInsertStatementWithValues

protected void extendInsertStatementWithValues(int i,
                                               java.sql.PreparedStatement statementForInsertion,
                                               java.util.HashMap<java.lang.String,java.lang.Object> original,
                                               java.util.HashMap<java.lang.String,java.lang.Object> workedOn,
                                               java.lang.String columnName,
                                               int columnType,
                                               int columnScale,
                                               java.lang.String columnNameOfRecordingDate,
                                               java.lang.String columnNameOfRecordingUser,
                                               java.lang.String recordingUser)
                                        throws java.sql.SQLException

Overrides:

extendInsertStatementWithValues in class SqlDialect

Throws:

java.sql.SQLException

extendUpdatePhrase

protected int extendUpdatePhrase(int countUpdateColumns,
                                 java.lang.StringBuilder updateStatement,
                                 java.util.HashMap<java.lang.String,java.lang.Object> original,
                                 java.util.HashMap<java.lang.String,java.lang.Object> workedOn,
                                 java.lang.String columnName,
                                 int columnType,
                                 int columnScale)

Overrides:

extendUpdatePhrase in class SqlDialect

getDbExpression

public static java.lang.String getDbExpression(java.sql.Date sqlDate)

Parameters:

sqlDate - the date to be formatted

Returns:

the specific variant of setting a date value

getDbExpression

public static java.lang.String getDbExpression(java.sql.Timestamp timeStamp)

Returns the database specific expression of the timestamp as specified.

Parameters:

timeStamp - the time stamp to be formatted

Returns:

the database specific expression of the timestamp

unifyTableName

public java.lang.String unifyTableName(java.lang.String tableName)

Description copied from class: SqlDialect

Unifies the table name.

Specified by:

unifyTableName in class SqlDialect

Parameters:

tableName - the table name to unify

Returns:

the unified table name

unifyColumnName

public java.lang.String unifyColumnName(java.lang.String columnName)

Description copied from class: SqlDialect

Unifies the column name.

Specified by:

unifyColumnName in class SqlDialect

Parameters:

columnName - the column name to unify

Returns:

the unified column name

getSqlCompareString

public java.lang.String getSqlCompareString(DateString dateString)

Description copied from class: SqlDialect

Returns the specific variant how date values are compared.

Specified by:

getSqlCompareString in class SqlDialect

Parameters:

dateString - the DateString to be prepared

Returns:

the prepared String for data comparison

getSqlCompareString

public java.lang.String getSqlCompareString(java.sql.Date date)

Description copied from class: SqlDialect

Returns the specific variant how date values are compared.

Specified by:

getSqlCompareString in class SqlDialect

Parameters:

date - the date value to be prepared

Returns:

the prepared String for data comparison

getWhereConditionFragementForExactDateComparison

public java.lang.String getWhereConditionFragementForExactDateComparison(java.lang.String columnName,
                                                                         java.sql.Date date)

Description copied from class: SqlDialect

Returns the compare fragment for exact date comparison regardless their time parts in where conditions. In case of overriding, Be advised that using date functions may cause performance leaks, therefore prefer BETWEEN.

Overrides:

getWhereConditionFragementForExactDateComparison in class SqlDialect

Parameters:

columnName - the name of the column containing the date value (which may include time parts!)

date - the date to compare to

Returns:

the applicable fragment for exact comparison regardless their time parts

getWorkedOnBoolean

public boolean getWorkedOnBoolean(java.lang.String columnName,
                                  java.util.HashMap<java.lang.String,java.lang.Object> workedOn)

Returns the value of a column as boolean in a worked on state - it might already been modified and differ from the original value.

Parameters:

columnName - the name of the column

workedOn - the buffer of worked on values of the row

Returns:

the actual value of a column

extendCreateStatement

protected void extendCreateStatement(java.lang.StringBuilder createStatement,
                                     AbstractAttribute attribute)

Overrides:

extendCreateStatement in class SqlDialect