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".

Best regards,
Roman Rokytskyy