https://issues.apache.org/bugzilla/show_bug.cgi?id=47360
Summary: Multiple hosts; database connection from one works,
other stops after some time
Product: Tomcat 5
Version: 5.0.0
Platform: PC
OS/Version: Windows Server 2003
Status: NEW
Severity: critical
Priority: P2
Component: Unknown
AssignedTo: dev@tomcat.apache.org
ReportedBy: nb4obe...@gmail.com
Hi,
We are hosting two applications from a single server. Database server is beyond
a firewall.
There are two (virtual) hosts, both connecting to the same database.
One URL (first page of the host) , has a select query. Other URL
has a login page which calls validation page.
After a few hours, first URL (the first server) works fine whereas
the second URL gives problem on validation page saying
"could not connect to Oracle".
Would appreciate help.
DB pooling context parameters is given below.
---------------
<DefaultContext path="" docBase="ROOT"
debug="5" reloadable="true" crossContext="true">
<Resource
name="jdbc/xyzdb"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/xyzdb">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:odbc:xyzdb</value>
</parameter>
<parameter>
<name>username</name>
<value>xyz</value>
</parameter>
<parameter>
<name>password</name>
<value>xyz</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>200</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>20</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>false</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>300</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>validationQuery</name>
<value>select 1 from dual</value>
</parameter>
</ResourceParams>
</DefaultContext>
----------------
tks
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@tomcat.apache.org
For additional commands, e-mail: dev-h...@tomcat.apache.org
