[MonetDB-users] error when connecting with iSQL-Viewer
I've just installed iSQL-Viewer and used its wizard to set up a connection to the VOC database that I loaded into MonetDB. But the connection doesn't work; instead I see an error apparently from MonetDB: 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:2014) at nl.cwi.monetdb.jdbc.MonetResultSet.next(MonetResultSet.java:1981) at org.isqlviewer.sql.ResultSetWrapper.next(ResultSetWrapper.java:1194) at org.isqlviewer.ui.JdbcWorkbench.buildSchemaMenu(JdbcWorkbench.java:1145) at org.isqlviewer.ui.JdbcWorkbench.changeConnection(JdbcWorkbench.java:695) at org.isqlviewer.ui.JdbcWorkbench.actionPerformed(JdbcWorkbench.java:290) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.isqlviewer.swing.action.SwingEventManager$EventLoop.delegateEvent(SwingEventManager.java:340) at org.isqlviewer.swing.action.SwingEventManager$EventLoop.run(SwingEventManager.java:319) at java.lang.Thread.run(Thread.java:636) I've googled the error message without finding anything relevant. I know the VOC database itself works because I managed to connect to it via both the command-line and using SQuirreL. The merovingian.log just says: 2010-04-13 14:06:14 MSG merovingian[7379]: proxying client pcx36.lmb.internal:52677 for database 'test' to mapi:monetdb://127.0.0.1:50002/test Can anybody give me a clue what might cause that error message? Thanks, Dave
Hi Dave, On 13-04-2010 14:34:15 +0100, Dave Howorth wrote:
I've just installed iSQL-Viewer and used its wizard to set up a connection to the VOC database that I loaded into MonetDB. But the connection doesn't work; instead I see an error apparently from MonetDB:
Can you tell me what version of JDBC you have in use? I thought we fixed this issue.
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:2014) at nl.cwi.monetdb.jdbc.MonetResultSet.next(MonetResultSet.java:1981) at org.isqlviewer.sql.ResultSetWrapper.next(ResultSetWrapper.java:1194) at org.isqlviewer.ui.JdbcWorkbench.buildSchemaMenu(JdbcWorkbench.java:1145) at org.isqlviewer.ui.JdbcWorkbench.changeConnection(JdbcWorkbench.java:695) at org.isqlviewer.ui.JdbcWorkbench.actionPerformed(JdbcWorkbench.java:290) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.isqlviewer.swing.action.SwingEventManager$EventLoop.delegateEvent(SwingEventManager.java:340) at org.isqlviewer.swing.action.SwingEventManager$EventLoop.run(SwingEventManager.java:319) at java.lang.Thread.run(Thread.java:636)
I've googled the error message without finding anything relevant. I know the VOC database itself works because I managed to connect to it via both the command-line and using SQuirreL.
The merovingian.log just says:
2010-04-13 14:06:14 MSG merovingian[7379]: proxying client pcx36.lmb.internal:52677 for database 'test' to mapi:monetdb://127.0.0.1:50002/test
Can anybody give me a clue what might cause that error message?
Thanks, Dave
Fabian Groffen wrote:
Hi Dave,
On 13-04-2010 14:34:15 +0100, Dave Howorth wrote:
I've just installed iSQL-Viewer and used its wizard to set up a connection to the VOC database that I loaded into MonetDB. But the connection doesn't work; instead I see an error apparently from MonetDB:
Can you tell me what version of JDBC you have in use? I thought we fixed this issue.
Sorry - I know very little about JDBC so I'm not sure what I'm looking for - how do I do that? Some things I do know: I just downloaded both MonetDB and iSQL-Viewer and I'm running on an up-to-date Ubuntu Karmic. /etc/alternatives/java -> /usr/lib/jvm/java-6-openjdk/jre/bin/java* Cheers, Dave
On 13-04-2010 15:37:20 +0100, Dave Howorth wrote:
Fabian Groffen wrote:
Hi Dave,
On 13-04-2010 14:34:15 +0100, Dave Howorth wrote:
I've just installed iSQL-Viewer and used its wizard to set up a connection to the VOC database that I loaded into MonetDB. But the connection doesn't work; instead I see an error apparently from MonetDB:
Can you tell me what version of JDBC you have in use? I thought we fixed this issue.
Sorry - I know very little about JDBC so I'm not sure what I'm looking for - how do I do that? Some things I do know:
I just downloaded both MonetDB and iSQL-Viewer and I'm running on an up-to-date Ubuntu Karmic.
/etc/alternatives/java -> /usr/lib/jvm/java-6-openjdk/jre/bin/java*
what is the name of the monetdb-X.Y-jdbc.jar file? Does iSQL have some option to show properties/details that perhaps show a version number?
participants (2)
-
Dave Howorth -
Fabian Groffen