I am sending long datatype value from
java to bigint parameter of stored procedure of sqlserver. I am using spring for datasource/jdbctemplate.
In Console:
INFO: checking value of long: 1231231234560
Here is the error i get after printing serviceNo:
I do get fine results if i change datatype of serviceNo to integer but it will be restricting since i want search on basis on bigger values also which will exceed the integer limit.
Kindly hep me in here as i am unable to understand why am i getting this error of varchar