de.must.dataobj

Class Db2400Dialect

java.lang.Object

de.must.dataobj.SqlDialect

de.must.dataobj.Db2400Dialect

public class Db2400Dialect
extends SqlDialect

Handles the specific DB2-AS400 dialect. Completes the work of DataObject.

See Also:

DataObject

Field Summary

Fields inherited from class de.must.dataobj.SqlDialect

BOOLEAN_FALSE_INT, BOOLEAN_TRUE_INT, dataObject, timestampFormat

Constructor Summary

Constructors

Constructor and Description
Db2400Dialect()

Method Summary

Modifier and Type	Method and Description
void	fillInsertStatementWithValues(java.sql.PreparedStatement statementForInsertion, java.util.HashMap<java.lang.String,java.lang.Object> original, java.util.HashMap<java.lang.String,java.lang.Object> workedOn, int columnCount, java.lang.String[] columnNames, int[] columnType, int[] columnScale, java.lang.String columnNameOfRecordingDate, java.lang.String columnNameOfRecordingUser, java.lang.String recordingUser)
boolean	getBoolean(java.lang.String columnName, java.util.HashMap<java.lang.String,java.lang.Object> original) Returns the value of a column as boolean.
java.lang.String	getCreateStatement(java.lang.String tableName, AbstractAttribute[] attributes, Index[] indices) Returns the specific create statement string of the specified table
static java.lang.String	getDbExpression(java.sql.Date sqlDate)
static java.lang.String	getDbExpression(java.sql.Time sqlTime) Returns the database specific expression of the time as specified.
java.lang.String	getSqlCompareString(boolean b) Returns the specific variant how boolean values are compared.
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	getUpdatePhrase(java.util.HashMap<java.lang.String,java.lang.Object> original, java.util.HashMap<java.lang.String,java.lang.Object> workedOn, java.lang.String entity, int columnCount, java.lang.String[] columnNames, int[] columnType, int[] columnScale) Returns the update statement string.
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.
void	initRow(java.util.HashMap<java.lang.String,java.lang.Object> original, java.util.HashMap<java.lang.String,java.lang.Object> workedOn, int columnCount, java.lang.String[] columnNames, int[] columnType, int[] columnScale) Initializes a row.
void	loadRow(java.sql.ResultSet rs, java.util.HashMap<java.lang.String,java.lang.Object> original, java.util.HashMap<java.lang.String,java.lang.Object> workedOn, int columnCount, java.lang.String[] columnNames, int[] columnType, int[] columnScale) Loads the row's values into buffers for random access.
void	setBoolean(java.lang.String columnName, boolean boolValue, java.util.HashMap<java.lang.String,java.lang.Object> workedOn) Sets the value of the specified column.
boolean	supportsPrimaryKey()
java.lang.String	transformStringWhenSaving(java.lang.String columnName, java.lang.String value) Converts String values before sending to database.
protected java.lang.String	transformVerticalSpacingWhenSaving(java.lang.String columnName, java.lang.String columnValue) Compresses column value and replaces all vertical spacings by a symbol.
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, extendCreateStatement, extendInsertStatementWithValues, extendToLength, extendUpdatePhrase, getCreateStatement, getCreateStatement, getIntDateValue, getLimitationFragment, getRowBoolean, getRowBoolean, getRowDate, getRowDate, getRowDouble, getRowDouble, getRowFloat, getRowFloat, getRowInt, getRowInt, getRowLong, getRowLong, getRowString, getRowString, getRowTime, getRowTime, getRowTimestamp, getSqlCompareString, getSQLFormat, initColumn, isKnownAsBoolean, isPartOfUniqueIndex, loadColumn, setAttributes, setDataObject, sqlSecure, supportsForeignKey

Methods inherited from class java.lang.Object

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

Constructor Detail

Db2400Dialect

public Db2400Dialect()

Method Detail

supportsPrimaryKey

public boolean supportsPrimaryKey()

Overrides:

supportsPrimaryKey in class SqlDialect

initRow

public void initRow(java.util.HashMap<java.lang.String,java.lang.Object> original,
                    java.util.HashMap<java.lang.String,java.lang.Object> workedOn,
                    int columnCount,
                    java.lang.String[] columnNames,
                    int[] columnType,
                    int[] columnScale)

Initializes a row. Needed to prepare an insert statement.

Overrides:

initRow in class SqlDialect

Parameters:

original - the buffer of original values (before changing values)

workedOn - the buffer of worked on values (after changing values)

columnCount - the number of the regarded columns

columnNames - the names of the regarded columns

