This project is read only now.

2 Replies Latest reply on Apr 27, 2010 2:42 AM by afibarra.armando.flores.biovetsa.com.mx

Composite Key + Mysql + EntityQuery broken in Seam 2.1.2

mrlueck Jun 15, 2009 7:36 PM

getCountEjbql() appears to have changed from 2.1.1.GA to 2.1.2. Hibernate is generating invalid SQL when asking for a count on an object with a composite key:

2009-06-15 12:21:50,250 INFO  [STDOUT] Hibernate: 
    select
        count((externalag0_.cd_ExtRef,
        externalag0_.cd_External_Office,
        externalag0_.cd_Source)) as col_0_0_ 
    from
        uhp.external_agent externalag0_ limit ?
2009-06-15 12:21:50,251 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1241, SQLState: 21000
2009-06-15 12:21:50,251 ERROR [org.hibernate.util.JDBCExceptionReporter] Operand should contain 1 column(s)
2009-06-15 12:21:50,253 ERROR [STDERR] Jun 15, 2009 12:21:50 PM com.sun.facelets.FaceletViewHandler handleRenderException

This was not the behavoir in 2.1.1.GA. 2.1.2 breaks backward compatibility.

1. Re: Composite Key + Mysql + EntityQuery broken in Seam 2.1.2

mrlueck Jun 15, 2009 9:15 PM (in response to mrlueck)

Resolved my problem by overriding getCountEjbql in my EntityQuery object:

     @Override
     protected String getCountEjbql(){
          String before = super.getCountEjbql();
          String after = before.replace("select count(externalAgent) ", "select count(*) ");
          //log.info("Before: \n\t" + before);
          //log.info("After: \n\t" + after);
          return(after);
     }

2. Re: Composite Key + Mysql + EntityQuery broken in Seam 2.1.2

afibarra.armando.flores.biovetsa.com.mx Apr 27, 2010 2:42 AM (in response to mrlueck)

Thank you very much for the answer !!!
Actions

Go to original post