Hi, we have a problem:
we have a SQL Server DB with internally linked a remote oracle DB.
We have created views in out SQL Server DB to map remote oracle tables.
When we try an insert sql on the SQL Server Enterprise Manager on the views all run correctly.
When we use EJB 3.0 to execute the same insert (via persist method) we receive this error:
Unable to start a nested transaction for OLE DB provider 'MSDAORA'. A nested transaction was required because the XACT_ABORT option was set to OFF"
SET XACT_ABORT ON