Hi Joachim,
I had the same problem with MySql. Although it won't help you a lot, I can 
tell you I did the following:
1. set database.connectionWaitTimeout to 200000
2. use jdbc:mysql://127.0.0.1:3306/nmrshiftdb?autoReconnect=true as database 
URL. The autoReconnect was not used before. I don't know what it does exactly 
and also don't know if it exists in Oracle.
These together helped. The application has now been running for weeks.
Stefan

Am Tuesday 02 December 2003 10:43 schrieb Joachim Müller:
> Hi all.
>
> we experience problems with the following setup:
>
> Jetspeed1.4b4 on Win2K
> Java 1.4.1
> Oracle 9.2
>
> Two Application Servers with Jetspeed are
> load balanced by apache mod_jk and are
> connected to the same Oracle database.
>
> After a certain uptime (2-3 days) the applications
> cannot make connections to the database
> anymore.
> (Propabely a side effect is that the controls.xreg
> file on the application servers is overwritten and
> set to zero size!)
>
> It seems to be that the connection pool
> does not free unused connections. We startet
> with the torque connection pool and switched
> then to the JDBC2 Connection Pool with no luck
> regarding this problem.
>
> Did anybody have the same problem? Does anybody
> connect jetspeed though an Tomcat JNDI Datasource
> successfully? (I did try but had no luck. Can
> someone supply an description for both Tomcat
> AND Jetspeed Config files?)
>
> Would it make sense to upgrade to Torque 3.1 in
> this regard?
>
> Would it make sense to upgrade to Jetspeed1.4
> final in this regard?
>
> Any help is much appreciated.
>
>
> Best Regards,
>
> Joachim

-- 
Stefan Kuhn M. A.
Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de)
Zülpicher Str. 47, 50674 Cologne
Tel: +49(0)221-470-7428   Fax: +49 (0) 221-470-7786
My public PGP key is available at http://pgp.mit.edu


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

Reply via email to