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

Class DerbySqlStyle

java.lang.Object

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

org.eclipse.scout.rt.server.jdbc.derby.DerbySqlStyle

All Implemented Interfaces:

Serializable, ISqlStyle

public class DerbySqlStyle
extends AbstractSqlStyle

Note: This class is mostly untested.

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
DerbySqlStyle()

Method Summary

Modifier and Type	Method	Description
String	createDateIsInDays(String attribute, String bindName)	P.NAME dateIsInDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInGEDays(String attribute, String bindName)	P.NAME dateIsInGEDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInGEMonths(String attribute, String bindName)	P.NAME dateIsInGEMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInGEWeeks(String attribute, String bindName)	P.NAME dateIsInGEWeeks :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createDateIsInLastDays(String attribute, String bindName)	P.NAME dateIsInLastDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInLastMonths(String attribute, String bindName)	P.NAME dateIsInLastMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInLEDays(String attribute, String bindName)	P.NAME dateIsInLEDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInLEMonths(String attribute, String bindName)	P.NAME dateIsInLEMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInLEWeeks(String attribute, String bindName)	P.NAME dateIsInLEWeeks :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createDateIsInMonths(String attribute, String bindName)	P.NAME dateIsInMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInNextDays(String attribute, String bindName)	P.NAME dateIsInNextDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInNextMonths(String attribute, String bindName)	P.NAME dateIsInNextMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInWeeks(String attribute, String bindName)	P.NAME dateIsInWeeks :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsNotToday(String attribute)	P.NAME dateIsNotToday
String	createDateIsToday(String attribute)	P.NAME dateIsToday
String	createDateTimeIsInGEHours(String attribute, String bindName)	P.NAME dateTimeIsInGEHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeIsInGEMinutes(String attribute, String bindName)	P.NAME dateTimeIsInGEMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeIsInLEHours(String attribute, String bindName)	P.NAME dateTimeIsInLEHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeIsInLEMinutes(String attribute, String bindName)	P.NAME dateTimeIsInLEMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeIsNotNow(String attribute)	P.NAME dateTimeIsNotNow
String	createDateTimeIsNow(String attribute)	P.NAME dateTimeIsNow
String	createTimeIsInGEHours(String attribute, String bindName)	P.NAME timeIsInGEHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createTimeIsInGEMinutes(String attribute, String bindName)	P.NAME timeIsInGEMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createTimeIsInHours(String attribute, String bindName)	P.NAME timeIsInHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createTimeIsInLEHours(String attribute, String bindName)	P.NAME timeIsInLEHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createTimeIsInLEMinutes(String attribute, String bindName)	P.NAME timeIsInLEMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createTimeIsInMinutes(String attribute, String bindName)	P.NAME timeIsInMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createTimeIsNotNow(String attribute)	P.NAME timeIsNow
String	createTimeIsNow(String attribute)	P.NAME timeIsNow
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, adaptBindNameTimeDateOp, buildBindFor, commit, createBetween, createBindFor, createContains, createDateBetween, createDateEQ, createDateGE, createDateGT, createDateLE, createDateLT, createDateNEQ, createDateTimeBetween, createDateTimeEQ, createDateTimeGE, createDateTimeGT, 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, createYearToDate, getConcatOp, getConfiguredDecimalConversionStrategy, getJdbcType, getLikeWildcard, 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

DerbySqlStyle

public DerbySqlStyle()

Method Details

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

createDateIsToday

public String createDateIsToday(String attribute)

Description copied from interface: ISqlStyle

P.NAME dateIsToday

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE) AND attribute < TRUNC(SYSDATE+1)
 

Specified by:

createDateIsToday in interface ISqlStyle

Overrides:

createDateIsToday in class AbstractSqlStyle

createDateIsInLastDays

public String createDateIsInLastDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLastDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE-( :firstBind ))
 AND
 attribute < TRUNC(SYSDATE+1)
 

Specified by:

createDateIsInLastDays in interface ISqlStyle

Overrides:

createDateIsInLastDays in class AbstractSqlStyle

createDateIsInNextDays

public String createDateIsInNextDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInNextDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE)
 AND
 attribute < TRUNC(SYSDATE+ :firstBind +1)
 

Specified by:

createDateIsInNextDays in interface ISqlStyle

Overrides:

createDateIsInNextDays in class AbstractSqlStyle

createDateIsInDays

public String createDateIsInDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE+ :firstBind )
 AND
 attribute < TRUNC(SYSDATE+ :firstBind +1)
 

