how can i fix this DBPool???
... how can i fix this DBPool??? slzang hi all: I am using a dbpool written by myself,but recently i find there are some trouble to connect ... server set wait_timeout=28800(default 8hours),so when the connections in dbpool do not be used in 8 hours, mysql server will disconnect it,then ...
http://www.javakb.com/Uwe/Forum.aspx/java-databases/1202
[ANN] DBPool : JDBC Connection Pooling - v4.7.2 released
... 2), and is available for download from http://www.snaq.net/java/DBPool/ DBPool is a pure-Java library for the pooling of ... ANN] DBPool : JDBC Connection Pooling - v4.7.2 released G Winstanley A new version of ...
http://www.javakb.com/Uwe/Forum.aspx/java-databases/1951
[ANN] DBPool : JDBC Connection Pooling - v4.7 released
... ANN] DBPool : JDBC Connection Pooling - v4.7 released [ANN] DBPool : JDBC Connection Pooling - v4.7 released Stan 20 Dec 2004 23:25 GMT A ... caching of statements * It's FREE, and source code is included DBPool has been used in many large-scale commercial applications throughout it's lifetime ...
http://www.javakb.com/Uwe/Threads/Article.aspx/java-announce/577
DBPool.jar / Mysql Creates a new pool for each connection
... from http://www.thep.lu.se/~nicklas/base2/download/mysql_example4.zip instaled the DBPool.jar ect I lauched the ConnectionPool.java program all seemed good. Now toDBPool.jar / Mysql Creates a new pool for each connection Fred Hi ...
http://www.javakb.com/Uwe/Forum.aspx/java-databases/936
Deadlock occurs on my application frequently
... Connection conn = null; Statement stmt = null; ResultSet rs = null; try{ while(true){ if(conn == null){ // dbPool is a connection pool by Proxool conn = dbPool.getConnection(); conn.setAutoCommit(false); } String sql = "SELECT url FROM rss ORDER BY id ASC"; stmt ... the RSSParser String title = RSSParser.getTitle(url); Connection conn = null; Statement stmt = null; try{ conn = ...
http://www.javakb.com/Uwe/Forum.aspx/java-databases/2303
About connection pooling
... I can use to make my servlet to pool connections (eg. DBPool, DBCP, JNDI (?))? Which of these pools should I use? Cheers, Mika Juha Laiho ...
http://www.javakb.com/Uwe/Forum.aspx/java-databases/1995
Database connection pool design
... approach? Thanks in advance, Tivo G Winstanley Take a look at DBPool: http://www.snaq.net/java/DBPool/ It can be easily configured to expire unused connections after a certain ...
http://www.javakb.com/Uwe/Forum.aspx/java-programmer/8868
How to get the data from a huge table efficiently?
... int queryEachTime = 1000; int queryFrequency = 5000; Connection conn = null; try { while(true) { if(conn == null){ // "dbPool" is a connection pool conn = dbPool.getConnection(); } CallableStatement qstmt = conn.prepareCall(sql, ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); //qstmt.setMaxRows(queryEachTime); //qstmt.setFetchSize ...
http://www.javakb.com/Uwe/Forum.aspx/java-databases/2271
Connection Pooling for multiple JSP's
... DB connection. I had seen an Enterprise Servlet example, that created a static DBPool in the init() method. There were obvious performance benefits, but I'm ...
http://www.javakb.com/Uwe/Forum.aspx/java-setup/1073
Can connection poolong be implemented in the simple java class?
... could achieve what you want, for example: Jakarta DBCP (as already mentioned) Proxool DBPool etc. Stan Garg As i am writing a very simple java program with ...
http://www.javakb.com/Uwe/Forum.aspx/java-programmer/34763