IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Problem using SQLServer 2000 with Microsoft JDBC Driver

  • 1.  Problem using SQLServer 2000 with Microsoft JDBC Driver

    Posted Thu March 18, 2004 12:27 AM

    Hi,

    I am trying to use Microsoft JDBC driver SP2 for SQL Server 2000 for defining connection pools for TN, IS Core Audit etc. I am able to make connection using the SQL Server 2000 but can not do any thing I am getting error

    java.sql.SQLException:[Microsoft] [SQL Server 2000 Driver for JDBC] Can’t start manual transaction mode because there are cloned connections

    My Environment is
    WM 6.1
    SQL Server : Developer Edition SQL Server 2000

    Does any body has any idea what this is? I try to serach for error but I could find other way around

    Can’t start a cloned connection while in manual transaction mode.

    But never found above error mentioned any where.

    I have some questions though

    1. Is it possible to use Microsoft SQL Server 200 Driver for JDBC with webMethods? ( I am using with 6.0.1 and that works fine)

    2. If yes, What am I doing wrong?

    3. Can we use MySQL database for configuration with WM6.1?

    Any help will be greatly appreciated. I have installed and configured almost all the versions webMethods came out with but I just cant figure this out?

    Thanks and regards
    Khushhal Mahajan


    #webMethods-General
    #webMethods
    #webMethods-Architecture
    #Integration-Server-and-ESB


  • 2.  RE: Problem using SQLServer 2000 with Microsoft JDBC Driver

    Posted Sat April 03, 2004 12:51 AM

    Pls use SelectMethod=cursor in DB URL


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods-Architecture


Related Content