RE: [JBoss-user] Does anybody work with XA driver for MS SQL Server?

2002-10-14 Thread Geer, Benjamin
David Jencks wrote: > You could try using 3.2 and setting the TrackConnectionByTx attribute to > true: this will prevent trying to do suspend/resume calls. Where can I set this attribute, and what is the syntax for setting it? Benjamin --

Re: [JBoss-user] Does anybody work with XA driver for MS SQL Server?

2002-10-10 Thread Robson Miranda
Does anybody work with XA driver for MS SQL Server?It seems that with MS JDBC driver you don't need to use more than one datasource to have problems. I'm always getting deadlock in the database when I have more than one user. I just tried with SapDB, just to make sure I didn't nothing wrong, and m

RE: [JBoss-user] Does anybody work with XA driver for MS SQL Server?

2002-10-10 Thread Alexey Yudichev
Title: RE: [JBoss-user] Does anybody work with XA driver for MS SQL Server? Just tried 3.2. Still get javax.transaction.xa.XAException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_end (400) returns -6     at

Re: [JBoss-user] Does anybody work with XA driver for MS SQL Server?

2002-10-10 Thread David Jencks
I didn't read your earlier messages carefully. Deadlock is unlikely to be related to local or xa tx, but rather varying resource ordering. The first message you show here seems to indicate that the driver is not fully xa compliant, and doesn't support suspend/resume. You could try using 3.2 and