Skip to Content
avatar image
Former Member

com.microsoft.sqlserver.jdbc.SQLServerDriver not Found

Hi,

I want to build a SQL connection via a UDF but unfortunately I get the message "Driver not found".

A JDBC channel works with this driver.

Can someone help me?

Regards,

Alex

udf.jpg (135.3 kB)
channel.jpg (105.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Dec 13, 2017 at 09:52 AM

    Hi Alexander!

    And why not to use JDBC lookup for that?

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2017 at 10:07 AM

    Hi Evgeniy,

    as soon as the connection is established i want to execute serveral stored procedure.

    Regardsa,

    Alex

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 13, 2017 at 10:12 AM

    Hi Alexander!

    Do you want to use stored procedure for data retrieval or for updating?

    And how do you test your mapping? Do you perform end-to-end testing?

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2017 at 10:29 AM

    for both, depending on the status in the mapping that should change.

    Regards,

    Alex

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 13, 2017 at 10:36 AM

    Hi Alexander!

    First of all, you shouldn't perform any actions having side effects (data state change, for example) in message mappings.

    I guess it could be achieved using standard functionality.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2017 at 10:56 AM

    Hi,

    It may be that it works in the standard, but I would like to use the UDF.

    Regards,

    Alex

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 13, 2017 at 11:21 AM

    Hi Alexander!

    Did you perform end-to-end testing?

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2017 at 06:53 AM

    Hi,

    this error prevents the test.

    Regards,

    Alex

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 14, 2017 at 01:05 PM

    Hi, Can you please include the import for this library "com.microsoft.sqlserver.jdbc.SQLServerDriver" in Import Instructions tab and try.

    Thanks,

    Ambuj

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ambuj!

      I guess we can't. Even if you add the appropriate driver's .jar to "Archives Used" and "com.microsoft.sqlserver.jdbc.*" to "Import Instructions", it won't work.

      Regards, Evgeniy.

  • avatar image
    Former Member
    Dec 14, 2017 at 01:09 PM

    Hi Ambuj,

    thanks for your reply, here my includes

    Best Regards,

    Alex

    Add comment
    10|10000 characters needed characters exceeded