Skip to Content
author's profile photo Former Member
Former Member

MYSQL driver class not found

Hello,

I am getting the same error in this thread while connecting to a MYSQL database. I have deployed the .sda file( forcefully, not using SUM or JSPM) after including the MYSQL jar file and the provider.xml.

I can find the mysql jar in my PI al11 folders. However in the java class loader the resource is not seen. I have restarted the j2ee engine several times. Please help to let me know why the class is not loaded.

Regards,

ninu sankar

pastedImage_0.png (14.5 kB)
pastedImage_1.png (20.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 07, 2016 at 11:44 AM

    Hi Ninu,

    Can you advise what you mean when saying that you deployed it forcefully? If not using SUM or JSPM (by the way, JSPM has been deprecated in newer releases anyway), did you deploy it using NWDS or AS Java Telnet deploy command? Besides options mentioned above and ANT scripts (all listed in SAP Note 1715441), I don't think there is another alternative to correctly deploy these libraries in a SAP supported way.


    Normally, when com.sap.aii.adapter.lib.sda is deployed correctly, provider.xml shall not appear in /lib directory on the application server - /lib directory shall only contain JAR files of JDBC/JMS drivers contained in a folder /lib of deployed com.sap.aii.adapter.lib.sda. Having this in mind and looking into screenshot of tx. AL11 that you provided, I would assume MySQL JDBC driver library and updated provider.xml where copied to corresponding directory on the application server, but not actually consistently deployed as a part of newly assembled com.sap.aii.adapter.lib.sda. Assuming this, can you deploy com.sap.aii.adapter.lib.sda by one of supported means mentioned above and check again if MySQL JDBC library gets listed in Java class loader view?

    Can you also post content of file provider.xml contained in deployed com.sap.aii.adapter.lib.sda? Does it have correct references to MySQL JDBC Connector library JAR file in "jars" section?

    As a side note, instead of manually assembling com.sap.aii.adapter.lib.sda and changing provider.xml in there, you may give a try to SDA Maker Tool, it helps a lot in automation and simplification of JDBC/JMS and Axis provider libraries assembly (see SAP Note 1987079 for more details on SDA Maker Tool).

    Regards,

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2016 at 11:34 AM

    Hi Ninu,

    I have deployed the .sda file( forcefully, not using SUM or JSPM)

    Why didn't you use JSPM?, it is standard way.

    Regards

    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.