"2147483647" is excel default value?

Question

I'm uploading one .xlsx file with some values. In my .xlsx file entered 2345678910 in cell.Next i'm uploaded but it is saved in database 2147483647 value. Next time i'm uploaded with 8345678910 value but shows error.

ERROR: Already 2147483647 value saved.

My Reg Exp:"^[a-zA-Z0-9]*$"

How to resolve it?

" saved in database"!! what type of database?do you mean XLS file itself? — houssam, May 15 '15 at 05:47
I'm using Oracle 10g. It is Excel problem or My java code problem? — Naresh, May 15 '15 at 05:50
what is the datatype of the field which you store this value in Oracle database? also remember that 2147483647 is the maximum value of int in java: see: https://community.oracle.com/thread/2124366 — houssam, May 15 '15 at 05:56
It is problem in my java code?. So how to retrive int to varchar in java. — Naresh, May 15 '15 at 06:07
to get better help, post the source code of java; post the structure of the table; explain your problem in details. — houssam, May 15 '15 at 06:10
And 2^31-1 = 2147483647, surprise surprise ;) Use a long instead. — ktorn, May 15 '15 at 06:39
In database column datatype is varchar and in my code i'm using string. — Naresh, May 15 '15 at 07:55

leekaiinthesky · Accepted Answer · 2015-05-15T08:30:02.880

4

@ktorn and many other commenters already commented with the answer. Use a long instead of an int in your Java code. int cannot store values larger than 2^31 - 1 = 2147483647.

edited May 15 '15 at 08:30

answered May 15 '15 at 08:22

leekaiinthesky

5,413
4
28
39

Hi i've small doubt.In my database i assigned **datatype** is varchar(255) for one field. In java i'm using **long** for getting value. Which one is best **long** or **double**. I want allow numeric values,special charecters and all... – Naresh May 18 '15 at 04:44
Use `long` if you want only integers, `double` if you want to include decimals. See http://stackoverflow.com/questions/415924/what-is-the-purpose-of-long-double-byte-char-in-java. – leekaiinthesky May 18 '15 at 05:42

"2147483647" is excel default value?

1 Answers1