I may be totally off the mark on this one, but is your driverClassName value really correct? In all my code, this value is an actual Java class name (something like "com.microsoft.jdbc.sqlserver.SQLServerDriver"). Everything else, like port, is encoded in the "url" parameter.
Jay | Jay Burgess [Vertical Technology Group] | http://www.vtgroup.com/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 2:09 PM To: Tomcat Users List Subject: Oracle 10G and JNDI & DataSource - Configuration files Hi all, I am trying to connect to an Oracle 10G database, which is located on a server on the same network. My application and Tomcat 5.5 reside on the same Windows 2003 machine. Oracle 10G is installed on a separate Windows 2003 machine. The name for the Oracle service is "OracleServicensmsb"; the database to connect is named "msbdb" and resides on the oracle server, which is called msbdev2; the port is 1521. I am unable to connect and all my tests point to errors in the configuration files. I have the following: In $CATALINA_HOME\conf\server.xml <Resource name="jdbc/msbDB" auth="Container" type="javax.sql.DataSource" username="userMe" password="myPassword" driverClassName="jdbc:oracle:thin:@msbdev2:1521:OracleServicensbdb"/> In $CATALINA_HOME\conf\context.xml <Resource name="jdbc/msbDB" auth="Container" type="javax.sql.DataSource" username="userMe" password="myPassword" driverClassName="jdbc:oracle:thin:@msbdev2:1521:OracleServensbdb" url="jdbc:msbdev2:msbDB"/> In my application's web.xml file, I have: <resource-ref> <res-ref-name>jdbc/msbDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> Am I missing something or doing something wrong? Thank you for your help. Nguessan --------------------------------------------------------------------- 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]
