Storing a secretkey in the database and retrieving it

Question

I am doing a project on password encryption and decryption using AES algorithm. I need to store the key of type SecretKeySpec in the database(ms-access) and have to retrieve it. How can i do this? I have created a column in the database of type oletype object. I am using a query:

String query="insert into encrypt values(?)";

how to set the parameter in the query?

Answer 1

As far as I know, Access supports the type OLE Object to store MS-documents and binary data like pictures, sounds, or other binary data. With the constraint that "they've to be created in other programs using the OLE protocol, that can be linked to or embedded in a Microsoft Access table. You must use a bound object frame in a form or report to display the OLE object."

I like to suggest to use MS SQL Server or MySQL (engines) so that you can impose many integrity and consistency checks more efficiently and effectively. MySQL provides a way to store binary values with BLOB type. SQL Server provides binary and varbinary for the same purpose...