I have configured an XA Driver to insert the data to the table on MS SQL Server. When i execute the Flow with a SOAP UI. I was able to insert the data the MS SQL table . But at the end the transaction is rolled back.
My Request is
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:mvn="http://xmlns.oracle.com/MVNEIDM/MVNESelfRegistration/MVNESelfRegistration">
Form weblogic server : -
Error committing transaction:; nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: weblogic.jdbc.sqlserverbase.ddc: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'dbo.SelfRegistration'. Error Code: 208
The process is completed with out any error but why it is rolling abck the transaction at the end. The object table was existing in the database and i mapped to the table for inserting the data from receive input variable to invoke input variable. BPEL Instance executed it till the end but at the end the transaction is rolled back.
No The table is in schema dbo ... i am using the jedveloper 184.108.40.206.0
While creating a db adapter in reference service-> i select the schema name dbo adn then table self registration. based on that i was doing my mapping..
Thanks i got the resolution. yes the object was not found since there is a difference in Database name .... but still the flow is executed in green colour and at the end it throws an exception as rolling back transaction.
Solution: I had a one linux server on which the databases are installed.
I have two application say x and y but i created only one XA Datasource to ms sql server since host name / ip address /usrname/pwd are same. i thought i can use same data source adn connecton name . But there is a difference in database name liek ABS , ABS_C.. when i create two data sources for two different connection pools for two data sources it was working fine.