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)
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
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...