事务提交的时候 ORA-01733: 此处不允许虚拟列出现这个异常

[kwp123]

更新issuemark 的sql=update issuemark set bonusfile=1 where issueid=655375
11-05 14:15:44.737 [ERROR] - ORA-01733: 此处不允许虚拟列

11-05 14:15:44.737 [ERROR] - ORA-01733: 此处不允许虚拟列

11-05 14:15:44.737 [ERROR] - Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
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.hongbo.lotto.scheduling.DrawFileDownloadScheduling.perform(DrawFileDownloadScheduling.java:240)
at com.hongbo.lotto.scheduling.DrawFileDownloadScheduling.execute(DrawFileDownloadScheduling.java:59)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.BatchUpdateException: ORA-01733: 此处不允许虚拟列

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9409)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 11 more


com.hongbo.lotto.scheduling.DrawFileDownloadScheduling.perform(DrawFileDownloadScheduling.java:240)在这行进行了事务的提交，就出现了这个异常。

[tony4geek]

是不是你更新视图 里面有条件关联的啊。

[kwp123]

没有视图的操作。

[tony4geek]

Could not execute JDBC batch update 你这个是多条吗？ 应该是更新的时候数据库关连了其他。 其次有没有锁表。

[kwp123]

是很多条，就是偶尔会发生这个异常。

[leo_leon]

lz这是lotto demo啊 自己做的么 可否分享啊