Hi Eric. After I moved commons sources in the project instead of using the compiled jars in the archive, things started working.... I better set up the env and build them mystelf before doing anything else.
So: the connection seems to work. I haven't looked at JNDI, actually I'm using Tomcat in developing but the target container is iPlanet, so I haven't plyed much with Tomcat. a. -=(-----Original Message----- -=(From: Eric Pugh [mailto:[EMAIL PROTECTED]] -=(Sent: Wednesday, June 05, 2002 3:59 PM -=(To: Alberto Bolchini; [EMAIL PROTECTED] -=(Subject: RE: [dbforms] Commons-DBCP Connection Pool -=( -=( -=(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(BasicDat -=(aSource.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
