Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Microsoft JDBC Driver XA Problem

3 views
Skip to first unread message

Jay Shen

unread,
Apr 10, 2005, 11:47:56 PM4/10/05
to
Hi,

I have applied XA support via the dll and script...but now I got the
following error. Anyone can point me a direction to fix this?
Thanks,

j-

20:44:06 [tyrex.resource.n3-db] [main] [transaction server is recovering] []
[] ERROR - Failed to create connection for default user
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]xa_open (0) returns -3
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown
Source)
at
com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at
com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.open(Unknown Source)
at com.microsoft.jdbcx.base.BaseXAConnection.<init>(Unknown Source)
at com.microsoft.jdbcx.base.BaseXADataSource.getXAConnection(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerDataSource.getXAConnection(Unknown
Source)
at
tyrex.resource.jdbc.ConnectionPool.createPooledConnection(ConnectionPool.java:841)
at
tyrex.resource.jdbc.ConnectionPool.completeInit(ConnectionPool.java:256)
at
tyrex.resource.jdbc.ConnectionPool.<init>(ConnectionPool.java:222)
at
tyrex.resource.jdbc.DataSourceConfig.createResource_(DataSourceConfig.java:237)
at
tyrex.resource.ResourceConfig.createResource(ResourceConfig.java:390)
at tyrex.resource.Resources.getResource(Resources.java:235)
at
tyrex.tm.impl.TransactionServerImpl.recover(TransactionServerImpl.java:582)
at
com.intalio.n3.common.tyrex.TyrexModule.initialize(TyrexModule.java:130)
at
com.intalio.n3.common.module.ModulesManager.initializeModule(ModulesManager.java:373)
at
com.intalio.n3.common.module.ModulesManager.initializeAllModules(ModulesManager.java:263)
at com.intalio.n3.Main.start(Main.java:454)
at com.intalio.n3.Main.main(Main.java:239)
20:44:09 [tyrex.resource.n3-db] [main] [null] [] [] ERROR - Failed to create
connection for default user java.sql.SQLException: [Microsoft][SQLServer
2000 Driver for JDBC][SQLServer]xa_open (0) returns -3
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown
Source)
at
com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at
com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.open(Unknown Source)
at com.microsoft.jdbcx.base.BaseXAConnection.<init>(Unknown Source)
at com.microsoft.jdbcx.base.BaseXADataSource.getXAConnection(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerDataSource.getXAConnection(Unknown
Source)
at
tyrex.resource.jdbc.ConnectionPool.createPooledConnection(ConnectionPool.java:841)
at
tyrex.resource.jdbc.ConnectionPool.completeInit(ConnectionPool.java:256)
at
tyrex.resource.jdbc.ConnectionPool.<init>(ConnectionPool.java:222)
at
tyrex.resource.jdbc.DataSourceConfig.createResource_(DataSourceConfig.java:237)
at
tyrex.resource.ResourceConfig.createResource(ResourceConfig.java:390)
at tyrex.resource.Resources.getResource(Resources.java:235)
at
tyrex.tm.impl.TransactionServerImpl.recover(TransactionServerImpl.java:626)
at
com.intalio.n3.common.tyrex.TyrexModule.initialize(TyrexModule.java:130)
at
com.intalio.n3.common.module.ModulesManager.initializeModule(ModulesManager.java:373)
at
com.intalio.n3.common.module.ModulesManager.initializeAllModules(ModulesManager.java:263)
at com.intalio.n3.Main.start(Main.java:454)
at com.intalio.n3.Main.main(Main.java:239)
20:44:10 [n3.common.module] [main] [null] [] [] WARN - Failed the initialize
module 'TransactionManager'
20:44:10 [n3.common.module] [main] [null] [] [] FATAL - ModulesManager
tyrex.resource.ResourceException: java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_open (0) returns -3
at
tyrex.resource.jdbc.ConnectionPool.<init>(ConnectionPool.java:225)
at
tyrex.resource.jdbc.DataSourceConfig.createResource_(DataSourceConfig.java:237)
at
tyrex.resource.ResourceConfig.createResource(ResourceConfig.java:390)
at tyrex.resource.Resources.getResource(Resources.java:235)
at
tyrex.tm.impl.TransactionServerImpl.recover(TransactionServerImpl.java:582)
at
com.intalio.n3.common.tyrex.TyrexModule.initialize(TyrexModule.java:130)
at
com.intalio.n3.common.module.ModulesManager.initializeModule(ModulesManager.java:373)
at
com.intalio.n3.common.module.ModulesManager.initializeAllModules(ModulesManager.java:263)
at com.intalio.n3.Main.start(Main.java:454)
at com.intalio.n3.Main.main(Main.java:239)


Manfred Rosenboom

unread,
Apr 11, 2005, 8:09:02 AM4/11/05
to
Jay Shen wrote:
> Hi,
>
> I have applied XA support via the dll and script...but now I got the
> following error. Anyone can point me a direction to fix this?
> Thanks,
>
> j-
>
> 20:44:06 [tyrex.resource.n3-db] [main] [transaction server is recovering] []
> [] ERROR - Failed to create connection for default user
> java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC][SQLServer]xa_open (0) returns -3
> at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Hi Jay,

Seems, that you haven't started the DTC (Distributed Transaction
Coordinator) service. This service is installed during the
MS SQL Server 2000 installation but with start type 'manual'.

BTW: which user do you use to connetc to the database ? If you don't
use sa (which would be a good idea) have in mind, that XA recovery is
only allowed for a system administrator. To allow all users to perform
XA recovery, you have to add the EXEC permission to PUBLIC for the
stored procedure xp_jdbc_recover (part of extended stored procedures) in
the master database.

Best,
Manfred

Jay Shen

unread,
Apr 11, 2005, 5:13:59 PM4/11/05
to
Thanks a lot, Manfred.

I did apply the suggestion to grant the rights. But for some reason, I am
still getting the same errors...weird...

"Manfred Rosenboom" <maro...@gmx.de> wrote in message
news:d3dpcu$d6c$1...@nntp.fujitsu-siemens.com...

0 new messages