java.lang.NumberFormatException: For input string: "12122009100"

[Nagaraju Pee]

Hi,
I want ti insert a number 12122009100 into a table called EMPDATA which has a column emp_val number(16,0) with preparedstatement.

Here i'm using getters and setters.

public class ZoneOffset {
private String DST_OFS_TM;
public String getDST_OFS_TM() {
		return DST_OFS_TM;
	}
	public void setDST_OFS_TM(String dst_ofs_tm) {
		DST_OFS_TM = dst_ofs_tm;
	}

}

The main class code snippet is as follows....

ZoneOffset offset = new ZoneOffset ();
offset.setDST_OFS_TM("12122009100");

PreparedStatement pst = con.prepareStatement(Insert into EMPDATA(emp_val ) values (?));
pst.setInt(1,Integer.parseInt(item.getDST_OFS_TM()));
pst.executeUpdate();

while executing the above class i'm getting NumberFormatException.
could anybody please assist me why i'm getting this exception

thanks

[Christophe Verré]

Use a long instead of an int.

[Nagaraju Pee]

Still i'm getting the same exception even though i changed it to long

[Christophe Verré]

Please show me your code.

[Nagaraju Pee]

The exception got resolved by replacing Integer.parseInt() with Double.parseDouble()

[Ulf Dittmer]

The exception may be resolved, but are you certain it's doing the right thing? If it's not possible to pass a parameter to a "setInt" method using the result of parsing in integer, then maybe it actually isn't an integer? In which case passing a Double would just mask the problem. Make sure the DB data type can handle all values that Double.parseDouble returns for all input values that may get passed into it.

[Christophe Verré]

Why doesn't it work with long ? Please show me your code.