IUS-JDBC-Driver and Transactions ?
Posted in 1998
Hello, are transactions supported in the JDBC-WinNT-Driver of the IUS913UC1 ? I set the autocommit on the actual connection to "false" and want to con.commit() some work. What happens is an exception as follows: "java.sql.SQLException: informix.api.DBClientException: Transaction state change error: expected COMMIT got BEGIN" When closing the connection another but similar exception occurs: "informix.api.jdbc.JDBCException: Transaction state change error: expected ABORT got BEGIN" Do i need to (re-)open a transaction or is this done (as i think) automatically by a commit() ? I checked the transcationlogging in the IUS (it is set to Unbuffered Logging). I also tried to change the isolation level [Connection.setTransactionIsolation()] but for the following values (nearly all except READ_COMMITTED) the error "isolation level x not supported" is written to std-out: TRANSACTION_READ_UNCOMMITTED TRANSACTION_SERIALIZABLE TRANSACTION_REPEATABLE_READ TRANSACTION_NONE Any ideas are welcomed, Gert. -- Gert Brinkmann email: gbrinkmann@dimedis.de Software Development tel: 0221/921260-0 dimedis GmbH fax: -99 Habsburgerring 2-12 http://www.dimedis.de 50674 Koeln http://www.RealTimeImage.de