I am developing an DB application using JPA where i need to update table having primitive type fields (Ex: int).

Sample Code:
***********

int salary = 200;
sql1 = "update exployee where sal > ?1";
Query query1 = em.createNativeQuery(sql1);
query1.setParameter(1, salary);

The setParameter is not accepting int since there is not method in Query class.

Also if i try to convert as integer object and try to update

query1.setParameter(1 , new Integer(salary));

I am getting run time error like follows..

[IntegerType] could not bind value '200' to parameter: 2; [BEA][SQLServer JDBC Driver]Invalid parameter binding(s).


Please help me to fix this.

Thanks,
Lakshmi

Seems you are using Java 1.4 then which doesn't support autoboxing of primitive types. Your alternative solution looks ok though. What is the type of the sal column in the database?

Oh, and your update statement is missing the set clause. The statement as given is not valid SQL. May be that is the problem and the error message is misleading?

Hi,

Thanks for the reply.
1. The actual Update Statment does have "set".

2. Table is in SQL Server and the salary column is 'int' type.
I cannot change the column type to String since it is replica of Production.

So creating Integer object and saving is also is not working with int.

I am using JDk1.6 and source version 1.6.


Thanks,

Lakshmi

Thanks,

Finally i got it worked.


Lakshmi

The position number should be 0. setParameter(position, value) starts numbering from 0. It's better to use named parameters, so this kind of confusion doesn't happen. See for ex. JPwH, pg. 684.