[ http://issues.apache.org/jira/browse/DBCP-128?page=all ]
Phil Steitz updated DBCP-128: ----------------------------- Bugzilla Id: (was: 39537) Version: 1.3 (was: Nightly Builds) > [dbcp] BasicDataSource.getConnection() Connections don't work as hashtable > keys -- test case provided > ----------------------------------------------------------------------------------------------------- > > Key: DBCP-128 > URL: http://issues.apache.org/jira/browse/DBCP-128 > Project: Commons Dbcp > Type: Bug > Versions: 1.3 > Environment: Operating System: Linux > Platform: PC > Reporter: vegandy > Attachments: BasicDataSourceExample.java.patch > > 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] $-> -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]