Alberto, I know that the getNumActive etc was added because of my request to use DBCP with dbforms.. Then there was some discussion on the commons mailing list about that, and there have been a fair number of changes.. However, I haven't updated my DBCP in a while, so I think that the difference is between your newer code base and my older codebase...
I will try and update my DBCP sometime today and see what happens, if you make progress let me know.. I would like to better integrated DBConnection in.. Also, have you looked at instead using JNDI, and creating your pool via tomcat, and then using DBForms JNDI support to just get your connection that way? Eric -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alberto Bolchini Sent: Wednesday, June 05, 2002 6:37 AM To: Eric Pugh; [EMAIL PROTECTED] Subject: RE: [dbforms] Commons-DBCP Connection Pool Hi Eric, I'm trying to test your DBConnection.java with the following env: platform: MS W2000 container: Tomcat 4.0.4-b2 database: PostgreSql 7.2.1 (running in cygwin) commons: to-nightly build (20020605) of both commons-dbcp and commons-pool. I siply followed your directions (checked out your posts on commons-dev as well) and at the fisrt call, everything seems to work: I get a "returning a connection" message, and a "Current Connections: active:0, idle:0" as well, the connection actually works and I get the resultset expected. After that, though, the subsequent call breaks at the commons-dbcp level, as I get a java.lang.NoSuchMethodError at org.apache.commons.dbcp.BasicDataSource.getNumActive(BasicDataSource.jav a:188) Have you ever experienced this sort of situation in your tests? Thanks. Alberto. -=(-----Original Message----- -=(From: Eric Pugh [mailto:[EMAIL PROTECTED]] -=(Sent: Tuesday, April 30, 2002 10:41 PM -=(To: 'Majid latif'; [EMAIL PROTECTED] -=(Subject: [dbforms] Commons-DBCP Connection Pool -=( -=( -=(Hi all, -=( -=(I looked at Poolman, and saw enough problems said about it -=(that I didn't -=(want to try and use that as the connection pooling -=(mechanism. However, -=(DbForms definitly needs one. I went and took a stab and -=(getting the DBCP -=(pool from the Jakarta Commons project to work. It seems to -=(work okay, but I -=(have only tested it -=(on MS SqlServer with the MS jdbc driver. I would love it if -=(other people -=(would give my changes a try. -=( -=(Also, I have not tested it under serious loads. Some of the -=(issues I have -=(found is that you must specify a max active connections, -=(otherwise it seems -=(to not get any connections. -=( -=(Also, I haven't tied the DbConnection.java class into being -=(setup in a good -=(way, for instance, with my copy you must have -=(commons-dbcp.jar in your path -=(so you can access the BasicDataSource. -=( -=(I will attach my DbConnection.java class. -=( -=(Below is my dbforms-config, notice the isJndi setting to -=(swap between DBCP -=(and not: -=( -=( <dbconnection -=( name = -=("jdbc:microsoft:sqlserver://trujillo:1433;DatabaseName=kinase -=(profiler" -=( isJndi = "DataSource" -=( conClass = -=("com.microsoft.jdbc.sqlserver.SQLServerDriver" -=( username = "SUserLogin" -=( password = "XXXXXX" -=( /> -=( -=( -=(Feed back much appreciated! -=( -=(Eric Pugh -=( _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
