Hi Ray, > * How does OO Base manage abandoned connections, > which might occur upon code crashes before the > connection.close() calls?
It unfortunately doesn't. However, for your particular problem, thus shouldn't hurt: When you open a connection, you usually get only a proxy to a real connection. This way, all "getConnection" calls return stubs which interally share their resources. If one of those stubs is abandoned, this shouldn't affect the ability to create additional stubs. (Except you used getIsolatedConnection, which really creates a new physical connection.) > * example test code and documentation for > the OO Base Connection object management? What exactly do you mean here? > * how to examine the current state of > all OO Base active connections? No chance, sorry. > * how to coerce the release of all connection objects > currently checked out from OO (pooled and non-pooled)? No real way, sorry. For pooled connections, the workaround would be to temporarily disabled connection pooling, and enable it again. > * how to change or reset management parameters > (maxActive, expire-idle-time, etc.) > of OO Base connections (pooled and non-pooled)? For the connection pool, those are configuration settings, which you can access programmatically. Basically, that's everything you find below the configuration node /org.openoffice.Office.DataAccess/ConnectionPool. I don't know whether there exist code snippets for reading/manipulating configuration settings - if you don't know/find some, I could sketch some. Outside the pool, there are no parameters for timeouts etc. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
