How to set a mysql decimal value in java prepared statement?

Question

How to set decimal value in java prepared statement. I was tried as follows

My table query

create table A (x decimal(22,0))

In java I tried to set it as

preperedStatmentObj.setLong(1,aLongValue);

But i am getting the following error

java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer

Thank you

Solution

Try using setBigDecimal

BigDecimal d = new BigDecimal(aLongValue);
preperedStatmentObj.setBigDecimal(1, d);

Comments

[Java_Dinesh]

Thanks for your nagative points. Atleast give me a releated Stack overflow link. Thank you