aspose file tools*
The moose likes JDBC and the fly likes how to insert a byte array into an MS Access database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to insert a byte array into an MS Access database" Watch "how to insert a byte array into an MS Access database" New topic
Author

how to insert a byte array into an MS Access database

Moiez Gohar
Greenhorn

Joined: Mar 26, 2009
Posts: 8
i am having problems inserting a byte array into an ms access database table. The first column of my table must accept a byte array, and the next column accepts a BigDecimal. I have successfully created the table "Encrypted_AES_Bytes" with the abovenamed columns. But i m unable to insert any rows. here's my code:





i get the following error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
please HELP.

while creating the table, i had made this query: "create table Encrypted_AES_Bytes (encaes byte[], rsaenc NUMERIC)"
is the query correct??

my objective is to store byte arrays in the first column of this table and BigInteger value int the next field/column
please help and guide me:
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to insert a byte array into an MS Access database