Hi Fernand, > - what is the differens between "getConnection "and > "getIsolatedConnection" (who seams to funcytion better)
getIsolatedConnection retrieves a, well, isolated connection :) With the normal "getConnection", you actually get a proxy object. All proxys obtained via this method share the same physical connection. As a consequence, operations done via one proxy might lead to visible results in the other. Using isolated connections is more expensive (since more physical connections are opened), but sometimes desired. > - how do i can control the "open" or "used" connections to a datasource, > ,we found "hasConnections" but no way to uses this service Sadly, there's currently no way to control those. (XDatabaseAccess::hasConnections is specified, but actually not implemented anywhere.) > - why and when turns a conncetion into "read-only" Normally, a read-only connection indicates that you tried to establish a connection where another connection already has exclusive access to the database. Isolated connections are a good candidate here: If you open two isolated connections, chances are good that the second of them is read-only. Also, read-only-ness often happens when you open a connection, somehow forget to close it, and later open another connection (whether isolated or not, there are various side conditions). So, I suggest you check your code whether you have a "connection leak" somewhere. Ciao Frank --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
