Bugs item #2812963, was opened at 2009-06-26 22:18
Message generated for change (Tracker Item Submitted) made by feherg
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2812963&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/JDBC
Group: SQL "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Fehér Gábor (feherg)
Assigned to: Fabian (mr-meltdown)
Summary: JDBC connection hangs if result is too long
Initial Comment:
Operating System: openSUSE 11.1
Compiler: gcc-4.3-34.243
Parser tools: package lex is not installed; flex-2.5.35-43.23; package yacc is
not installed; bison-2.3-127.26
More tools: autoconf-2.63-1.136; automake-1.10.1-4.284; libtool-2.2.6-1.35
MonetDB version: May2009 from source (with a recent head checkout of
buildtools, and binary distribution of JDBC)
Loaded MonetDB modules: sql; xml; batxml; geom;
Java 1.5.0 is used.
It seems to me that if a large number of bytes is received through a JDBC
connection, a "ResultSet is closed!" exception is thrown:
Exception in thread "main" java.sql.SQLException: ResultSet is closed!
at nl.cwi.monetdb.jdbc.MonetResultSet.absolute(MonetResultSet.java:181)
at nl.cwi.monetdb.jdbc.MonetResultSet.relative(MonetResultSet.java:2024)
at nl.cwi.monetdb.jdbc.MonetResultSet.next(MonetResultSet.java:1991)
at MonetJDBC.query(MonetJDBC.java:76)
at MonetJDBC.main(MonetJDBC.java:31)
I can reproduce this with my atteched java program. First it generates a table
with 3000 rows, and then issues a query on it...
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2812963&group_id=56967
------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs