ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher.Mathru...@sybase.com
Subject RE: nearly time to give up on XA
Date Fri, 20 Apr 2007 16:07:46 GMT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii" 
format="flowed" delsp="yes;" plain; text Content-Type: 7bit 
Content-Transfer-Encoding:>
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=247585315-20042007><FONT face=Arial 
color=#0000ff size=2>I'm using iBatis with Spring for XA and have no problems. 
It is difficult getting all the technologies to play together but XA is 
difficult and it requires a bit of patience. I'm currently using Spring 2.0.2 
with iBatis 2.3.0. My transaction manager is Bitronix as I am not running within 
JBoss. It works exceptionally well and is very easy to 
configure.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=247585315-20042007><FONT face=Arial 
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=247585315-20042007><FONT face=Arial 
color=#0000ff size=2>One thing you need to make certain of is that you read the 
documentation carefully pertaining to the JDBC drivers you are using. I tried 
the jTDS driver but seeing as I am running against Sybase ASE, jTDS was not a 
good choice as it does not fully implement XA to whereas JConnect does. I 
believe jTDS does support XA for SQL Server but only if you have executed the 
SQL script supplied with it and have installed the dll. So make certain that you 
have performed everything that the JDBC documentation 
outlines.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Mark Volkmann &lt;mark@ociweb.com&gt;

[mailto:Mark Volkmann &lt;mark@ociweb.com&gt;] <BR><B>Sent:</B>
Friday, April 
20, 2007 8:45 AM<BR><B>To:</B> user-java@ibatis.apache.org<BR><B>Subject:</B>

nearly time to give up on XA<BR></FONT><BR></DIV>
<DIV></DIV>I'm nearing the end of four days trying to get XA transactions to 
<BR>work. It's a complicated soup of technologies that have to come 
<BR>together. I'm using the following. <BR><BR>* JBoss 4.0.5 <BR>*
Spring 2.0.2 
<BR>* iBATIS 2.3.0 <BR>* Abator 1.0.0 (generates Spring DAOs for iBATIS) <BR>*

Oracle 9i and the i-net GATE JDBC driver <BR>* SQL Server 2000 and the JTDS 1.2 
JDBC driver <BR><BR>There are just too many parts to get straight! <BR>*

spring-beans.xml <BR>* oracle-ds.xml <BR>* sqlserver-ds.xml <BR>* an Abator

configuration file for each database <BR>* an iBATIS SqlMapConfig.xml file for 
each database <BR>* jboss-web.xml <BR><BR>Due to all the variables in tool

selection, it's really difficult to <BR>find an example on the web that matches 
your specific situation. <BR><BR>My code runs fine, but when I purposely throw
a 
RuntimeException to <BR>force a database rollback, it doesn't rollback. The acts 
as though <BR>it's configured to do an autocommit after every database 
operation. <BR><BR>I think what I need to see is examples of configuring XA 
datasources <BR>in JBoss for <BR>* Oracle using the i-net GATE JDBC driver <BR>*

SQL Server using the JTDS JDBC driver <BR><BR>I'd really appreciated it if 
someone could email those to me. <BR><BR></BODY></HTML>


Mime
View raw message