Specified by:

createDateIsInDays in interface ISqlStyle

Overrides:

createDateIsInDays in class AbstractSqlStyle

createDateIsInWeeks

public String createDateIsInWeeks(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInWeeks :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE+ (( :firstBind ) *7) )
 AND
 attribute < TRUNC(SYSDATE+(( :firstBind ) *7)+1)
 

Specified by:

createDateIsInWeeks in interface ISqlStyle

Overrides:

createDateIsInWeeks in class AbstractSqlStyle

createDateIsInLastMonths

public String createDateIsInLastMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLastMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(ADD_MONTHS(SYSDATE,(-1)*( :firstBind )))
 AND
 attribute < TRUNC(SYSDATE+1)
 

Specified by:

createDateIsInLastMonths in interface ISqlStyle

Overrides:

createDateIsInLastMonths in class AbstractSqlStyle

createDateIsInNextMonths

public String createDateIsInNextMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInNextMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE)
 AND
 attribute < TRUNC(ADD_MONTHS(SYSDATE, :firstBind )+1)
 

Specified by:

createDateIsInNextMonths in interface ISqlStyle

Overrides:

createDateIsInNextMonths in class AbstractSqlStyle

createDateIsInMonths

public String createDateIsInMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(ADD_MONTHS(SYSDATE, :firstBind ))
 AND
 attribute < TRUNC(ADD_MONTHS(SYSDATE, :firstBind )+1)
 

Specified by:

createDateIsInMonths in interface ISqlStyle

Overrides:

createDateIsInMonths in class AbstractSqlStyle

createDateIsInLEDays

public String createDateIsInLEDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLEDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute < TRUNC(SYSDATE  + :firstBind +1)
 

Specified by:

createDateIsInLEDays in interface ISqlStyle

Overrides:

createDateIsInLEDays in class AbstractSqlStyle

createDateIsInLEWeeks

public String createDateIsInLEWeeks(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLEWeeks :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute < TRUNC(SYSDATE+(( :firstBind )*7)+1)
 

Specified by:

createDateIsInLEWeeks in interface ISqlStyle

Overrides:

createDateIsInLEWeeks in class AbstractSqlStyle

createDateIsInLEMonths

public String createDateIsInLEMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLEMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute < TRUNC(ADD_MONTHS(SYSDATE, :firstBind )+1)
 

Specified by:

createDateIsInLEMonths in interface ISqlStyle

Overrides:

createDateIsInLEMonths in class AbstractSqlStyle

createDateIsInGEDays

public String createDateIsInGEDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInGEDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE  + :firstBind )
 

Specified by:

createDateIsInGEDays in interface ISqlStyle

Overrides:

createDateIsInGEDays in class AbstractSqlStyle

createDateIsInGEWeeks

public String createDateIsInGEWeeks(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInGEWeeks :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE+(( :firstBind )*7))
 

Specified by:

createDateIsInGEWeeks in interface ISqlStyle

Overrides:

createDateIsInGEWeeks in class AbstractSqlStyle

createDateIsInGEMonths

public String createDateIsInGEMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInGEMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >=TRUNC(ADD_MONTHS(SYSDATE, :firstBind ))
 

Specified by:

createDateIsInGEMonths in interface ISqlStyle

Overrides:

createDateIsInGEMonths in class AbstractSqlStyle

createDateIsNotToday

public String createDateIsNotToday(String attribute)

Description copied from interface: ISqlStyle

P.NAME dateIsNotToday

In an Oracle implementation this could be represented as

( attribute <TRUNC(SYSDATE) OR attribute >=TRUNC(SYSDATE+1))

Specified by:

createDateIsNotToday in interface ISqlStyle

Overrides:

createDateIsNotToday in class AbstractSqlStyle

createDateTimeIsNow

public String createDateTimeIsNow(String attribute)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsNow

In an Oracle implementation this could be represented as

 ( attribute >= TRUNC(SYSDATE, 'MI') AND attribute < (TRUNC(SYSDATE, 'MI')+(1/24/60)))
 

Specified by:

createDateTimeIsNow in interface ISqlStyle

Overrides:

createDateTimeIsNow in class AbstractSqlStyle

createDateTimeIsInLEMinutes

public String createDateTimeIsInLEMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsInLEMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute < (TRUNC(SYSDATE, 'MI')+(( :firstBind +1)/24/60))
 

Specified by:

createDateTimeIsInLEMinutes in interface ISqlStyle

Overrides:

