reset password
Author Message
Urvashi
Posts: 34
Posted 12:51 May 07, 2009 |

I am getting this error when i try to submit the blog entry form

 

Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into Blog_Entries (Title, Content, Post_Time, blog, id) values (NULL, <p>hello</p>, 2009-05-07 12:45:04.593000 -07:00:00, 1, 19) was aborted.  Call getNextException to see the cause.
    at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2531)
    at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:395)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1344)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:343)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2668)
    at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
    ... 61 more

 

help

abhishek_sharma
Posts: 79
Posted 13:10 May 07, 2009 |

Even I was gttng this kind of error before Runtime Error.

Then I override the formbackup object, and now I am successfully able to insert data, on the same time I am not very much sure whether to use formbackup object or not.

Just give a try by using tht object and see if it works for u or not

cysun
Posts: 2935
Posted 13:48 May 07, 2009 |
Urvashi wrote:

I am getting this error when i try to submit the blog entry form

 

Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into Blog_Entries (Title, Content, Post_Time, blog, id) values (NULL, <p>hello</p>, 2009-05-07 12:45:04.593000 -07:00:00, 1, 19) was aborted.  Call getNextException to see the cause.
    at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2531)
    at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:395)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1344)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:343)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2668)
    at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
    ... 61 more

 

help

There should be more in the error message. Usually it tells you why the insert failed, like "violating not-null or unique constraint" or something.

Urvashi
Posts: 34
Posted 13:51 May 07, 2009 |

its resolved, it was a unique constraint violation.

thank you