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">
<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"/>
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!
The issue is generated by the character ';' placed at the end of the sql query.
Please edit the DB adapter and Remove the ';' character at the end of the sql query.
Redeploy the project .