>Column 'date' in field list is ambiguous
This results from a join query when a column referenced is ambiguous.
Try getting to trace the generated SQL and you will know what is going on
On 1/26/2010 7:33 AM, glassfish_at_javadesktop.org wrote:
> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>