OK.  I saw a message in log file that my bean was not bound because it did not have 
local interfaces, even though it
was being bound with its remote interfaces.  So I added some local interfaces, and 
voila, it worked, but with a very
strange twist.

This is all running in same JVM, JBoss 3.0.0

I discovered that for the method that is implemented with DynamicQL, not only does the 
local home interface return a
Collection of local interfaces to the bean, but that the remote home interface returns 
a Collection of local
interfaces to the bean, as well !!

So it appears that DynamicQL is only suppose to work with local interfaces and my 
question is this.  Is this a feature
or a bug of DynamicQL?

Thanks



Greg Turner wrote:

> This is JBoss 3.0
>
> 2002-07-29 20:15:46,184 DEBUG
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.CustomerEJB.ejbSelectGeneric]
> DYNAMIC-QL: SELECT OBJECT (a) FROM Customer a WHERE a.state IN (?1,?2)
> 2002-07-29 20:15:46,184 DEBUG
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.CustomerEJB.ejbSelectGeneric]
> SQL: SELECT DISTINCT t0_a.ID, t0_a.fname, t0_a.lname, t0_a.addr,
> t0_a.city, t0_a.state, t0_a.zip FROM CUSTOMER t0_a WHERE t0_a.state
> IN(?, ?)
> 2002-07-29 20:15:46,184 DEBUG
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.CustomerEJB.ejbSelectGeneric]
> Executing SQL: SELECT DISTINCT t0_a.ID, t0_a.fname, t0_a.lname,
> t0_a.addr, t0_a.city, t0_a.state, t0_a.zip FROM CUSTOMER t0_a WHERE
> t0_a.state IN(?, ?)
> 2002-07-29 20:15:46,304 ERROR [org.jboss.ejb.plugins.LogInterceptor]
> TransactionRolledbackException, causedBy:
> java.lang.NullPointerException
>  at
> 
>org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.getEntityEJBLocalObject(BaseLocalContainerInvoker.java:199)
>
>  at
> 
>org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.getEntityLocalCollection(BaseLocalContainerInvoker.java:210)
>
>  at
> 
>org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:169)
>
>  at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.execute(JDBCDynamicQLQuery.java:90)
>
> The SQL that is being generated looks to be well formed, so I am not
> sure what is problem.  The comments for BaseLocalContainerInvoker says
> its for handling local interface ejb proxies, but my code is using all
> remote interfaces.  Everything in same JVM.  Servlet gets remote
> interface to session bean, getting remote interface to entity bean which
> is doing the dynamic query.
>
> Any ideas?
>
> Greg
>
> -------------------------------------------------------
> This sf.net email is sponsored by: Dice - The leading online job board
> for high-tech professionals. Search and apply for tech jobs today!
> http://seeker.dice.com/seeker.epl?rel_code=31
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user

--
Greg Turner, JBoss Authorized Consultant

Tiburon Enterprise Systems
http://www.tiburon-e-systems.com
Box 1171
Tiburon, CA 94920
415-332-3363




-------------------------------------------------------
This sf.net email is sponsored by: Dice - The leading online job board
for high-tech professionals. Search and apply for tech jobs today!
http://seeker.dice.com/seeker.epl?rel_code=31
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to