 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Struts - A MVC web framework | | Tomcat - JSP/Servlet container | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | | JSP - A mailing list about Java Server Pages specification and reference | |
Struts & Hibernate
|
|
|
| | | Two Connection pools - Tomcat 4.1.29- Please help!! | Two Connection pools - Tomcat 4.1.29- Please help!! 2004-01-12 - By GuptaD@(protected)
Back
Hi,
I was wondering that is it possible at all to create 2 pools of
connections which are to be used by the same application. I tried to do
someyhing like this in server.xml but the second one doesn't work: -
it's giving me following error for second one
--Cannot create PoolableConnectionFactory--
I will really appreciate if somebosy could post the code if you've done it
already...
-- the part of server.xml looks like this-- ---- ------
<Resource name="jdbc/CrdbConn" auth="Container"
type="javax.sql.DataSource  "/>
<ResourceParams name="jdbc/CrdbConn">
<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourc
eFactory</value></parameter>
<parameter><name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter><name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value></parameter>
<parameter><name>url</name>
<value>jdbc:oracle:thin:@(protected):1521:drpd</value></parameter>
<parameter><name>username</name><value>cweb</value></parameter>
<parameter><name>password</name><value>cweb</value></parameter>
</ResourceParams>
<!-- HDB connection -->
<Resource name="jdbc/hdbConn" auth="Container"
type="javax.sql.DataSource "/>
<ResourceParams name="jdbc/hdbConn">
<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourc
eFactory</value></parameter>
<parameter><name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter><name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value></parameter>
<parameter><name>url</name>
<value>jdbc:oracle:thin:@(protected):1521:HDB</value></parameter>
<parameter><name>username</name><value>admin</value></parameter>
<parameter><name>password</name><value>admin</value></parameter>
</ResourceParams>
<!-- end HDB -->
-- --- end of part of
server.xml-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
my web.xml looks like this
-- ---- ---web.xml-- ---- ---- ---- ---- ---
<?xml version="1.0"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">
<web-app>
<context-param>
<param-name>appversion</param-name>
<param-value>Development</param-value>
</context-param>
<context-param>
<param-name>som</param-name>
<param-value>Divya Gupta</param-value>
</context-param>
<context-param>
<param-name>amphost</param-name>
<param-value>sundev01</param-value>
</context-param>
<context-param>
<param-name>ampsid</param-name>
<param-value>am2d</param-value>
</context-param>
<context-param>
<param-name>crdbhost</param-name>
<param-value>dpwdev02</param-value>
</context-param>
<context-param>
<param-name>crdbsid</param-name>
<param-value>drpd</param-value>
</context-param>
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/CrdbConn</res-ref-name>
<res-type>javax.sql.DataSource </res-type>
<res-auth>Container</res-auth>
</resource-ref>
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/hdbConn</res-ref-name>
<res-type>javax.sql.DataSource </res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
---end of web.xml-- ---- ---- ---- ---- ---- -----
Thanks in advance,
Regards,
Divya
|
|
|
