Support Forums: Message List - Designing and Testing JDBC Code http://www.theserverside.com Most recent forum messages en Jive Forums Silver 5.5.30 (www.jivesoftware.com) Wed, 22 May 2013 07:40:46 -0400 This code is *not* quite nasty http://www.theserverside.com/discussions/thread.tss?thread_id=24308 You have a connection pool and there are a lot of queries to the database. The connection are shared between users are closed very rarely, only when unused for a long period of time. This is the case of most application servers....]]> Thu, 04 Mar 2004 10:49:28 -0500 Thu, 04 Mar 2004 10:49:28 -0500 Thu, 04 Mar 2004 10:49:28 -0500 Mar 4, 2004 Bob Lee 0 This code really is *a bit* nasty in its potential effects http://www.theserverside.com/discussions/thread.tss?thread_id=24308 I've seen this problem often enough and recently enough to believe that it's reasonably common for connections not to cascade the cleanup, despite what the javadocs say. I don't think this behaviour was explicitly mentioned in the...]]> Thu, 04 Mar 2004 10:47:28 -0500 Thu, 04 Mar 2004 10:47:28 -0500 Thu, 04 Mar 2004 10:47:28 -0500 Mar 4, 2004 Bob Lee 0 This code is *not* quite nasty http://www.theserverside.com/discussions/thread.tss?thread_id=24308 Thu, 04 Mar 2004 10:46:19 -0500 Thu, 04 Mar 2004 10:46:19 -0500 Thu, 04 Mar 2004 10:46:19 -0500 Mar 4, 2004 Mircea Crisan 1 This code really is *a bit* nasty in its potential effects http://www.theserverside.com/discussions/thread.tss?thread_id=24308 Wed, 03 Mar 2004 19:18:57 -0500 Wed, 03 Mar 2004 19:18:57 -0500 Wed, 03 Mar 2004 19:18:57 -0500 Mar 3, 2004 David Friar 1 This code is *not* quite nasty http://www.theserverside.com/discussions/thread.tss?thread_id=24308 I hope someone can correct me on this but it isn't my understanding that closing a connection implicitly closes statements. Sure, any statements that were created for a given connection will not be usable after the connection has...]]> Wed, 03 Mar 2004 17:50:15 -0500 Wed, 03 Mar 2004 17:50:15 -0500 Wed, 03 Mar 2004 17:50:15 -0500 Mar 3, 2004 Bob Lee 4 This code is quite nasty http://www.theserverside.com/discussions/thread.tss?thread_id=24308 ...]]> Wed, 03 Mar 2004 16:21:45 -0500 Wed, 03 Mar 2004 16:21:45 -0500 Wed, 03 Mar 2004 16:21:45 -0500 Mar 3, 2004 David Friar 5 This code is quite nasty http://www.theserverside.com/discussions/thread.tss?thread_id=24308 Err, Bob, ever though about closing your statements? In a finally clause perhaps?...]]> Wed, 03 Mar 2004 15:46:09 -0500 Wed, 03 Mar 2004 15:46:09 -0500 Wed, 03 Mar 2004 15:46:09 -0500 Mar 3, 2004 Bob Lee 6 This code is quite nasty http://www.theserverside.com/discussions/thread.tss?thread_id=24308 Wed, 03 Mar 2004 15:07:49 -0500 Wed, 03 Mar 2004 15:07:49 -0500 Wed, 03 Mar 2004 15:07:49 -0500 Mar 3, 2004 David Friar 7 Designing and Testing JDBC Code http://www.theserverside.com/discussions/thread.tss?thread_id=24308 In my experience, most DAO problems found in unit tests are a result of the application being out of sync with the database structure....]]> Wed, 03 Mar 2004 14:32:48 -0500 Wed, 03 Mar 2004 14:32:48 -0500 Wed, 03 Mar 2004 14:32:48 -0500 Mar 3, 2004 Slava Imeshev 0 Reasons for separated SQL, take 2 http://www.theserverside.com/discussions/thread.tss?thread_id=24308 My experience is that ~10% of the DAO methods end up having custom SQL queries that are not supported by HSQLDB....]]> Wed, 03 Mar 2004 14:20:53 -0500 Wed, 03 Mar 2004 14:20:53 -0500 Wed, 03 Mar 2004 14:20:53 -0500 Mar 3, 2004 Juozas Baliuka 0 Answer: http://www.theserverside.com/discussions/thread.tss?thread_id=24308 Wed, 03 Mar 2004 13:58:53 -0500 Wed, 03 Mar 2004 13:58:53 -0500 Wed, 03 Mar 2004 13:58:53 -0500 Mar 3, 2004 Jason Jones 0 Designing and Testing JDBC Code http://www.theserverside.com/discussions/thread.tss?thread_id=24308 In my experience, most DAO problems found in unit tests are a result of the application being out of sync with the database structure....]]> Wed, 03 Mar 2004 13:49:00 -0500 Wed, 03 Mar 2004 13:49:00 -0500 Wed, 03 Mar 2004 13:49:00 -0500 Mar 3, 2004 Juozas Baliuka 0 Designing and Testing JDBC Code http://www.theserverside.com/discussions/thread.tss?thread_id=24308 Wed, 03 Mar 2004 13:05:01 -0500 Wed, 03 Mar 2004 13:05:01 -0500 Wed, 03 Mar 2004 13:05:01 -0500 Mar 3, 2004 Jeff Drost 2 Designing and Testing JDBC Code http://www.theserverside.com/discussions/thread.tss?thread_id=24308 Wed, 03 Mar 2004 12:52:50 -0500 Wed, 03 Mar 2004 12:52:50 -0500 Wed, 03 Mar 2004 12:52:50 -0500 Mar 3, 2004 Slava Imeshev 0 Keeping Database Agnostic?? http://www.theserverside.com/discussions/thread.tss?thread_id=24308 Wed, 03 Mar 2004 12:38:28 -0500 Wed, 03 Mar 2004 12:38:28 -0500 Wed, 03 Mar 2004 12:38:28 -0500 Mar 3, 2004 Rob Harrop 0