Re: Not in transaction SQLException

Hi, in order to be in a transaction you have to issue SQL statement "BEGIN WORK;", which is probably missing in your scenario. The exception are ANSI databases (ANSI logging mode). With these databases you are always automatically in a transaction (even without "BEGIN WORK;"). If your application expects this, then you probably have to change your database to ANSI logging mode (use "ontape" or "ondblog" utility to change the logging mode). Note: once your database has logging mode ANSI it is not so easy to switch (back) to another logging mode. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 29.07.2005 23:51:56: > Hello, i am running a java application connected via JDBC Driver > 3.00.JC1 to an Informix 9.40.FC4 database. After executing several > querys, when the application commits a transaction i get "Not in > transaction" SQLException. The getAutoCommit() attribute is false, so > its not the problem. sending to informix-list