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 146298 - org.netbeans.api.db.explorer.DatabaseException: Invalid state, the Connection object is closed.
Summary: org.netbeans.api.db.explorer.DatabaseException: Invalid state, the Connection...
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: David Vancouvering
URL: http://statistics.netbeans.org/except...
Keywords:
Depends on:
Blocks:
 
Reported: 2008-09-05 11:02 UTC by davideconsonni
Modified: 2008-11-12 17:51 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 106160

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 davideconsonni 2008-09-05 11:02:25 UTC 
the problem come with jtds driver.
with com.microsoft.sqlserver.jdbc.SQLServerDriver works well :S

Build: NetBeans IDE Dev (Build 200809050201)
VM: Java HotSpot(TM) Client VM, 10.0-b23, Java(TM) SE Runtime Environment, 1.6.0_07-b06
OS: Linux, 2.6.24.5-smp, i386
User comments: 
STACKTRACE: (first 10 lines)
org.netbeans.api.db.explorer.DatabaseException: Invalid state, the Connection object is closed.
        at org.netbeans.modules.db.explorer.infos.TableListNodeInfo.initChildren(TableListNodeInfo.java:113)
        at org.netbeans.modules.db.explorer.infos.DatabaseNodeInfo.loadChildren(DatabaseNodeInfo.java:710)
        at org.netbeans.modules.db.explorer.infos.DatabaseNodeInfo.getChildren(DatabaseNodeInfo.java:698)
        at org.netbeans.modules.db.explorer.nodes.DatabaseNode$DatabaseNodeChildFactory.createKeys(DatabaseNode.java:382)
        at org.openide.nodes.AsynchChildren.run(AsynchChildren.java:147)
        at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
        at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Comment 1 John Baker 2008-09-05 18:10:03 UTC 
Please provide steps to reproduce
Comment 2 davideconsonni 2008-09-05 18:32:22 UTC 
add jtds driver (http://jtds.sourceforge.net/) and connect to a sqlserver 2005 database.
Comment 3 David Vancouvering 2008-10-09 18:50:47 UTC 
User has provided steps and we need to try to reproduce.  

The workaround is to use the MS driver, so this is a P3.  It's funny, for most people the JTDS driver works better than
the MS driver.

Actually, this may be fixed now, as we fixed some timing issues around opening a connection.  David, can you see if this
still happens for you?
Comment 4 David Vancouvering 2008-11-12 17:51:05 UTC 
User hasn't responded saying whether they can reproduce, and I'm pretty sure this bug is fixed.