- This topic has 2 replies, 3 voices, and was last updated 19 years, 10 months ago by
.
-
Posts
-
Oracle 9i works great with the latest 3.8.4 update! Thanks guys. 😀
However, I still can’t get MySQL 4.0.22 to work with the ER diagramer. It prints the tables and their fields OK but not relationship diagrams.
I am using MySQL 4.0.22, MySQL-AB JDBC Driver 3.0.5, InnoDB for table storage (Transactions supported).
My tables are all Table Information except Foreign Keys.Any ideas? Thanks.
Try and upgrade your driver to the new 3.1 GA release, because I use MySQL 4.0.22 w/ Inno and 4.1.7 w/ Inno and successfully print out my diagrams to take to meetings and such.
Gduan,
Glad to hear Oracle is working for you. Good deal.
Relationship lines will only be drawn if your database stores Foreign Key Constraints in it’s schema.
Re: MySQL, I see you are using InnoDB for storage, which does store Foreign Keys. Transaction support is of no consequence to the ER Designer.
You mentioned that you cannot see foreign key information, which is why the ER Designer is not showing the relationship lines.
Are you sure you are creating relationships with dependancy constraints in your schema? Have you observed Foreign keys anywhere at all in the Database Explorer? DB Browser, Table Info View,ER Designer, anywhere?
As Riyad mentioned – update your driver, maybe it isn’t picking them up.
Best,
Brian.
