I don't know if this is just specific to Derby, or a general issue with closing a session. If you use the embedded JDBC driver with Derby, only one connection can be open on a Derby database at a time.
If you open a Derby database with SQuirreL using the embedded driver, closing the session does not completely release the connection to the database. In order to be able to connect to database with another application, you must completely exit SQuirreL. Closing the session should be sufficient.
Log in to post a comment.