columnType - the types of the regarded columns

columnScale - the scales of the regarded columns

loadRow

public void loadRow(java.sql.ResultSet rs,
                    java.util.HashMap<java.lang.String,java.lang.Object> original,
                    java.util.HashMap<java.lang.String,java.lang.Object> workedOn,
                    int columnCount,
                    java.lang.String[] columnNames,
                    int[] columnType,
                    int[] columnScale)

Loads the row's values into buffers for random access.

Overrides:

loadRow in class SqlDialect

Parameters:

rs - the used result set

original - the buffer of original values (before changing values)

workedOn - the buffer of worked on values (after changing values)

columnCount - the number of the regarded columns

columnNames - the names of the regarded columns

columnType - the types of the regarded columns

columnScale - the scales of the regarded columns

fillInsertStatementWithValues

public void fillInsertStatementWithValues(java.sql.PreparedStatement statementForInsertion,
                                          java.util.HashMap<java.lang.String,java.lang.Object> original,
                                          java.util.HashMap<java.lang.String,java.lang.Object> workedOn,
                                          int columnCount,
                                          java.lang.String[] columnNames,
                                          int[] columnType,
                                          int[] columnScale,
                                          java.lang.String columnNameOfRecordingDate,
                                          java.lang.String columnNameOfRecordingUser,
                                          java.lang.String recordingUser)
                                   throws java.sql.SQLException

Overrides:

fillInsertStatementWithValues in class SqlDialect

Throws:

java.sql.SQLException

transformStringWhenSaving

public java.lang.String transformStringWhenSaving(java.lang.String columnName,
                                                  java.lang.String value)

Description copied from class: SqlDialect

Converts String values before sending to database. Needed if databases comes in trouble with control bytes like e.g. "\n", Override it if necessary.

Overrides:

transformStringWhenSaving in class SqlDialect

value - the value to transform

Returns:

the transformed value

transformVerticalSpacingWhenSaving

protected java.lang.String transformVerticalSpacingWhenSaving(java.lang.String columnName,
                                                              java.lang.String columnValue)

Compresses column value and replaces all vertical spacings by a symbol.

Parameters:

columnName - the name of the column to be transformed

columnValue - the column value

Returns:

the transformed value

getUpdatePhrase

public java.lang.String getUpdatePhrase(java.util.HashMap<java.lang.String,java.lang.Object> original,
                                        java.util.HashMap<java.lang.String,java.lang.Object> workedOn,
                                        java.lang.String entity,
                                        int columnCount,
                                        java.lang.String[] columnNames,
                                        int[] columnType,
                                        int[] columnScale)

Returns the update statement string.

Overrides:

getUpdatePhrase in class SqlDialect

Parameters:

original - the buffer of original values (before changing values)

workedOn - the buffer of worked on values (after changing values)

entity - the table name

columnCount - the number of the regarded columns

columnNames - the names of the regarded columns

columnType - the types of the regarded columns

columnScale - the scales of the regarded columns

Returns:

the update statement string

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.Time sqlTime)

Returns the database specific expression of the time as specified.

Parameters:

sqlTime - the time to be formatted

Returns:

the specific variant of setting a time value

unifyTableName

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

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)

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)

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

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

getSqlCompareString

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

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

getSqlCompareString

public java.lang.String getSqlCompareString(boolean b)

Description copied from class: SqlDialect

Returns the specific variant how boolean values are compared.

Overrides:

getSqlCompareString in class SqlDialect

Parameters:

b - the boolean value to be prepared

Returns:

the prepared String for boolean comparison

getBoolean

public boolean getBoolean(java.lang.String columnName,
                          java.util.HashMap<java.lang.String,java.lang.Object> original)

Returns the value of a column as boolean.

Overrides:

getBoolean in class SqlDialect

Parameters:

columnName - the name of the column

original - the buffer of original values of the row

Returns:

the value of a column

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

setBoolean

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

Sets the value of the specified column.

Overrides:

setBoolean in class SqlDialect

Parameters:

columnName - the name of the column to be set

boolValue - the value the column shall be set to

workedOn - the buffer of worked on values of the row

getCreateStatement

public java.lang.String getCreateStatement(java.lang.String tableName,
                                           AbstractAttribute[] attributes,
                                           Index[] indices)

Description copied from class: SqlDialect

Returns the specific create statement string of the specified table

Overrides:

getCreateStatement in class SqlDialect

Parameters:

tableName - the name of the table to be created

attributes - the attribute of the table to be created

indices - the indices to be created

Returns:

the create statement string