RE: Help on database and server configuration

[Caroline Jen]

Please find the Tomcat 5.0.27 connection pool
configuration procedure in the attachment.
 
--- Ben Souther <[EMAIL PROTECTED]> wrote:

> If you have a specific question, or can't figure out
> an entry in your
> log files, feel free to ask. 
> 
> 
> 
> 
> 
> 
> On Tue, 2004-09-21 at 09:33, Shanti Priya wrote:
> > Hi ben!!
> >               I have gone through that,but it's
> not that useful for me as i
> > have a bug with my database setups.As already
> suggested by the other user i
> > set up the classes12.zip in lib also.Please help
> me out.
> > thanks
> > shanti
> > 
> > -----Original Message-----
> > From: Ben Souther [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, September 21, 2004 6:53 PM
> > To: Tomcat Users List
> > Subject: Re: Help on database and server
> configuration
> > 
> > 
> > Hereyougo...
> > 
> >
>
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/index.html
> > 
> > 
> > 
> > On Tue, 2004-09-21 at 09:23, Shanti Priya wrote:
> > > Hi!!
> > >               I have an application war file
> with me,that has to be
> > > installed on local tomcat5.It's developed using
> jsp/struts and oracle is
> > the
> > > database.I basically use remote database and plz
> help me out in setting
> > the
> > > server configurations and all.
> > >
> > >
> > > Thanks & Regards,
> > > Shanti Priya Sunkara
> > >
> > > Location        : Pune, India
> > > Email           : [EMAIL PROTECTED]
> > >
> > >
> > >
> > >
>
---------------------------------------------------------------------
> > > 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]
> > 
> > 
> > 
> >
>
---------------------------------------------------------------------
> > 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]
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
Tomcat 5.0.27, j2sdk1.4.2 and Windows XP, Oracle 9i

Step 1. 

DBCP uses the Jakarta-Commons Database Connection Pool. It relies on number of 
Jakarta-Commons componenets:

Jakarta-Commons DBCP 1.2.1 
Jakarta-Commons Collections 2.1.1 
Jakarta-Commons Pool 1.2
 
These jar files along with your the jar file for your JDBC driver should be installed 
in 
$CATALINA_HOME/common/lib. 
NOTE:Third Party drivers should be in jarfiles, not zipfiles. Tomcat only adds 
$CATALINA_HOME/common/lib/*.jar to the classpath. 

Step 2.
download the most up-to-date version of the classes12.zip rename it to classes12.jar 
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm
and place it in TOMCAT_HOME\common\lib

Step 3.
check the read and execute access to the classes12.jar file (by right-click on the 
file and 

look for 'properties')

Step 4. C:\jakarta-tomcat-5.0.27\conf\server.xml configuration 
Note: I added the following code in between the <realm .../> element and the <Host> 
element.

<DefaultContext>
   <Resource name="jdbc/OracleDB" auth="Container"
             type="javax.sql.DataSource"/> 

   <ResourceParams name="jdbc/OracleDB">
      <parameter>
         <name>factory</name>
         <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
      </parameter>
      <parameter>
         <name>maxWait</name>
         <value>5000</value>
      </parameter>
      <parameter>
         <name>maxActive</name>
         <value>20</value>
      </parameter>
      <parameter>
         <name>password</name>
         <value>your password</value>
      </parameter>
      <parameter>
         <name>url</name>
         <value>jdbc:oracle:thin:@172.19.47.22:1521:SystemID</value>
      </parameter>
      <parameter>
         <name>driverClassName</name>
         <value>oracle.jdbc.driver.OracleDriver</value>
      </parameter>
      <parameter>
         <name>maxIdle</name>
         <value>10</value>
      </parameter>
      <parameter>
         <name>username</name>
         <value>your username</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>
</ResourceParams>
</DefaultContext>

Step 5. web.xml Configuration (the one in MyApp/WEB-INF directory)

add these lines after the <taglib> element
**********************
<resource-ref>
 <description>Oracle Datasource</description>
 <res-ref-name>jdbc/OracleDB</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>
**********************


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]