users@glassfish.java.net

Re: DBSchema Auto-Generation is Incorrect

From: Rochelle Raccah <Rochelle.Raccah_at_Sun.COM>
Date: Mon, 13 Jul 2009 16:09:20 -0700

Hi Mark,

You can go to here
https://glassfish.dev.java.net/source/browse/glassfish/cmp/generator/database/libsrc/com/sun/jdo/spi/persistence/generator/database/
and pick the properties file for your database (in your case
MYSQL.properties), then you will find the list of reserved words.

IIRC, the NB and capture schema code paths are slightly different, so
that is why you may see some differences in the generated files.

Rochelle



glassfish_at_javadesktop.org wrote:
> Thanks Rochelle for the feedback.
>
> I will try to rename that table and those fields and see how that goes. Is there some list published that shows what the reserved words are?
>
> I am using GlassFish 2.1 connecting to MySQL 5.0.51a using the MySQL drivers.
>
> Also, is there any reason why the dbschema file generated from Netbeans and the capture utility are different then the file that is generated by GlassFish during deployment?
>
> Thanks again.
>
> Mark
> [Message sent by forum member 'markag' (markag)]
>
> http://forums.java.net/jive/thread.jspa?messageID=355216
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>