I'm migrating my database from postgresql to informix (version 11.7) and there seems to be a problem with transaction handling.
I use SmartGWT 3.1.
server.properties:
Executing a simple fetch on any DS results with error:
When I change autoJoinTransactions to "none" in server.properties, no error occur!
According to http://www.smartclient.com/smartgwte...inTransactions transactions should be supported on informix.
Please help :)
I use SmartGWT 3.1.
server.properties:
Code:
sql.ifx.autoJoinTransactions: true sql.ifx.database.type: informix sql.ifx.interface.type: driverManager sql.ifx.driver: com.informix.jdbc.IfxDriver sql.ifx.driver.context: _container_ sql.ifx.driver.portNumber: 7078 sql.ifx.driver.password: ****** sql.ifx.driver.driverName: informix sql.ifx.driver.networkProtocol: tcp sql.ifx.driver.serverName: localhost sql.ifx.driver.databaseName: my_db sql.ifx.driver.name: informix sql.ifx.driver.driverType: thin sql.ifx.driver.user: informix
Code:
java.sql.SQLException: ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF
According to http://www.smartclient.com/smartgwte...inTransactions transactions should be supported on informix.
Please help :)
Comment