| Author |
Finders still do not work
|
Jenny Kalinina
Ranch Hand
Joined: Nov 07, 2002
Posts: 52
|
|
Hi everybody,
Thanks for the help. Now ejbCreate(...) is okay,
but when I add any Finder and try to generate deploy and RMIC code, I always have the same message:
�OO-SQL schema parser error: #75: {1}�
�BeanName1_Alias t1 does not have a column STAFF_USERID�
Does not matter which finder I am trying to add, the message text is exactly the same.
My descriptora are:
For public java.util.Enumeration findAll() throws javax.ejb.FinderException, java.rmi.RemoteException;
select e from Xi_userfileBean e where 1=1
For public java.util.Collection findByUserName(java.lang.String username) throws javax.ejb.FinderException, java.rmi.RemoteException;
select e from Xi_userfileBean e where e.staff_userid = ?1
Thanks in advance
|
 |
Kyle Brown
author
Ranch Hand
Joined: Aug 10, 2001
Posts: 3879
|
|
Jenny are you working in WSAD 4.0 or 5.0?
Kyle
|
Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
|
|
Jenny Kalinina
Ranch Hand
Joined: Nov 07, 2002
Posts: 52
|
|
|
I am working i WSAD 4.0
|
|
Kyle Brown
author
Ranch Hand
Joined: Aug 10, 2001
Posts: 3879
|
|
OK, then my first recommendation is DO NOT use the EJB-QL finders. That was a "tech preview" in WAS 4.0 and is NOT either compatible with real EJB-QL as used in WAS 5.0, nor particulary reliable. Instead, I'd suggest you use where clause finders as explained in my WebSphere Workbook. Do a search for "finders" in this forum and you'll even find detailed instructions I gave quite recently on how to do this in WSAD.
Kyle
|
|
 |
|
|
subject: Finders still do not work
|
|
|
0