createDateTimeIsInLEMinutes in class AbstractSqlStyle

createDateTimeIsInLEHours

public String createDateTimeIsInLEHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsInLEHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute <(TRUNC(SYSDATE, 'MI')+((1/24/60)+( :firstBind /24)))
 

Specified by:

createDateTimeIsInLEHours in interface ISqlStyle

Overrides:

createDateTimeIsInLEHours in class AbstractSqlStyle

createDateTimeIsInGEMinutes

public String createDateTimeIsInGEMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsInGEMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >=(TRUNC(SYSDATE, 'MI')+( :firstBind /24/60))
 

Specified by:

createDateTimeIsInGEMinutes in interface ISqlStyle

Overrides:

createDateTimeIsInGEMinutes in class AbstractSqlStyle

createDateTimeIsInGEHours

public String createDateTimeIsInGEHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsInGEHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= (TRUNC(SYSDATE, 'MI')+( :firstBind /24))
 

Specified by:

createDateTimeIsInGEHours in interface ISqlStyle

Overrides:

createDateTimeIsInGEHours in class AbstractSqlStyle

createDateTimeIsNotNow

public String createDateTimeIsNotNow(String attribute)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsNotNow

In an Oracle implementation this could be represented as

 ( attribute <TRUNC(SYSDATE, 'MI') OR  attribute >=(TRUNC(SYSDATE, 'MI')+(1/24/60)))
 

Specified by:

createDateTimeIsNotNow in interface ISqlStyle

Overrides:

createDateTimeIsNotNow in class AbstractSqlStyle

createTimeIsNow

public String createTimeIsNow(String attribute)

Description copied from interface: ISqlStyle

P.NAME timeIsNow

In an Oracle implementation this could be represented as

 attribute >= ((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI'))/24/60

 AND
 attribute < ((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+(1/24/60))/24/60
 

Specified by:

createTimeIsNow in interface ISqlStyle

Overrides:

createTimeIsNow in class AbstractSqlStyle

createTimeIsNotNow

public String createTimeIsNotNow(String attribute)

Description copied from interface: ISqlStyle

P.NAME timeIsNow

In an Oracle implementation this could be represented as

 attribute < ((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI'))/24/60

 OR
 attribute > ((TO_CHAR(SYSDATE,'HH24')*60)+TO_CHAR(SYSDATE,'MI')+(1/24/60))/24/60
 

Specified by:

createTimeIsNotNow in interface ISqlStyle

Overrides:

createTimeIsNotNow in class AbstractSqlStyle

createTimeIsInMinutes

public String createTimeIsInMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute >=((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24/60))/24/60
 AND
 attribute <((TO_CHAR(SYSDATE,'HH24')*60)+TO_CHAR(SYSDATE,'MI')+(( :firstBind +1)/24/60))/24/60
 

Specified by:

createTimeIsInMinutes in interface ISqlStyle

Overrides:

createTimeIsInMinutes in class AbstractSqlStyle

createTimeIsInHours

public String createTimeIsInHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >=((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24))/24/60
 AND
 attribute <((TO_CHAR(SYSDATE,'HH24')*60)+TO_CHAR(SYSDATE,'MI')+( :firstBind /24)+(1/24/60))/24/60
 

Specified by:

createTimeIsInHours in interface ISqlStyle

Overrides:

createTimeIsInHours in class AbstractSqlStyle

createTimeIsInLEMinutes

public String createTimeIsInLEMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInLEMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute <((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+(( :firstBind +1)/24/60))/24/60
 

Specified by:

createTimeIsInLEMinutes in interface ISqlStyle

Overrides:

createTimeIsInLEMinutes in class AbstractSqlStyle

createTimeIsInLEHours

public String createTimeIsInLEHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInLEHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute <((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24)+(1/24/60))/24/60
 

Specified by:

createTimeIsInLEHours in interface ISqlStyle

Overrides:

createTimeIsInLEHours in class AbstractSqlStyle

createTimeIsInGEMinutes

public String createTimeIsInGEMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInGEMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >=((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24/60))/24/60
 

Specified by:

createTimeIsInGEMinutes in interface ISqlStyle

Overrides:

createTimeIsInGEMinutes in class AbstractSqlStyle

createTimeIsInGEHours

public String createTimeIsInGEHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInGEHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute >=((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24))/24/60
 

Specified by:

createTimeIsInGEHours in interface ISqlStyle

Overrides:

createTimeIsInGEHours in class AbstractSqlStyle