[Monetdb-developers] Error with the Java Client

Fabian Groffen Fabian.Groffen at cwi.nl
Fri Sep 22 16:57:03 CEST 2006

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.

More information about the developers-list mailing list