Java Doc for CacheConnection.java in  » Database-JDBC-Connection-Pool » DBPool » snaq » db » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation
1. 6.0 JDK Core
2. 6.0 JDK Modules
3. 6.0 JDK Modules com.sun
4. 6.0 JDK Modules com.sun.java
5. 6.0 JDK Modules sun
6. 6.0 JDK Platform
7. Ajax
8. Apache Harmony Java SE
9. Aspect oriented
10. Authentication Authorization
11. Blogger System
12. Build
13. Byte Code
14. Cache
15. Chart
16. Chat
17. Code Analyzer
18. Collaboration
19. Content Management System
20. Database Client
21. Database DBMS
22. Database JDBC Connection Pool
23. Database ORM
24. Development
25. EJB Server geronimo
26. EJB Server GlassFish
27. EJB Server JBoss 4.2.1
28. EJB Server resin 3.1.5
29. ERP CRM Financial
30. ESB
31. Forum
32. GIS
33. Graphic Library
34. Groupware
35. HTML Parser
36. IDE
37. IDE Eclipse
38. IDE Netbeans
39. Installer
40. Internationalization Localization
41. Inversion of Control
42. Issue Tracking
43. J2EE
44. JBoss
45. JMS
46. JMX
47. Library
48. Mail Clients
49. Net
50. Parser
51. PDF
52. Portal
53. Profiler
54. Project Management
55. Report
56. RSS RDF
57. Rule Engine
58. Science
59. Scripting
60. Search Engine
61. Security
62. Sevlet Container
63. Source Control
64. Swing Library
65. Template Engine
66. Test Coverage
67. Testing
68. UML
69. Web Crawler
70. Web Framework
71. Web Mail
72. Web Server
73. Web Services
74. Web Services apache cxf 2.0.1
75. Web Services AXIS2
76. Wiki Engine
77. Workflow Engines
78. XML
79. XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation » Database JDBC Connection Pool » DBPool » snaq.db 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   snaq.db.CacheConnection

CacheConnection
final public class CacheConnection implements Connection,StatementListener,Reusable(Code)
Connection wrapper that implements statement caching.
See Also:   snaq.db.CachedStatement
See Also:   snaq.db.CachedPreparedStatement
See Also:   snaq.db.CachedCallableStatement
author:
   Giles Winstanley


Field Summary
protected  Connectioncon
    
protected  Mapcs
    
protected  ListcsUsed
    
protected  ListnonCachable
    
protected  ConnectionPoolpool
    
protected  Mapps
    
protected  ListpsUsed
    
protected  Listss
    
protected  ListssUsed
    

Constructor Summary
public  CacheConnection(ConnectionPool pool, Connection con)
     Creates a new CacheConnection object, using the supplied Connection.

Method Summary
public  voidclearWarnings()
    
public  voidclose()
     Overrides method to provide caching support.
public  voidcommit()
    
public  StatementcreateStatement()
     Overrides method to provide caching support.
public  StatementcreateStatement(int resultSetType, int resultSetConcurrency)
     Overrides method to provide caching support.
public  StatementcreateStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)
     Overrides method to provide caching support.
protected  voidflushOpenCallableStatements()
     Flushes the open CallableStatement cache for this connection.
protected  voidflushOpenNonCachableStatements()
     Flushes the non-cachable Statements for this connection.
protected  voidflushOpenPreparedStatements()
     Flushes the open PreparedStatement cache for this connection.
protected  voidflushOpenStatements()
     Flushes the open Statement cache for this connection.
protected  voidflushSpareCallableStatements()
     Flushes the spare CallableStatement cache for this connection.
protected  voidflushSparePreparedStatements()
     Flushes the spare PreparedStatement cache for this connection.
protected  voidflushSpareStatements()
     Flushes the spare Statement caches for this connection.
public  booleangetAutoCommit()
    
public  StringgetCatalog()
    
public  intgetHoldability()
    
public  DatabaseMetaDatagetMetaData()
    
public  intgetOpenCallableStatementCount()
     Returns the current number of CallableStatements that are in use.
public  intgetOpenNonCachableStatementCount()
     Returns the current number of non-cachable statements that are in use.
public  intgetOpenPreparedStatementCount()
     Returns the current number of PreparedStatements that are in use (not including CallableStatements).
public  intgetOpenStatementCount()
     Returns the current number of Statements that are in use (not including PreparedStatements & CallableStatements).
public  ConnectiongetRawConnection()
     Returns the raw underlying Connection object for which this provides a wrapper.
public  intgetSpareCallableStatementCount()
     Returns the current number of spare CallableStatements that are cached.
public  intgetSparePreparedStatementCount()
     Returns the current number of spare PreparedStatements that are cached.
public  intgetSpareStatementCount()
     Returns the current number of spare Statements that are cached.
public  intgetTransactionIsolation()
    
public  MapgetTypeMap()
    
public  SQLWarninggetWarnings()
    
public  booleanisCachingAllStatements()
     Returns whether caching of CallableStatements is enabled.
public  booleanisCachingCallableStatements()
     Returns whether caching of CallableStatements is enabled.
