org.hibernate.exception.SQLGrammarException

Could not execute JDBC batch update

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web189

Stack trace

  • org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2411) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) at com.urbancode.persistence.hibernate.TxManagerSessionGuard.flush(TxManagerSessionGuard.java:203) at com.urbancode.air.vc.Transaction.commit(Transaction.java:93) at com.urbancode.air.vc.Transaction.commitAndEnd(Transaction.java:215) at com.urbancode.ds.persistence.database.UDTxManager.commitVTX(UDTxManager.java:93) at com.urbancode.ds.persistence.database.UDTxManager.doFinalCommit(UDTxManager.java:50) at com.urbancode.persistence.hibernate.TxManager.commit(TxManager.java:516) at com.urbancode.ds.subsys.deploy.agent.AgentTaskBatcher.executeBatch(AgentTaskBatcher.java:181) at com.urbancode.ds.subsys.deploy.agent.AgentTaskBatcher.run(AgentTaskBatcher.java:120) at java.lang.Thread.run(Thread.java:785) Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into ds_agent (version, sec_resource_id, active, agent_version, apikey_id, description, endpoint_id, error_data, ghosted_date, impersonation_force, impersonation_group, impersonation_password, impersonation_sudo, impersonation_user, jms_cert, last_contact, last_properties_hash, license_type, name, relay_id, last_status, working_directory, id) values (0, '715336c2-2c02-483c-817c-037d018be716', 'Y', NULL, NULL, NULL, 'PrWe3dZ5SiqxayRN6Wjg', NULL, 0, 'N', NULL, NULL, 'N', NULL, NULL, NULL, NULL, 'NONE', 'agent-PrWe3dZ5SiqxayRN6Wjg', NULL, NULL, NULL, '1966c585-d1b2-469a-9d93-fb8acbbb2194') was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2725) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2906) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ... 21 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
6 more bugmates