GeeCON Prague 2014*
The moose likes Websphere and the fly likes Finders still do not work Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Websphere
Bookmark "Finders still do not work" Watch "Finders still do not work" New topic
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: 3892
    
    5
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: 3892
    
    5
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Finders still do not work