Bikram B Kapoor wrote:
I am facing a serious problem with Connection in OJB. The
situation this error occurs is when the site has been inactive for quite
some time
Use a validation query that just performs a fast/simple query to "ping" the
database server. This can be eg "SELECT 1 FROM DUAL" (Oracle) or "SELECT 1"
(many others, I think also for MySQL).
Use any SQL tool to check which validation query you can use.
Put the validation query in the connection-pool settings of your OJB
jdbc-connection-descriptor. For syntax read here:
http://db.apache.org/ojb/docu/guides/repository.html#connection-pool-N1023A
NB: this is a feature of your RDBMS server and will apply to all JDBC clients
using connection pools (not OJB-specific).
Regards,
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
