org.synchronoss.cpo.jdbc
Class JdbcDataSource

Package class diagram package JdbcDataSource
java.lang.Object
  extended by org.synchronoss.cpo.jdbc.JdbcDataSource
All Implemented Interfaces:
javax.sql.DataSource

public class JdbcDataSource
extends java.lang.Object
implements javax.sql.DataSource

A class for preallocating, recycling, and managing JDBC connections.

Taken from Core Servlets and JavaServer Pages from Prentice Hall and Sun Microsystems Press, http://www.coreservlets.com/. © 2000 Marty Hall; may be freely used or adapted.


Constructor Summary
JdbcDataSource(JdbcDataSourceInfo jdsi)
           
 
Method Summary
protected  void closeAllConnections()
          Close all the connections.
 void free(java.sql.Connection connection)
           
 java.sql.CallableStatement getCachedCallableStatement(java.sql.Connection c, java.lang.String sql)
           
 java.sql.CallableStatement getCachedCallableStatement(java.sql.Connection c, java.lang.String sql, int resultSetType, int resultSetConcurrency)
           
 java.sql.CallableStatement getCachedCallableStatement(java.sql.Connection c, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
           
 java.sql.CallableStatement getCachedCallableStatement(java.sql.Connection c, java.lang.String sql, java.lang.String key)
           
 java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c, java.lang.String sql)
           
 java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c, java.lang.String sql, int autoGeneratedKeys)
           
 java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c, java.lang.String sql, int[] columns)
           
 java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c, java.lang.String sql, int resultSetType, int resultSetConcurrency)
           
 java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
           
 java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c, java.lang.String sql, java.lang.String key)
           
 java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c, java.lang.String sql, java.lang.String[] columns)
           
 java.sql.Connection getConnection()
           
 java.sql.Connection getConnection(java.lang.String userName, java.lang.String password)
           
 JdbcDataSourceInfo getDataSourceInfo()
           
 int getLoginTimeout()
           
 java.io.PrintWriter getLogWriter()
           
 void setDataSourceInfo(JdbcDataSourceInfo dataSourceInfo)
           
 void setLoginTimeout(int seconds)
           
 void setLogWriter(java.io.PrintWriter out)
           
 java.lang.String toString()
           
protected  int totalConnections()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

JdbcDataSource

public JdbcDataSource(JdbcDataSourceInfo jdsi)
               throws java.sql.SQLException
Throws:
java.sql.SQLException
Method Detail

getConnection

public java.sql.Connection getConnection(java.lang.String userName,
                                         java.lang.String password)
                                  throws java.sql.SQLException
Specified by:
getConnection in interface javax.sql.DataSource
Throws:
java.sql.SQLException

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException
Specified by:
getConnection in interface javax.sql.DataSource
Throws:
java.sql.SQLException

free

public void free(java.sql.Connection connection)

totalConnections

protected int totalConnections()

closeAllConnections

protected void closeAllConnections()
Close all the connections. Use with caution: be sure no connections are in use before calling. Note that you are not required to call this when done with a JdbcDataSource, since connections are guaranteed to be closed when garbage collected. But this method gives more control regarding when the connections are closed.


toString

public java.lang.String toString()
Overrides:
toString in class java.lang.Object

getLogWriter

public java.io.PrintWriter getLogWriter()
                                 throws java.sql.SQLException
Specified by:
getLogWriter in interface javax.sql.DataSource
Throws:
java.sql.SQLException

setLogWriter

public void setLogWriter(java.io.PrintWriter out)
                  throws java.sql.SQLException
Specified by:
setLogWriter in interface javax.sql.DataSource
Throws:
java.sql.SQLException

setLoginTimeout

public void setLoginTimeout(int seconds)
                     throws java.sql.SQLException
Specified by:
setLoginTimeout in interface javax.sql.DataSource
Throws:
java.sql.SQLException

getLoginTimeout

public int getLoginTimeout()
                    throws java.sql.SQLException
Specified by:
getLoginTimeout in interface javax.sql.DataSource
Throws:
java.sql.SQLException

getCachedCallableStatement

public java.sql.CallableStatement getCachedCallableStatement(java.sql.Connection c,
                                                             java.lang.String sql,
                                                             java.lang.String key)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedPreparedStatement

public java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c,
                                                             java.lang.String sql,
                                                             java.lang.String key)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedPreparedStatement

public java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c,
                                                             java.lang.String sql)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedPreparedStatement

public java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c,
                                                             java.lang.String sql,
                                                             int autoGeneratedKeys)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedPreparedStatement

public java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c,
                                                             java.lang.String sql,
                                                             int[] columns)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedPreparedStatement

public java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c,
                                                             java.lang.String sql,
                                                             java.lang.String[] columns)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedPreparedStatement

public java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c,
                                                             java.lang.String sql,
                                                             int resultSetType,
                                                             int resultSetConcurrency)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedPreparedStatement

public java.sql.PreparedStatement getCachedPreparedStatement(java.sql.Connection c,
                                                             java.lang.String sql,
                                                             int resultSetType,
                                                             int resultSetConcurrency,
                                                             int resultSetHoldability)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedCallableStatement

public java.sql.CallableStatement getCachedCallableStatement(java.sql.Connection c,
                                                             java.lang.String sql)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedCallableStatement

public java.sql.CallableStatement getCachedCallableStatement(java.sql.Connection c,
                                                             java.lang.String sql,
                                                             int resultSetType,
                                                             int resultSetConcurrency)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getCachedCallableStatement

public java.sql.CallableStatement getCachedCallableStatement(java.sql.Connection c,
                                                             java.lang.String sql,
                                                             int resultSetType,
                                                             int resultSetConcurrency,
                                                             int resultSetHoldability)
                                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getDataSourceInfo

public JdbcDataSourceInfo getDataSourceInfo()
Returns:
Returns the dataSourceInfo.

setDataSourceInfo

public void setDataSourceInfo(JdbcDataSourceInfo dataSourceInfo)
Parameters:
dataSourceInfo - The dataSourceInfo to set.


Copyright © 2009. All Rights Reserved.