Teiid exception, when setautocommit is false "TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000457"
barfa.anil Jun 7, 2019 10:08 AMI am using teiid two datasources. when I set "setAutocommit=true" is work fine. But when I set "setAutocommit=false" is gives below error.
ERROR c.b.t.d.i.b.DataCloningService.error(38) - TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 mysql_cloud1: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3fc4c856[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@563b6686 connection handles=0 lastReturned=1559025839295 lastValidated=1559025275191 lastCheckedOut=1559025839214 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@343f2260 mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@1047af01[pool=DSMYSQL20190527075619087] xaResource=LocalXAResourceImpl@46f7c7d7[connectionListener=3fc4c856 connectionManager=5cf0e3a1 warned=false currentXid=null productName=MySQL productVersion=5.7.14-google-log jndiName=java:/DSMYSQL20190527075619087] txSync=null]
org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 mysql_cloud1: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3fc4c856[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@563b6686 connection handles=0 lastReturned=1559025839295 lastValidated=1559025275191 lastCheckedOut=1559025839214 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@343f2260 mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@1047af01[pool=DSMYSQL20190527075619087] xaResource=LocalXAResourceImpl@46f7c7d7[connectionListener=3fc4c856 connectionManager=5cf0e3a1 warned=false currentXid=null productName=MySQL productVersion=5.7.14-google-log jndiName=java:/DSMYSQL20190527075619087] txSync=null]
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:723)
at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:65)
at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:561)
at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135)
at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40)
at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79)
at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:285)
at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:323)
at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
at com.sun.proxy.$Proxy74.read(Unknown Source)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:422)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:570)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:423)