org.springframework.jdbc.UncategorizedSQLException

(HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - tasklist.complete = <p>Create new <span class="nobr"><a href="http://jira.atlassian.com/secure/project/ManageVersions.jspa?pid=10240" title="Visit page outside Confluence" rel="nofollow">version(s) <sup><img class="rendericon" src="/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"/></sup></a></span> if needed <br/> Logging: 14 log statements generated by this request: [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(255) [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(255) [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Could not execute JDBC batch update Throwable: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.


Solutions on the web293

Solution icon of atlassian
via Atlassian JIRA by Mark Chaimungkalanont, 1 year ago
/ManageVersions.jspa?pid=10240" title="Visit page outside Confluence" rel="nofollow">version(s) <sup><img class="rendericon" src="/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"/></sup></a></span> if needed <br/> Logging: 14

Solution icon of atlassian
via Atlassian JIRA by Mark Chaimungkalanont, 1 year ago
/ManageVersions.jspa?pid=10240" title="Visit page outside Confluence" rel="nofollow">version(s) <sup><img class="rendericon" src="/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"/></sup></a></span> if needed <br/> Logging: 14

Solution icon of atlassian
via Atlassian JIRA by Nathan Lee, 11 months ago
.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 3 insert into LINKS (DESTPAGETITLE, DESTSPACEKEY, CONTENTID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, LINKID) values ( was aborted. Call getNextException() to see the

Solution icon of atlassian
via Atlassian JIRA by Owen Fellows, 1 year ago
(HibernateTemplate): encountered SQLException [Batch entry 0 delete from PAGETEMPLATES where TEMPLATEID= was aborted. Call getNextException() to see the cause.]; nested exception is: Batch entry 0 delete from PAGETEMPLATES where TEMPLATEID= was

Solution icon of web
Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [/* insert com.sapienter.jbilling.server.item.db.ItemTypeDTO */ insert into item_type (description, entity_id, order_line_type_id, OPTLOCK, id) values

Solution icon of coderanch
, start_datetime, OPTLOCK, id) values (?, ?, ?, ?, ?, ?)]; SQL state [null]; error code [0]; failed batch; nested exception is java.sql.BatchUpdateException: failed batch

Solution icon of web
via JIRA by Yannick Marcon, 10 months ago
` (`datasource`, `value_table`, `variable`, `name`, `missing`) VALUES ('ccc', 'Drugs', 'CLASS', 'Human', 0)]; nested exception is java.sql.SQLException: liquibase.exception.DatabaseException: Duplicate entry 'ccc-Drugs-CLASS-Human' for key 'PRIMARY' [Failed

Solution icon of coderanch
via Coderanch by Mothea Anil Kumar, 7 months ago
individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.]; nested exception is com.ibm.db2.jcc.c.ud: Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an

Solution icon of coderanch
PreparedStatementCallback; uncategorized SQLException for SQL [insert into movies_tbl(id,title,price,lang) values (?,?,?,?)]; SQL state [S1000]; error code [0]; General error; nested exception is java.sql.SQLException: General error

Solution icon of sourceforge
via symmetricds by moshe1011
, 1 year ago
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; SQL state [S1000]; error code [0]; Cannot convert class java.lang.String to SQL type requested due to java.lang.NullPointerException - null; nested exception is java.sql.SQLException: Cannot convert class java.lang.String to SQL type requested due to java.lang.NullPointerException - null

Stack trace

  • org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - tasklist.complete = <p>Create new <span class="nobr"><a href="http://jira.atlassian.com/secure/project/ManageVersions.jspa?pid=10240" title="Visit page outside Confluence" rel="nofollow">version(s) <sup><img class="rendericon" src="/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"/></sup></a></span> if needed <br/> Logging: 14 log statements generated by this request: [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(255) [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(255) [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Could not execute JDBC batch update Throwable: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:181) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)

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

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.