Fabian, I can accept that my transaction is invalid and there is no way to tell what the state of tables/object is but I cannot except that a fatal java exception is what is expected. I would expect a java error stating that the state of the database is unknown and please roll back the last transaction. Am I expecting too much from open software? Jim

Message: 5 Date: Fri, 22 Sep 2006 16:57:03 +0200 From: Fabian Groffen Subject: Re: [Monetdb-developers] Error with the Java Client

Hi Jim,

On 22-09-2006 10:47:13 -0400, Jim Foley wrote:

...

voc-> start transaction; Operation successful

auto commit mode: off voc-> select * from tables; Error: SELECT: no such table 'tables'

Your transaction died here ...

...

voc-> voc-> create table test voc=> (id int, jimnum decimal(38,2)); Error: current transaction is aborted (please ROLLBACK)

... hence the error message you need to rollback

...

voc-> \d A fatal exception occurred: java.sql.SQLException: current transaction is aborted (please ROLLBACK)

This might be a bit hefty, but in fact is expected behaviour, since your transaction has been invalidated, so it is unknown what tables/objects there should be at this moment.

------------------------------