webMethods

webMethods

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

Getting error in new JDBC adapter connection (IS 8.2 version) using sql server 2005.

  • 1.  Getting error in new JDBC adapter connection (IS 8.2 version) using sql server 2005.

    Posted Tue October 13, 2015 01:26 AM

    Hello Everyone,

    My self mahesh here. I am new to webMethods. I am creating the JDBC adapter connection using sql server 2005. I already download the jdbc driver 4.0 jar files from microsoft website and copied to the “C:\SoftwareAG\IntegrationServer\lib\jars” location and I restart the IS server also. Then I try to click on Enable to"Yes" I am getting the below error.

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource MySecondTest.SQLServerConnection:SQLServerConnection.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

    Kindly help me some one on this issue.

    Thanks and Regards
    Mahesh


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


  • 2.  RE: Getting error in new JDBC adapter connection (IS 8.2 version) using sql server 2005.

    Posted Tue October 13, 2015 05:38 AM

    Nope, place the .zip or .jar file containing the
    classes in the
    Integration Server_directory\instances\instance_name\packages\WmJDBCAdapter\co
    de\jars directory.

    Restart Integration Server.
    The server automatically adds the .zip or .jar libraries to its classpath after the restart.


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


  • 3.  RE: Getting error in new JDBC adapter connection (IS 8.2 version) using sql server 2005.

    Posted Wed October 21, 2015 01:16 PM

    Hi Mahesh C.,

    as stated by the error message the driver version does not match the java version.
    Can you provide the jar-file-name you have used?

    Additionally provide the output of “java -version” for the JDK/JRE being used.
    What is the Fix-Level of your JDBC -Adapter 6.5?

    There is the possibility to update the java version from 1.6 to 1.7 for wM 8.2.
    See UpdateManager under Infrastructure for details.
    Read the accomanying readme very carefully to avoid any odd circumstances.
    Also check Empower for the related KB-Article.

    I agree with Mahesh K. about to where to place the jars.

    I have checked the version of the Jars I have downloaded from Microsoft in February 2015:

    Package Version from MS Knowledgebase: sqljdbc_4.1.5605.100

    • sqljdbc.jar Classfile Version x31 (Decimal 49)
    • sqljdbc4.jar Classfile Version x32 (Decimal 50)
    • sqljdbc41.jar Classfile Version x33 (Decimal 51)

    The classfile version is indicating the Java version being required as minimum.

    Regards,
    Holger


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


Related Content