users@glassfish.java.net

Re: DBSchema Auto-Generation is Incorrect

From: Rochelle Raccah <Rochelle.Raccah_at_Sun.COM>
Date: Thu, 09 Jul 2009 17:29:57 -0700

I know that "9" is added to (sql) reserved words like "user" and "table"
when necessary.

Rochelle


glassfish_at_javadesktop.org wrote:
> I have been having issues with deploying my EAR application to Glassfish. I have finally narrowed the problem down to being the DBSchema file that is being generated. If I generate it from NetBeans or using the dbschema capture utility, they look fine. However, glassfish errors out during deployment stating a table doesn't exist. Now, if I allow GlassFish to generate the dbschema file during deployment, the the application deploys but it throws exceptions when navigating the site stating that a column name doesn't exist. For some reason the auto-generated file it is appending the number "9" to certain column and table names (ex. "user9" table, when in the database the table is called "user". Or field name "year9", when in the database its "year".)
>
> Any ideas what I could be doing wrong? Is this a bug? Please help.
>
> Thanks
> Mark
> [Message sent by forum member 'markag' (markag)]
>
> http://forums.java.net/jive/thread.jspa?messageID=354561
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>