[Eclipsesql-bugs] [ eclipsesql-Bugs-3426001 ] failure to close connections

[SourceForge.net <no...@so...>]

Bugs item #3426001, was opened at 2011-10-19 16:58
Message generated for change (Comment added) made by hhilbert
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3426001&group_id=132863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: eugene (kulinek)
>Assigned to: Heiko Hilbert (hhilbert)
Summary: failure to close connections

Initial Comment:
I tested several times - With Eclipse+sqlexplorer plugin I connect to JavaDB using embedded driver (from JDK 1.6.27) using derby.jar (new profile had to be created). Once connected I disconnect. That works fine. I go to  SQLExplorer app (with eclipse built in)  and try to connect but I get exception saying that there is someone else already connected. However, if I close the eclipse+plugin I can connect with SQLExplorer app. That means the connection was not released until I closed eclipse+plugin

Note that JavaDB embedded allows only one connection to DB.  

----------------------------------------------------------------------

>Comment By: Heiko Hilbert (hhilbert)
Date: 2011-10-19 19:54

Message:
That is not a bug. 
It is because you are using the embedded driver. Which mean you have
started a 'database server' in that JVM on your data filese. So after
opening one connection the 'database server' is started and will reelase
the databse files only if you shutdown the embedded database or close the
VM. 
Here:
http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html#shutdown
you can find this:
>>>>
Derby supports multiple connections to a given database. An example of an
embedded application that manages concurrent users is a Tomcat or Geronimo
application server that embeds Derby. Any number of users can execute Web
applications that access a database through that Web server.

However, only one JVM may boot ("open") that database, so multiple
applications running in different JVMs cannot access the same database. 
<<<<<<

Your solution could be to use the Derby network server and network client.
This is described here:
http://db.apache.org/derby/papers/DerbyTut/ns_intro.html

Regards
Heiko


----------------------------------------------------------------------

Comment By: eugene (kulinek)
Date: 2011-10-19 17:19

Message:
Same happens if I use SQL Explorer and Eclipse DTP. Closing connections
does not release resources and the other app cannot connect until I
actually shut down the whole app. 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3426001&group_id=132863