java.lang.class not found

[Former Member]

Hi,

I configured scenario FILE TO JDBC, the sender channel is successful but in the receiving I am getting the error that java.lang.class not found.

In the receiver communication channel, I gave "com.microsoft.jdbc.sqlserverdriver".

what database connection parameters need to be given??

Thanks,

Satish.

[Former Member]

Whats your database ?

As Suresh said, did you deploy your JDBC driver ?

How to ?

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide... to install and configure external drivers for jdbc and jms adapters.pdf

After configuring your communication channel, did you check the Adapter Monitor

XI SP > 09

http://<host>:5<sysnum>00/rwb -> Component Monitoring -> All Display -> Adapter Engine -> Adapter Monitor

XI SP <= 09

http://<host>:5<sysnum>00/AdapterFramework

Oracle Driver & Connection:

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@<hostname>:<port_umber>:<database_name>

SQL Server Driver & Connection:

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:1433;DatabaseName=<DBName>

regards

Shravan

[Former Member]

Did you instal the jdbc driver in the j2ee engine? You have to do this if the jdbc adapter has to work. Here is an excerpt from help.sap.com:

<i>To be able to use the JDBC adapter you must install the JDBC driver for the database that you want to connect to. The required Java libraries are product-specific and must be obtained from the database vendor. Following installation, you must deploy the Java libraries on the J2EE server so that the JDBC adapter can access the required Java classes at runtime.</i>

Regards,

Suresh