[Resolved] Urgent : Insert data through DB Adapter into MS SQL Server fails
Hi All,
I'm using SOA, Jdev 11.1.1.3 to insert the data into the MS SQL server table with one of the columns (Hec_Id) as PRIMARY KEY. It is not an IDENTITY column as seen in the Jdeveloper Database Editor because IDENTITY option is unchecked.
I am not assigning anything in Hec_Id. The project compiles successfully but fails to insert data at run time throwing the following exception.
59a1fad2:-7ffc-00000000000114f0] [WEBSERVICE.name: selectupdatehector_client_ep] [J2EE_APP.name: soa-infra] [URI: /soa-infra/services/default/HectorDbOperations/selectupdatehector_client_ep] <WSInvocationManager::invoke> got FabricInvocationException[[
oracle.fabric.common.FabricInvocationException: BINDING.JCA-12563
Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertHector.Tblhector].
Caused by java.sql.SQLSyntaxErrorException: [OWLS][SQLServer JDBC Driver][SQLServer]Invalid object name 'DUAL'..
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.
I have gone through some SRs but all are related to 10g.
Anyone having any idea would be very helpful. Any pointers welcome.
Regards,
Neeraj Sehgal
Edited by: Neeraj Sehgal on Jun 13, 2011 7:47 AM