Question

ORA-00911: 无效字符 jdbctemplate

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [insert into lzkhit.plan(plan_title,project_name,plan_desc,plan_analy,plan_category,plan_level,plan_state,expect_dt,creator_id,create_dt,regenerator,update_dt,plan_num) values ('2','2', '2', '2', '1', '1', '1', '2011-06-30', '1', '2011-06-28 20:53:34', '0', '2011-06-28', '');]; nested exception is java.sql.SQLException: ORA-00911: 无效字符

但是这句话在plsql里没问题的，，， 擦擦。。。。害的我饭都没吃。。。大侠指点下！！！！！

Answer 1

insert into lzkhit.plan(plan_title,project_name,plan_desc,plan_analy,plan_category,plan_level,plan_state,expect_dt,creator_id,create_dt,regenerator,update_dt,plan_num) values ('2','2', '2', '2', '1', '1', '1', '2011-06-30', '1', '2011-06-28 20:53:34', '0', '2011-06-28', '');
最后面那个分号不该有

Answer 2

把代码贴出来