I'm trying to use SQLServer 2000 with the i-net OPTA 2000 driver on
JBoss pre-2.1 and am getting "javax.transaction.xa.XAException: The XID
is
not valid" when I first try to select a row from SQL Server. I've
attached more
details from the log below, in case it's useful.
The support people at I-Net are sayiog that there doesn't seem to be a
transaction open when the statement is executed. However, I am using
Container-managed transaction handling, with the following entries in
the deployment descriptor: -
<assembly-descriptor>
<container-transaction>
<method>
<ejb-name>Security</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
</assembly-descriptor>
Any help very much appreciated.
Regards
Dave
-----------------------------------------------------------------------
[driveDS] Starting
[driveDS] XA Connection pool driveDS bound to java:/driveDS
[driveDS] [TDS Driver]getXAConnection( drive, drive )
[driveDS] SQL Server 7 unicode mode
[driveDS] Test License with 2 Connections
[driveDS] Driver: i-net OPTA 2000 4.00
[driveDS] Statement.close
[driveDS] select count(*) from master.dbo.sysprocesses where
program_name = 'i-net OPTA 2000'
[driveDS] Number of connections :1
[driveDS] Statement.close
[driveDS] select value from master..sysoptions where id=101
[driveDS] Statement.close
[driveDS] create table master..sysoptions(id int,value numeric(18,0))
insert into master..sysoptions(id,value) values(101,1003136367349)
[driveDS] No transaction right now.
[driveDS] Pool driveDS [0/0/10] gave out new object:
com.inet.tds.k@4b42cf
[driveDS] [TDS Driver]XA_CONNECTION_GET
[driveDS] [TDS Driver]XA_CONNECTION_FREE
[driveDS] Pool driveDS [0/1/10] returned object com.inet.tds.k@4b42cf to
the pool.
[driveDS] Started
[Service Control] Started 25 services
[Default] JBoss 2.1-BETA-Mar-26-2001 Started in 0m:11s
[driveDS] Connection.close
[Security] LOGLEVEL IS 2
[Security] 18/04/2001:10:01:42,DEBUG,executing SELECT * FROM USERDETAIL
WHERE USERNAME = 'richarddrew',ve.ejb.classes.SQLManager.executeQuery
[Security] LOOKING UP DATASOURCE java:/driveDS
[driveDS] Resource 'com.inet.tds.k@4b42cf' enlisted for
'com.inet.tds.k@4b42cf'.
[driveDS] Pool driveDS [1/1/10] gave out pooled object:
com.inet.tds.k@4b42cf
[driveDS] [TDS Driver]XA_CONNECTION_GET
[driveDS] SQL Server 7 unicode mode
[driveDS] Test License with 2 Connections
[driveDS] Driver: i-net OPTA 2000 4.00
[driveDS] Statement.close
[driveDS] select count(*) from master.dbo.sysprocesses where
program_name ='i-net OPTA 2000'
[driveDS] Number of connections :1
[driveDS] Statement.close
[driveDS] select value from master..sysoptions where id=101
[driveDS] Statement.close
[driveDS] create table master..sysoptions(id int,value numeric(18,0))
insert into master..sysoptions(id,value) values(101,1003136502083)
[driveDS] Statement.close
[driveDS] SELECT * FROM USERDETAIL WHERE USERNAME = 'richarddrew'
[driveDS] javax.transaction.xa.XAException: The XID is not valid.
[Security] XAException: tx=XidImpl [FormatId=257, GlobalId=VWSWS6//1,
BranchQual=] errorCode=XAER_NOTA
[Security] javax.transaction.xa.XAException: The XID is not valid.
[Security] at com.inet.tds.k.if(Unknown Source)
[Security] at com.inet.tds.k.for(Unknown Source)
[Security] at com.inet.tds.k.rollback(Unknown Source)
[Security] at
org.jboss.tm.TxCapsule.rollbackResources(TxCapsule.java:1552)
[Security] at org.jboss.tm.TxCapsule.rollback(TxCapsule.java:408)
[Security] at
org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:88)
[Security] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor
CMT
.
java:307)
[Security] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[Security] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav
a:1
9
0)
[Security] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[Security] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer
.ja
v
a:271)
[Security] at
>org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPConta
iner
I
nvoker.java:392)
[Security] at java.lang.reflect.Method.invoke(Native Method)
[Security] at sun.rmi.server.UnicastServerRef.dispatch(Unknown
Source)
[Security] at sun.rmi.transport.Transport$1.run(Unknown Source)
[Security] at java.security.AccessController.doPrivileged(Native
Method)
[Security] at sun.rmi.transport.Transport.serviceCall(Unknown
Source)
[Security] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown
Source)
[Security] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
[Security] at java.lang.Thread.run(Unknown Source)
[driveDS] javax.transaction.xa.XAException: The XID is not valid.
Dave Horner
Symularity Limited
Leeds Innovation Centre
103 Clarendon Road
Leeds, LS2 9DF
Tel: 0113 384 5723
Fax: 0113 384 5701
Mob: 07973 325881
The information contained in this e-mail is intended for the named
recipients only. It may contain privileged and confidential information.
If you are not the addressee or the person responsible for delivering
this to the addressee, you may not copy, distribute or take action in
reliance on it. If you have received this e-mail in error, please notify
us immediately by returning the original message to the sender by
e-mail.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
