hi there,
I'm facing a serious problem I wasn't able to fix it in
the past 2 weeks which 's still causing me headaches :-(
But first I have a question that may help to understand
my problem:
Does Tomcat create a new database session pool for every
threa that gets started out of my application / context ?
if yes: this is exactly my problem - every time I start
a new thread the number of jdbc connections to
my oracle 8i increases.
is there a way that every new thread uses the
connection pool which's normally associated to
the configured context?
if now: my headaches will get worse :-( so it seems that
the pooling configuration is completely ignored
under my 'sun solaris 64bit'
(no, it's not my own machine - little bit too
expensive for private use ;-)
Have you every had such kind a problems? and know how to
solve them?
...to insure I've configured it all right:
<Context path="/mtp" docBase="mtp" debug="0"
reloadable="true" cookies="true" swallowOutput="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_mtp_log." suffix=".txt"
timestamp="true" directory="/tmp"/>
<Resource name="jdbc/DSTest" scope="Shareable"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/DSTest">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@host:port:sid</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>1000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>user</value>
</parameter>
<parameter>
<name>password</name>
<value>pass</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>1</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>false</value>
</parameter>
</ResourceParams>
</Context>
greets,
clemens
(the newby with the bad english ;-)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
