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:oracle-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]>
