Problem connecting tomcat6 with oracle db in ubuntu

[suzanne d'souza]

Hey guys,

i would really appreciate some help on this..

i installed ubuntu server in remote n then tomcat6..i deployed my war using tomcat manager..

n placed classes12.jar n ojdbc14.jar in

/var/lib/tomcat6/common/classes

and created an xml file called age_rep.xml (age_rep is my appl folder name).my Age_rep.xml looks like this :

<Context allowLinks="true" override="true">

                 <Resource name="jdbc/systemdev" auth="Container"
              type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
              url="jdbc:oracle:thin:@10.13.1.14:1521:ORCL"
              username="dev12" password="dev123" maxActive="20" maxIdle="10"
              maxWait="-1"/> 

       </Context>

i then modified web.xml file in

/var/lib/tomcat6/webapps/age_rep/WEB-INF (age_rep is my appl folder).web.xml looks like

<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app>

<resource-ref>
 <description>Oracle Datasource example</description>
 <res-ref-name>jdbc/systemdev</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>
</web-app>

and then i have included the below line in my code

 ic = new InitialContext(parms);
            DataSource ds = (DataSource)ic.lookup("java:comp/env/jdbc/systemdev");
            con = ds.getConnection();
            stmt = con.createStatement();

but still its not getting corrected..
I followed the same procedure(except placed the jar files in tomcats/lib) in windows and that works fine..please help

[Tim Holloway]

You seem to have something strange going on. The common/lib directory was part of Tomcat 5, but no longer exists in Tomcat 6. In Tomcat 6, database driver jars should go in the TOMCAT_HOME/lib directory. Also, classes12 is about 10 years ago and was replaced by the ojdbc14.jar.

[suzanne d'souza]

sir.i tried reinstalling tomcat6 again on my ubuntu..the path is the same..
n still no changes