Prasad, My internet access is down right now, as soon as I get that up and running I will send you a link to the archives where I saw a thread regarding your problem. Thanks, Sohil
-----Original Message----- From: prasad chaturvedula [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 1:50 AM To: Tomcat Users List Subject: Re: Known problem with tomcat, jndi datasourc - PLEASE HELP Hi Can pleae you give me pointers to solutions to the problem of a null for teh driverclass name, there seems to be no solution in the archives till date. Thanks. Prasad --- "MARU, SOHIL (SBCSI)" <[EMAIL PROTECTED]> wrote: > Hello All, > I have been scouring the mailing list archives > and lot of other > places. I am seeing a problem configuring a > datasource with Tomcat. I > have put the following entry in my 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] > __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ --------------------------------------------------------------------- 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]
