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:
<interaction-spec className="oracle.tip.adapter.db.DBPureSQLInteractionSpec">
<property name="SqlString" value="UPDATE SET = # WHERE = #"/>
<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!