Hi Roman,

rrokytskyy schrieb:

>
> Hi,
>
> > By the way, can you tell me why I have to
> > send a commit on an isql prompt to see the
> > changes I have made from a java program?
>
> Most likely isql works using SNAPSHOT transaction isolation. This
> means that you see state of database as it was when your isql
> transaction started. To see most recent changes, you need new
> transaction. This is achieved by issuing "commit".

This behaviour confused a colleague of mine. I didn't try it yet,
but I hop this is not the behaviour of JCA-JDBC.

ciao
Hans Georg