org.outerj.daisy.jdbcutil
Class JdbcHelper

java.lang.Object
  extended by 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)
           
 java.lang.String getLowerCaseFunction()
           
abstract  java.lang.String getSharedLockClause()
           
 java.lang.String[] getStringConcatFunction()
           
 java.lang.String getStringLeftFunction()
           
 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 getStringRightFunction()
           
 java.lang.String getSubstringFunction()
           
 java.lang.String getUpperCaseFunction()
           
 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()

getStringLeftFunction

public java.lang.String getStringLeftFunction()

getStringRightFunction

public java.lang.String getStringRightFunction()

getSubstringFunction

public java.lang.String getSubstringFunction()

getLowerCaseFunction

public java.lang.String getLowerCaseFunction()

getUpperCaseFunction

public java.lang.String getUpperCaseFunction()

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.



Copyright © -2012 . All Rights Reserved.