jdbc adapter:unable to locate a suitable JDBC driver

[xinjiang_li]

Hi,gurus:

My scenario is jdbc to file.

Ater I activated the scenario,there was an error occured in RWB: " Unable to locate a suitable JDBC driver".But we have deployed relavant driver in SDM,so why did it happen?Any help will be appreciated!

[Former Member · Accepted solution]

Hello xinjiang,

What database are you connecting to? Assuming that you have deployed the driver properly in SDM. Please check the parameters in your Sender JDBC Communication channel, particularly "JDBC Driver" and "Connection".

For example, if your are connecting to a SQLServer database,

JDBC Driver should contain "com.microsoft.jdbc.SQLServerDriver"

and Connection should contain jdbc:microsoft:sqlserver://<db-hostname>;databaseName=<db-name>

Hope that helps you out!

Glenn

[xinjiang_li · Accepted solution]

Hi,Glenn :

Thank you very much,the problem was solved.

The reason is that I input the incorrect parameter in "JDBC Driver".

But now another problem occured:

In RWB,it said "Error establishing socket".Any ideas?

[Former Member · Accepted solution]

Hi Xinjiang,

I've never encountered that error before. Could you post more details? Also, it might help if you close this thread and open another with the "Error Socket" title so someone browsing the threads who's familiar with your error can more readily reply.

Please provide more info about your error.

Glenn

[xinjiang_li · Accepted solution]

Hi:

The issue was solved by setting the logging on to sqlserver to mixed mode.

Thank you very much.