You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by "Phil Steitz (JIRA)" <ji...@apache.org> on 2006/09/10 07:34:23 UTC
[jira] Updated: (DBCP-128) [dbcp] BasicDataSource.getConnection()
Connections don't work as hashtable keys -- test case provided
[ http://issues.apache.org/jira/browse/DBCP-128?page=all ]
Phil Steitz updated DBCP-128:
-----------------------------
Bugzilla Id: (was: 39537)
Fix Version/s: 1.3
Affects Version/s: 1.2.1
(was: 1.3)
Fix version should have been 1.3, affects 1.2.1
> [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
> Issue Type: Bug
> Affects Versions: 1.2.1
> Environment: Operating System: Linux
> Platform: PC
> Reporter: vegandy
> Fix For: 1.3
>
> 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: www@animal $-> 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: www@animal $-> 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: www@animal $->
--
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: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org