Add following code in server.xml to create a JNDI under context tag:-
Here is the JNDI created for oracle DB
<Resource name="jdbc/XYZ" auth="SERVLET"
type="oracle.jdbc.pool.OracleConnectionCacheImpl"/>
<ResourceParams name="jdbc/XYZ">
<parameter>
<name>factory</name>
<value>org.apache.naming.factory.BeanFactory</value>
</parameter>
<parameter>
<name>driverType</name>
<value>thin</value>
</parameter>
<parameter>
<name>serverName</name>
<value>0.0.0.0</value>
</parameter>
<parameter>
<name>networkProtocol</name>
<value>tcp</value>
</parameter>
<parameter>
<name>databaseName</name>
<value>xyz</value>
</parameter>
<parameter>
<name>portNumber</name>
<value>1521</value>
</parameter>
<parameter>
<name>user</name>
<value>xyz</value>
</parameter>
<parameter>
<name>password</name>
<value>a</value>
</parameter>
<parameter>
<name>maxLimit</name>
<value>5</value>
</parameter>
</ResourceParams>
Write the following code in web.xml of your application
<!-- Example of datasources setup -->
<resource-ref>
<description>Oracle DataSource</description>
<res-ref-name>jdbc/XYZ</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
After that make the connection in action classes using this JNDI.
-----Original Message-----
From: amit fulambarkar [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 12:48 PM
To: struts-user@jakarta.apache.org
Subject: about struts.
How can i implement connection pooling in struts. What will be the
server.xml? and what the things i would have to do.Give the code.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
