Storing a byte array into MySQL binary column with JdbcTemplate

Question

I have a MySQL table (simplified):

CREATE TABLE `tokens` (
    `token` BINARY(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

And I try to insert a row like this:

JdbcTemplate jdbcTemplate; // org.springframework.jdbc.core.JdbcTemplate
...
String sql = "INSERT INTO `tokens` (`token`) VALUES (?)";
String token = "123e4567e89b12d3a456426655440000"; // UUID
jdbcTemplate.update(sql, new Object[]{token.getBytes()});

But I get this exception:

Data truncation: Data too long for column 'token' at row 1

What do I do wrong? Thanks.

Edit: see my answer, I missed the hexadecimal conversion (token is an UUID).

"Data truncation: Data too long for column 'token' at row 1 " — e4c5
– e4c5, Commented Sep 21, 2016 at 3:32
increase size of column token . change token BINARY(16) to token BINARY(32) — Arunkumar Tech Expert
– Arunkumar Tech Expert, Commented Oct 5, 2016 at 4:09
@Arunkumar I was missing the hexadecimal conversion, a 32 chars UUID contains 16 hexadecimal codes. — Maxime Laval
– Maxime Laval, Commented Oct 5, 2016 at 14:04

Maxime Laval · Accepted Answer · 2016-09-21 15:17:41Z

1

Here is the solution to store the token (which is an UUID):

jdbcTemplate.update(sql, new Object[]{DatatypeConverter.parseHexBinary(token)});

Let us know if there are other ways...

answered Sep 21, 2016 at 15:17

Maxime Laval

4,4288 gold badges47 silver badges63 bronze badges

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

Collectives™ on Stack Overflow

Storing a byte array into MySQL binary column with JdbcTemplate

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