JDBC query insert with special character ("\N", "\S" and "\T")

Question

I have raw insert query like

insert into sample(id, name) values(1, 'text \\N\');

Getting SqlException while trying to insert via jdbc but the same insert query is working if I insert via mysql command prompt(console).

jdbc insert query is failing due to special characters("\N") in name field.

so how to overcome and insert the name with \N?

@Nawnit Sen: for some reason I am receiving name with \\N\ so my part is to process without any modification — Sasikumar Murugesan
– Sasikumar Murugesan, Commented Sep 28, 2018 at 12:39
@SasikumarMurugesan can you add the complete error message? And try "\\N\\" this might work — Nawnit Sen
– Nawnit Sen, Commented Sep 28, 2018 at 12:45

Gord Thompson · Accepted Answer · 2018-10-23 18:07:32Z

The cleanest approach is to not use a raw SQL query at all. If, as you've stated, you receive the name from some other process then it is presumably in a String variable (or property, or similar) so you can simply use a parameterized query to perform the insert:

// example data int theId = 1; String theName = "the name you received from somewhere else"; // PreparedStatement ps = conn.prepareStatement("INSERT INTO sample (id, name) VALUES (?, ?)"); ps.setInt(1, theId); ps.setString(2, theName); ps.executeUpdate();

Collectives™ on Stack Overflow

JDBC query insert with special character ("\N", "\S" and "\T")

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related