You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by snowch <sn...@coralms.com> on 2009/05/03 22:19:33 UTC

XA questions

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
-- 
View this message in context: http://www.nabble.com/XA-questions-tp23359374p23359374.html
Sent from the OFBiz - User mailing list archive at Nabble.com.