org.outerj.daisy.jdbcutil
Class JdbcHelper

java.lang.Object
  org.outerj.daisy.jdbcutil.JdbcHelper

public abstract class JdbcHelper
extends java.lang.Object

Method Summary

void	closeConnection(java.sql.Connection conn)
void	closeStatement(java.sql.Statement stmt)
java.lang.String[]	getDayOfMonthFunction()
java.lang.String[]	getDayOfWeekFunction()
java.lang.String[]	getDayOfYearFunction()
java.lang.String[]	getExtractMonthFunction() 1 = January
java.lang.String[]	getExtractYearFunction()
static JdbcHelper	getInstance(javax.sql.DataSource dataSource, org.apache.avalon.framework.logger.Logger logger)
static JdbcHelper	getInstance(java.lang.String databaseProductName, org.apache.avalon.framework.logger.Logger logger)
abstract java.lang.String	getSharedLockClause()
java.lang.String[]	getStringConcatFunction()
java.lang.String[]	getStringLengthFunction() Returns the name of a SQL function that gets the length of a string (in characters, not in bytes).
java.lang.String[]	getWeekFunction() First week = week with a sunday.
void	rollback(java.sql.Connection conn)
abstract void	startTransaction(java.sql.Connection conn)

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

public static JdbcHelper getInstance(java.lang.String databaseProductName,
                                     org.apache.avalon.framework.logger.Logger logger)

getInstance

public static JdbcHelper getInstance(javax.sql.DataSource dataSource,
                                     org.apache.avalon.framework.logger.Logger logger)

closeStatement

public void closeStatement(java.sql.Statement stmt)

closeConnection

public void closeConnection(java.sql.Connection conn)

rollback

public void rollback(java.sql.Connection conn)

startTransaction

public abstract void startTransaction(java.sql.Connection conn)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getSharedLockClause

public abstract java.lang.String getSharedLockClause()

getStringLengthFunction

public java.lang.String[] getStringLengthFunction()

Returns the name of a SQL function that gets the length of a string (in characters, not in bytes).

getStringConcatFunction

public java.lang.String[] getStringConcatFunction()

getExtractYearFunction

public java.lang.String[] getExtractYearFunction()

getExtractMonthFunction

public java.lang.String[] getExtractMonthFunction()

1 = January

getDayOfWeekFunction

public java.lang.String[] getDayOfWeekFunction()

getDayOfMonthFunction

public java.lang.String[] getDayOfMonthFunction()

getDayOfYearFunction

public java.lang.String[] getDayOfYearFunction()

getWeekFunction

public java.lang.String[] getWeekFunction()

First week = week with a sunday.