Skip to Content
avatar image
Former Member

Getting Error while connecting to mysql databse from SAP MII

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 17, 2016 at 09:18 AM

    Try to give below:

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

    Regards,

    Abhijeet

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 18, 2016 at 12:07 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded