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
