users@glassfish.java.net

ambiguous field error on Glassfish Hibernate Plugin

From: <glassfish_at_javadesktop.org>
Date: Tue, 26 Jan 2010 07:33:08 PST

Hello,
I am trying to deploy a JEE application working OK on JBoss 5 to Glassfish v3, which uses Hibernate 3.5ß2.
In my app I have a Form EJB with a relation to FormField EJBs. Both EJBs have a field named "date". I get:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'date' in field list is ambiguous

(as I said, I have no problem with JBoss 5 built in Hibernate).

This is generated SQL so I cannot easily modify it. Any ideas/help on how to solve this generated SQL problem?

(Sorry i cannot post generated SQL as I haven't been able to start SQl tracing on Hibernate. Sorry also if this is a Hibernate problem and not related to Glassfish. Any help is anyway appreciated)

Thanks,
Ignacio
[Message sent by forum member 'icordoba' (icordoba_at_skios.es)]

http://forums.java.net/jive/thread.jspa?messageID=383036