Excellent catch, jaikiran! I had several "version" fields in various tables, one of which (and only one) was defined as a varchar. Checking the generated hbm I found that this was being defined as a Hibernate version element, which it didn't need to be. Changing that one field to a name different than "version" cleared the problem. I've now changed all "version" fields to be prefixed with a table identifier to avoid this issue in the future.
Many thanks. It sure is nice to start the new year with a completely unclear problem clarified. :-) I have one more minor issue that cropped up on deployment after fixing this problem. I get a number of messages like this: 10:14:41,326 ERROR [SchemaExport] Unsuccessful: create table crunch.tool (guid varchar(50) not null, state integer, displayName text, Application varchar(50), lastUpdate datetime, wrapperGuid varchar(50), helpGuid varchar(50), toolVersion text, interpreter varchar(50), addDate datetime, lastUse datetime, toolOwner varchar(50), fileGuid varchar(50), toolTypeGuid varchar(50), toolValidator varchar(50), primary key (guid)) | 10:14:41,326 ERROR [SchemaExport] Table 'tool' already exists I believe this is because my persistence.xml includes this line: <property name="hibernate.hbm2ddl.auto" value="create-drop"/> And because I've already loaded the db prior to deployment (as part of the build process in order to do the Hibernate reverse engineering). Removing this line from persistence.xml causes other problems. These messages are only informative as far as I can tell, but it would be nice to eliminate them to make a clean deployment. Do you know how I might be able to do this? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4116462#4116462 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4116462 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
