Problem in sending long value to bigint parameter of stored procedure from java

[Zainab Haf]

I am sending long datatype value from java to bigint parameter of stored procedure of sqlserver. I am using spring for datasource/jdbctemplate.

 public ArrayList<SearchResult> getSearchResults(Input in) throws SQLException 
     {

       ArrayList<SearchResult> output=new ArrayList<SearchResult>();
       System.out.println("checking value of long: "+in.getServiceNo());
   	   String sql="{CALL mo_AdvanceSearch(?, ?)}";
	   output=(ArrayList<SearchResult>)jdbcTemplate.query(sql, new MasterResultSearchMapper(),in.getServiceNo(), in.getFullname());
       return output;
     } 

In Console:

INFO: checking value of long: 1231231234560

Here is the error i get after printing serviceNo:

     
    org.springframework.dao.DataIntegrityViolationException:PreparedStatementCallback; SQL [{CALL mo_AdvanceSearch(?, ?)}]; Error converting data type varchar to numeric.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to numeric.

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

[Tim Holloway]

But how does this relate to JavaServer Faces? If you need Sping JDBC help, the experts on that topic hang out in the Spring forum, not here.

[Zainab Haf]

Ok.
Solved the problem.