Insert java byte array in table using Statement

Question

Can we insert a java byte array in hsqldb table as blob datatype by using Statement class(without using prepared statement)?

Andreas · Accepted Answer · 2016-02-27 05:50:55Z

1

Since you shouldn't insert user data into a SQL statement using string concatenation anyway, why do you care?

Using PreparedStatement is the right way to do it.

Though, technically, you could execute a SELECT statement, and insert the data using an updatable ResultSet, but I wouldn't recommend it. Inserting a row using a dummy SELECT statement is just plain unnecessary overhead.

Or you could build a HSQLDB Binary Literal, but why go through all that work, when you'll get it for free with a PreparedStatement?

edited Feb 27, 2016 at 5:50

answered Feb 27, 2016 at 5:45

Andreas

160k13 gold badges164 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

Insert java byte array in table using Statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related