Getting Error while connecting to mysql databse from SAP MII

[Former Member]

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.

[Former Member]

Hi Abhijeet,

Below Server URL formate is the correct one.

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

Issue is because of UserName through which trying to access mysql DB.

"User" should have all privileges to access mysql DB.

and validation query should be SELECT NOW() as SELECT GETDATE() is for MSSQL.

Regards,

Hari.

[abhinaste]

Try to give below:

Server URL: jdbc:mysql://<host>:<port>; databaseName = <dbname>

Regards,

Abhijeet