title: ResultSetMetaData returning BigDecimal insted of int
body: <p>Need some help regarding jdbc metadata.
  I am using ResultsetMetaData to get metadata of columns of a table on <strong>Oracle10g</strong>. I am using ojdbc14.jar. There is a field in table ID declared as Number . This field is being read with jdbc at runtime to get its metadata attributes. <strong>ResultSetMetaData.getColumnClassName()</strong> is returning <strong>java.math.BigDecimal</strong> while I am expecting it to be Integer or int or long or Long type.
  I even tried creating table with statement with explicitly defining <strong>int</strong> type for ID column as</p>
  
  <pre><code>CREATE TABLE COST_DETAILS ( ID **INT** Primary Key...
  </code></pre>
  
  <p>but still ResultSetMetaData is returning BigDecimal for ID column.</p>
  
  <p>Is there any way to create table with any particular column type so that it will retrun int/long type?</p>
  
  <p>or is ResultsetMetaData always returns BigDecimal for Oracle.</p>