CODEWITHSUNDEEP
hibernatenamed-queryhibernate-native-query
fatherazrael
fatherazrael

Reputation: 5987

Hibernate: how to set parameters to createNativeQuery?

I am using following query:

public String getAmount(String userId, String companyId) {
    Integer amountList = entityManager.createNativeQuery("SELECT scan.attorney.Get_Amount(?, ?) AS amount FROM DUAL")
                    .setParameter(1, companyId).setParameter(2, userId).getFirstResult();
    return amountList.toString();
}

when getAmount is passed, we also pass userID and company ID but it is not fetching correct value where we run query in database with same values, it is fetching correctly.

Can anyone suggest what is wrong in above native query?

Upvotes: 1

Views: 2324

Answers (2)

shubhendra sen
shubhendra sen

Reputation: 206

Another way

String sql = "select * from table where id = ?1;"
Em.createNativeQuery(sql);

Sql.setParameter(1,id);

Upvotes: 1

shubhendra sen
shubhendra sen

Reputation: 206

String sql = "select * from table where id = :id;"
Em.createNativeQuery(sql);

Sql.setParameter("id",id);

Upvotes: 2

Related Questions