JDBC Stored procedure to IDOC Scenario

[sukumar_perumalsamy]

Dear All,

MS SQL 2008 R2 Express Edition is sender JDBC and receiver is IDOC.

we have configured Sqljdbc4.jar in PI server, when i try to connect ot JDBC its throwing below error message.

SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Configuration is : JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

                            connection is : jdbc:sqlserver://<IP address>;instanceName=SAPINSTANCE

Processing parameters are :

Query SQL statement : SQL EXECUTE <stored procedure name>

Document name  is : MT_CarDax

update SQL statement is : <TEST>  (no update or modify )

PI and Sender applications are in local network ,

In Configuration i am able to see only JDBC 2.0 after the hot fix , does it show JDBC 4.0? or JDBC 2.0 is enough?

Please let me know is above my configuration parameters are correct.

thanks and regards

Sukumar

[baskar_gopalakrishnan2 · Accepted solution]

The message shows that JDBC drivers are not deployed properly. So runtime you get class not found exception. What is your PI version? and jvm version? You need to see only one drivers version. Remove the old version drivers and keep only the latest version.

[sukumar_perumalsamy · Accepted solution]

Dear Baskar,

JRE is 1.6.0.27

we installed JDBC 4.0

when we installed JDBC 3.0 we got JRE will not support install SQLJDBC4.jar.

then we installed JDBC4.0 but error raised ---SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

please advice.

Regards

Sukumar

[baskar_gopalakrishnan2 · Accepted solution]

Hopefully your jdk version is 1.5 or above. First delete the old version drivers and deploy the latest drivers. If your drivers are not installed succesfully you will get this error. Take help from Basis.

the link shows the compatibility details for jdbc version vs jdk version and sql server

http://www.microsoft.com/en-us/download/details.aspx?id=11774

[sukumar_perumalsamy · Accepted solution]

Dear All,

i have solved the issue after redeplying the JDBC4.0, and faced issue when executing the mapping its due to Caps letter in JDBC message mapping for ROW, after changing to row then flow worked well....

Cheers

Sukumar

[MichalKrawczyk]

Hi,

>>>>SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

that means that the driver was not installed properly and runtime cannot find class:

com.microsoft.sqlserver.jdbc.SQLServerDriver

Please check the JDBC driver installation on PI procedure once more and install it properly

Regards,

Michal Krawczyk

[sukumar_perumalsamy]

Dear Michal,

can you confirm my processing parameters are correct?

Query SQL statement : SQL EXECUTE <stored procedure name>

Document name  is : MT_CarDax

update SQL statement is : <TEST>  (no update or modify )

Regards

Sukumar

[Former Member]

hi sukumar,

once you have to check ur JDBC drivers installtion on pi what was posted by earler poster and

2 & 3 parameters are correct but

Query SQL statement : EXECUTE &lt;stored procedure name&gt;  only no need to write SQL before execute ........</p></body>

ex: http://scn.sap.com/thread/1943329