Adding Foreign Key Constraints with Mac

12 views
Skip to first unread message

dbexternal

unread,
Jan 2, 2009, 4:12:39 PM1/2/09
to DB Solo
Greetings,

I'm currently evaluating DB Solo, and running into issues with foreign
key constraints. I've added, both initially when I created the table
and after using the add constraint option, and don't get any sort of
error. But, they don't show up in the Constraints or References tabs
- guess they're not really being added.

I'm using a Mac, DB Solo v3.5 with MySQL using the mysql-connector-
java-5.0.6 JDBC driver.

Any ideas?

Thanks!

DB Solo

unread,
Jan 2, 2009, 5:07:34 PM1/2/09
to DB-...@googlegroups.com
What is the table type of your table? I think only InnoDB tables
actually do anything with foreign keys.

Marko

dbexternal

unread,
Jan 3, 2009, 7:49:24 AM1/3/09
to DB Solo
Thanks Marko, that did it. Is there anyway of creating the table as
InnoDB? I could only figure out how to alter the engine type after
the fact.

On Jan 2, 5:07 pm, "DB Solo" <mhant...@gmail.com> wrote:
> What is the table type of your table? I think only InnoDB tables
> actually do anything with foreign keys.
>
> Marko
>

DB Solo

unread,
Jan 3, 2009, 8:27:19 AM1/3/09
to DB-...@googlegroups.com
Unfortunately this is not yet supported, but will probably be
supported soon. Like you said, you can only change the type after
you've created the table.

marko
Reply all
Reply to author
Forward
0 new messages