Hello everyone,
I am using oracle and ejb components.
I have two records in a table with name like 'abc xyz' and 'abc'.
i have written a finder method 'findByName(String name)'.
What i want is that, this method should return all those records in which the argument is found.
eg if i pass execute findByName("ab") method, i want both the records to be returned.
the sql query for it works absolutely fine.
select * from tablexyz where name like '%ab%'
i want a similar ejb-ql.
thanking in advance for the help.