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