public  booleanisCachingPreparedStatements()
     Returns whether caching of CallableStatements is enabled.
public  booleanisCachingStatements()
     Returns whether caching of CallableStatements is enabled.
public  booleanisClosed()
    
 booleanisOpen()
     Added to provide caching support.
public  booleanisReadOnly()
    
public  StringnativeSQL(String sql)
    
public  CallableStatementprepareCall(String sql)
     Overrides method to provide caching support.
public  CallableStatementprepareCall(String sql, int resultSetType, int resultSetConcurrency)
     Overrides method to provide caching support.
public  CallableStatementprepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
     Overrides method to provide caching support.
public  PreparedStatementprepareStatement(String sql)
     Overrides method to provide caching support.
public  PreparedStatementprepareStatement(String sql, int resultSetType, int resultSetConcurrency)
     Overrides method to provide caching support.
public  PreparedStatementprepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
     Overrides method to provide caching support.
public  PreparedStatementprepareStatement(String sql, int autoGeneratedKeys)
    
public  PreparedStatementprepareStatement(String sql, int[] columnIndexes)
    
public  PreparedStatementprepareStatement(String sql, String[] columnNames)
    
public  voidrecycle()
     Puts connection back in a state where it can be reused.
public  voidrelease()
     Destroys the wrapped connection.
public  voidreleaseSavepoint(Savepoint savepoint)
    
public  voidrollback()
    
public  voidrollback(Savepoint savepoint)
    
public  voidsetAutoCommit(boolean autoCommit)
    
public  voidsetCacheAll(boolean cache)
     Sets whether to use caching for all types of Statement.
public  voidsetCacheCallableStatements(boolean cache)
     Sets whether to use caching for CallableStatements.
public  voidsetCachePreparedStatements(boolean cache)
     Sets whether to use caching for PreparedStatements.
public  voidsetCacheStatements(boolean cache)
     Sets whether to use caching for Statements.
public  voidsetCatalog(String catalog)
    
public  voidsetHoldability(int holdability)
    
 voidsetOpen()
     Added to provide caching support.
public  voidsetReadOnly(boolean readOnly)
    
public  SavepointsetSavepoint()
    
public  SavepointsetSavepoint(String name)
    
public  voidsetTransactionIsolation(int level)
    
public  voidsetTypeMap(Map map)
    
public  voidstatementClosed(CachedStatement s)
     Callback invoked when a statement is closed.

Field Detail
con
protected Connection con(Code)



cs
protected Map cs(Code)



csUsed
protected List csUsed(Code)



nonCachable
protected List nonCachable(Code)



pool
protected ConnectionPool pool(Code)



ps
protected Map ps(Code)



psUsed
protected List psUsed(Code)



ss
protected List ss(Code)



ssUsed
protected List ssUsed(Code)




Constructor Detail
CacheConnection
public CacheConnection(ConnectionPool pool, Connection con)(Code)
Creates a new CacheConnection object, using the supplied Connection.




Method Detail
clearWarnings
public void clearWarnings() throws SQLException(Code)



close
public void close() throws SQLException(Code)
Overrides method to provide caching support.



commit
public void commit() throws SQLException(Code)



createStatement
public Statement createStatement() throws SQLException(Code)
Overrides method to provide caching support.



createStatement
public Statement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException(Code)
Overrides method to provide caching support.



createStatement
public Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException(Code)
Overrides method to provide caching support.



flushOpenCallableStatements
protected void flushOpenCallableStatements() throws SQLException(Code)
Flushes the open CallableStatement cache for this connection.



flushOpenNonCachableStatements
protected void flushOpenNonCachableStatements() throws SQLException(Code)
Flushes the non-cachable Statements for this connection.



flushOpenPreparedStatements
protected void flushOpenPreparedStatements() throws SQLException(Code)
Flushes the open PreparedStatement cache for this connection.



flushOpenStatements
protected void flushOpenStatements() throws SQLException(Code)
Flushes the open Statement cache for this connection.



flushSpareCallableStatements
protected void flushSpareCallableStatements() throws SQLException(Code)
Flushes the spare CallableStatement cache for this connection.



flushSparePreparedStatements
protected void flushSparePreparedStatements() throws SQLException(Code)
Flushes the spare PreparedStatement cache for this connection.



flushSpareStatements
protected void flushSpareStatements() throws SQLException(Code)
Flushes the spare Statement caches for this connection.



getAutoCommit
public boolean getAutoCommit() throws SQLException(Code)



getCatalog
public String getCatalog() throws SQLException(Code)



getHoldability
public int getHoldability() throws SQLException(Code)



getMetaData
public DatabaseMetaData getMetaData() throws SQLException(Code)



getOpenCallableStatementCount
public int getOpenCallableStatementCount()(Code)
Returns the current number of CallableStatements that are in use.



getOpenNonCachableStatementCount
public int getOpenNonCachableStatementCount()(Code)
Returns the current number of non-cachable statements that are in use. (Currently only some PreparedStatements are non-cachable by virtue of a request made at creation for support for auto-generated keys.)
See Also:   snaq.db.CacheConnection.prepareStatement(Stringint)
See Also:   snaq.db.CacheConnection.prepareStatement(Stringint[])
See Also:   snaq.db.CacheConnection.prepareStatement(StringString[])



