2009-08-12 11:38:01:DEBUG main org.hibernate.pretty.Printer - listing entities:
2009-08-12 11:38:01:DEBUG main org.hibernate.pretty.Printer - com.hundsun.hibernate.YbtYwls{bxlsh=11, bxxym=11, zhmc=11, zjrq=11, jyje=11.0, zdh=11, xym=11, cpdm=11, jyzt=1, jymc=11, jysj=11, id=component[zwrq,ptzlsh]{zwrq=20081001, ptzlsh=00000051}, czyh=11, zjjydm=11, bxfrq=11, bxjydm=11, jybz=11, zjxym=11, jyzh=11, qdlx=11, bdh=11, jydm=9008, yjylsh=11, bxxyxx=11, gsdm=11, jgbh=11, jyrq=11, zjxyxx=11, xyxx=11, zjlsh=11}
2009-08-12 11:38:01:DEBUG main org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-08-12 11:38:01:DEBUG main org.hibernate.SQL -
/* insert com.hundsun.hibernate.YbtYwls
*/ insert
into
ybtdb2.gaps32.ybt_ywls
(jydm, jymc, yjylsh, gsdm, cpdm, bdh, jyzh, zhmc, jybz, jyje, jgbh, czyh, zdh, jyrq, jysj, qdlx, xym, xyxx, jyzt, bxfrq, bxlsh, bxjydm, bxxym, bxxyxx, zjrq, zjlsh, zjjydm, zjxym, zjxyxx, zwrq, ptzlsh)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-08-12 11:38:01:DEBUG main org.hibernate.util.JDBCExceptionReporter - could not insert: [com.hundsun.hibernate.YbtYwls] [/* insert com.hundsun.hibernate.YbtYwls */ insert into ybtdb2.gaps32.ybt_ywls (jydm, jymc, yjylsh, gsdm, cpdm, bdh, jyzh, zhmc, jybz, jyje, jgbh, czyh, zdh, jyrq, jysj, qdlx, xym, xyxx, jyzt, bxfrq, bxlsh, bxjydm, bxxym, bxxyxx, zjrq, zjlsh, zjjydm, zjxym, zjxyxx, zwrq, ptzlsh) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2229)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.hundsun.action.InsertDrlsActionHandler.execute(InsertDrlsActionHandler.java:157)
at org.jbpm.graph.def.Action.execute(Action.java:125)
at org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:281)
at org.jbpm.graph.def.Node.execute(Node.java:412)
at org.jbpm.graph.def.Node.enter(Node.java:388)
at org.jbpm.graph.def.Transition.take(Transition.java:166)
at org.jbpm.graph.def.Node.leave(Node.java:477)
at org.jbpm.graph.node.StartState.leave(StartState.java:80)
at org.jbpm.graph.exe.Token.signal(Token.java:226)
at org.jbpm.graph.exe.Token.signal(Token.java:149)
at org.jbpm.graph.exe.ProcessInstance.signal(ProcessInstance.java:304)
at bank.dealwith.NetServerThread.dealwith(NetServerThread.java:138)
at bank.dealwith.NetServerThread.main(NetServerThread.java:216)
2009-08-12 11:38:01:WARN main org.hibernate.util.JDBCExceptionReporter - SQL Error: -201, SQLState: 42000
2009-08-12 11:38:01:ERROR main org.hibernate.util.JDBCExceptionReporter - A syntax error has occurred.
2009-08-12 11:38:01:ERROR main org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: could not insert: [com.hundsun.hibernate.YbtYwls]
请问是什么问题啊,更新其他表好像可以的。
2009-08-12 11:38:01:DEBUG main org.hibernate.pretty.Printer - com.hundsun.hibernate.YbtYwls{bxlsh=11, bxxym=11, zhmc=11, zjrq=11, jyje=11.0, zdh=11, xym=11, cpdm=11, jyzt=1, jymc=11, jysj=11, id=component[zwrq,ptzlsh]{zwrq=20081001, ptzlsh=00000051}, czyh=11, zjjydm=11, bxfrq=11, bxjydm=11, jybz=11, zjxym=11, jyzh=11, qdlx=11, bdh=11, jydm=9008, yjylsh=11, bxxyxx=11, gsdm=11, jgbh=11, jyrq=11, zjxyxx=11, xyxx=11, zjlsh=11}
2009-08-12 11:38:01:DEBUG main org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-08-12 11:38:01:DEBUG main org.hibernate.SQL -
/* insert com.hundsun.hibernate.YbtYwls
*/ insert
into
ybtdb2.gaps32.ybt_ywls
(jydm, jymc, yjylsh, gsdm, cpdm, bdh, jyzh, zhmc, jybz, jyje, jgbh, czyh, zdh, jyrq, jysj, qdlx, xym, xyxx, jyzt, bxfrq, bxlsh, bxjydm, bxxym, bxxyxx, zjrq, zjlsh, zjjydm, zjxym, zjxyxx, zwrq, ptzlsh)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-08-12 11:38:01:DEBUG main org.hibernate.util.JDBCExceptionReporter - could not insert: [com.hundsun.hibernate.YbtYwls] [/* insert com.hundsun.hibernate.YbtYwls */ insert into ybtdb2.gaps32.ybt_ywls (jydm, jymc, yjylsh, gsdm, cpdm, bdh, jyzh, zhmc, jybz, jyje, jgbh, czyh, zdh, jyrq, jysj, qdlx, xym, xyxx, jyzt, bxfrq, bxlsh, bxjydm, bxxym, bxxyxx, zjrq, zjlsh, zjjydm, zjxym, zjxyxx, zwrq, ptzlsh) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2229)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.hundsun.action.InsertDrlsActionHandler.execute(InsertDrlsActionHandler.java:157)
at org.jbpm.graph.def.Action.execute(Action.java:125)
at org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:281)
at org.jbpm.graph.def.Node.execute(Node.java:412)
at org.jbpm.graph.def.Node.enter(Node.java:388)
at org.jbpm.graph.def.Transition.take(Transition.java:166)
at org.jbpm.graph.def.Node.leave(Node.java:477)
at org.jbpm.graph.node.StartState.leave(StartState.java:80)
at org.jbpm.graph.exe.Token.signal(Token.java:226)
at org.jbpm.graph.exe.Token.signal(Token.java:149)
at org.jbpm.graph.exe.ProcessInstance.signal(ProcessInstance.java:304)
at bank.dealwith.NetServerThread.dealwith(NetServerThread.java:138)
at bank.dealwith.NetServerThread.main(NetServerThread.java:216)
2009-08-12 11:38:01:WARN main org.hibernate.util.JDBCExceptionReporter - SQL Error: -201, SQLState: 42000
2009-08-12 11:38:01:ERROR main org.hibernate.util.JDBCExceptionReporter - A syntax error has occurred.
2009-08-12 11:38:01:ERROR main org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: could not insert: [com.hundsun.hibernate.YbtYwls]
请问是什么问题啊,更新其他表好像可以的。
2009-08-12 11:38:01:DEBUG main org.hibernate.pretty.Printer - com.hundsun.hibernate.YbtYwls{bxlsh=11, bxxym=11, zhmc=11, zjrq=11, jyje=11.0, zdh=11, xym=11, cpdm=11, jyzt=1, jymc=11, jysj=11, id=component[zwrq,ptzlsh]{zwrq=20081001, ptzlsh=00000051}, czyh=11, zjjydm=11, bxfrq=11, bxjydm=11, jybz=11, zjxym=11, jyzh=11, qdlx=11, bdh=11, jydm=9008, yjylsh=11, bxxyxx=11, gsdm=11, jgbh=11, jyrq=11, zjxyxx=11, xyxx=11, zjlsh=11}
这里是hibernate生成的配置文件
<class name="com.hundsun.hibernate.YbtYwls" table="ybt_ywls" schema="gaps32" catalog="ybtdb2">
把catalog="ybtdb2"去掉就可以了,不知道为什么,ybtdb2是我的数据库的名字。
不知道有谁可以解释一下。