[Monetdb-developers] Error with the Java Client
jfoley at jjfoley.com
Sat Sep 23 05:44:20 CEST 2006
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
Am I expecting too much from open software?
> Message: 5
> Date: Fri, 22 Sep 2006 16:57:03 +0200
> From: Fabian Groffen <Fabian.Groffen at cwi.nl>
> 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
> > 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