SetParametres in Query

Question

I'm trying to set a query with lot of parameters.

for a query with 1 param its working fine:

//**
    List<?> list = null;
    String query = String.format("from %s where %s = :%s ", a, uniqueField[0], uniqueField[0]);
    list = s.createQuery(query).setParameter(uniqueField[0], arg0.getSsn()).list();

how can i do the same with this query :

List<?> list = null;
String query = String.format("from %s where %s = :%s and %s = :%s ", a, uniqueField[0], uniqueField[0], uniqueField[1], uniqueField[1]);
// list = s.createQuery(query)... ?

Thanks for any advices..

Just name the parameters then: ":param1", ":param2". Then q.setParameter(":param1", value1).setParam(":param2", value2) ... — K.Nicholas, May 11 '16 at 18:15

score 0 · Accepted Answer · edited May 23 '17 at 12:31

0

When using a query, you can either use named parameters or positional parameters. Named parameters are pretty easy, I'm not sure what the performance implications are:

So, just name the parameters then: ":param1", ":param2". Then q.setParameter(":param1", value1).setParam(":param2", value2).

Reference: In JPA which type of parameter is better to use “positional/named”?

edited May 23 '17 at 12:31

Community

1
1

answered May 11 '16 at 21:27

K.Nicholas

10,956
4
46
66

SetParametres in Query

1 Answers1