Hi,
My experience with jboss transaction management lead me to think that jboss
starts its transactions just fine. I also suspect that the line
[MSADictionary] [TDS Driver]XA_CONNECTION_GET
is jboss starting the xid.
I recall some discussion that the Oracle xa driver requiredd use of the
Oracle Xid class, rather than the jboss one. There is a patch where the
xid is created that under some circumstances uses the Oracle xid class for
all jboss xids. Perhaps you will need to use the Opta2000 xid class?
One thing that has mystified me about the java xa "spec" is where the xid
instances are supposed to come from. It looks to me as if any XAResource
is supposed to be able to accept any XId implementation. I would think that
the transaction manager should be responsible for creating Xids, although I
would kind of expect a factory method, and that it ought to be able to use
any implementation of the interface it wants to. However the discussion
about the Oracle drivers indicated that Oracle supplied their own xid
implementation with their driver, and required its use. I can't find a
part of the spec that this violates, however it seems to guarantee that
distributed transactions can only be used with resources from one
vendor!!!!! Maybe this is a spec defect.
I have no actual experience with Oracle xa drivers or Opta2000 drivers, but
perhaps this would be worth investigating anyway.
david jencks
On 2001.07.09 12:15:53 -0400 Jord Sonneveld wrote:
> No-one is complaining because they're all using the Minerva XA-JDBC
> wrappers :)
>
> I am having these same kinds of problems, but with Oracle 8.1.7 and
> jboss 2.2.2. Could you send me a more detailed stack trace?
>
> j\s
>
> -----Original Message-----
> From: Mark Crowley [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 04, 2001 1:57 PM
> To: '[EMAIL PROTECTED]'
> Subject: [JBoss-user] CMP Entity Bean using Opta2000 Driver - Has Anyone
> got this to work???
>
>
> I and a number of other Opta2000 users are trying without success to
> create
> CMP Entity bean. The bean deploys correctly, the datasource starts
> happily
> and JBoss creates the necessary table (proving the datasource is setup
> and
> working correctly), but when ever the bean is accessed (for example
> using a
> finder method) the following exception is generated (looging has been
> turned
> on as well):
>
> [MSADictionary] [TDS Driver]XA_CONNECTION_GET
> [MSADictionary] SQL Server 7 unicode mode
> [MSADictionary] Single Server License
> [MSADictionary] Driver: i-net OPTA 2000 4.10
> [MSADictionary] Statement.close
> [MSADictionary] SELECT server,catalog,chartID FROM ChartData
> [MSADictionary] Statement.close
> [MSADictionary] [TDS Driver]XA_CONNECTION_FREE
> [MSADictionary] javax.transaction.xa.XAException: The Xid is not
> valid.(XidImpl [FormatId=257, GlobalId=ZEBEDEE//0, BranchQual=1])
> resource
> manager:com.inet.tds.k@785d65
> [ChartData] XAException: tx=XidImpl [FormatId=257, GlobalId=ZEBEDEE//0,
> BranchQual=] errorCode=XAER_NOTA
> [ChartData] javax.transaction.xa.XAException: The Xid is not
> valid.(XidImpl
> [FormatId=257, GlobalId=ZEBEDEE//0, BranchQual=1]) resource
> manager:com.inet.tds.k@785d65
> [ChartData] at com.inet.tds.k.if(Unknown Source)
>
> We have been in touch with the tech-support for the driver who
> eventually
> came to the following conclusion:
>
> "The exception occurs because there is a rollback of the transaction
> with a
> specific XID but no transaction has been started. There seem be a bug in
> JBoss. JBoss is calling a rollback for a DT without starting a DT".
>
> I find it hard to believe there arent 1000's of people complaining about
> this, and therefore believe there is no bug, just a problem in my set
> up.
>
> My environment is
>
> OS: Win2K
> App Server: JBoss 2.2.2 with Tomcat 3.2.2
> JDBC: Opta2000 Tds driver 4.10
>
> Has anybody actually managed to get a CMP Entity bean working in JBoss
> with
> the Opta driver?
>
> Any thoughts, help, pointers would be much appreciated.
>
> Thanks in advance.
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
> <META NAME="Generator" CONTENT="MS Exchange Server version 6.0.4418.33">
> <TITLE>RE: [JBoss-user] CMP Entity Bean using Opta2000 Driver - Has
> Anyone got this to work???</TITLE>
> </HEAD>
> <BODY>
> <!-- Converted from text/plain format -->
>
> <P><FONT SIZE=2>No-one is complaining because they're all using the
> Minerva XA-JDBC wrappers :)</FONT>
> </P>
>
> <P><FONT SIZE=2>I am having these same kinds of problems, but with Oracle
> 8.1.7 and jboss 2.2.2. Could you send me a more detailed stack
> trace?</FONT></P>
>
> <P><FONT SIZE=2>j\s</FONT>
> </P>
>
> <P><FONT SIZE=2>-----Original Message-----</FONT>
>
> <BR><FONT SIZE=2>From: Mark Crowley [<A
>
>HREF="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]</A>]</FONT>
>
> <BR><FONT SIZE=2>Sent: Wednesday, July 04, 2001 1:57 PM</FONT>
>
> <BR><FONT SIZE=2>To: '[EMAIL PROTECTED]'</FONT>
>
> <BR><FONT SIZE=2>Subject: [JBoss-user] CMP Entity Bean using Opta2000
> Driver - Has Anyone</FONT>
>
> <BR><FONT SIZE=2>got this to work???</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=2>I and a number of other Opta2000 users are trying without
> success to create</FONT>
>
> <BR><FONT SIZE=2>CMP Entity bean. The bean deploys correctly, the
> datasource starts happily</FONT>
>
> <BR><FONT SIZE=2>and JBoss creates the necessary table (proving the
> datasource is setup and</FONT>
>
> <BR><FONT SIZE=2>working correctly), but when ever the bean is accessed
> (for example using a</FONT>
>
> <BR><FONT SIZE=2>finder method) the following exception is generated
> (looging has been turned</FONT>
>
> <BR><FONT SIZE=2>on as well):</FONT>
> </P>
>
> <P><FONT SIZE=2>[MSADictionary] [TDS Driver]XA_CONNECTION_GET</FONT>
>
> <BR><FONT SIZE=2>[MSADictionary] SQL Server 7 unicode mode</FONT>
>
> <BR><FONT SIZE=2>[MSADictionary] Single Server License</FONT>
>
> <BR><FONT SIZE=2>[MSADictionary] Driver: i-net OPTA 2000 4.10</FONT>
>
> <BR><FONT SIZE=2>[MSADictionary] Statement.close</FONT>
>
> <BR><FONT SIZE=2>[MSADictionary] SELECT server,catalog,chartID FROM
> ChartData</FONT>
>
> <BR><FONT SIZE=2>[MSADictionary] Statement.close</FONT>
>
> <BR><FONT SIZE=2>[MSADictionary] [TDS Driver]XA_CONNECTION_FREE</FONT>
>
> <BR><FONT SIZE=2>[MSADictionary] javax.transaction.xa.XAException: The
> Xid is not</FONT>
>
> <BR><FONT SIZE=2>valid.(XidImpl [FormatId=257, GlobalId=ZEBEDEE//0,
> BranchQual=1]) resource</FONT>
>
> <BR><FONT SIZE=2>manager:com.inet.tds.k@785d65</FONT>
>
> <BR><FONT SIZE=2>[ChartData] XAException: tx=XidImpl [FormatId=257,
> GlobalId=ZEBEDEE//0,</FONT>
>
> <BR><FONT SIZE=2>BranchQual=] errorCode=XAER_NOTA</FONT>
>
> <BR><FONT SIZE=2>[ChartData] javax.transaction.xa.XAException: The Xid is
> not valid.(XidImpl</FONT>
>
> <BR><FONT SIZE=2>[FormatId=257, GlobalId=ZEBEDEE//0, BranchQual=1])
> resource</FONT>
>
> <BR><FONT SIZE=2>manager:com.inet.tds.k@785d65</FONT>
>
> <BR><FONT SIZE=2>[ChartData] at
> com.inet.tds.k.if(Unknown Source)</FONT>
> </P>
>
> <P><FONT SIZE=2>We have been in touch with the tech-support for the
> driver who eventually</FONT>
>
> <BR><FONT SIZE=2>came to the following conclusion:</FONT>
> </P>
>
> <P><FONT SIZE=2>"The exception occurs because there is a rollback of
> the transaction with a</FONT>
>
> <BR><FONT SIZE=2>specific XID but no transaction has been started. There
> seem be a bug in</FONT>
>
> <BR><FONT SIZE=2>JBoss. JBoss is calling a rollback for a DT without
> starting a DT".</FONT>
> </P>
>
> <P><FONT SIZE=2>I find it hard to believe there arent 1000's of people
> complaining about</FONT>
>
> <BR><FONT SIZE=2>this, and therefore believe there is no bug, just a
> problem in my set up.</FONT>
> </P>
>
> <P><FONT SIZE=2>My environment is</FONT>
> </P>
>
> <P><FONT SIZE=2>OS: Win2K</FONT>
>
> <BR><FONT SIZE=2>App Server: JBoss 2.2.2 with Tomcat 3.2.2</FONT>
>
> <BR><FONT SIZE=2>JDBC: Opta2000 Tds driver 4.10 </FONT>
> </P>
>
> <P><FONT SIZE=2>Has anybody actually managed to get a CMP Entity bean
> working in JBoss with</FONT>
>
> <BR><FONT SIZE=2>the Opta driver?</FONT>
> </P>
>
> <P><FONT SIZE=2>Any thoughts, help, pointers would be much
> appreciated.</FONT>
> </P>
>
> <P><FONT SIZE=2>Thanks in advance.</FONT>
> </P>
>
> <P><FONT SIZE=2>_______________________________________________</FONT>
>
> <BR><FONT SIZE=2>JBoss-user mailing list</FONT>
>
> <BR><FONT SIZE=2>[EMAIL PROTECTED]</FONT>
>
> <BR><FONT SIZE=2><A
>HREF="http://lists.sourceforge.net/lists/listinfo/jboss-user";>http://lists.sourceforge.net/lists/listinfo/jboss-user</A></FONT>
> </P>
>
> </BODY>
> </HTML>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
