Originally reported by David Coldrick on mailing list. He used H2
(http://www.h2database.com/html/frame.html) embedded database and registered it
in DB Explorer. Then connect/disconnect and try to connect from other
application. However, the connection is still locked by IDE. It seems Disconnect
action doesn't really close the connection to DB.
Workaround: stop IDE
Evidence of bug in IDE:
I have this sample:
Connection conn =
"sa", " ");
PreparedStatement stmt = conn.prepareStatement("select * from PERSON");
ResultSet rs = stmt.executeQuery();
System.out.println(rs.getInt(1) + ", " + rs.getString(2));
Open/close connection but don't stop JVM. I was able to connect in the DB from IDE.
Needs handling similar to embedded Derby.
See also issue 85339.
Reassigned to new owner.
*** Issue 158587 has been marked as a duplicate of this issue. ***
NB6.7 was released already - http://www.netbeans.org/community/releases/67/
Postpone fixing this issue on the next release.
Hope it's http://hg.netbeans.org/main-golden/rev/33ab9ed49a09