file to jdbc gave an error !! pls help me....

[former_member185856]

Hi,

When I was running a scenario on File to JDBC....the follwing error occurred...

<b>Initialization error: Loading jdbc driver 'sun.com.microsoft.jdbc.SQLserverDriver' failed: java.lang.ClassNotFoundException: sun.com.microsoft.jdbc.SQLserverDriver

Found in negative cache

</b>

I have given the parameter as ;

com.microsoft.jdbc.SQLserverDriver

jdbc:microsoft:sqlserver://192.168.1.144:1433;databaseName=cmr1

where cmr1 is the database name..in the MSSQL server. which is under JDBC database.

ANY HELP ON THIS....PLS ..AND THANKS IN ADVANCE....

regards,

Sunil K Shetty

[Former Member]

now that i look at the error i am seeing that the class that it is trying to load is

'sun.com.microsoft.jdbc.SQLserverDriver' however in the config you said it is 'com.microsoft.jdbc.SQLserverDriver' ...

Please verify...

Thanks,

Renjith

[Former Member]

Please add the required JDBC drivers onto XI's java stack as said in the how-to guide ...

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

Thanks,

Renjith

[Former Member]

Hi,

see

deploy the JDBC drivers using the guide

Deploying and Removing JDBC Drivers

http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/content.htm

Regards

Chilla..

[bhavesh_kantilal]

Is the JDBC adapter installed on the XI server?

It looks like the driver is not installed,

Regards

Bhavesh

[former_member185856]

Ya....JDBC drivers are installed.... I tried with command prompt....

D:\jdbc>drivertool check aii_af_jmsproviderlib.sda

SAP XI 3.0 JDBC/JMS Driver Tool. Version 1.0.1615

Copyright (C) 2005 SAP AG. All rights reserved.

DISCLAIMER: This program is provided "as is" without warranty of any kind.

Checking consistency of aii_af_jmsproviderlib.sda:

The SDA aii_af_jmsproviderlib.sda contains the following correctly

registered driver JARs:

msbase.jar

mssqlserver.jar

msutil.jar

mysql-connector-java-3.1.11-bin.jar

SDA validation successful.

THNAKS IN ADVANCE....

regards,

Sunil...