Some oracle drivers are allegedly xa compatible however you have to use
their own Xid implementation (there's an ugly hack in the tm to do this)
and specify to use their implementation in jboss.jcml somewhere.. I think
there's a comment about this.
I have never tried it, I recall a few people getting it to work and many
coming to grief. If you get it to work maybe you'd contribute the config
to the manual with the gotchas you had to overcome?
Thanks
david jencks
On 2001.09.22 18:39:23 -0400 "Ferguson, Doug" wrote:
> What is entailed in changing to an XA DataSource...
> Are the oracle drivers XA compatible?
>
> d.
>
>
>
> -----Original Message-----
> From: Ole Husgaard [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, September 22, 2001 5:09 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] Transaction Exception !!! / ejbStore
>
>
> Hi,
>
> "Ferguson, Doug" wrote:
> >
> > I've done some more research and it appears that there is alittle more
> going
> > on.
> >
> > We have two datasources. 1 is for failover.
> > The 2nd database syncs with the other every 10 minutes.
> > For our user session we have to write to both of the databases.
> > This wier exception was occuring when both databases were set to the
> same
> > database.
> >
> > Note: Could this be because jBoss sees the databases as different but
> they
> > are actually the same?
>
> I guess so. In that case, the commit would happen twice on the
> same database.
>
> I have to warn against using the XA wrapper with more than one
> datasource:
> Problem is that the XA prepare step is a no-op in the wrapper,
> so the commit step is not guaranteed to succeed.
> So the TM could do the commit step fine on the first datasource,
> and if the commit step fails on the second data source you end
> up with a heuristic, and your data integrity is void.
>
> To get around that problem, use _real_ XA datasources, without
> the wrapper.
>
>
> Best Regards,
>
> Ole Husgaard.
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
