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">
Erros on SOAP UI are :
<faultstring>[FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'dbo.SelfRegistration'.</faultstring>
From Managed server log the error is
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.
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.
Venugopal SSSS Raja Patnaik