<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=062430217-30032007><FONT face=Arial size=2>I'm running
into a
rather odd and difficult issue to nail down and I believe it is associated to
the way connections are cached. </FONT></SPAN></DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial size=2>iBatis:
2.3.0.668</FONT></SPAN></DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial size=2>Spring:
2.0</FONT></SPAN></DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial size=2>Transaction
Manager:
Bitronix</FONT></SPAN></DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial size=2>DB: Sybase ASE
12.0.0.8</FONT></SPAN></DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial size=2>JDBC Driver:
Sybase
JConnect 6.0</FONT></SPAN></DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial size=2>I've got a running
transaction that I suspend prior to an insert into a given table. (Long story as
to why I suspend) When I suspend the TX the insert that I perform needs to be on
a clean connection, one not associated with the transaction. (It seems either
ASE or JConnect is </FONT></SPAN><SPAN class=062430217-30032007><FONT><FONT
face=Arial size=2>not really capable of running more than one transaction at a
time on a single connection. This has something to do with implicit / explicit
transaction demarcation. So when I need a connection to perform the insert I
actually need a new connection. </FONT></FONT></SPAN></DIV>
<DIV><SPAN class=062430217-30032007><FONT><FONT face=Arial
size=2></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=062430217-30032007><FONT><FONT face=Arial size=2>Is
there any
way of configuring iBatis to do this type of behavior? As I debug the code I see
in the UserProvidedTransaction class that it simply returns the connection it
was given at time of instantiation, effectively this can be the same connection
that was part of the TX.</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=062430217-30032007><FONT face=Arial size=2>Thanks for the
help...</FONT></SPAN></DIV>
<DIV><SPAN class=062430217-30032007></SPAN> </DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial size=2>Chris Mathrusse</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="mailto:christopher.mathrusse@sybase.com">christopher.mathrusse@sybase.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2>(925) 236-5553</FONT></DIV>
<DIV> </DIV></BODY></HTML>
|