cancel
Showing results for 
Search instead for 
Did you mean: 

MYSQL driver class not found

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

vadimklimov
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hello Vadim,

The deployment is done using telnet command forcefully.

Regards,

Ninu Sankar

vadimklimov
Active Contributor
0 Kudos

Hi Ninu,

In AS Java Telnet, can you check if MySQL JDBC driver class can be recognized and found by class loader? This can be done by executing following command in AS Java Telnet:

llr -all -f com/mysql/jdbc/Driver.class

If class loader found driver's class, you should be able to see output of the command llr, similar to the one below (containing a reference to a binary file(s) where the class is located):

If driver's class wasn't deployed correctly and wasn't found by class loader, output of the command llr will look like this:

If you see a latter case, please re-assemble com.sap.aii.adapter.lib.sda and re-deploy it again to the PI system.

Regards,

Vadim

Former Member
0 Kudos

hello,

I have used the sda maker this time and it deployed successfully.

Regards,

Ninu Sankar

Answers (1)

Answers (1)

iaki_vila
Active Contributor
0 Kudos

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