Skip to Content
0

Getting Error while connecting to mysql databse from SAP MII

Nov 16, 2016 at 01:08 PM

85

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhijeet Naste Nov 17, 2016 at 09:18 AM
0

Try to give below:

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

Regards,

Abhijeet

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 18, 2016 at 12:07 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded