Hello Robert, indeed, the JDBC driver does such a thing *by default*, but only if you are not inside a transaction (as here a re-connect would result in weird things, as the timeout at the database does an implicit rollback).
Because you ask of this feature, I assume that automatism did not work, so you are possibly out of luck with that idea, cause your application does some transactional stuff. You may look into the Orion appserver itself, whether there is some mechanism for keeping a connection only a limited time - most application servers have some option like this. For the use with application servers, it is generally not the usual practice to use a connection that times out at the database. Coming back to your problem - perhaps you can send more details on the crash itself, such as the contents of knldiag after the crash, such that it is perhaps possible to check what is happening. Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Robert Kr�ger [mailto:krueger@;signal7.de] > Sent: Tuesday, October 29, 2002 3:51 PM > To: [EMAIL PROTECTED] > Subject: JDBC driver reconnect question > > > > Hi, > > we still have a problem with the database crashing with > malloc failures > (seemingly runnig out of memory) after running for a few > days. We have > investigated some more (after having exchanged operating > system version and > some hardware components) and noticed that the connection > pooling algorithms > of our application server (orion) lead to connections being > used for a long > time. We somehow suspect a memory leak in SAPDB related to > connections being > used for a long time (BTW. is there a way to check that?). > > Does the JDBC driver support transparent reconnects of timed > out connections? > If so, we could simply set a very low connection timeout and > rely on the JDBC > driver to reconnect? Is this possible? > > Thanks in advance, > > Robert > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
