Re: Exception in xa_open with SqlServer 2000 SP3a on Win 2003

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 10:20:19 -0700
To: "David S. Faller" <david_faller@de.ibm.com>

David S. Faller wrote:

> Hi!
>
> I have an application server and try to access my SqlServer 2000
> database running on Win 2003 using a two-phase commit connection
> (datasource property enable2Phase=true). The JDBC driver is SP3.
>
> I receive the following exception:
>
> Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC][SQLServer]xa_open (0) returns -3

Hi. That's not a driver issue, it is a failure of an ancillary ddl that
implements the extended stored procedures thet SQLServer uses for XA.
There have been recent fixes to those DLLs, so the first thing to do is to
upgrade the DBMS to the latest fixpack.
Joe Weinstein at BEA

> 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)
>
> If I disable either the enable2Phase or use a SqlServer database on
> Win2000 everything works fine.
>
> Any ideas?
>
> My JDBC driver reports the following:
> Database product name : Microsoft SQL Server
> Database product version : Microsoft SQL Server 2000 - 8.00.760 (Intel
> X86)
> JDBC driver name : SQLServer
> JDBC driver version : 2.2.0040

Relevant Pages

  • Re: Fatal error 682 and SqlDependency
    ... Cannot execute as the database principal because the ... However, this error is unrelated to the size of the query notification, is ... When this error happens in the server messages for one query notification ... SqlServer 2005 Notification Services feature to get notified about changes ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MySQL used with VB .NET 1.0
    ... Whatever process you eventually develop for getting the data from an EXCEL spreadsheet on your machine into a database on your ISPs server will be much more complicated than a simple CSV export and FTP. ... I don't think that much people here use MySql as SqlServer Express from Microsoft is freeware. ...
    (microsoft.public.dotnet.languages.vb)
  • Exception in xa_open with SqlServer 2000 SP3a on Win 2003
    ... The JDBC driver is SP3. ... If I disable either the enable2Phase or use a SqlServer database on ... Database product name: Microsoft SQL Server ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Moving full-text index to a different system - problems
    ... What I did was to restore the database into a database which had the db_id I ... > The Content Index for project <SQLServer SQL0001100005> cannot be loaded. ... > The previous crawl was reset, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Insert between separate databases
    ... the other is a remote sql server which I can access via ip address. ... You can link the remote sqlserver database inside access if I'm not mistaken, ... If you use sqlserver, and you have both catalogs in the same server, you can do: ...
    (microsoft.public.dotnet.framework.adonet)
Loading