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 157243

Summary: org.netbeans.modules.db.metadata.model.api.MetadataModelException: org.netbeans.modules.db.metadata.model.api.MetadataException: java.sql.SQLException: Invalid state, the Connection object is closed.
Product: db Reporter: Roman Mostyka <romanmostyka>
Component: CodeAssignee: Jaroslav Havlin <jhavlin>
Status: RESOLVED WORKSFORME    
Severity: blocker Keywords: RANDOM
Priority: P3    
Version: 6.x   
Hardware: All   
OS: All   
URL: http://statistics.netbeans.org/exceptions/detail.do?id=145423
Issue Type: DEFECT Exception Reporter: 145423
Attachments: stacktrace
dialog
stacktrace
stacktrace

Description Roman Mostyka 2009-01-21 15:27:08 UTC
Build: NetBeans IDE Dev (Build 090120)
VM: Java HotSpot(TM) Client VM, 1.5.0_16-133, Java(TM) 2 Runtime Environment, Standard Edition, 1.5.0_16-b06-284
OS: Mac OS X, 10.5.6, i386

User Comments:
romanmostyka: 1. Add jTDS driver.
2. Add connection to MS SQL Server using this driver.
3. Connect to it.
4. Disconnect.

Result: I repeated steps 3 and 4 several times and MetadataModelException arises.



Stacktrace: 
org.netbeans.modules.db.metadata.model.api.MetadataModelException: org.netbeans.modules.db.metadata.model.api.MetadataException: java.sql.SQLException: Invalid state, the Connection object is closed.
        at org.netbeans.modules.db.metadata.model.JDBCConnMetadataModel.runReadAction(JDBCConnMetadataModel.java:99)
        at org.netbeans.modules.db.metadata.model.api.MetadataModel.runReadAction(MetadataModel.java:89)
        at org.netbeans.modules.db.explorer.node.ViewNodeProvider.initialize(ViewNodeProvider.java:98)
        at org.netbeans.api.db.explorer.node.NodeProvider.getNodes(NodeProvider.java:103)
        at org.netbeans.modules.db.explorer.node.NodeRegistry.getNodes(NodeRegistry.java:149)
        at org.netbeans.api.db.explorer.node.ChildNodeFactory.createKeys(ChildNodeFactory.java:104)
Comment 1 Roman Mostyka 2009-01-21 15:27:19 UTC
Created attachment 76101 [details]
stacktrace
Comment 2 Jiri Rechtacek 2009-02-10 15:19:44 UTC
Reassigned to new owner.
Comment 3 bartvdc 2009-04-30 09:21:52 UTC
I get similar when invoking code completion in a query to get the column names.
It adds : Invalid descriptor index
The connection is to sql server DB through an odbc link. It just shows a dialog, no reporting possible.
see dialog in attach.
Comment 4 bartvdc 2009-04-30 09:24:25 UTC
Created attachment 81277 [details]
dialog
Comment 5 Jiri Rechtacek 2009-04-30 15:27:33 UTC
*** Issue 163655 has been marked as a duplicate of this issue. ***
Comment 6 Jiri Rechtacek 2009-07-01 07:44:42 UTC
NB6.7 was released already - http://www.netbeans.org/community/releases/67/
Postpone fixing this issue on the next release.
Comment 7 Exceptions Reporter 2009-09-02 01:55:52 UTC
Build: NetBeans IDE 6.7.1 (Build 200907230233)
VM: Java HotSpot(TM) Client VM, 14.0-b16, Java(TM) SE Runtime Environment, 1.6.0_14-b08
OS: Windows XP, 5.1, x86

User Comments: 


Stacktrace: 
java.net.SocketException: socket closed
        at java.net.SocketInputStream.socketRead0(SocketInputStream.java:0)
        at java.net.SocketInputStream.read(SocketInputStream.java:129)
        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)
Comment 8 Exceptions Reporter 2009-09-02 01:55:56 UTC
Created attachment 86947 [details]
stacktrace
Comment 9 Exceptions Reporter 2009-09-02 01:56:01 UTC
This issue already has 6 duplicates 
see http://statistics.netbeans.org/exceptions/detail.do?id=145423
Comment 10 Exceptions Reporter 2009-10-16 09:14:44 UTC
Build: NetBeans IDE 6.8 M2 (Build 200910071658)
VM: Java HotSpot(TM) Client VM, 14.2-b01, Java(TM) SE Runtime Environment, 1.6.0_16-b01
OS: Windows XP, 5.1, x86

User Comments: 
Selected the Tables node in the Services tree for a MySQL database when error occurred.

Stacktrace: 
java.net.SocketException: Software caused connection abort: recv failed
        at java.net.SocketInputStream.socketRead0(SocketInputStream.java:0)
        at java.net.SocketInputStream.read(SocketInputStream.java:129)
        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)
Comment 11 Exceptions Reporter 2009-10-16 09:14:49 UTC
Created attachment 89593 [details]
stacktrace
Comment 12 Exceptions Reporter 2009-10-16 09:14:54 UTC
This issue already has 7 duplicates 
see http://statistics.netbeans.org/exceptions/detail.do?id=145423
Comment 13 Jaroslav Havlin 2012-06-05 16:06:50 UTC
Cannot reproduce. The bug seems to be already fixed.
Closing. Please reopen if you can encounter this problem again. Thanks.