Data services 4.2 with mysql JDBC driver

[Former Member]

Hi All,

We are installing data services in unix server where mysql is the repository database.While giving repository details(Find it in first image) we are getting the error as provided in the second image.We do have the jar file in the path mentioned still we are getting this error.

Any help/insight on the below issue will be highly appreciated.Thanks in advance!

Repo details:

error:-

Thanks,

Sunil Panda

[Former Member · Accepted solution]

Check the SAP note 1806731 - There is a problem to connect to repository: JDBC database driver for 'MySQL' is not loade...

You have install the correct version as given in the note. - http://downloads.mysql.com/archives/mysql-connector-java-5.1/mysql-connector-java-5.1.18.zip

[Former Member · Accepted solution]

Hi Arun,

Thanks a lot for your reply! It resolved the driver issue as we are not getting the above error.

Now we are getting the error as below.I am sure about the login information as we installed IPS with same credentials.Any input on this will be really helpful.

Thanks,

Sunil

[Former Member · Accepted solution]

Hi Sunil,

Normally that kind of error is associated with the user name and pwd. Since you mentioned that's not the case, i would suggest to check the connection to the repo using ip address or DB Server name. Also make an entry in the hosts file (as done in windows). I guess it is the socket file in UNIX, but not sure , you could check this link - https://dev.mysql.com/doc/refman/5.5/en/connecting.html

Arun

[Former Member · Accepted solution]

Hi Arun,

I am able to connect to mysql from the terminal by providing server/db details

Thanks,

Sunil

[Former Member · Accepted solution]

Hi Sunil,

    I have met the same  problem ,have you already solved the problem? Can you show me how to solve the problem，thanks！

    by the way,the logon information here  is the ame credentials as we installed IPS or we should create another database？

[Former Member]

Hi Sunil,

follow the note 1806731 and download the correct and supported version jdbc driver.

except that you should install the odbc and configure it

the MySQL odbc driver file :/usr/lib64/libmyodbc5w.so

ODBC Lib Path:/usr/lib64

Driver Name：MySQL

the Driver Name should be configured in the /etc/unixODBC/odbcinst.ini

hope this will help you