Thanks, Yeah I tried this and either get a NPE (can't see the Oracle driver) or an error if I reference the Tomcat factory class, like I've previously done on my older version (4.1.xx). I might try backing up to 6.0.18 and give it a shot.
-----Original Message----- From: Karthik Nanjangude [mailto:karthik.nanjang...@xius-bcgi.com] Sent: Thursday, February 25, 2010 10:58 PM To: Tomcat Users List Subject: RE: DB connection error -Tomcat 6 config Hi I hope this helps <?xml version="1.0" encoding="UTF-8"?> <Context workDir="work/Catalina/localhost/appwar"> <Resource name="jdbc/OrclDB" auth="Container" type="oracle.jdbc.pool.OracleDataSource" factory="oracle.jdbc.pool.OracleDataSourceFactory" user="ABCD" password="WXYZ" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@<IP>:1521:<SERVICE>"/> </Context> I have been using this from TC 5.0.18.0 ,5.0.20.0 , 5.0.24.0 And have never any issues with connection pool With Oracle 10GDB , JDK1.4 /1.5,ojdbc14.jar With regards karthik -----Original Message----- From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Sent: Friday, February 26, 2010 2:16 AM To: 'Tomcat Users List' Subject: RE: DB connection error -Tomcat 6 config Sorry for the delay - supplying both my META-INF/context.xml and webapps/WEB-INF/web.xml contents. Should be noted: for the factory type in the params below, I tried both factory="org.apache.commons.dbcp.BasicDataSourceFactory" and factory="org.apache.dbcp.BasicDataSourceFactory", each to no avail. I removed the commons ref to test out since there's no commons/lib dir in TC 6.0.24, unlike in TC 4.1.31 Please apprise if the error is glaring here and I just can't see it. That's certainly possible! Thanks, Chuck. context.xml in META-INF fldr ---------<?xml version="1.0" encoding="UTF-8"?> <!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. --> <Context> <!-- omitting - factory="oracle.jdbc.pool.OracleDataSourceFactory" below--> <Resource name="jdbc/myoracle" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="125" maxIdle="15" maxWait="7000" removeAbandoned="true" removeAbandonedTimeout="30" logAbandoned="true" username="user_name" password="pass_word" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@159.177.102.100:1526:MYSID" minEvictableIdleTimeMillis="5000" timeBetweenEvictionRunsMillis = "10000" testWhileIdle="true" /> </Context> in webapps/WEB-INF/web.xml <resource-ref> <description>My Ora datasource</description> <res-ref-name>jdbc/myoracle</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> -----Original Message----- From: Caldarale, Charles R [mailto:chuck.caldar...@unisys.com] Sent: Tuesday, February 23, 2010 5:53 PM To: Tomcat Users List Subject: RE: DB connection error -Tomcat 6 config If you don't mind, post your <Context> element again. The error message indicates something doesn't match between what your JSP/servlet is requesting and what's registered via the <Resource> element. - Chuck --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
