RE: Create New Data Source

[Propes, Barry L]

here ya go, Shekhar...see my XML config for JNDI.

Keep in mind, I'm on an older version oF TC, so you can probably align and list 
your param attributes all in one, or more conveniently than I was able to.


<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.OracleDriver</value>
   </parameter>
   <parameter>
     <name>url</name>
     <value>jdbc:oracle:thin:@192.222.44.999:1521:SID</value>
   </parameter>
   <parameter>
     <name>username</name>
     <value>user_name</value>
   </parameter>
   <parameter>
     <name>password</name>
     <value>xxxxxxxxxx</value>
   </parameter>
   <parameter>
     <name>maxActive</name>
     <value>125</value>
   </parameter>
   <parameter>
     <name>maxIdle</name>
     <value>15</value>
   </parameter>
   <parameter>
     <name>maxWait</name>
     <value>7000</value>
   </parameter>
 <parameter>
 <name>removeAbandoned</name>
 <value>true</value>
 </parameter>
 <parameter>
 <name>removeAbandonedTimeout</name>
 <value>60</value>
 </parameter>
 <parameter>
 <name>logAbandoned</name>
 <value>true</value>
 </parameter>

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 28, 2007 11:02 AM
To: Tomcat Users List
Subject: Create New Data Source 


Hello list ,
Can someone please tell me how do I test the connectivity from tomcat 
server to oracle database. I am good on Unix/databases but new to Tomcat. 

I have oracle instance named as : lawtst .

lawtest  running at cemcp62 .  (system name)

user name is - sdhotre -password is password .

I see following fields when I click on create data source . Where do the 
above values go or is there an example somewhere that I can follow? 

Data Sources 
Property  Value 
JNDI Name: 
Data Source URL: 
JDBC Driver Class: 
User Name: 
Password: 
Max. Active Connections: 
Max. Idle Connections: 
Max. Wait for Connection: 
Validation Query: 

Thanks 
Shekhar Dhotre.
Unix Admin.
CobbEnergy (Atlanta).
 

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]