I noticed you modified the example so that you use the .jocl configuration file. Are you sure the poolingDriverExample.jocl in accessible to the program in your classpath. So the directory _not_ the file itself should be in your class path. Try accessing that file as a resource from within your program. Hamish
> -----Original Message----- > From: Nancy Crisostomo Martinez [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 04, 2002 7:35 PM > To: Jakarta Commons Users List > Subject: Re: [DBCP]Connection Pool examples troubles > > > Hi! > Sorry again, > > First of all THANK YOU very much Hamish, I had forgotten to > register the driver. > Now, the ManualPoolingDriverExample.java works perfect.! > > But I don't know, I think (do you agree?) it would be better > for me to use the > JOCLPoolingDriver, (because, it would be feasible to have the > pool (open) waiting > for requests from my application(is a kind of shopping cart > available in the > Intranet formed by some jsp's files which access to the DB) > So, I'm still worried because in that file > (JOCLPoolingDriverExample.java) I'm now > getting this message: > > Creating connection. > java.sql.SQLException: No pool found for > jdbc:apache:commons:dbcp:/poolingDriverExample. > at > org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:143) > at > java.sql.DriverManager.getConnection(DriverManager.java:517) > at > java.sql.DriverManager.getConnection(DriverManager.java:199) > at > connpool.JOCLPoolingDriverExample.main(JOCLPoolingDriverExampl > e.java:145) > > > And it's caused in this piece of code: > > System.out.println("Creating connection."); > here-->conn = > DriverManager.getConnection("jdbc:apache:commons:dbcp:/pooling > DriverExample"); > System.out.println("Creating statement."); > stmt = conn.createStatement(); > System.out.println("Executing statement."); > > > I set all the jar files in the classpath, even the > poolingDriverExample.jocl file > that is placed in the tomcat's lib directory �is it ok?. and > I registered the > drive like: > -Djdbc.drivers=oracle.jdbc.driver.OracleDriver:org.apache.comm ons.dbcp.PoolingDriver > > What is wrong now? > Thank you! > Nancy > > > > > Barney Hamish wrote: > > > Hello, > > It looks like you missed the instructions at the top of the > source code > > (given below). You need to register the DB driver somehow > _before_ you run > > the example program.... > > Hamish > > > > // > > // Invoke the class using two arguments: > > // * the connect string for your underlying JDBC driver > > // * the query you'd like to execute > > // You'll also want to ensure your underlying JDBC driver > > // is registered. You can use the "jdbc.drivers" > > // property to do this. > > // > > // For example: > > // java -Djdbc.drivers=oracle.jdbc.driver.OracleDriver \ > > // -classpath > > > commons-collections.jar:commons-pool.jar:commons-dbcp.jar:orac > le-jdbc.jar:. > > \ > > // ManualPoolingDriverExample > > // "jdbc:oracle:thin:scott/tiger@myhost:1521:mysid" > > // "SELECT * FROM DUAL" > > // > > > > > -----Original Message----- > > > From: Nancy Crisostomo Martinez [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, September 04, 2002 4:33 PM > > > To: Jakarta Commons Users List > > > Subject: Re: [DBCP]Connection Pool examples troubles > > > > > > > > > Hi everybody, > > > > > > I don't know what is wrong with the code, or maybe there is > > > something wrong with > > > the way I'm trying to run the examples that come with the > BDCP API. > > > When I tried to run the ManualPoolingDriverExample.java and the > > > ManualPoolingDataSourceExample.java files I always got the > > > same error message that > > > I got when I try to run the JOCLPoolingDriverExample.java > > > this error message: > > > Creating connection. > > > java.sql.SQLException: No suitable driver > > > at > > > java.sql.DriverManager.getConnection(DriverManager.java:537) > > > at > > > java.sql.DriverManager.getConnection(DriverManager.java:199) > > > at > > > connpool.JOCLPoolingDriverExample.main(JOCLPoolingDriverExampl > > > e.java:145) > > > > > > The line I got the error is this: > > > System.out.println("Creating connection."); > > > here--> conn = > > > DriverManager.getConnection("jdbc:apache:commons:dbcp:/pooling > > > DriverExample"); > > > System.out.println("Creating statement."); > > > stmt = conn.createStatement(); > > > System.out.println("Executing statement."); > > > > > > I don't know what is happening. > > > I had set the poolingDriverExample.jocl file in the > > > classpath, but I don't know > > > what is happening... > > > > > > Please, help me! > > > > > > Nancy > > > > > > > > > > > > Barney Hamish wrote: > > > > > > > I got it working under 3.X you just have to make sure all > > > the right stuff is > > > > included in your class path i.e. xerxes, commons packages, > > > your .jocl config > > > > file etc. > > > > > > > > Although it's possible to run it under 3.x it's probably > > > better if you do > > > > upgrade. Have a look at the tomcat site, where they > > > recommend versions of > > > > tomcat are ready to be used in production. > > > > > > > > Hamish > > > > > > > > > -----Original Message----- > > > > > From: Nancy Crisostomo Martinez > [mailto:[EMAIL PROTECTED]] > > > > > Sent: Tuesday, September 03, 2002 4:37 PM > > > > > To: Jakarta Commons Users List > > > > > Subject: Re: [DBCP]Connection Pool examples > > > > > > > > > > > > > > > One more question about this: > > > > > Is it possible to implement a pool connection using Jakarta > > > > > commons in Tomcat 3.3 > > > > > or do I have to upgrade to 4.x? > > > > > This is because I found a couple of examples but they are > > > > > implemented in Tomcat > > > > > 4.x. > > > > > > > > > > If I have to upgrade, which version do you recomend me? > > > > > > > > > > Thanks, > > > > > Nancy. > > > > > > > > > > > > > > > Barney Hamish wrote: > > > > > > > > > > > See below... > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: Nancy Crisostomo Martinez > > > [mailto:[EMAIL PROTECTED]] > > > > > > > Sent: Monday, September 02, 2002 5:39 PM > > > > > > > To: Jakarta Commons Users List > > > > > > > Subject: Re: [DBCP]Connection Pool examples > > > > > > > > > > > > > > > > > > > > > Thanks Barney, > > > > > > > > > > > > > > I haven't found in the documentation how to setup > the pool. > > > > > > > > > > > > I must admit a struggled with the DBCP docos at first too. > > > > > They are on the > > > > > > terse side. Have a look at the examples in that come with > > > > > DBCP. There is one > > > > > > on how to use it in driver mode and one for DataSource > > > > > mode. You can run the > > > > > > both from the console. That should give you a pretty good > > > > > idea of what you > > > > > > need to do in your application. > > > > > > > > > > > > > The only documentation > > > > > > > I had read is the one generated with JavaDoc that > comes with > > > > > > > JBDC but it is > > > > > > > pretty short. > > > > > > > -I couldn't find the advantages or disadvantages and > > > > > > > differences in using the > > > > > > > PoolingDriver or using the PoolinDataSource.I > would like to > > > > > > > read a detailed > > > > > > > explanation about this, and I couldn't find it in the that > > > > > > > documentation. > > > > > > > > > > > > Datasources are the newer and I believe prefered way of > > > > > obtaining access to > > > > > > databases. I'm sure there are articles on the java.sun.com > > > > > website comparing > > > > > > them. > > > > > > > > > > > > > -In addition, I would like to know where are the basic > > > > > > > classes to implement the > > > > > > > pool. > > > > > > > > > > > > DBCP uses the generic object pools implemented in the > > > > > jakarta commons Pool > > > > > > project to implement connection pooling. > > > > > > http://jakarta.apache.org/commons/pool.html > > > > > > > > > > > > Goodluck, > > > > > > Hamish > > > > > > > > > > > > > > > > > > > > Thanks again, and I hope you don't get > desesperated about my > > > > > > > ignorance, but I'm > > > > > > > new. > > > > > > > > > > > > > > Nancy. > > > > > > > > > > > > > > > > > > > > > Barney Hamish wrote: > > > > > > > > > > > > > > > DBCP implements the connection pooling API, all > you have to > > > > > > > do is configure > > > > > > > > it. Have you looked at the DBCP documentation? > It details > > > > > > > how to setup a > > > > > > > > connection pool. What is your specific problem? > > > > > > > > > > > > > > > > Hamish > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > > From: Nancy Crisostomo Martinez > > > > > [mailto:[EMAIL PROTECTED]] > > > > > > > > > Sent: Monday, September 02, 2002 5:03 PM > > > > > > > > > To: Jakarta Commons Users List > > > > > > > > > Subject: [DBCP]Connection Pool examples > > > > > > > > > > > > > > > > > > > > > > > > > > > Hi everyone! > > > > > > > > > I've sent this question before but > unfortunatly, I haven't > > > > > > > > > recieved any > > > > > > > > > answer. > > > > > > > > > > > > > > > > > > I would like to know if there are some > practical examples > > > > > > > > > on-line about > > > > > > > > > how to implement the Data Base Connection Pool API. > > > > > > > (Tomcat, Oracle) > > > > > > > > > Could you please give me some references? > > > > > > > > > > > > > > > > > > Thanks in advance > > > > > > > > > Nancy. > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > To unsubscribe, e-mail: > > > > > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > For additional commands, e-mail: > > > > > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > To unsubscribe, e-mail: > > > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > For additional commands, e-mail: > > > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > To unsubscribe, e-mail: > > > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > For additional commands, e-mail: > > > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > > > > -- > > > > > > To unsubscribe, e-mail: > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > For additional commands, e-mail: > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > -- > > > > > To unsubscribe, e-mail: > > > > > <mailto:[EMAIL PROTECTED]> > > > > > For additional commands, e-mail: > > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > -- > > > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > For additional commands, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > -- > > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > > > -- > > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
