Thanks for this meaning full explications but :
- When after redoing my coding homework , a connection is still left
"open" due to a usermachine who chrashes.... how can i close "all
conections" ? instead of sending a mail to the users and asking to
restart OO :-)
Thanks for any hint
Frank Schönheit - Sun Microsystems Germany wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
