title: Numeric overflow Exception in java JDBC
body: <p>This query returns a numeric overflow exception. Values from 1 to 14 are retrieved easily but bigger values (from 15 on) cannot be.</p>
  
  <p>I am using ORACLE XE. How do I fix this?</p>
  
  <p>Here's my code:</p>
  
  <pre><code>pst=con.prepareStatement("Select * from student where sut_id like 'Kul7Dub514'");
  rs=pst.executeQuery();
  while(rs.next)
  {
      smob.setText(Integer.toString(rs.getInt(15)));
      fmob.setText(Integer.toString(rs.getInt(16)));
      mmob.setText(Integer.toString(rs.getInt(17)));
      col.setText(rs.getString(18));
      address.setText(rs.getString(19));
  }
  </code></pre>
  
  <p>Student's table:</p>
  
  <pre><code>create table student ( stu_id varchar(10) primary key, stu_image Blob,
   stu_first_name varchar(20) not null,
   stu_middle_name varchar(20) not null,
   stu_last_name varchar(20) not null,
   fat_first_name varchar(20) not null,
   fat_middle_name varchar(20),
   fat_last_name varchar(20) not null,
   mot_first_name varchar(20),
   mot_middle_name varchar(20),
   mot_last_name varchar(20),
   dob Date,
   gender varchar(6),
   ac_yr varchar(10),
   mobno number(11),
   fatmob number(11),
   motmob number(11),
   edu_center varchar(50),
   address varchar(150) )
  </code></pre>