Skip to Content
avatar image
Former Member

jdbc adapter:unable to locate a suitable JDBC driver

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 08, 2008 at 02:27 AM

    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

    Add comment
    10|10000 characters needed characters exceeded