getOpenPreparedStatementCount
public int getOpenPreparedStatementCount()(Code)
Returns the current number of PreparedStatements that are in use (not including CallableStatements).



getOpenStatementCount
public int getOpenStatementCount()(Code)
Returns the current number of Statements that are in use (not including PreparedStatements & CallableStatements).



getRawConnection
public Connection getRawConnection()(Code)
Returns the raw underlying Connection object for which this provides a wrapper. This is provided as a convenience method for using database-specific features for which the Connection object needs to be upcast. (e.g. to use Oracle-specific features needs to be cast to oracle.jdbc.OracleConnection). To maintain the stability of the pooling system it is important that the raw connection is not destabilized when used in this way.



getSpareCallableStatementCount
public int getSpareCallableStatementCount()(Code)
Returns the current number of spare CallableStatements that are cached.



getSparePreparedStatementCount
public int getSparePreparedStatementCount()(Code)
Returns the current number of spare PreparedStatements that are cached.



getSpareStatementCount
public int getSpareStatementCount()(Code)
Returns the current number of spare Statements that are cached.



getTransactionIsolation
public int getTransactionIsolation() throws SQLException(Code)



getTypeMap
public Map getTypeMap() throws SQLException(Code)



getWarnings
public SQLWarning getWarnings() throws SQLException(Code)



isCachingAllStatements
public boolean isCachingAllStatements()(Code)
Returns whether caching of CallableStatements is enabled.



isCachingCallableStatements
public boolean isCachingCallableStatements()(Code)
Returns whether caching of CallableStatements is enabled.



isCachingPreparedStatements
public boolean isCachingPreparedStatements()(Code)
Returns whether caching of CallableStatements is enabled.



isCachingStatements
public boolean isCachingStatements()(Code)
Returns whether caching of CallableStatements is enabled.



isClosed
public boolean isClosed() throws SQLException(Code)



isOpen
boolean isOpen()(Code)
Added to provide caching support.



isReadOnly
public boolean isReadOnly() throws SQLException(Code)



nativeSQL
public String nativeSQL(String sql) throws SQLException(Code)



prepareCall
public CallableStatement prepareCall(String sql) throws SQLException(Code)
Overrides method to provide caching support.



prepareCall
public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) throws SQLException(Code)
Overrides method to provide caching support.



prepareCall
public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException(Code)
Overrides method to provide caching support.



prepareStatement
public PreparedStatement prepareStatement(String sql) throws SQLException(Code)
Overrides method to provide caching support.



prepareStatement
public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency) throws SQLException(Code)
Overrides method to provide caching support.



prepareStatement
public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException(Code)
Overrides method to provide caching support.



prepareStatement
public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException(Code)



prepareStatement
public PreparedStatement prepareStatement(String sql, int[] columnIndexes) throws SQLException(Code)



prepareStatement
public PreparedStatement prepareStatement(String sql, String[] columnNames) throws SQLException(Code)



recycle
public void recycle() throws SQLException(Code)
Puts connection back in a state where it can be reused.



release
public void release() throws SQLException(Code)
Destroys the wrapped connection.



releaseSavepoint
public void releaseSavepoint(Savepoint savepoint) throws SQLException(Code)



rollback
public void rollback() throws SQLException(Code)



rollback
public void rollback(Savepoint savepoint) throws SQLException(Code)



setAutoCommit
public void setAutoCommit(boolean autoCommit) throws SQLException(Code)



setCacheAll
public void setCacheAll(boolean cache)(Code)
Sets whether to use caching for all types of Statement.



setCacheCallableStatements
public void setCacheCallableStatements(boolean cache)(Code)
Sets whether to use caching for CallableStatements.



setCachePreparedStatements
public void setCachePreparedStatements(boolean cache)(Code)
Sets whether to use caching for PreparedStatements.



setCacheStatements
public void setCacheStatements(boolean cache)(Code)
Sets whether to use caching for Statements.



setCatalog
public void setCatalog(String catalog) throws SQLException(Code)



setHoldability
public void setHoldability(int holdability) throws SQLException(Code)



setOpen
void setOpen()(Code)
Added to provide caching support.



setReadOnly
public void setReadOnly(boolean readOnly) throws SQLException(Code)



setSavepoint
public Savepoint setSavepoint() throws SQLException(Code)



setSavepoint
public Savepoint setSavepoint(String name) throws SQLException(Code)



setTransactionIsolation
public void setTransactionIsolation(int level) throws SQLException(Code)



setTypeMap
public void setTypeMap(Map map) throws SQLException(Code)



statementClosed
public void statementClosed(CachedStatement s) throws SQLException(Code)
Callback invoked when a statement is closed.



Methods inherited from java.lang.Object
native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc)
public boolean equals(Object obj)(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
final native public Class getClass()(Code)(Java Doc)
native public int hashCode()(Code)(Java Doc)
final native public void notify()(Code)(Java Doc)
final native public void notifyAll()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc)
final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc)
final public void wait() throws InterruptedException(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.