Re: Vexing problem with Tomcat 5.0.28/Pointbase/JNDI/ConnectionPooling
This tells me a lot: Caused by: java.sql.SQLException: No suitable driver Make sure the driver .jar file is in common/lib and the driverClassName parameter of your ResourceParams element references the correct driver class (don't use a DataSource class here). In your case, I think that should be 'com.pointbase.jdbc.jdbcUniversalDriver'. If you move the driver file into common/lib, restart Tomcat so it can see the jar file. --David Suraj Sashidharan wrote: Hi all, Tomcat 5.0.28 with Pointbase - Trying to obtain a database connection from the DataSource. I saw a zillion places in the web where they've discussed a problem quite similar to the exception shown below BUT, none exactly like what I'm experiencing. And by the way, I couldn't even find one case where they were trying to connect with Pointbase. I followed documentation from all over the web, but I don't see anything that I could be missing. To explain, many have complained about null values for class and URL in the exception message that you see below, but I don't have that problem. What could be wrong? I have spent 5 hours trying to fix this. (It is not even a case of the JDBC driver not being located as I get a different error message when I remove the JDBC driver .jar files (pbclient.jar). Pointbase is up and running on port 9092. Funny thing is the same error message comes up whether Pointbase is running or not.) Please HELP !! Exception : org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.pointbase.jdbc.jdbcDataSource' for connect URL 'jdbc:pointbase:server://localhost:9092/dbCompany' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at dataaccess.UserDatabaseAccessBean.findByUserId(Unknown Source) at security.databaseclient.SecurityBean.login(Unknown Source) at security.SecurityControllerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) at framework.MainControllerServlet.processRequest(Unknown Source) at framework.MainControllerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at
Re: Vexing problem with Tomcat 5.0.28/Pointbase/JNDI/ConnectionPooling
Hi David, Your suggestion solved the problem. I never realized that I had put in a wrong class for the driver. (I didn't have to do any of the other suggestions that you'd made in order to make it work). Thanks so much for spending your time on this and helping me out. Thanks again! From: David Smith [EMAIL PROTECTED] Reply-To: Tomcat Users List tomcat-user@jakarta.apache.org To: Tomcat Users List tomcat-user@jakarta.apache.org Subject: Re: Vexing problem with Tomcat 5.0.28/Pointbase/JNDI/ConnectionPooling Date: Sun, 12 Jun 2005 13:49:52 -0400 This tells me a lot: Caused by: java.sql.SQLException: No suitable driver Make sure the driver .jar file is in common/lib and the driverClassName parameter of your ResourceParams element references the correct driver class (don't use a DataSource class here). In your case, I think that should be 'com.pointbase.jdbc.jdbcUniversalDriver'. If you move the driver file into common/lib, restart Tomcat so it can see the jar file. --David Suraj Sashidharan wrote: Hi all, Tomcat 5.0.28 with Pointbase - Trying to obtain a database connection from the DataSource. I saw a zillion places in the web where they've discussed a problem quite similar to the exception shown below BUT, none exactly like what I'm experiencing. And by the way, I couldn't even find one case where they were trying to connect with Pointbase. I followed documentation from all over the web, but I don't see anything that I could be missing. To explain, many have complained about null values for class and URL in the exception message that you see below, but I don't have that problem. What could be wrong? I have spent 5 hours trying to fix this. (It is not even a case of the JDBC driver not being located as I get a different error message when I remove the JDBC driver .jar files (pbclient.jar). Pointbase is up and running on port 9092. Funny thing is the same error message comes up whether Pointbase is running or not.) Please HELP !! Exception : org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.pointbase.jdbc.jdbcDataSource' for connect URL 'jdbc:pointbase:server://localhost:9092/dbCompany' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at dataaccess.UserDatabaseAccessBean.findByUserId(Unknown Source) at security.databaseclient.SecurityBean.login(Unknown Source) at security.SecurityControllerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) at framework.MainControllerServlet.processRequest(Unknown Source) at framework.MainControllerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102
Re: Vexing problem with Tomcat 5.0.28/Pointbase/JNDI/ConnectionPooling
Hi Doug, Your suggestion is right on the money. Everything works well now. Thanks a lot! Regards, Suraj. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Vexing problem with Tomcat 5.0.28/Pointbase/JNDI/ConnectionPooling
Hi all, Tomcat 5.0.28 with Pointbase - Trying to obtain a database connection from the DataSource. I saw a zillion places in the web where they've discussed a problem quite similar to the exception shown below BUT, none exactly like what I'm experiencing. And by the way, I couldn't even find one case where they were trying to connect with Pointbase. I followed documentation from all over the web, but I don't see anything that I could be missing. To explain, many have complained about null values for class and URL in the exception message that you see below, but I don't have that problem. What could be wrong? I have spent 5 hours trying to fix this. (It is not even a case of the JDBC driver not being located as I get a different error message when I remove the JDBC driver .jar files (pbclient.jar). Pointbase is up and running on port 9092. Funny thing is the same error message comes up whether Pointbase is running or not.) Please HELP !! Exception : org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.pointbase.jdbc.jdbcDataSource' for connect URL 'jdbc:pointbase:server://localhost:9092/dbCompany' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at dataaccess.UserDatabaseAccessBean.findByUserId(Unknown Source) at security.databaseclient.SecurityBean.login(Unknown Source) at security.SecurityControllerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) at framework.MainControllerServlet.processRequest(Unknown Source) at framework.MainControllerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:243) at
Re: Vexing problem with Tomcat 5.0.28/Pointbase/JNDI/ConnectionPooling
Try this: parameter namedriverClassName/name valuecom.pointbase.jdbc.jdbcUniversalDriver/value /parameter in place of: parameter namedriverClassName/name valuecom.pointbase.jdbc.jdbcDataSource/value /parameter Doug - Original Message - From: Suraj Sashidharan [EMAIL PROTECTED] To: tomcat-user@jakarta.apache.org Sent: Saturday, June 11, 2005 5:38 PM Subject: Vexing problem with Tomcat 5.0.28/Pointbase/JNDI/ConnectionPooling Hi all, Tomcat 5.0.28 with Pointbase - Trying to obtain a database connection from the DataSource. I saw a zillion places in the web where they've discussed a problem quite similar to the exception shown below BUT, none exactly like what I'm experiencing. And by the way, I couldn't even find one case where they were trying to connect with Pointbase. I followed documentation from all over the web, but I don't see anything that I could be missing. To explain, many have complained about null values for class and URL in the exception message that you see below, but I don't have that problem. What could be wrong? I have spent 5 hours trying to fix this. (It is not even a case of the JDBC driver not being located as I get a different error message when I remove the JDBC driver .jar files (pbclient.jar). Pointbase is up and running on port 9092. Funny thing is the same error message comes up whether Pointbase is running or not.) Please HELP !! Exception : org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.pointbase.jdbc.jdbcDataSource' for connect URL 'jdbc:pointbase:server://localhost:9092/dbCompany' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at dataaccess.UserDatabaseAccessBean.findByUserId(Unknown Source) at security.databaseclient.SecurityBean.login(Unknown Source) at security.SecurityControllerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) at framework.MainControllerServlet.processRequest(Unknown Source) at framework.MainControllerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799