• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

convert Double to BigInteger and retrieving byte array

 
Moiez Gohar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
my application requires BigInteger values to be used as prime numbers used to generate RSA encryption and decryption keys.
I am using Microsoft Jet Driver with MS Access 2000, and so had to go for BigDecimal instead of BigInteger (as BigInteger is not a supported type, neither by JDBC nor by Access 2000).



now, for retrieving the byte[] from the first column, and the BigDecimal from the next, following is the code:


when i insert any row into my table, the insertion is executed successfully.
but when i issue the selection query, i get the result in which the byte arrays are succeeded by a number of 0-valued bytes like: for the byte array: {1,3} i get the result as: 2 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ..... (totally 508 zeroes)

what is wrong with my code?? why am i not getting back the exact byte array as 2 3 ?? please HELP.
 
Moiez Gohar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am sorry for wrongly phrasing the topic...

my objective is to store byte[] in the first column of the table, and a BigInteger in the next column. I am using MS Access 2000. I am using JDBC:ODBC bridge with Microsoft Jet Driver.

what should i do to attain my aforementioned objective??
should i use a different driver, or a different DBMS??
please guide me!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic