You must put your Oracle driver in common/lib also, where tomcat will try to find for its only use. Do that and tell us if went everything ok.
> ---------- > De: Didier Wiroth[SMTP:[EMAIL PROTECTED] > Responder: Tomcat Users List > Enviada: ter�a-feira, 4 de novembro de 2003 12:11 > Para: [EMAIL PROTECTED] > Assunto: Tomcat oracle 9 question > > Hi, > > We have windows 2000 server running oracle 9.2.0.1. > > I've installed a freebsd machine running tomcat 4.1.27 which has the > following config in server.xml: > ------------start snip------------------ > <Context className="org.apache.catalina.core.StandardContext" > cachingAllowed="true" > > charsetMapperClass="org.apache.catalina.util.CharsetMapper" > cookies="true" crossContext="false" debug="1" > displayName="Apache-Axis" > docBase="our_application" > mapperClass="org.apache.catalina.core.StandardContextMapper" > path="/our_application" privileged="false" > reloadable="false" swallowOutput="false" useNaming="true" > > wrapperClass="org.apache.catalina.core.StandardWrapper"> > <Logger > className="org.apache.catalina.logger.FileLogger" > prefix="localhost_our_application_log." suffix=".txt" > timestamp="true"/> > <Resource name="jdbc/myoracle" auth="Container" > type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/myoracle"> > <parameter> > <name>factory</name> > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>driverClassName</name> > > <value>oracle.jdbc.driver.OracleDriver</value> > </parameter> > <parameter> > <name>url</name> > > <value>jdbc:oracle:thin:@ourserver:1521:ourdatabase</value> > </parameter> > <parameter> > <name>username</name> > <value>xyz</value> > </parameter> > <parameter> > <name>password</name> > <value>xyz</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>80</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>40</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>10000</value> > </parameter> > </ResourceParams> > </Context> > --------------end snip ----------------- > I've installed the jdk1.4 oracle 9.2.0.1 jdbc drivers in the > webapplication > WEB-INF/lib directory > 1) ojdbc14.jar > 2) ocrs12.zip (which I also copied to ocrs12.jar to be sure both are > present) > > The web.xml of the webapplication has the following lines: > -----------------start snip----------------- > <resource-ref> > <description>mysql connection</description> > <res-ref-name>jdbc/myoracle</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > -----------------stop snip-------------------- > > Here is stdout.log > --------------------start snip---------------- > Apache Tomcat/4.1.27 > WebappClassLoader: > validateJarFile(/usr/local/jakarta-tomcat4.1/webapps/ourdatabase/WEB-INF/l > ib > /servlet.jar) - jar not > loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: > javax/servlet/Servlet.class > NoKey > getDataType=javax.naming.NameNotFoundException: Name NoKey is not bound in > this Context > NoKey > - (null) : javax.naming.NameNotFoundException: Name NoKey is not bound in > this Context > -------------------------stop snip---------------- > > Unfortunately it doesn't work :-( there are no database connections. Do I > also need to install an oracle 9i client (I don't hope because freebsd > doesn't have an available client) > > Thanks for any kind of help > Didier > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] >
