qq_29432727
2015-08-11 15:50insert语句在pl/sql中替换数据可以执行,但是java中却报错
java语句:
public int initiating(String title, String content, String numberLimit,String fkCustomerId) {
String pkId = "44";
String sql="insert into ACTIVITY_INFO (pk_id,title,content,fk_customer_id,number_limit,create_date) values(:pkId,:title,:content,:fkCustomerId,:numberLimit,sysdate)";
Query query = this.getSession().createQuery(sql);
query.setParameter("pkId", pkId);
query.setParameter("title", title);
query.setParameter("content", content);
query.setParameter("fkCustomerId", fkCustomerId);
query.setParameter("numberLimit", numberLimit);
int num = query.executeUpdate();
return num;
}
报错信息:
严重: Servlet.service() for servlet [springMvc] in context with path [/CREOAMS] threw exception [Request processing failed; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: values near line 1, column 89 [insert into ACTIVITY_INFO (pk_id,title,content,fk_customer_id,number_limit,create_date) values(:pkId,:title,:content,:fkCustomerId,:numberLimit,sysdate)]] with root cause
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: values near line 1, column 89 [insert into ACTIVITY_INFO (pk_id,title,content,fk_customer_id,number_limit,create_date) values(:pkId,:title,:content,:fkCustomerId,:numberLimit,sysdate)]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
- 点赞
- 回答
- 收藏
- 复制链接分享
1条回答
为你推荐
- 在Oracle PL/SQL中创建数据包,遇到报错:PLS-00103:出现符号“CREATE”,请问如何解决?
- oracle
- 1个回答
- 关于oracle触发器操作的疑问
- 数据库
- 0个回答
- 关于Oracle RAISE的使用
- 数据库
- 0个回答
- 急 Oracle ORA-00904 标识符无效问题
- 数据库
- oracle
- 0个回答
- mysql中如何使用变量向插入数据
- sql
- mysql
- 数据
- 3个回答