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