2 Replies Latest reply: Nov 30, 2012 12:02 PM by 977303 RSS

    Database Adapter InsertProblem

    user8695019
      Hi All,

      I am trying to insert a row in the master and detail table, and for that I am using Custom SQL. The problem is that I have two insert commands and
      TopLink probably does not allow this.

      Here is the jca file:

      <adapter-config name="InsertMasterDetailTables" adapter="Database Adapter" wsdlLocation="InsertMasterDetailTables.wsdl" xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata">

      <connection-factory location="eis/DB/test1" UIConnectionName="test1" adapterRef=""/>
      <endpoint-interaction portType="InsertMasterDetailTables_ptt" operation="InsertMasterDetailTables">
      <interaction-spec className="oracle.tip.adapter.db.DBPureSQLInteractionSpec">
      <property name="SqlString" value="INSERT INTO incoming_files (id_paketa, file_type, status) VALUES (#lv_id_paketa, #lv_file_type, #lv_status); INSERT INTO incoming_file_lines (id, id_paketa, file_line) VALUES (#lv_id, #lv_id_paketa, #lv_file_line);"/>
      <property name="GetActiveUnitOfWork" value="false"/>
      </interaction-spec>
      <input/>
      </endpoint-interaction>

      </adapter-config>

      And error that I get:

      Non Recoverable System Fault :

      BINDING.JCA-12563 Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'InsertMasterDetailTables' failed due to: Pure SQL Exception. Pure SQL Execute of INSERT INTO incoming_files (id_paketa, file_type, status) VALUES (?, ?, ?); INSERT INTO incoming_file_lines (id, id_paketa, file_line) VALUES (?, ?, ?); failed. Caused by java.sql.SQLSyntaxErrorException: ORA-00911: invalid character . ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.



      Than You in advance!