Title: Message
First, are you sure that wrapping the query across lines works correctly? Second, are you remembering to add the pattern-matching character to your string before passing it to ejbSelectClientOfRepresentativeByFullName (phew!)? As in,
 
    String id = "8247823874";
    String name = "Bob L";
    ejbSelectClientOfRepresentativeByFullName(id, name + "%");  // Oracle
 
That's all I can suggest at this time. I haven't implemented any ejbSelect methods yet ... just finders.
 
Dave
 
David Harkness
Sony Pictures Digital Networks
-----Original Message-----
From: Fabio Braga de Oliveira [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 7:05 AM
To: [EMAIL PROTECTED]
Subject: [Xdoclet-user] Re: EJB-QL-Compiler-Error

Hello, list!
 
I see the messages from Mathias Wessendorf and David Harkness, and try the solution give for this problem, but don't work yet for me!
I have the method:
 

/**

* @ejb.select query="SELECT OBJECT(c)

* FROM Representative r, IN(r.clients) c

* WHERE r.id = ?1 AND

* c.corporate.party.fullName LIKE '?2'"

* result-type-mapping="Remote"

*/

public abstract Collection ejbSelectClientOfRepresentativeByFullName(

String id,

String pattern);

 

I need to find a Client by a pattern, but this doesn't work for me, the JBoss accept the ejbql but doesn't find the Client...

Maybe he is searching the string '?2' ????

Somebody can help?

Sorry the bad english..

Thanks!!!! 

Reply via email to