Hi there,
Here's some background to my question.
I have defined two views to another SQL server from the one I am connecting
to. ( Distributed query in MSSQL-speak )
The two tables and classes are mapped in a 1-to-many relationship. I can
load from the views just fine. My problem is with writing the one and many
rows in the two tables.
When writing I get:
java.sql.SQLException: Unable to start a nested transaction for OLE DB
provider 'SQLOLEDB'. A nested transaction was required because the
XACT_ABORT option was set to OFF.
I know from a kb article at MS that OLE-DB providers don't support nested
transactions with XACT_ABORT OFF when doing distributed transactions or
queries.
So how do I set XACT_ABORT ON with castor in this case?
If it's easy I'll do it, otherwise I'll just use the driver directly for
writing these rows.
many thanks - richard
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
