3 Replies Latest reply on Mar 22, 2017 8:27 AM by shawkins

Unable to execute batch update on oracle database with jdbc Statement.

kulbhushanc Mar 20, 2017 10:56 AM

Hi,

I am getting different behavior when performing update using batch on oralce and mysql database.

teiid version: 9.1.3

jboss version: Wildfly 10.0.0

Scenario:

In case of Mysql:

I am able to insert a records when a batch contains both duplicate and non-duplicate records

In case of oracle:

It only throws exception for violating duplicate key constrains and non-duplicate record insertion also fails

both scenario throws the exception, the stack trace as below.

Stack Trace:

Mar 20, 2017 8:09:42 PM org.teiid.net.socket.SocketServerInstanceImpl exceptionOccurred

WARNING: Unable to read: unexpected exception

java.io.OptionalDataException

at java.io.ObjectInputStream.readObject0(Unknown Source)

at java.io.ObjectInputStream.readObject(Unknown Source)

at org.teiid.client.ResultsMessage.readExternal(ResultsMessage.java:286)

at java.io.ObjectInputStream.readExternalData(Unknown Source)

at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)

at java.io.ObjectInputStream.readObject0(Unknown Source)

at java.io.ObjectInputStream.readObject(Unknown Source)

at org.teiid.net.socket.Message.readExternal(Message.java:56)

at java.io.ObjectInputStream.readExternalData(Unknown Source)

at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)

at java.io.ObjectInputStream.readObject0(Unknown Source)

at java.io.ObjectInputStream.readObject(Unknown Source)

at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:108)

at java.io.ObjectInputStream.readObject(Unknown Source)

at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117)

at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:306)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)

at com.sun.proxy.$Proxy1.read(Unknown Source)

at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:405)

at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:551)

at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:404)

at org.teiid.jdbc.StatementImpl.executeBatch(StatementImpl.java:332)

at com.test.mySql.WithTeiid.executeSqlInBatch(WithTeiid.java:429)

at com.test.mySql.WithTeiid.main(WithTeiid.java:58)

org.teiid.jdbc.TeiidSQLException: org.teiid.net.socket.SingleInstanceCommunicationException

at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)

at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:559)

at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:404)

at org.teiid.jdbc.StatementImpl.executeBatch(StatementImpl.java:332)

at com.test.mySql.WithTeiid.executeSqlInBatch(WithTeiid.java:429)

at com.test.mySql.WithTeiid.main(WithTeiid.java:58)

Caused by: org.teiid.net.socket.SingleInstanceCommunicationException

at org.teiid.net.socket.SocketServerInstanceImpl.exceptionOccurred(SocketServerInstanceImpl.java:226)

at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:310)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)

at com.sun.proxy.$Proxy1.read(Unknown Source)

at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:405)

at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:551)

... 4 more

Caused by: java.io.OptionalDataException

at java.io.ObjectInputStream.readObject0(Unknown Source)

at java.io.ObjectInputStream.readObject(Unknown Source)

at org.teiid.client.ResultsMessage.readExternal(ResultsMessage.java:286)

at java.io.ObjectInputStream.readExternalData(Unknown Source)

at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)

at java.io.ObjectInputStream.readObject0(Unknown Source)

at java.io.ObjectInputStream.readObject(Unknown Source)

at org.teiid.net.socket.Message.readExternal(Message.java:56)

at java.io.ObjectInputStream.readExternalData(Unknown Source)

at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)

at java.io.ObjectInputStream.readObject0(Unknown Source)

at java.io.ObjectInputStream.readObject(Unknown Source)

at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:108)

at java.io.ObjectInputStream.readObject(Unknown Source)

at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117)

at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:306)

... 12 more

Thanks,

Kulbhushan Chaskar.

1. Re: Unable to execute batch update on oracle database with jdbc Statement.

shawkins Mar 20, 2017 11:20 AM (in response to kulbhushanc)

What is the client version? The stack appears that it's happening when warnings are deserialized, but it's not clear from this description of the other forum post why this is happening.
Actions
2. Re: Unable to execute batch update on oracle database with jdbc Statement.

kulbhushanc Mar 21, 2017 1:34 AM (in response to shawkins)

client version(Teiid AdminShell) is also 9.1.3, I always keep same version as Teiid AdminShell as that of teiid. I downloaded it from the page Downloads · Teiid
right now page showing different version. what it functionality it adds?
Actions
3. Re: Unable to execute batch update on oracle database with jdbc Statement.

shawkins Mar 22, 2017 8:27 AM (in response to kulbhushanc)

AdminShell will be relatively unchanged by a different fix version. The issues addressed can be obtained from JIRA or the release blog post - teiid: Teiid 9.1.4 Released

In any case the exception you are seeing is not something that is expected or has otherwise been identified and would not be affected by just a simple fix release change.

I have tried to replicate using what seems like a similar setup - 9.1.x, an oracle backend, and a failing statement batch update - but have had no luck in reproducing. Can you provide a representative reproduction scenario including the client code here or on a JIRA issue?
Actions

Go to original post