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

From: David S. Faller (david_NOSPAM_faller_at_de.ibm.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 11:49:17 +0200
To: Joe Weinstein <joe@bea.com>

Hi Joe,

Thanks for this information. I verified that the SQL Server has been
updated to SP3a and that the sqljdbc.dll in my SQL Server's binn
directory is the one shipped with the latest JDBC driver (SP3).
Still no luck...

Can you give me more details on which dll has to be updated and where to
get the update? The list of post-SP3 updates of SQL Server does not list
any XA related issues
(http://support.microsoft.com/common/canned.aspx?Sz=kbSQLServ2000presp4fix).

Thanks,
David Faller

Joe Weinstein wrote:
>
>
> 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: Exception in xa_open with SqlServer 2000 SP3a on Win 2003
    ... The list of post-SP3 updates of SQL Server does not list ... David Faller ... > implements the extended stored procedures thet SQLServer uses for XA. ... > Joe Weinstein at BEA ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: SQL Server stops responding
    ... Microsoft SQL Server Storage Engine ... on several occasions SQLServer simply stopped responding. ... > Nothing was recorded in the event logs. ... > In the SQLServer error logs occasionally there is the entry 'LogEvent: ...
    (microsoft.public.sqlserver.server)
  • Re: Web site database - Access or SQL Server?
    ... SQLServer will perform better that access for a variety ... added security features as well as many performance benefits, ... extensive and normalized, the tuning tools in SQLServer, in the hands of a ... window to edit your SQL Server sprocs, but don't throw away the Enterprise ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Web Service Deployment
    ... The exception is complaining that it cannot find a SQL Server using the ... Are you able to ping SQLServer from machine2 using just the ... > I created a virtual directory on machine2 and pointed it to the directory ... > access denied" and refers to a work space ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: SQLserver connect ????
    ... running SQL Server and all 3 of them have an MSDE database on them. ... sqlserver database, ... all devices can connect to its sql server and msde ... Also uninstalled NAV, rebooted, and still no connection ...
    (microsoft.public.dotnet.framework.compactframework)
Loading