How to convert a String to blob in java?

Question

I have a String which contains a large mail body. I need to save it to the database in the form of blob. How to convert it to the blob in java? Sample String below:

<html><center> <body style='background-color: #e5e4e2;'> <table id='mainTable' style='background-color: #ffffff; width: 70%; height: auto;margin-left: auto; margin-right: auto;'><tr> <td> <table style='width: 100%;background-color: #2B547E; height: 50px; margin-top: 30px; margin-left: auto; margin-right: auto;'> <tr> <td width='50%'><img src="cid:image" height='50' width='150' style='padding-left: 10px;'></td> <td width='50%' style='text-align: right; color: white; font-family: verdana; font-size: 12px;'> </td></tr> </table> </td> </tr></table> <table id='mainTable1' style='background-color: #ffffff; width: 70%; height: auto;margin-left: auto; margin-right: auto;'> <tr> <td> <table style='width: 100%; height: 50px; margin-top: 30px; margin-left: auto; margin-right: auto;'><tr> <td width='50%' style='color:red;font-size:21px;'>Congratulations, Joselyn Valdes-Flores </td> <td width='50%' style='text-align: right; color: white; font-family: verdana; font-size: 12px;'> </td> </tr> <tr> <td style='font-size:18px;width:97%;font-style:italic'> This email confirms your Phone Interview  with Manager, Accounts Receivable  in   Burger King Corporation  You will be called at your mobile number </td> </tr> </table> </td> </tr> </table> <table  style='background-color: #ffffff; width: 70%; height: auto;margin-left: auto; margin-right: auto;'><tr style='color:green'> Interview LineUp <th style='color:gray;font-size:21px;text-align:left;font-style: italic'>Interviewe</th><th  style='color:gray;font-size:21px;text-align:left;font-style: italic'>Timing1</th><th  style='color:gray;font-size:21px;text-align:left;font-style: italic'>Timing2</th></tr><tr><td>Jeet Chatterjee</td><td>12:00am</td><td>2:00am</td></tr><tr><td>Ramu</td><td>2:00am</td><td>4:00am</td></tr></table><table id='mainTable2' style='background-color: #ffffff; width: 70%; height: auto;margin-left: auto; margin-right: auto; margin-top:12px;'><tr> <td style='font-size:18px; color:#2B547E;word-wrap: break-word;font-style: italic'> hii</td> </tr> </table> <table  style='background-color: #ffffff; width: 70%; height: auto;margin-left: auto; margin-right: auto;'> <tr> <td style='font-size:18px;color:#2B547E;word-wrap: break-word;font-style: italic'> Best Regards,</td><td style='font-size:24px;color:#2B547E;word-wrap: break-word;font-style: italic'> Jeet Chatterjee</td></tr> </table></body> </center> </html>

I want to save it in a database in the blob column. How to do this??

Most databases save arbitrary "bytes" as BLOBs, so you can just give bytes of the string to the database driver. — s.d
– s.d, Commented Sep 6, 2015 at 15:37
For non-binary text, a CLOB would be more appropriate for text operations on the database level. — Joop Eggen
– Joop Eggen, Commented Sep 6, 2015 at 15:39

Akash Thakare · Accepted Answer · 2015-09-06 15:38:59Z

3

You can do it by getting byte[] content from String

byte[] byteData = yourString.getBytes("UTF-8");//Better to specify encoding
Blob blobData = dbConnection.createBlob();
blobData.setBytes(1, byteData);

Moreover, you can directly store String to BLOB column.

edited Sep 6, 2015 at 15:38

answered Sep 6, 2015 at 15:22

Akash Thakare

23k11 gold badges64 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

lucifer Over a year ago

why i need a dbConnection?

Akash Thakare Over a year ago

@lucifer To create blob instance you can use database connection Object.

lucifer Over a year ago

without database connection i can not make blob object?

Akash Thakare Over a year ago

@lucifer No there is no use of Blob instance other than inserting blob data to blob column. Only way I know about is creating blob instance with db connection object.

Akash Thakare Over a year ago

@JoopEggen Thanks that would be more elegant though.

Petar · Accepted Answer · 2021-07-26 07:20:28Z

2

You can do it by first getting the byte[] from String using:

byte[] byteData = yourString.getBytes();

and after that doing the next line of code:

Blob docInBlob = new SerialBlob(byteData);

Blob is from java.sql package and SerialBlob is from javax.sql.rowset.serial package.

answered Jul 26, 2021 at 7:20

Petar

3511 gold badge4 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to convert a String to blob in java?

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related