Bugs item #593236, was opened at 2002-08-09 16:57 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=593236&group_id=22866
Category: JBossServer Group: v3.1 Status: Open Resolution: None Priority: 5 Submitted By: Joe Simone (jsimone) Assigned to: Nobody/Anonymous (nobody) Summary: EJB query fails in 3.0.1RC1, ok in 3.0.0 Initial Comment: The follow EJB query works perfectly with 3.0.0 final but fails with 3.0.1RC1 ... <query> <query-method> <method-name>findBySession</method- name> <method-params> <method- param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> SELECT OBJECT(a) FROM Session AS s, IN (s.course.track.program.event.attendees) AS a, IN (a.attendeeSessions) AS attsess WHERE s.id= ?1 AND attsess.session.id = s.id </ejb-ql> </query> Here is the error that comes out of 3.0.1RC1 ... [java] getSessionEnrolledAttendees(-807297147- 1865639104)... [java] java.rmi.ServerException: RemoteException occurred in server thread; nested exception is: [java] java.rmi.ServerException: Find failed: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] [DB2/NT] SQL0206N "T6_S_COURSE_TRACK_PROGRAM_EVENT.ID" is not valid in the context where it is used. SQLSTATE=42703 [java] ; nested exception is: [java] javax.ejb.EJBException: Find failed: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] [DB2/NT] SQL0206N "T6_S_COURSE_TRACK_PROGRAM_EVENT.ID" is not valid in the context where it is used. SQLSTATE=42703 [java] java.rmi.ServerException: Find failed: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] [DB2/NT] SQL0206N "T 6_S_COURSE_TRACK_PROGRAM_EVENT.ID" is not valid in the context where it is used. SQLSTATE=42703 [java] ; nested exception is: [java] javax.ejb.EJBException: Find failed: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] [DB2/NT] SQL0206N "T6_S_COURSE_TRACK_PROGRAM_EVENT.ID" is not valid in the context where it is used. SQLSTATE=42703 [java] javax.ejb.EJBException: Find failed: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] [DB2/NT] SQL0206N "T6_ S_COURSE_TRACK_PROGRAM_EVENT.ID" is not valid in the context where it is used. SQLSTATE=42703 [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceived FromServer(StreamRemoteCall.java:240) [java] at sun.rmi.transport.StreamRemoteCall.executeCall (StreamRemoteCall.java:215) [java] at sun.rmi.server.UnicastRef.invoke (UnicastRef.java:117) [java] at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invok e(Unknown Source) [java] at org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.i nvoke(JRMPInvokerProxy.java:128) [java] at org.jboss.invocation.InvokerInterceptor.invoke (InvokerInterceptor.java:108) [java] at org.jboss.proxy.TransactionInterceptor.invoke (TransactionInterceptor.java:73) [java] at org.jboss.proxy.SecurityInterceptor.invoke (SecurityInterceptor.java:76) [java] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke (StatelessSessionInterceptor.java:111) [java] at org.jboss.proxy.ClientContainer.invoke (ClientContainer.java:76) [java] at $Proxy3.getSessionEnrolledAttendees (Unknown Source) [java] at com.highnotes.ebu.client.test.AttendeeTest.main (AttendeeTest.java:130) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=593236&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development