JdbcIO informix connection problem

[gbuzic]

Unable to read data from informix non-logged database due to connection error problem caused by setAutoCommit statement [https://www.ibm.com/docs/en/informix-servers/12.10?topic=SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_non_logged_database.html].

Caused by: java.sql.SQLException: Transactions not supported
com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.java:421)
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:396)
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:378)
com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:2185)
org.apache.commons.dbcp2.DelegatingConnection.setAutoCommit(DelegatingConnection.java:801)
org.apache.commons.dbcp2.DelegatingConnection.setAutoCommit(DelegatingConnection.java:801)
org.apache.beam.sdk.io.jdbc.JdbcIO$ReadFn.processElement(JdbcIO.java:1543)

[cwashcraft]

I am getting this same error with Informix, caused by calling setAutoCommit() on a non-logged database

Caused by: java.sql.SQLException: Transactions not supported
	com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.java:424)
	com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:399)
	com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:381)
	com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:2185)
	org.apache.commons.dbcp2.DelegatingConnection.setAutoCommit(DelegatingConnection.java:801)
	org.apache.commons.dbcp2.DelegatingConnection.setAutoCommit(DelegatingConnection.java:801)
	org.apache.beam.sdk.io.jdbc.JdbcIO$ReadFn.processElement(JdbcIO.java:1581)

Seems to have been brought by this fix: https://issues.apache.org/jira/browse/BEAM-12044

#14349

[cwashcraft]

.take-issue

[cwashcraft]

.close-issue