Without setting a parameter of named query?

Question

For example I have a named query:

@NamedQuery(name = "Students", query = "SELECT s FROM Student WHERE s.active = 'Y' OR s.name= :name)

Sometimes I wanna set the 'name' parameter with a value and sometimes not. Does it cause an error when I don't set it?

related: stackoverflow.com/questions/2444603/…

Bozho
– Bozho

2010-12-22 12:33:43 +00:00
Commented Dec 22, 2010 at 12:33 — Bozho
– Bozho, Commented Dec 22, 2010 at 12:33

Bozho · Accepted Answer · 2010-12-22 12:18:41Z

You have to set it always. Otherwise - create two queries - one with param, and one without. You can place the common part in a constant (static final)

kamaci · Accepted Answer · 2010-12-22 12:58:46Z

I found a solution like this:

if (my test criteria){ query.setParameter("name", "name of a student"); } else { query.setParameter("name", " "); }

I am setting the name parameter with whitespace character so it works.

Collectives™ on Stack Overflow

Without setting a parameter of named query?

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related