| Thomas Günter 2006-03-27, 9:23 am |
| Hi all,
I've the following configuration in my project:
JBoss 4.0.1 SP1
j2sdk1.4.2_06
DB server: MS SQLServer 2000 (SP4)
JDB driver: MS SQLServer 2000 Driver for JDBC (SP3)
sqljdbc.dll copied and initjdbc.sql done at server side.
When the datasource for the SQLServer 2000 Driver below is deployed the
exception further down is thrown. Does anybody know something about this
return code -4?
Any help is appreciated.
Thanks.
--thomas
---------
<xa-datasource>
<jndi-name>BFlowDS</jndi-name>
<track-connection-by-tx/>
<track-statements>true</track-statements>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</xa-datasource-class>
<xa-datasource-property
name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property
name="DatabaseName">guenttom_xt14pl2</xa-datasource-property>
<xa-datasource-property
name="SelectMethod">cursor</xa-datasource-property>
<user-name>guenttom_xt14pl2</user-name>
<password>guenttom_xt14pl2</password>
<no-tx-separate-pools />
<transaction-isolation> TRANSACTION_READ_COM
MITTED</transaction-isolation>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>500000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<metadata>
<type-mapping>MS SQLSERVER2000</type-mapping>
</metadata>
</xa-datasource>
13:06:25,107 WARN & #91;TransactionImpl]
XAException:
tx=TransactionImpl:X
idImpl[FormatId=257, GlobalId=pc38712/1,
BranchQual=, localId=1] errorCode=XAER_RMERR
javax.transaction.xa.XAException: [Microsoft][SQLServer 2000 Driver for
JDBC]& #91;SQLServer]xa_com
mit (40000000) returns -4
at
com.microsoft.jdbcx.sqlserver. SQLServerImplXAResou
rce. executeXaRpc(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver. SQLServerImplXAResou
rce.commit(Unknown Source)
at com.microsoft.jdbcx.base.BaseXAResource.commit(Unknown Source)
at
org.jboss.resource.adapter.jdbc.xa.XAManagedConnection. commit(XAManagedConn
ection.java:176)
at
org.jboss.tm. TransactionImpl$Reso
urce. commit(TransactionIm
pl.java:2141)
at
org.jboss.tm.TransactionImpl. commitResources(Tran
sactionImpl.java:1674)
at org.jboss.tm.TransactionImpl. commit(TransactionIm
pl.java:312)
at org.jboss.tm.TxManager.commit(TxManager.java:200)
at
org.jboss.mq.sm.jdbc. JDBCStateManager$JDB
CSession. close(JDBCStateManag
er.java:624)
at
org.jboss.mq.sm.jdbc.JDBCStateManager. initDB(JDBCStateMana
ger.java:482)
at
org.jboss.mq.sm.jdbc.JDBCStateManager. startService(JDBCSta
teManager.java:399)
at
org.jboss.system.ServiceMBeanSupport. jbossInternalStart(S
erviceMBeanSupport.java:272)
at
org.jboss.system.ServiceMBeanSupport. jbossInternalLifecyc
le(ServiceMBeanSuppo
rt.java:222)
at sun.reflect. GeneratedMethodAcces
sor2.invoke(Unknown Source)
at
sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher. invoke(ReflectedDisp
atcher.java:144)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at
org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:249)
at
org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:642)
at
org.jboss.system. ServiceController$Se
rviceProxy. invoke(ServiceContro
ller.java:891)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:416)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:438)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:438)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:438)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:438)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:438)
at sun.reflect. GeneratedMethodAcces
sor10.invoke(Unknown Source)
at
sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher. invoke(ReflectedDisp
atcher.java:144)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at
org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:249)
|