while executing this sql statement in java i m getting this error

Question

this is my sql statement in java.

//validating for employee no exits in database or not

String importTable = getConfig().getImportTable();
        String sql = "update "
                + importTable
                + " set errMsg = case when errMsg is null or errMsg ='' then '' else errMsg + '<br>' end "
                + "+ 'Employeeno doesn't exists in the database.(' + employeeno + ')' "
                + " where employeeno is not null and not exists (select * from uae_empinfo where employee = "
                + importTable + ".cid)";
        executeCommand(sql);

this is the error:-

org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL []; Invalid SQL statement or JDBC escape, terminating ''' not found.; nested exception is java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not found.

@no.good.at.coding: Oops!! I didn't notice. Thanks.

Adeel Ansari
– Adeel Ansari

2011-05-18 06:04:43 +00:00
Commented May 18, 2011 at 6:04 — Adeel Ansari
– Adeel Ansari, Commented May 18, 2011 at 6:04

mu is too short · Accepted Answer · 2011-05-18 04:36:39Z

3

Your problem is that you have an embedded single quote here:

+ "+ 'Employeeno doesn't exists in the database.(' + employeeno + ')' "
// -------------------^

So you end up with unbalanced single quotes and invalid SQL. You need to properly escape your text before trying to turn it into SQL.

answered May 18, 2011 at 4:36

mu is too short

436k71 gold badges863 silver badges822 bronze badges

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

1 Comment

no.good.at.coding Over a year ago

@vivek I fail to understand why you've not accepted this answer or any of the others in your previous questions. Are you unaware of how to do so? Please see meta.stackexchange.com/questions/5234/…

Adeel Ansari · Accepted Answer · 2011-05-18 04:38:49Z

2

You need to use PreparedStatement, instead.

answered May 18, 2011 at 4:38

Adeel Ansari

39.9k12 gold badges97 silver badges135 bronze badges

Collectives™ on Stack Overflow

while executing this sql statement in java i m getting this error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related