[Sqlrelay-discussion] sqlrelay and re-excuted queries with db2

[Matt H. <mh...@co...>]

I am using sqlrelay version 0.39.4, the perl api (not dbi), and ibm db2.  
I cannot re-use a prepared query.  When the second "executeQuery" is 
issued, the process hangs.  The database is fine, but the sqlrelay server 
must be restarted.

The perl:

use SQLRelay::Connection;
use SQLRelay::Cursor;
my $conn = SQLRelay::Connection->new('host',port,"",'user','pass',0,1);
my $cur = SQLRelay::Cursor->new($conn);
$cur->prepareQuery("query");
$cur->clearBinds();
$cur->inputBind(1,13);
$cur->executeQuery() || $cur->errorMessage();
$cur->clearBinds();
$cur->inputBind(1,2);
$cur->executeQuery() || $cur->errorMessage(); # hangs here
$conn->endSession();

This is from the server logs:

[snip]

processing query...

re-executing...

commit or rollback check...

done with commit or rollback check

processing query failed

done processing query

handling error...

returning error...

done returning error

database is down...

[snip]

Any help would be appreciated, 
Thanks