When using mysql with jdbc I always use its autoreconnect feature (within and without jetspeed). This feature is described in the documentation for the mysql JDBC-Driver. Oracle does not have such a "feature". The URL looks then like torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/jetspeed?autoReconnect=true
Without autoReconnect=true I had applications (not using torque but jdbc directly) loosing the connection after something like 2 or three days. I hope this helps Thomas Grundey ----- Original Message ----- From: "Danny" <[EMAIL PROTECTED]> To: "Jetspeed User Mailing List (E-Mail)" <[EMAIL PROTECTED]> Sent: Thursday, July 10, 2003 12:44 PM Subject: MySQL DB looses permanently connection.... We have jetspeed (1.4 build 4) configured with MySQL DB (I must admit, that the Sever is quite a poor machine) and some portlets, that generate charts from DB. Everything works fine, but after a while Jetspeed looses the connection to the DB. And when the connection is lost, Jetspeed has to be restarted. My question now is: Is this a know thing? Is this related to Jetspeed? (We have another Jetspeed based application working with Oracle, where everything is OK) Is this related to the server? (pentium 1, 128 MB RAM, OS Windows NT) Anny hint is appreciated. Danny ========================================== T-Systems Multimedia Solutions GmbH Danny Gehl Authorized Java Center (AJC) Hausanschrift: Riesaer Straße 5, 01029 Dresden Tel.: (0351) 8505 845 Fax.: (in Arbeit) E-Mail: mailto:[EMAIL PROTECTED] http://www.T-Systems-MMS.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
