Storing a byte array in MS-SQL

[mswombat]

Hi,
I'm new to the forums and new to Java. I have a byte[] field which contains encrypted data that I need to store in a SQL database. I'm trying to store this data in a varbinary field in SQL but don't know how to do this. I keep getting SQL exception errors.

Do I need to do any conversions to store the byte[] into a varbinary, and then retrieve the varbinary from sql and then convert back to a byte array.


Thanks,
Cassandra.

[sicarie]

mswombat-

Could you post your error messages and code?

Just a guess, but if your'e getting class not found errors, you probably need to declare/register/attach the driver, but we could help more if the code and errors were available.

sicarie