Hi Cor, >>> after 30 min of inactivity with a form the connection to a >>> jdbc-datasource has been closed automatically (don't know if base or the >>> driver is guilty here ;) ). >>> To reestablish, I would like to create an UNO-Listener, which informs me >>> about the lost connection, so that I can reconnect via api. >> >> There is no such mechanism, I fear. > > It's not the same as offered in the UI via Tools|Options|OOo > Base|Connections? There is a time-out on that page for each tpe of > conection.
No, that's the time after which closed connections are "really" closed. If the user (or some script) closes a connection, then internally, this connection is put into the so-called connection pool. When the same connection is requested again, the connection from the pool is used, instead of re-creating a new one. When the time you specify in the option is passed without this happening, then the connection is really closed. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
