Anybody can help? I also have similar problem for forum portlet.
My system is linux+AS4.0.2+PostgreSQL 8. When i delete a post, the deletion always fail! But i can post/reply. Only delete post doesn't work. anonymous wrote : | 2005-07-30 13:20:17,479 DEBUG [org.hibernate.SQL] delete from jbp_forums_topics where jbp_id=? | 2005-07-30 13:20:17,479 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement | 2005-07-30 13:20:17,479 DEBUG [org.hibernate.type.IntegerType] binding '20' to parameter: 1 | 2005-07-30 13:20:17,480 DEBUG [org.hibernate.jdbc.AbstractBatcher] Adding to batch | 2005-07-30 13:20:17,480 DEBUG [org.hibernate.jdbc.AbstractBatcher] Executing batch size: 1 | 2005-07-30 13:20:17,481 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements | : 1, globally: 1) | 2005-07-30 13:20:17,481 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement | 2005-07-30 13:20:17,481 DEBUG [org.hibernate.util.JDBCExceptionReporter] Could not execute JDBC batch update [delete from jb | p_forums_topics where jbp_id=?] | java.sql.BatchUpdateException: Batch entry 0 delete from jbp_forums_topics where jbp_id=20 was aborted. Call getNextExcepti | on to see the cause. | at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2387) | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1257) | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:334) | at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2446) | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:701) | at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57) | at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:172) | at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226) | at org.hibernate.engine | | ...................... | ....................... | | 2005-07-30 13:20:17,485 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null | 2005-07-30 13:20:17,505 ERROR [org.hibernate.util.JDBCExceptionReporter] Batch entry 0 delete from jbp_forums_topics where j | bp_id=20 was aborted. Call getNextException to see the cause. | 2005-07-30 13:20:17,505 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 23503 | 2005-07-30 13:20:17,505 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: update or delete on "jbp_forums_topics" viol | ates foreign key constraint "fkf2c0436dbfb64ffa" on "jbp_forums_posts" | 2005-07-30 13:20:17,505 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state w | ith session | org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:63) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) | at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:179) | at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226) | at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) | at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274) | at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:48) | at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:697) | at org.hibernate.impl.SessionImpl.prepareQueries(SessionImpl.java:881) | at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:871) | at org.hibernate.impl.SessionImpl.list(SessionImpl.java:820) | at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) | | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3887413#3887413 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3887413 ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
