title: Inserting to Numeric field using prepared statement
body: <p>I try to insert a value to an SQL server Numeric field using a prepared statment:</p>
  
  <pre><code>int temp = 5;
  type = java.sql.Types.NUMERIC;                      
  System.out.println(temp);
  prd.setObject(i+1, temp,type);
  </code></pre>
  
  <p>But this gives me a <code>"Arithmetic overflow error converting numeric to data type numeric"</code>.</p>
  
  <p>I also tried to convert the int to a Number Or inserting it using <code>prd.setInt</code>, but this also doesn't work.</p>
  
  <p>What is the right way to set a value in a prepared statement, which will be inserted successfuly in an SQL server Numeric field?</p>