[SAP Commerce][1905] MySQL JDBC Driver connection error

[Former Member]

Hi SAP Community,

I have SAP Commerce 1905 and I'm trying to install the b2b_acc_plus accelerator, using MySQL as a database. However, when I try to run ant initialize, I get the following error:

[yDbDriverValidator] 15:33:30,501 [main] ERROR DbDriverValidator - Database driver - com.mysql.jdbc.Drivercould not be found. Make sure you have it under <HYBRIS_FOLDER>/hybris/bin/platform/lib/dbdriver

I have the "mysql-connector-java-5.1.46.jar" file in the dbdriver folder, with the MySQL server running.

If anyone has any ideas, I'd be very grateful for your help.

Thanks,

Nikola

[arvind-kumar_avinash · Accepted solution]

Hi Nikola Stavrevski - it looks like the value of db.driver is not correct in your local.properties file. Given below are the correct values:

• com.mysql.jdbc.Driver for a 5.x driver
• com.mysql.cj.jdbc.Driver for a 8.x driver

Please let me know if you still face the issue.

Note:

• For Hybris v1905, the compatible versions of MYSQL are 5.6, 5.7, 8.0.
• For the 8.x databases, use the latest 8.x driver, for example, 8.0.15.
• For the 5.x databases, the 5.x drivers (at least 5.1.x) are recommended due to some known problems occurring if you use the 8.x driver with the 5.x databases.

[Former Member · Accepted solution]

Hi arvind-kumar-avinash,

Thank you very much for the detailed answer. However, it wasn't a problem with the driver or configuration.

The issue was that I was adding the driver to the platform/lib/dbdriver folder, then installing the recipe, and then setting the properties. When I tried to install the recipe first, and then add the driver and properties, it worked.

In any case, your answer was very helpful and insightful, thank you!

[arvind-kumar_avinash · Accepted solution]

You are most welcome, Nikola Stavrevski.

[Former Member · Accepted solution]

For Hybris v1905, I recommend to use
MySQL v8.0.20 and connector v8.0.20

For Hybris v1905 I had compatibility issue with MySQL v5.6.41, but with v8.0.20 it works.