Re: [Squirrel-sql-users] DB2 Type 4 Driver: SqlException: Invalid operation: result set closed

[Gerd W. <bir...@t-...>]

Hi Karim,

unfortunately what you see here is a follow up error that occurred while 
writing the log. This bug is fixed in CVS and will be available with the 
next snapshot. Nonetheless from the second part of the stacktrace I 
could see where the original error was raised. It is the place where 
SQuirreL tries to close the result set.

Though I haven't got the driver's error message itself it is very 
probable that your driver closes a result set when it fully is iterated 
through. That is, as I assumed, the same problem we had with the Derby 
DB. We can't do anything about it. It's a problem of the driver. But you 
should still see query results when you use the latest SQuirreL 
snapshot, don't you?

Gerd

Karim D. Saloojee wrote:
> Hi Gerd
> 
> Unfortuneately I cannot use the NET driver in our environment. Its just 
> that out environment is very peculiar and that is not really an option. 
> I will get a hold of the latest weekly build. Here is the stack trace 
> you asked for:
> 
> 109570 [Thread-3] ERROR 
> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet  - Error 
> positioning caret in log text component
> javax.swing.text.BadLocationException: Can't translate offset to line
>    at javax.swing.JTextArea.getLineOfOffset(JTextArea.java:353)
>    at 
> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet.refreshLog(ViewLogsSheet.java:281) 
> 
>    at 
> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet.access$700(ViewLogsSheet.java:58) 
> 
>    at 
> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet$Refresher.run(ViewLogsSheet.java:421) 
> 
>    at 
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>    at java.lang.Thread.run(Thread.java:536)
> 116304 [Thread-2] ERROR 
> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask  - 
> Error occured executing SQL
> java.lang.StringIndexOutOfBoundsException: String index out of range: -35
>    at java.lang.String.substring(String.java:1480)
>    at 
> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask.processQuery(SQLExecuterTask.java:429) 
> 
>    at 
> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask.run(SQLExecuterTask.java:238) 
> 
>    at 
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>    at java.lang.Thread.run(Thread.java:536)
> 
> TIA
> 
> Regards,
> Karim