Numeric overflow Exception in java JDBC

Question

This query returns a numeric overflow exception. Values from 1 to 14 are retrieved easily but bigger values (from 15 on) cannot be.

I am using ORACLE XE. How do I fix this?

Here's my 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));
}

Student's table:

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) )

what is the meta-data for the student table.

Scary Wombat
– Scary Wombat

2014-05-01 08:23:07 +00:00
Commented May 1, 2014 at 8:23 — Scary Wombat
– Scary Wombat, Commented May 1, 2014 at 8:23

Scary Wombat · Accepted Answer · 2014-05-01 08:31:28Z

21

As the data in your DB is Number(11), this will not fit into an Integer.

Try a Long and rs.getLong(15);

answered May 1, 2014 at 8:31

Scary Wombat

44.9k6 gold badges38 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ibre5041 · Accepted Answer · 2020-12-10 12:51:00Z

1

Most likely you do not perform any mathematical operations with that "numbers". Since you do not treat them as numbers, but as identifiers. You should use Java type BigDecimal. This is a type which is most similar to Oracle datatype NUMBER. Or you can also use datatype provided by jdbc drivers oracle.sql.NUMBER.

edited Dec 10, 2020 at 12:51

answered May 1, 2014 at 10:58

ibre5041

5,3261 gold badge24 silver badges40 bronze badges

Collectives™ on Stack Overflow

Numeric overflow Exception in java JDBC

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related