Java select query throws an error on DB2 database?

Question

Java DB2 Sql command throws an error if i have a ' in my String i tried to replace it with a escape sequence but it would not work on the DB2 end any help ? I want the ' to be present in the String.

Error

com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-10, SQLSTATE=42603, SQLERRMC=', DRIVER=3.63.123

Java

String FUNC_VP = "Chris O'Connor/Henry/George";
String myQuery = "SELECT DISTINCT(VICE_PRES) FROM EMP_HC WHERE FUNC_VP ='"+funcvp_name.replace("'", "/'")+"'";

Unrelated, but: distinct is not a function

user330315
– user330315

2014-04-12 08:12:12 +00:00
Commented Apr 12, 2014 at 8:12 — user330315
– user330315, Commented Apr 12, 2014 at 8:12

Kayaman · Accepted Answer · 2014-04-12 08:11:51Z

8

Use a PreparedStatement and its setParameter() methods. It will handle things like escaping for you, and you'll never have to wonder how a particular database might handle things. It also prevents SQL injection, so there's no good reason not to use it.

answered Apr 12, 2014 at 8:11

Kayaman

73.8k6 gold badges91 silver badges128 bronze badges

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

Comments

DaveH · Accepted Answer · 2014-04-12 08:09:05Z

1

Try

String FUNC_VP = "Chris O''Connor/Henry/George";

To escape an apostrohe on DB2 it seems you have to use two apostrophes

answered Apr 12, 2014 at 8:09

DaveH

7,3675 gold badges36 silver badges62 bronze badges

1 Comment

Clockwork-Muse Over a year ago

(Not downvoting because this is technically correct, but...) No, don't escape them yourself - this is just papering over a larger problem: the op may be (probably is) open to SQL Injection. Use prepared statements (As the other answer states), and you don't even have to do the escaping yourself. There should be no reason to ever need to do the escaping yourself for a statement.

Collectives™ on Stack Overflow

Java select query throws an error on DB2 database?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related