MySQL Forums
Forum List  »  Other Migration

MySQL in Rational Studio
Posted by: Dimitrios Bourekas
Date: September 01, 2005 01:27AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL in Rational Studio
9628
September 01, 2005 01:27AM
3592
October 04, 2005 12:20AM
3307
September 05, 2006 05:16AM
3542
November 29, 2006 10:59AM
3470
September 10, 2008 08:33AM
3543
December 10, 2006 05:44AM
3267
December 10, 2006 05:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.