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
  • 1.  JDBC Connection Issue

    Posted Mon March 10, 2025 09:20 AM

    Hi Everyone,

    We have encountered a below error for a JDBC connection in our server.

    Error:

    [ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

    This driver is not configured for integrated authentication.

    Please find below JDK version of the 10.15 IS server.

    Java version

    17.0.13 (61.0)

    Java VM name

    OpenJDK 64-Bit Server VM


    Please also find the below screenshot of jar file which is updated in the server VM.

    image

    Please find the below connection properties.

    Can somebody please help us with the above issue.

     

    Thanks & Regards,

    Uday Kiran Kondi



    ------------------------------
    Uday kiran Kondi
    ------------------------------


  • 2.  RE: JDBC Connection Issue

    Posted Mon March 10, 2025 10:33 AM

    Hi Uday,

    please check if you can switch to a newer version of the driver as version 9 is 4 years old now.
    Might be that the version 9 driver was not supporting integrated authentication via JDBC connection.
    Driver version should be equal to or greater than 12.6.

    Regards,
    Holger



    ------------------------------
    Holger von Thomsen
    Software Developer
    Deutsche Telekom IT GmbH
    Darmstadt
    ------------------------------



  • 3.  RE: JDBC Connection Issue

    Posted Mon March 10, 2025 10:57 AM

    Hi Holger,

    We have tried with the new version 12.8 file. But still facing the same error as earlier.

    Error:

    [ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

    This driver is not configured for integrated authentication.

    Thanks & Regards,

    Uday Kiran Kondi



    ------------------------------
    Uday kiran Kondi
    ------------------------------



  • 4.  RE: JDBC Connection Issue

    Posted Mon March 10, 2025 11:11 AM

    Hi Uday,

    when exchanging the native auth dll for the driver, this requires a complete shutdown and restart of the IS instance.
    Additionally, the matching jar files should be placed under packages/WmJDBCAdapter/code/jars/static instead of packages/WmJDBCAdapter/code/jars/ in this case.

    You might find this link helpful: Building the connection URL to MS SQL with integrated auth.

    Regards,
    Holger



    ------------------------------
    Holger von Thomsen
    Software Developer
    Deutsche Telekom IT GmbH
    Darmstadt
    ------------------------------



  • 5.  RE: JDBC Connection Issue

    Posted Mon March 10, 2025 12:41 PM

    Hi Holger,

    We have tried placing the dll file under the path packages/WmJDBCAdapter/code/jars/static.

    A complete shutdown and restart of the IS instance was also followed.

    But the issue is not yet resolved.

    Thanks & Regards,

    Uday Kiran Kondi



    ------------------------------
    Uday kiran Kondi
    ------------------------------



  • 6.  RE: JDBC Connection Issue

    Posted Tue March 11, 2025 12:27 PM

    Hi Uday,

    the dll belongs under lib/jars/custom and the jar belongs under packages/WmJDBCAdapter/code/jars/static.
    Usually, the jar would belong under packages/WmJDBCAdapter/code/jars, but due to neccessity of the dll it needs to be under the static subdirectory.

    Regards,
    Holger



    ------------------------------
    Holger von Thomsen
    Software Developer
    Deutsche Telekom IT GmbH
    Darmstadt
    ------------------------------



  • 7.  RE: JDBC Connection Issue

    Posted Mon March 17, 2025 07:21 AM

    Hi Holger,

    Thank you for your information provided.

    We have added the jar and dll files as required, and the JDBC connection is working fine now.

    Regards,

    Uday



    ------------------------------
    Uday kiran Kondi
    ------------------------------