-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dieter Kroemer wrote:
> Hi, > > I'm a teacher in germany and searching for a database, wich supports > foreign-keys and is supported from OOo. (Well I found the HSQLD-Database > (Hermann Kienlein was helping) which is working, but with MySQL I could do > all my jobs in schools with only _one_ database). > Till now, I thought mysql can't work with foreign keys, but I read, that > tables in the innodb-format can do this. But if I work with the jdbc-driver > and OOo, OOo doesn't support the foreignkeys-gui :-(( (the cause is the > jdbc-Driver) > > Does anybody know, if a future version of the jdbc-Driver will support this > foreignkeys-feature of innodb-format? It does (and has for quite some time). What version of MySQL are you using? The most recent two releases (4.0.14 and 4.0.15) have changed the output format for the metadata that the JDBC driver uses to parse foreign keys, so the JDBC driver had to be updated (but hasn't been rolled up into a release). Please try a nightly build of Connector/J from http://mmmysql.sourceforge.net/snapshots/stable/ Regards, -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/bdHGtvXNTca6JD8RAqykAKCGofe+Hho8prh5PiIVSK+GwSJb9wCdFfo6 LHEP/PIKllo2B7s0Agt00a4= =1FRI -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]