Hi,

I just looked through the code and I didn't find the con.commit().
There might be a bug in driver (or more correctly, non-implemented
specs) when driver should commit in setAutoCommit(...) and
setTransactionIsolation(...) methods. I have to check the specs. If
this is true, then it explains the behaviour: you do not see the
change made in one transaction from another transaction until you
commit that transaction. You might try to set transaction isolation
to "dirty read" and example should work.

I will check the specs on this issue. Also, it might take some time
to add this feature because we have to check if there's no side
effects in case of JCA. But you might add this to your source code if
you have non-managed case: in methods FBConnection.setAutoCommit
(boolean) and in FBConnection.setTransactionIsolation(int) add the
following code on the begining of the method:

if (inTransaction())
commit();

But again, I'm not sure if this is the reason, and if the code above
is compliant with specs.

Best regards,
Roman Rokytskyy

P.S. BTW, are encodings working in your application?