Skip to Content
0
Former Member
Nov 16, 2016 at 01:08 PM

Getting Error while connecting to mysql databse from SAP MII

225 Views

Hello Experts,

I am trying to establish connection to mysql (version 5.7) database from MII (version 15.1).

Any external JDBC drivers are required to establish connection.Can any one help me from where have to download and procedure to upload.

Provided details as below.

JDBC Driver :com.mysql.jdbc.Driver.

Server URL: jdbc:mysql://<host>:<port>/<dbname>?profileSQL=true.

validation query :SELECT GETDATE().

getting following error.

Unable to create connection to database for <dataservername>
[EXCEPTION]
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at com.sap.lhcommon.system.CustomClassLoader.findClass(CustomClassLoader.java:232)
at java.lang.ClassLoader.loadClass(ClassLoader.java:490)...

Regards,

Hari.