Package org.eclipse.scout.rt.server.jdbc.db2

Class DB2SqlStyle

java.lang.Object

org.eclipse.scout.rt.server.jdbc.style.AbstractSqlStyle

org.eclipse.scout.rt.server.jdbc.db2.DB2SqlStyle

All Implemented Interfaces:

Serializable, ISqlStyle

Direct Known Subclasses:

DB2OracleModeSqlStyle

public class DB2SqlStyle
extends AbstractSqlStyle

See Also:

• Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class org.eclipse.scout.rt.server.jdbc.style.AbstractSqlStyle

AbstractSqlStyle.DecimalConversion

Field Summary

Fields inherited from interface org.eclipse.scout.rt.server.jdbc.style.ISqlStyle

MAX_LIST_SIZE, MAX_SQL_STRING_LENGTH, PLAIN_BIND_MARKER_PREFIX

Constructor Summary

Constructors

Constructor	Description
DB2SqlStyle()

Method Summary

Modifier and Type	Method	Description
protected String	adaptBindNameTimeDateOp(String bindName)
String	getConcatOp()	ansi: +
String	getLikeWildcard()	ansi: *
protected int	getMaxListSize()
boolean	isBlobEnabled()	flag signaling whether BLOB or LONG RAW should be used for byte[] binds
boolean	isClobEnabled()	flag signaling whether CLOB or LONG VARCHAR should be used for char[] and large String binds
boolean	isLargeString(String s)
void	testConnection(Connection conn)	test a connection before use Note: this method is called before *every* sql connection pool transaction Note: this method is not called when an rmi connection pool is used

Methods inherited from class org.eclipse.scout.rt.server.jdbc.style.AbstractSqlStyle

adaptBindName, buildBindFor, commit, createBetween, createBindFor, createContains, createDateBetween, createDateEQ, createDateGE, createDateGT, createDateIsInDays, createDateIsInGEDays, createDateIsInGEMonths, createDateIsInGEWeeks, createDateIsInLastDays, createDateIsInLastMonths, createDateIsInLEDays, createDateIsInLEMonths, createDateIsInLEWeeks, createDateIsInMonths, createDateIsInNextDays, createDateIsInNextMonths, createDateIsInWeeks, createDateIsNotToday, createDateIsToday, createDateLE, createDateLT, createDateNEQ, createDateTimeBetween, createDateTimeEQ, createDateTimeGE, createDateTimeGT, createDateTimeIsInGEHours, createDateTimeIsInGEMinutes, createDateTimeIsInLEHours, createDateTimeIsInLEMinutes, createDateTimeIsNotNow, createDateTimeIsNow, createDateTimeLE, createDateTimeLT, createDateTimeNEQ, createEndsWith, createEQ, createGE, createGT, createIn, createInList, createInList, createLE, createLike, createLT, createNEQ, createNotContains, createNotEndsWith, createNotIn, createNotInList, createNotInList, createNotLike, createNotNull, createNotStartsWith, createNull, createNumberNotNull, createNumberNull, createStartsWith, createTextNotNull, createTextNull, createTimeIsInGEHours, createTimeIsInGEMinutes, createTimeIsInHours, createTimeIsInLEHours, createTimeIsInLEMinutes, createTimeIsInMinutes, createTimeIsNotNow, createTimeIsNow, createYearToDate, getConfiguredDecimalConversionStrategy, getJdbcType, getLowerToken, getNvlToken, getSysdateToken, getTrimToken, getUpperToken, isCreatingInListGeneratingBind, readBind, registerOutput, rollback, toAggregationAvg, toAggregationCount, toAggregationMax, toAggregationMedian, toAggregationMin, toAggregationSum, toArray, toLikePattern, toPlainText, writeBind

Methods inherited from class java.lang.Object

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

Constructor Details

DB2SqlStyle

public DB2SqlStyle()

Method Details

getConcatOp

public String getConcatOp()

Description copied from interface: ISqlStyle

ansi: +

Specified by:

getConcatOp in interface ISqlStyle

Overrides:

getConcatOp in class AbstractSqlStyle

getLikeWildcard

public String getLikeWildcard()

Description copied from interface: ISqlStyle

ansi: *

Specified by:

getLikeWildcard in interface ISqlStyle

Overrides:

getLikeWildcard in class AbstractSqlStyle

getMaxListSize

protected int getMaxListSize()

Specified by:

getMaxListSize in class AbstractSqlStyle

isLargeString

public boolean isLargeString(String s)

Returns:

true to handle string as CLOB resp. LONG VARCHAR or false to handle string as simple String see ISqlStyle.isClobEnabled()

isBlobEnabled

public boolean isBlobEnabled()

Description copied from interface: ISqlStyle

flag signaling whether BLOB or LONG RAW should be used for byte[] binds

isClobEnabled

public boolean isClobEnabled()

Description copied from interface: ISqlStyle

flag signaling whether CLOB or LONG VARCHAR should be used for char[] and large String binds

testConnection

public void testConnection(Connection conn)
                    throws SQLException

Description copied from interface: ISqlStyle

test a connection before use
Note: this method is called before *every* sql connection pool transaction
Note: this method is not called when an rmi connection pool is used

Throws:

SQLException

adaptBindNameTimeDateOp

protected String adaptBindNameTimeDateOp(String bindName)

Overrides:

adaptBindNameTimeDateOp in class AbstractSqlStyle