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]

Reply via email to