Hi, I've been trying to get MySQL to work with Rational Studio and still haven't managed to get the table structure of the database. My settings in the "New Connection" wizard are:
MySQL version 3.23
JDBC Driver: Other
Database: person
Host: localhost
Port: 3306
Driver: com.mysql.jdbc.Driver
Class Location: c:\mysql-connector-java-3.0.17-ga-bin.jar
Connection URL: jdbc:mysql://localhost/person?relaxAutoCommit=true
UserID: ...(as usual)
Password: ...(as usual)
Issues:
1. if I take away the relaxAutoCommit=true part, it complains about autoCommit
2. At the left side, there is no entry for the MySQL database manager, so it chooses Cloudscape
3. I am able to successfuly connect to my person db but it won't get the table structure
I found the following link
http://www.webspherepower.com/issuesprint/issue200310/00001111.html which describes connection of MySQL with Websphere studio 5, not Rational 6. There is no MySQL database ventor in Rational!
Any help is appreciated
Thanks