atom feed11 messages in org.apache.commons.devQuestion about DBCP
FromSent OnAttachments
Steve CohenApr 29, 2002 9:29 pm.txt
Brekke, JeffApr 30, 2002 7:03 am 
Eric PughApr 30, 2002 7:19 am 
Eric PughApr 30, 2002 7:25 am.java
AnjanApr 30, 2002 9:41 am 
Eric PughApr 30, 2002 10:18 am 
Eric PughApr 30, 2002 10:30 am 
Craig R. McClanahanApr 30, 2002 11:06 am 
Anjan BacchuApr 30, 2002 11:40 am 
Eric PughApr 30, 2002 1:53 pm 
Craig R. McClanahanApr 30, 2002 2:19 pm 
Subject:Question about DBCP
From:Eric Pugh (epu@upstate.com)
Date:Apr 30, 2002 7:19:14 am
List:org.apache.commons.dev

Hi all,

Can anyone provide pointers to open source sites using DBCP? I am trying to get DBCP to work with DbForms (www.dbforms.org). DbForms currently uses Poolman as it's suggested pool for JDBC connections, but it badly needs something newer and easier to set up!

I have managed to tweak the class ManualPoolingDataSourceExample to work with MSSql Server. However, what is confusing to me is how in the example my jdbc driver is passed in? I see it goes in from the commandline as -Djdbc.drivers=oracle.jdbc.driver.OracleDriver, but I never see how it get's used. In addition, when i hardcoded my driver, I couldn't get it to work until I added a Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") at the top of the code in my copy of ManualPoolingDataSourceExample.

Can someone give me some pointers on how the -Djdbc.drivers value actually get's registered with the DriverManager?

Also, how can I verify that I am actually pooling connections, versus creating a new one over and over?

I have attached my copy of ManualPoolingDataSourceExample that I have renamed to ManualPoolingDataSourceTest, and am using under JUnit to test.

Eric