Skip to Content
0

com.microsoft.sqlserver.jdbc.SQLServerDriver not Found

Dec 13, 2017 at 08:09 AM

69

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

10 Answers

Evgeniy Kolmakov Dec 13, 2017 at 09:52 AM
0

Hi Alexander!

And why not to use JDBC lookup for that?

Regards, Evgeniy.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 13, 2017 at 10:07 AM
0

Hi Evgeniy,

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

Regardsa,

Alex

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Dec 13, 2017 at 10:12 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 13, 2017 at 10:29 AM
0

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

Regards,

Alex

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Dec 13, 2017 at 10:36 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 13, 2017 at 10:56 AM
0

Hi,

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

Regards,

Alex

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Dec 13, 2017 at 11:21 AM
0

Hi Alexander!

Did you perform end-to-end testing?

Regards, Evgeniy.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 14, 2017 at 06:53 AM
0

Hi,

this error prevents the test.

Regards,

Alex


99593-output.jpg (27.3 kB)
Share
10 |10000 characters needed characters left characters exceeded
ambuj mishra Dec 14, 2017 at 01:05 PM
0

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

Thanks,

Ambuj


Show 1 Share
10 |10000 characters needed characters left 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.

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

Hi Ambuj,

thanks for your reply, here my includes

Best Regards,

Alex


include.jpg (221.4 kB)
Share
10 |10000 characters needed characters left characters exceeded