|
Hi Forum,
I have some questions about XA in ofbiz. My concern stems from my customers choice of database which is MSSQL 2005 which seems fairly complex to setup to support XA. Also, I'm also receiving the warning:
[XAConnectionFactory.java:119:WARN ] no xares in rms for con org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAConnectionImpl@1107304
I am currently using one datasource in my ofbiz setup. This points to a sql server 2005 database. One of my services calls a legacy stored procedure in that database. The stored procedure reads/writes to another database via. the syntax DBNAME.SCHEMA.OBJECT, E.g.
ALTER PROCEDURE [dbo].[CreateJobHistoryNote] () AS
BEGIN
...
INSERT INTO SequenceDB.dbo.tblSequenceNotes VALUES ('x')
...
END
- Q1) Does the above setup require XA in ofbiz?
I would like to setup another datasource in ofbiz to put all the stock ofbiz tables into different schema separate from my legacy tables (which is currently dbo).
- Q2) Does the above setup require XA in ofbiz?
Many thanks in advance,
Chris
|