Skip to Content
author's profile photo Evgeniy Gubskiy
0
Evgeniy Gubskiy

Driver Class Could not be found

Posted on Aug 10, 2016 at 07:03 AM 362 Views

Hello!

Im trying install JDBC driver into mi XI system (PI 7.3)

Driver was installed

pidadm 65> cd /usr/sap/PID/DVEBMGS00/j2ee/cluster/bin/ext/com.sap.aii.adapter.lib/lib/

pidadm 66> ll

total 1048

-rwxr-xr-x. 1 pidadm sapsys 904 Aug 10 09:34 com.sap.aii.adapter.lib_api.jar

-rw-r--r--. 1 pidadm sapsys 537303 Aug 10 14:48 sqljdbc4.jar

-rw-r--r--. 1 pidadm sapsys 518072 Aug 10 09:34 sqljdbc.jar

And im was installed app http://localhost:50000/ftpjdbc

Im trying connection:

com.microsoft.sqlserver.jdbc

and received message:

ClassNotFoundException Occurred : Driver Class Could not be found.com.microsoft.sqlserver.jdbc

but to Oracle DB with class:

oracle.jdbc.driver.OracleDriver connecting is ok

whats is problem, guys?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Iñaki Vila
    Iñaki Vila
    Posted on Aug 10, 2016 at 07:27 AM
    0

    Hi Evgeny,

    Check the point 8 to know if the driver is deployed How to Deploy the JDBC Driver in PI 7.1/7.3

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

    • Vadim Klimov Evgeniy Gubskiy
      Aug 12, 2016 at 07:24 AM

      Evgeniy, llr output indicates the class was finely recognized and had been loaded, which looks perfectly good to me. Is it possible for you to prepare a scenario with JDBC sender or receiver, connecting to MS SQL database and using this class in configuration of the communication channel, just to verify if this is an issue with FTP/JDBC Test Tool or something different?

      Regards,

      Vadim

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2016 at 08:20 PM
    0

    Hello Evgeniy,

    check the deployed drives with SAP Note #1829286. But if I see it correctly, you have sqljdbc4.jar! file name (with "!" symbol at the end). Try to avoid it.

    Also, please tell the MS SQL version you're connecting to. Adapter settings would be great as well 😉

    In any case, here's a good collection of "must read" materials for such a problem:

    SAP KBA 2232201 - SAPClassNotFoundException thrown by JDBC adapter while connecting to Microsoft SQL Server 2008 database

    SAP KBA 1829286 - PI: How to check which drivers are installed for the JMS and JDBC Adapters

    SAP KBA 1816456 PI: Deploying new JMS/JDBC drivers overwrites existing deployed drivers

    SAP KBA 1138877 How to Deploy External Drivers JDBC/JMS Adapters

    SAP KBA 398807 - Microsoft SQL Server: JDBC driver support matrix

    SAP KBA 2142959 - How to check the version of Microsoft JDBC Driver for SQL Server

    Best regards,
    Vadym

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.