Thank you You know what, all that advises made me somewhat confused, i have reread Tomcat Documentation, now, am not sure about the following: 1. Which is best, servlet.xml or context.xml? 2. If it is servlet.xml, which servlet.xml, is it the config file for the container, or my web application servlet.xml file. 3. Where shall i put jdbc driver class file, in my web application META-INF or in Tomcat lib folder.
I susbect with jdbc driver, if you look at otn.oracle, you will find many drivers for all jdks, but there is no one for JDK 6. On 5/26/07, Pid <[EMAIL PROTECTED]> wrote:
Mohammed Zabin wrote: > Thank you Christ >> For instance, I usually see "oracle.jdbc.driver.OracleDriver" instead of >> what you have above. > > It's as you stated above. But with Oracle 9i and onwards, the driver > must be > oracle.jdbc.OracleDriver, anyways, > i am looking for a solution, and I am sure that i'll find one, thank you If you've not found it yet you need to carefully re-read the advice we've offered. I think we've identified the problem and advised a solution each time, I also think you're changing more than just what we've recommended you change, and thus introducing more problems. Your last issue was that you have moved the Resource definition to GlobalResources, then failed to add the ResourceLink that makes it available to the Context. Your previous issue was that you hadn't added the driver jar to the correct place for Tomcat's classloaders to find it. The issue before that* was that your Resource config definition was incorrect, as were the previous two attempts. Before that your JSP was faulty as you hadn't imported any of the classes you needed. p * Hopefully I've got these in the right order. server.xml : GlobalResource def yourapp.xml : Context def, ResourceLink web.xml : web app deployment desc, Resource Ref your.jsp : imports, active code > On 5/25/07, Christopher Schultz <[EMAIL PROTECTED]> wrote: >> >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Mohammed, >> >> Mohammed Zabin wrote: >> > I put the jar file in my WEB-INF/lib and CATALINA_HOME/lib and >> CLASSPATH, >> > but nothing changed, I got the same error >> >> No, you are getting a different error. The first one was >> ClassNotFoundException. Now, you are getting: >> >> >>>> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create >> >>>> JDBC driver of class '' for connect URL 'null' >> >> Those are not the same. >> >> Search the archives for "Cannot create JDBC driver of class ''" and I'm >> sure you'll find this question answered hundreds of times over. >> >> It usually turns out to be an incorrect JDBC URL or an incorrect driver >> class name. Please check these over /carefully/: >> >> >>>> driverClassName="oracle.jdbc.OracleDriver" >> >>>> url="jdbc:oracle:thin:@127.0.0.1:1521:orcldb" >> >> For instance, I usually see "oracle.jdbc.driver.OracleDriver" instead of >> what you have above. >> >> - -chris >> >> -----BEGIN PGP SIGNATURE----- >> Version: GnuPG v1.4.7 (MingW32) >> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org >> >> iD8DBQFGVvxA9CaO5/Lv0PARArmAAJsEdBWX6X0TcjTLZ30hFYNjACEAZQCgr9+d >> 7ag9qjj7Q+Uxg23E0P21XyU= >> =EAkm >> -----END PGP SIGNATURE----- >> >> --------------------------------------------------------------------- >> To start a new topic, e-mail: users@tomcat.apache.org >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >
