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.