store and retrieve binary data from database

[Former Member]

i am struggling to store binary[] into database

webdynpro data dictionary having the following fields

Message - binary

how am i going to store into database and retrieve from database and bind to a textbox....

pls advice

[former_member182372 · Accepted solution]

Hi,

Check this

Best regards, Maksim Rashchynski.

[Former Member]

Purely based on jdbc, you can do the following:

For storing in:

PreparedStatement ps = ...

ps.setBinaryStream(i, new ByteArrayInputStream(byteArray),

byteArray.length);

For retrieving from:

ps.getBinaryStream(i);

Dennis