-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Hello, Gianny
glad to tell you that now the second ejbQL select distinct r.user from ForumRolle r where r.userRolle.id=?1 order by r.user.username asc is working :) Well, at least, again no sudden death on deploy time :P I'll now implement a home method that uses the ejbSelect. I don't expect any problems from now on. Don't mind about the problems :P We're here to report you any problems and discuss them. And I'm glad that you fixed it in such a short time :) Best regards Dirk Gianny Damour schrieb: > Hello Dirk, > > Thanks for trying this out. > > I looked at your new problem and applied another TranQL fix to resolve > it. Basically, the prefetch group selection for ejbSelect was wrong as I > naively applied the same prefetch group selection mechanism than for > finders... Could you please do me another favor and download the latest > TranQL-1.4-SNAPSHOT artifact and tried it out? > > BTW, if your "Default" prefetch group selects all the CMP Fields of the > selected EJB, then you do not need it: by default, all CMP Fields, which > are not mapped to LOB types are prefetched by default. > > Sorry for these problems, > Gianny > > > On 24/10/2006, at 8:37 PM, Kaeto23 wrote: > >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: RIPEMD160 >> >> Hello, Gianny >> >> glad to tell you that this ejbQL >> >> select distinct count(p.id) from Post as p where p.thread.forum.id=?1 >> >> now works. At least I can deploy the ear without any sudden death :P >> I'll implement the ejbHome method in some minutes to test if the >> counting is correct ;) >> >> Anyway, this ejbQL >> >> select distinct r.user from ForumRolle r where r.userRolle.id=?1 order >> by r.user.username asc >> >> from the bean ForumRolle (see the other posts where I included the >> source file) ends in an exception like this: >> >> Caused by: java.lang.IllegalArgumentException: QuerySource >> [EMAIL PROTECTED] and PrefetchGroup >> [EMAIL PROTECTED] >> >> do not match. >> at >> org.tranql.sql.prefetch.PrefetchGroupTransform.<init>(PrefetchGroupTransform.java:65) >> >> at >> org.tranql.builder.SQLQueryBuilder.buildSelects(SQLQueryBuilder.java:219) >> at >> org.openejb.deployment.CMPContainerBuilder.buildIt(CMPContainerBuilder.java:311) >> >> at >> org.openejb.deployment.AbstractContainerBuilder.createConfiguration(AbstractContainerBuilder.java:354) >> >> at >> org.openejb.deployment.CMPEntityBuilder.createBean(CMPEntityBuilder.java:213) >> >> ... 32 more >> >> I'll recompile the forum project again with another prefetch for the >> ejbSelect. Maybe that works :/ >> >> Best regards >> >> Dirk > > - -- Kaeto23 HTTP: http://kaeto23.dnsalias.com (german!) Jabber: jabber://[EMAIL PROTECTED]/DS2 Reclaim Your Inbox! http://www.mozilla.org/products/thunderbird/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFPg88biSTaBU+G6oRA3V2AJ48j6YSQljWK51+HAt9sHHig0+c1gCeOFB3 brIa25Hnt5ya79Oqp2iZkGs= =QOZ0 -----END PGP SIGNATURE----- ___________________________________________________________ Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de
