please could someone take a look on this???? isn't it a kind of strange????? the strange thing is the "t0_p."
Emerson Cargnin - MSA wrote: > I have an 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) > > 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-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > ------------------------------------------------------- Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
