Receiver JDBC adapter - JDBC driver value on comm channel

[Former Member]

Hi,

We are trying to connect to an SQL database. All the relevant drivers have been deployed as per the configuration guide.

Now setting up the comm channel for the receiver JDBC adapter.

What is the value for the "JDBC Driver" parameter in this case ?

i think it should be <b>com.microsoft.jdbc.sqlserver.SQLServerDriver</b>

Is this right ?

Kind regards

Colin.

[MichalKrawczyk · Accepted solution]

hi,

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

Regards,

michal

[Former Member · Accepted solution]

Hi Michal,

Do you have to have both correct ?

I have added both parameters and get this error in the RWB:

Receiver Adapter v1325 for Party '', Service 'Itecs':

Configured at 10:30:00 2006-05-30

Initialization error: Loading jdbc driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' failed: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

-

---

Loader Info -

---

ClassLoader name: [service:com.sap.aii.adapter.jdbc.svc]

Parent loader name: [Frame ClassLoader]

References:

service:com.sap.aii.af.cpa.svc

service:com.sap.aii.af.ms.svc

service:com.sap.aii.af.svc

service:com.sap.aii.adapter.xi.svc

library:com.sap.aii.af.lib

library:com.sap.aii.messaging.runtime

library:com.sap.xi.util.misc

common:service:iiop;service:naming;service:p4;service:ts

common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:com.sap.security.core.ume.service;service:connector;service:dbpool;service:keystore;service:security;service:userstore

library:ejb20

library:sapxmltoolkit

library:com.sap.guid

library:com.sap.tc.Logging

library:jms

Resources:

/usr/sap/SXD/D02/j2ee/cluster/server0/bin/services/com.sap.aii.adapter.jdbc.svc/aii_adapter_jdbc_svc.jar

Loading model: {parent,local,references}

-

---

Available JDBC drivers:

No deployed JDBC Drivers found

Any ideas ?

Kind regards

Colin.

[MichalKrawczyk · Accepted solution]

hi,

but did you deploy the driver first?

as per guide:

https://websmp206.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDrivers.zip

?

Regards,

michal

[bhavesh_kantilal · Accepted solution]

Hi ,

The error log clearly states, <b><i>Available JDBC drivers:

No deployed JDBC Drivers found</i></b>

Even if you have deployed your driver, I think you must have made some mistake during the deployment process.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Regards,

Bhavesh

[bhavesh_kantilal]

Hi Colin,

You are on the right track.

The Driver for MS SQL Server

<b>com.microsoft.jdbc.sqlserver.SQLServerDriver</b>

Connection String for MS SQL Server:

<b>jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname></b>

Regards,

Bhavesh