Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

inserting byte[] into MS Access Database...

 
Moiez Gohar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What data types have those two attributes in the DB?
 
Moiez Gohar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks Ulf for your attention...
The data type of the first column is byte[], and the second column's data type is NUMERIC. (as NUMERIC is the corresponding data type name for the JDBC data type BigDecimal.) or am i wrong in mapping JDBC data types to corresponding data type name in MS Access Database?? please guide me... my objective is to store byte array in the first column and BigInteger or BigDecimal (any one will do) in the next. please guide me.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic