No I haven't seen it before. I assume you have a bad ejb-jar.xml file, or you are trying to do something unsupported by JBossCMP (like unknown primary keys). I just won't know until I see the ejb-jar.xml file.
-dain Emerson Cargnin - MSA wrote: > ok, but have you seen some kind of wrong sql generation bug appeareing > in 3.0.0?? > > Dain Sundstrom wrote: > >> File a bug report a sourceforge. Make sure to include the ejb-jar.xml >> file, or the revelent sections if it is huge. >> >> -dain >> >> Emerson Cargnin - MSA wrote: >> >>> I have an CMP application that used to work until rc2, after trying >>> to use with rc3 or 3.0.0 it start to give me jdbc error. >>> Here is the ejb-ql and sql generated for it: >>> >>> ejb-ql : select object (o) from Praca where p.municipio.uf.oid= ?1 >>> >>> sql : >>> SELECT t0_p.oid FROM PRACA t0_p, MUNICIPIO t2_p_municipio, UF >>> t1_p_municipio_uf WHERE (t1_p_municipio_uf.oid = ?) AND >>> (t0_p.=t2_p_municipio.oid AND t2_p_municipio.=t1_p_municipio_uf.oid) >>> >>> obs: take a look on the "t0_p.=", it looks really strange... >>> >>> i'm gonna test against the cvs HEAD version ... >>> >>> there's a n:1 relation from PRACA to MUNICIPIO (locale - > city ) and >>> a n:1 from MUNICIPIO to UF (city -> state) >>> >>> >>> the jboss.log >>> >>> 2002-06-20 16:31:28,143 DEBUG [RMI TCP Connection(2)-127.0.0.2]: >>> javax.ejb.FinderException: Find failed: java.sql.SQLException: >>> ORA-01747: invalid user.table.column, table.column, or column >>> specification >>> at >>> >org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:143) > >>> >>> at >>> >org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:40) > >>> >>> at >>> >org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:472) > >>> >>> at >>> >org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:348) > >>> >>> at >>> >org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:323) > >>> >>> at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:610) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>> >>> at >>> >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>> >>> at java.lang.reflect.Method.invoke(Method.java:324) >>> at >>> >org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1116) > >>> >>> at >>> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73) >>> >>> at >>> >org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:257) > >>> >>> at >>> >org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215) > >>> >>> at >>> >org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:134) > >>> >>> at >>> >org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79) >>> >>> at >>> >org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44) > >>> >>> at >>> >org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:98) >>> >>> at >>> >org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:167) >>> >>> at >>> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52) >>> >>> at >>> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:104) >>> >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:109) >>> at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487) >>> at >>> >org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invokeHome(BaseLocalContainerInvoker.java:227) > >>> >>> at >>> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) >>> >>> at $Proxy49.findByFilter(Unknown Source) >>> >>> >>> >>> >>> ------------------------------------------------------- >>> Sponsored by: >>> ThinkGeek at http://www.ThinkGeek.com/ >>> _______________________________________________ >>> Jboss-development mailing list >>> [EMAIL PROTECTED] >>> https://lists.sourceforge.net/lists/listinfo/jboss-development >> >> >> >> > > > > > ------------------------------------------------------- > Sponsored by: > ThinkGeek at http://www.ThinkGeek.com/ > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development -- xxxxxxxxxxxxxxxxxxxxxxxx Dain Sundstrom Chief Architect JBossCMP JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ------------------------------------------------------- Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
