DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUGĀ· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=39537>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED ANDĀ· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=39537 Summary: BasicDataSource.getConnection() Connections don't work as hashtable keys -- test case provided Product: Commons Version: Nightly Builds Platform: PC OS/Version: Linux Status: NEW Severity: normal Priority: P2 Component: Dbcp AssignedTo: commons-dev@jakarta.apache.org ReportedBy: [EMAIL PROTECTED] Code I'm working with uses a Connection as a key in a Hashtable, and while I was trying to move from DbConnectionBroker to DBCP, I ran into some problems. When retrieving the value from the Hashtable using the Connection originally returned by BasicDataSource.getConnection(), I don't get the value back that was inserted into the Hashtable. I get null instead. I've provided a patch to BasicDataSourceExample.java that can be used as a very basic test case. For the purposes of the test, I set up HSQLDB (originally this was discovered using JSQLConnect to connect to a MS SQL Server DB), and, using the HSQLDB's DatabaseManager, populated a database with the test data (Options -> Insert test data). The patch to BasicDataSourceExample.java the will get a connection, use it to insert a string into a Hashtable, then do some tests that show the problem, while still succssfully retrieving data from the database. Also in the patch are changes so you can provide all the arguments at the command line. I tested this with DBCP 1.2.1 with it's dependencies and with the nightly dump http://cvs.apache.org/builds/jakarta-commons/nightly/commons-dbcp/commons-dbcp-20060509.tar.gz, with the latest releases of commons-collections and commons-pool. For both tests the j2ee.jar was version 1.4 and hsqldb.jar was version 1.8.0.2. Here's the output from the session with the latest nightly build: 805: [EMAIL PROTECTED] $-> javac -cp /home/www/hsqldb/j2ee.jar:/www/classes/commons-collections-3.1.jar:/www/classes/commons-pool-1.3.jar:/home/www/hsqldb/dbcp/commons-dbcp/commons-dbcp.jar:/usr/share/java/hsqldb-1.8.0.2.jar BasicDataSourceExample.java 806: [EMAIL PROTECTED] $-> java -cp /home/www/hsqldb/j2ee.jar:/www/classes/commons-collections-3.1.jar:/www/classes/commons-pool-1.3.jar:/home/www/hsqldb/dbcp/commons-dbcp/commons-dbcp.jar:/usr/share/java/hsqldb-1.8.0.2.jar: BasicDataSourceExample "org.hsqldb.jdbcDriver" "jdbc:hsqldb:file:/home/www/hsqldb/test" "sa" "" "SELECT FIRSTNAME, LASTNAME FROM CUSTOMER" Setting up data source. Done. Creating connection. Hash contains key: jdbc:hsqldb:file:/home/www/hsqldb/test, UserName=SA, HSQL Database Engine Driver ? false Hash value for key: jdbc:hsqldb:file:/home/www/hsqldb/test, UserName=SA, HSQL Database Engine Driver ? null Hash contains value: test ? true Creating statement. Executing statement. Results: Laura Steel Susanne King Anne Miller Michael Clancy Sylvia Ringer Laura Miller Laura White James Peterson Andrew Miller James Schneider Anne Fuller Julia White George Ott Laura Ringer Bill Karsen Bill Clancy John Fuller Laura Ott Sylvia Fuller Susanne Heiniger Janet Schneider Julia Clancy Bill Ott Julia Heiniger James Sommer Sylvia Steel James Clancy Bob Sommer Susanne White Andrew Smith Bill Sommer Bob Ringer Michael Ott Mary King Julia May George Karsen John Steel Michael Clancy Andrew Heiniger Mary Karsen Susanne Miller Bill King Robert Ott Susanne Smith Sylvia Ott Janet May Andrew May Janet Fuller Robert White George Fuller 807: [EMAIL PROTECTED] $-> -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]