In order to explain: I'm trying to make some database transactions within an application and want to test it immediately in SQuirrel SQL. When Squirrel is running my application throws an exception because the database file is blocked by Squirrel.
I establish a connection to an h2 database via SQuirrel SQL Client (version 4.5.1). The driver used is "H2 embedded". In the menu I found an item called "Reconnect". Is it possible to disconnect and reconnect (using the menu item mentioned) after some time? In the best case, the session stays alive during the disconnect/reconnect process. If there is no way to do this, is it possible to connect to the db in read only mode?
Sorry, SQuirreL doesn't offer such a function yet.
Here's a workaround you may try. In the reconnect dialog click the "+" button on the right.
Change your connection URL such that reconnect fails. Now you should be disconnected.
Thank you for the hint
Committed the following new feature (excerpt from change log):
Reconnect dialog (ctrl+T) allows to skip opening a new connection.
To open a connection again reopen the reconnect dialog.
This option may be useful for example when your connection
disturbs external activities on the database.
The feature will be available in future snapshots and versions.
IMHO, this is a terrible user interface. A menu item "reconnect" starting a dialog that says "open a new connection" with a checkbox "oh but skip the part about opening a new connection" ? Errrk.
How about changing the menu item to "database connection" , it brings up a dialog divided, the top section has a button "open a new connection" (if it is closed), or if it's still open "close and reopen connection" (if it is open) and "cancel", and the bottom section has a button "close the connection" or "cancel"