Please double check and make sure your ojdbc.jar is in $CATALINA_HOME/common/lib.
-----Original Message----- From: MARU, SOHIL (SBCSI) [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 8:02 AM To: [EMAIL PROTECTED] Subject: No Suitable Driver Problem Hey Doug, I tried moving the username up, still does not work, any other clues, am still stumped. Thanks, Sohil Server.xml <Context path="/loa" docBase="C:\software\eclipse\workspace\HRTechnology\TOMCAT_ROOT" reloadable="true"> <Resource name="jdbc/loacenet" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/loacenet"> ......... ......... ......... ......... <parameter> <name>password</name> <value>databasepassword</value> </parameter> <parameter> <name>url</name> <value>jdbc:oracle:[EMAIL PROTECTED]:1521:[sid]</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>username</name> <value>user</value> </parameter> </ResourceParams> </Context> However when I try to load my plugin in the struts application, I get the following exception. I looked at everything on archives and on there people were complaining about NULL for driverClassName, in my case, it reads the drivername and url properly and still blows up. Please help. I am using Tomcat 5.0 with the latest ojdbc14.jar/commons-dbcp-1.1.jar in common/lib and am trying to connect to oracle 8.1.7. org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class ' oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:oracle:[EMAIL PROTECTED] :1521:[sid]', cause: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:243) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:743) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:518) at com.sbc.hrtech.framework.utility.InitializerPlugin.init(InitializerPl ugin.java:41) at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServle t.java:1158) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:473) at javax.servlet.GenericServlet.init(GenericServlet.java:256) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper. java:1044) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:88 7) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex t.java:3960) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4 283) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1125) at org.apache.catalina.core.StandardHost.start(StandardHost.java:832) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1125) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:518 ) at org.apache.catalina.core.StandardService.start(StandardService.java:5 19) at org.apache.catalina.core.StandardServer.start(StandardServer.java:234 5) at org.apache.catalina.startup.Catalina.start(Catalina.java:598) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398) Excpetion in InitializerPlugin The java code in the plugin is as follows Context init = new InitialContext(); Context ctx = (Context) init.lookup("java:comp/env"); DataSource dataSource = (DataSource) ctx.lookup("jdbc/loacenet"); c = dataSource.getConnection(); -- line which blows up st = c.createStatement(); --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
