how to insert BigInteger value in the oracle database.

Question

i m trying to insert a BigInteger value in the oracle database.i m trying like this:

BigInteger a=new BigInteger("4280972057205720579205792572075927209857");
String str=new String(a.toByteArray());

now in the database :

 PerparedStatement pstmt=con.prepareStatement("insert into database values(?)");
 pstmt.setString(1,str);
pstmt.executeUpdate();

if i m using str="hello" then it is working fine.but if i m using str=new String(a.toByteArray()) then nothing(null) is inserted in the database.why it is so.please explain and also suggest some method to do so.

Answer 1

Documentation for BigInteger.toByteArray():

Returns a byte array containing the two's-complement representation of this BigInteger. The byte array will be in big-endian byte-order: the most significant byte is in the zeroth element.

This has nothing to do with representing it in Decimal! You want to use BigInteger.toString() to get the string.

Answer 2

why not use a.toString(); ?

Answer 3

What is the difference with your previous post?

http://stackoverflow.com/questions/3052772/how-to-store-biginteger-values-in-oracle-database