on 11-16-2016 1:08 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try to give below:
Server URL: jdbc:mysql://<host>:<port>; databaseName = <dbname>
Regards,
Abhijeet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.