@raffaelecorvino Your SQL statement is incorrect, it seems. You need to change it: You have: select userid from storeaccess where username='ANDY' and password'PASSWD'
And it should be: select userid from storeaccess where username='ANDY' and password='PASSWD' So there is a = missing. Regarding my previous problem, I was able to solve it: I changed the EJB QL sentences to include Schema. Here is the part of ItemBean.java with the XDoclet tags: | * @ejb.finder | * query="SELECT OBJECT(a) FROM mySchema as a" | * signature="java.util.Collection findAll()" | * | * @ejb.finder | * query="SELECT OBJECT(b) FROM mySchema as b where b.supplierID = ?1" | * signature="java.util.Collection findBySupplierID(java.lang.String supplierID)" | * | * @ejb.finder | * query="SELECT OBJECT(c) FROM mySchema as c where c.quantity = 0" | * signature="java.util.Collection findByOutOfStock()" | | <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3827012#3827012";>View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3827012>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
