org.synchronoss.cpo.jdbc
Class JdbcDataSource
java.lang.Object
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.
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()
|
boolean |
isWrapperFor(java.lang.Class<?> iface)
|
void |
setDataSourceInfo(JdbcDataSourceInfo dataSourceInfo)
|
void |
setLoginTimeout(int seconds)
|
void |
setLogWriter(java.io.PrintWriter out)
|
java.lang.String |
toString()
|
protected int |
totalConnections()
|
|
unwrap(java.lang.Class<T> iface)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
JdbcDataSource
public JdbcDataSource(JdbcDataSourceInfo jdsi)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
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.
unwrap
public <T> T unwrap(java.lang.Class<T> iface)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
isWrapperFor
public boolean isWrapperFor(java.lang.Class<?> iface)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
Copyright © 2010. All Rights Reserved.