Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

parameterized LIKE with EJB QL

 
Atay Akyuz
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
posted November 17, 2003 05:06 AM
--------------------------------------------------------------------------------
Hi!
I want to use "parameterized LIKE" in EJB QL. I use WSAD 5.0 with EJB 2.0. I have tried with theese following two solutions without success:
SELECT OBJECT(o) FROM Uppgift o WHERE o.objectId LIKE ?1
SELECT OBJECT(0) FROM Uppgift o WHERE LOCATE( ?1, o.description ) > 0
The error message I get is: "qeury cannot be pushed down"
--------------------------
Thanks in advance
Atte from Sweden
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Atte, as "atay" does not comply with our naming policy, I'll have to ask you to change it.
Thanks.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 35762
412
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The EJB spec says you can't use a parameter in a like clause. Interesting workaround on JavaRanch thread.
 
Atay Akyuz
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It seems like a very good alternative, but I tried and it doesn't work with WSAD with EJB 2.0. I get the message:
"query cannot be pushed down".
Do anyone know how I get get round this?
Thank in advance
-----------
Atay from Sweden
 
Everybody's invited. Except this tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!