Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL7008 ERROR WHEN UPDATE ON DB2 OSB 11G

Andres SanzJul 25 2017 — edited Jul 26 2017

Hi everyone, this is the first time I use the OSB 11.7 to connect to a DB2 AS400 database. I think i've done that the right way, I was able to create my db adapters with JDeveloper, to setup a datasource in Weblogic even to use a business service to do a simple select on a table, but when I try to do an update I get the following message:

Pure SQL Execute of UPDATE SCHEMA.TABLE SET COL1 = ? WHERE COL2 = ? failed.
Caused by java.sql.SQLException: [SQL7008] TABLE of SCHEMA not valid for operation. (Translated from spanish)

I already tried to use XA vs NoXA transaction and both of them with One-Phase Commit and still the same error. I am sure it is not about permissions because I'm able to do the updates from DBeaver client. My JCA looks like this:

<interaction-spec className="oracle.tip.adapter.db.DBPureSQLInteractionSpec">

     <property name="SqlString" value="UPDATE SCHEMA.TABLE SET COL1 = #COL1 WHERE COL2 = #COL2"/>

     <property name="QueryTimeout" value="30"/>

     <property name="GetActiveUnitOfWork" value="false"/>

</interaction-spec>

What else should I do in order to accomplish the goal of the update? Thank you so much for your help!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 23 2017
Added on Jul 25 2017
2 comments
871 views