Subject Re: After UDF exception, the current connection stops working
Author Roman Rokytskyy
Hi,

Sorry, I cannot reproduce your bug report. In CVS,
client-java/src/test/org/firebirdsql/jdbc/ directory you will find a
class TestFBResultSet, its last method testBugReport1() tries to
reproduce your bug. Please, modify the code of that method so, that it
will cause NullPointerException you're talking about.

> I don't think the problem is in my Venus.doShowResultset because
> a different SQL Manager from Hypersonic has the same problem.
> As a matter of fact my Venus.doShowResultset should not be called
> in the first place. Here is the code:
>
> try {
> executionTime_i = System.currentTimeMillis ();
> res_i = stmt_i.executeQuery (sql);
> executionTime_i = System.currentTimeMillis () -
> executionTime_i;
> }
> catch (SQLException e) {
> dispStatus ("ERROR: Failed to execute the cmd. Reason: " +
> e.getMessage ());
> e.printStackTrace ();
> return;
>}
>
>
> // tmpPane.append
>
> final JTextArea tmpPane2 = tmpPane;
> Runnable subThread = new Runnable () {
> public void run () {
> int rowCnt = doShowResultset (tmpPane2);
> dispStatus (rowCnt + " row(s) in " +
> executionTime_i + " ms (" + new java.util.Date ().toString () +
> ")");
> if (graphics_i != null) update (graphics_i);
> }
> };
> SwingUtilities.invokeLater (subThread);

Can it be that you close the statement before the doShowResultset is
called?

Best regards,
Roman Rokytskyy