This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 205524 - Services-window/databases. Disconnecting jdbc driver (org.hsqldb.jdbcDriver) keeps db file locked
Summary: Services-window/databases. Disconnecting jdbc driver (org.hsqldb.jdbcDriver) ...
Status: RESOLVED DUPLICATE of bug 187568
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 7.0.1
Hardware: All All
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-24 13:07 UTC by houtm035
Modified: 2011-11-24 18:45 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description houtm035 2011-11-24 13:07:26 UTC 
Product Version = NetBeans IDE 7.0.1 (Build 201107282000)
Operating System = Windows XP version 5.1 running on x86
Java; VM; Vendor = 1.6.0_19
Runtime = Java HotSpot(TM) Client VM 16.2-b04

Dear support,

I added a HSQLDB jdbc driver (version 2.2.5) to the Databases/Drivers list
Then added a jdbc connection. 
Selected the HSQLDB (embedded) type from the wizard
entered   jdbc:hsqldb:<path + file_without_extension>

The database can be inspected etc. 
Disconnecting seems to go Ok, but the .lck and .log file are still open by netbeans.
( those files and the temporary directory can not be deleted.)
Also clicking the memory graph for performing GC doesn't release the handles.
Comment 1 houtm035 2011-11-24 13:19:18 UTC 
"HSQLdb (embedded )" requires to call execute  " SHUTDOWN; "  before closing the connection.

This is not available from the same menu the "disconnect" is performed.
Not sure how implementation dependant the 'shutdown' command is though.
Comment 2 matthias42 2011-11-24 18:45:00 UTC 
This is a duplicate of bug #187568. It's special for embedded databases and for hsqldb there is a working solution (see the mentioned bug). It's specific for the database and only applicable to embedded databases.

*** This bug has been marked as a duplicate of bug 187568 ***