SAP Lumira - java class not found in classpath com.mysql.jdbc.driver

[Former Member]

I am trying to connect to a MySQL database (add new dataset) and I receive the error: Java Class not found in classpath: com.mysql.jdbc.Driver

I downloaded the latest MySQL drivers and restarted the application, but still get the same error. I can't find anything in the Community in regards to connecting to a MySQL database regarding this error message.

Any help would be greatly appreciated.

[TammyPowlas · Accepted solution]

Ray - please see this SAP note to see if it helps you http://service.sap.com/sap/support/notes/2113343

Tammy

[Former Member · Accepted solution]

I cannot get to this link for some reason...

[TammyPowlas · Accepted solution]

It says this:

"

Cause

• The MS SQL drivers have not been installed or defined in SAP Lumira

Resolution

1. Download the latest SQL drivers from:
   http://www.microsoft.com/en-in/download/details.aspx?id=11774
2. In SAP Lumira under the File menu find Preferences.
3. Click on SQL Drivers.
4. Select the SQL Driver.
5. Restart SAP Lumira.

[Former Member · Accepted solution]

I have the MS SQL Server Drivers already loaded, but what I am having a problem with is MySQL. I did load the drivers for MySQL and it is there, but I still get the error. I also restarted the app after the driver install.

[former_member183750 · Accepted solution]

See if one of the following helps:

[XI 3.0] JDBC connection to mysql from Webi

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter (#SAPLumira)

Got Enhancement ideas? Use the SAP Idea Place 

[former_member183750]

Public URL to the KBA quoted by Tammy:

https://apps.support.sap.com/sap/support/knowledge/public/en/2113343

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter (#SAPLumira)

Got Enhancement ideas? Use the SAP Idea Place