Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Finders still do not work

 
Jenny Kalinina
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jenny are you working in WSAD 4.0 or 5.0?
Kyle
 
Jenny Kalinina
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am working i WSAD 4.0
 
Kyle Brown
author
Ranch Hand
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic