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 219013 - java.sql.SQLException: Stream has already been closed
Summary: java.sql.SQLException: Stream has already been closed
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 7.2
Hardware: All All
: P3 normal (vote)
Assignee: Jaroslav Havlin
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-25 18:05 UTC by renato_marquez
Modified: 2012-09-26 15:14 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 192756


Attachments
stacktrace (1.40 KB, text/plain)
2012-09-25 18:05 UTC, renato_marquez
Details

Note You need to log in before you can comment on or make changes to this bug.
Description renato_marquez 2012-09-25 18:05:46 UTC
This bug was originally marked as duplicate of bug 179959, that is already resolved. This bug is still valid, so this seems to be another bug, but it might be related.

Build: NetBeans IDE 7.2 (Build 201207171143)
VM: Java HotSpot(TM) 64-Bit Server VM, 21.0-b17, Java(TM) SE Runtime Environment, 1.7.0-b147
OS: Windows 7

User Comments:
_m4c0_: I have an Oracle connection. The DBMS was configured to kill the connection after a 5 minutes timeout. Steps:

1. Connect to database at Services TC
2. Right click on database, "Execute command"
3. Executed some random SQL
4. Wait until timeout
5. Tryed to run more SQL (the exception was thrown)
6. Right click on database, "Disconnect"
7. Repeated 2 and 3 (the exception was thrown again - that's the one I'm reporting)

lukeester: I excuted a very expensive SQL query
I canceled the query execution in netbeans by clicking the 'X' on its task in the bottom right corner
Netbeans locked up
I killed the netbeans.exe process
I started Netbeans back up
I executed an SQL query on a completely different connection to a different DB and that caused the exception

GUEST: Estava executando uma query simples, quando ocorreu o problema.

GUEST: Tried to run "select * from SYS.ALL_CONSTRAINTS" on an oracle database

GUEST: Clicking execute query on Oracle database.




Stacktrace: 
java.sql.SQLException: Stream has already been closed
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)
   at oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:212)
   at oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:281)
   at oracle.jdbc.driver.T4CLongAccessor.getString(T4CLongAccessor.java:422)
Comment 1 renato_marquez 2012-09-25 18:05:49 UTC
Created attachment 124902 [details]
stacktrace
Comment 2 Jaroslav Havlin 2012-09-26 14:47:20 UTC
Please, columns of what types were returned from the query?
Is the error thrown every time you execute the query, or was it thrown only once?
Wasn't the server really down, or connection broken or closed?
Thank you.
Comment 3 renato_marquez 2012-09-26 14:56:02 UTC
Hello jhavlin,

Truthfully, I do not remember the query submitted to the database.

The error was generated only once.

As I was connected to the server via a VPN, and this, in turn, is unstable, I think this must have been the reason for the exception.

Regards
Comment 4 Jaroslav Havlin 2012-09-26 15:14:33 UTC
Hello Renato,

thank you very much for such a quick answer!

I also think that this error was caused by broken connection.
However, if you encounter any problems that we can fix, let us know :-)

Kind regards.