Java SQL prepared statement for unsigned int

Question

I would like to insert some unsigned int value using a prepared statement.

setInt() slaps me with a DataTruncation if the second parameter is above 2,147,483,647 (Max Signed Int) although my underlying table can chew up to 4,294,967,295 (Max Unsigned Int)

Is there such a thing as setUnsignedInt()? Should I use setLong() although the table is setup as (INT(10) UNSIGNED)?
Thanks

score 4 · Answer 1 · answered Feb 28 '12 at 21:49

Yes, you should use setLong(). You'll note that the javadocs tell you:

Sets the designated parameter to the given Java long value. The driver converts this to an SQL BIGINT value when it sends it to the database.

So be aware that it would allow you to set a value larger than 2^32-1 which would then be rejected by the DB (hopefully; I suppose it could wrap).

score 3 · Answer 2 · edited May 23 '17 at 10:29

3

To do this you use the next smallest data type that will hold the current max (unsigned) value. For Integer that would be Long. You can then discard anything above the max (unsigned) value for Integer.

This post will shed some light

edited May 23 '17 at 10:29

Community

1
1

answered Feb 28 '12 at 21:47

Woot4Moo

23,987
16
94
151

score 2 · Accepted Answer · answered Feb 28 '12 at 21:46

2

Typically when you need an unsigned primitive's headroom in Java you just go to the next tier up in size. In your case, that's a long.

answered Feb 28 '12 at 21:46

Raevik

1,945
9
32
53

Java SQL prepared statement for unsigned int

3 Answers3