jboss jboss-4.0.3RC2/Portal Forum/Postgresql
svan9420 Sep 24, 2005 10:56 PMI am receiving serious errors with hibernate and postgresql 8.0 on the linux platform.
When I post content to the forum, sometimes the content posts successfully, but other times, it does not and a lot of exceptions are thrown.
I turned on sql in the hibernate configuration files. So I am able to see most the sql that is being executed in the database.
First of all, here is my configuration for jboss, jboss-portal and postgresql.
JBOSS=jboss-4.0.3RC2
JBOSS-PORTAL=jboss-portal-2.0.1RC1
JBOSS-FORUMS=jboss-forums-2.0
POSTGRESQL=8.0.3
JAVA=Java HotSpot(TM) Client VM (build 1.5.0_04-b05, mixed mode, sharing)
Second, here are my configuration files for hibernate just for the forum:
FORUM HIBERNATE Config located in $JBOSS_HOME/server/default/deploy/portal-forums.ear/portal-forums.sar/conf/hibernate
------------------------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory name="java:portal/ForumSessionFactory"> <property name="connection.datasource">java:PortalDS</property> <property name="show_sql">true</property> <!-- Force the dialect instead of using autodetection --> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <!-- Mapping files --> <mapping resource="org/jboss/portlet/forums/impl/CategoryImpl.hbm.xml"/> <mapping resource="org/jboss/portlet/forums/impl/ForumImpl.hbm.xml"/> <mapping resource="org/jboss/portlet/forums/impl/PollImpl.hbm.xml"/> <mapping resource="org/jboss/portlet/forums/impl/PosterImpl.hbm.xml"/> <mapping resource="org/jboss/portlet/forums/impl/PostImpl.hbm.xml"/> <mapping resource="org/jboss/portlet/forums/impl/TopicImpl.hbm.xml"/> <mapping resource="org/jboss/portlet/forums/impl/WatchImpl.hbm.xml"/> </session-factory> </hibernate-configuration>
------------------------------------------------------------
Here are the errors that are being thrown.
20:36:07,407 INFO [STDOUT] Hibernate: select userimpl0_.jbp_uid as jbp1_2_, userimpl0_.jbp_root_pref_set_id as jbp2_2_, userimpl0_.jbp_uname as jbp3_2_, userimpl0_.jbp_givenname as jbp4_2_, userimpl0_.jbp_familyname as jbp5_2_, userimpl0_.jbp_password as jbp6_2_, userimpl0_.jbp_realemail as jbp7_2_, userimpl0_.jbp_fakeemail as jbp8_2_, userimpl0_.jbp_regdate as jbp9_2_, userimpl0_.jbp_viewrealemail as jbp10_2_, userimpl0_.jbp_enabled as jbp11_2_ from jbp_users userimpl0_ where userimpl0_.jbp_uname=? 20:36:07,422 INFO [STDOUT] Hibernate: select roles0_.jbp_uid as jbp2_1_, roles0_.jbp_rid as jbp1_1_, roleimpl1_.jbp_rid as jbp1_0_0_, roleimpl1_.jbp_name as jbp2_0_0_, roleimpl1_.jbp_displayname as jbp3_0_0_ from jbp_role_membership roles0_ left outer join jbp_roles roleimpl1_ on roles0_.jbp_rid=roleimpl1_.jbp_rid where roles0_.jbp_uid=? 20:36:07,430 INFO [STDOUT] Hibernate: select dynamic0_.jbp_uid as jbp1_0_, dynamic0_.jbp_value as jbp2_0_, dynamic0_.jbp_name as jbp3_0_ from jbp_user_prop dynamic0_ where dynamic0_.jbp_uid=? 20:36:07,438 INFO [STDOUT] Hibernate: select userprefse0_.jbp_id as jbp1_6_0_, userprefse0_.jbp_parent_id as jbp2_6_0_, userprefse0_.name as name6_0_ from jbp_user_pref_set userprefse0_ where userprefse0_.jbp_id=? 20:36:07,445 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,450 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,459 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,464 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,475 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,480 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,489 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,495 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,503 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,508 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,514 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,520 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,544 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,550 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,559 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,566 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,571 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,579 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,588 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,600 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,607 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,616 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,625 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,630 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,636 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,642 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,650 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,656 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,662 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,668 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,676 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,682 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,688 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,694 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,702 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,709 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,715 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,721 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,730 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,736 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,741 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,747 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,754 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,760 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,766 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,771 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,779 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,785 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,791 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,797 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,805 INFO [STDOUT] Hibernate: select content0_.jbp_set_id as jbp4_1_, content0_.jbp_id as jbp1_1_, content0_.jbp_name as jbp2_1_, content0_.jbp_id as jbp1_4_0_, content0_.jbp_name as jbp2_4_0_, content0_.jbp_type as jbp3_4_0_ from jbp_user_pref content0_ where content0_.jbp_set_id=? 20:36:07,812 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? 20:36:07,833 INFO [STDOUT] Hibernate: select posterimpl0_.jbp_id as jbp1_44_, posterimpl0_.jbp_user_id as jbp2_44_, posterimpl0_.jbp_post_count as jbp3_44_ from jbp_forums_posters posterimpl0_ where posterimpl0_.jbp_user_id=? 20:36:07,858 INFO [STDOUT] Hibernate: select max(postimpl0_.jbp_create_date) as col_0_0_ from jbp_forums_posts postimpl0_, jbp_forums_posters posterimpl1_ where postimpl0_.jbp_poster_id=posterimpl1_.jbp_id and posterimpl1_.jbp_user_id=? 20:36:07,867 INFO [STDOUT] INTERVAL:516 20:36:07,870 INFO [STDOUT] Hibernate: select forumimpl0_.jbp_id as jbp1_42_0_, forumimpl0_.jbp_category_id as jbp2_42_0_, forumimpl0_.jbp_description as jbp3_42_0_, forumimpl0_.jbp_last_post_id as jbp4_42_0_, forumimpl0_.jbp_name as jbp5_42_0_, forumimpl0_.jbp_order as jbp6_42_0_, forumimpl0_.jbp_topic_count as jbp7_42_0_, forumimpl0_.jbp_post_count as jbp8_42_0_, forumimpl0_.jbp_prune_enable as jbp9_42_0_, forumimpl0_.jbp_prune_next as jbp10_42_0_, forumimpl0_.jbp_status as jbp11_42_0_, forumimpl0_.jbp_type as jbp12_42_0_ from jbp_forums_forums forumimpl0_ where forumimpl0_.jbp_id=? 20:36:07,880 INFO [STDOUT] Hibernate: select categoryim0_.jbp_id as jbp1_41_0_, categoryim0_.jbp_order as jbp2_41_0_, categoryim0_.jbp_title as jbp3_41_0_ from jbp_forums_categories categoryim0_ where categoryim0_.jbp_id=? 20:36:07,889 INFO [STDOUT] Hibernate: select nextval ('hibernate_sequence') 20:36:07,894 INFO [STDOUT] Hibernate: select nextval ('hibernate_sequence') 20:36:07,900 INFO [STDOUT] Hibernate: select nextval ('hibernate_sequence') 20:36:07,933 INFO [STDOUT] Hibernate: select categoryim0_.jbp_id as col_0_0_ from jbp_forums_categories categoryim0_ order by categoryim0_.jbp_order asc 20:36:07,940 INFO [STDOUT] Hibernate: select categoryim0_.jbp_id as jbp1_41_0_, categoryim0_.jbp_order as jbp2_41_0_, categoryim0_.jbp_title as jbp3_41_0_ from jbp_forums_categories categoryim0_ where categoryim0_.jbp_id=? 20:36:07,968 INFO [STDOUT] Hibernate: insert into jbp_forums_posts (jbp_topic_id, jbp_edit_count, jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, jbp_poster_id, jbp_id) values (?, ?, ?, ?, ?, ?, ?, ?) 20:36:07,979 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null 20:36:07,980 ERROR [JDBCExceptionReporter] Batch entry 0 insert into jbp_forums_posts (jbp_topic_id, jbp_edit_count, jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, jbp_poster_id, jbp_id) values (NULL, 0, NULL, 2005-09-24 20:36:07.888000-0600, Bad Query, 20:27:43,068 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? , 33, 172) was aborted. Call getNextException to see the cause. 20:36:07,981 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 22001 20:36:07,981 ERROR [JDBCExceptionReporter] ERROR: value too long for type character varying(255) 20:36:07,982 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:182) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:75) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:151) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1910) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2287) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:48) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:284) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:49) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:731) at org.hibernate.impl.SessionImpl.prepareQueries(SessionImpl.java:915) at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:905) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:940) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at org.jboss.portlet.forums.impl.ForumsModuleImpl.findForumsByCategoryID(ForumsModuleImpl.java:259) at org.jboss.portlet.forums.ForumsPortlet.fillShowCategoryContext(ForumsPortlet.java:1957) at org.jboss.portlet.forums.ForumsPortlet.fillShowIndexContext(ForumsPortlet.java:1925) at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:325) at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:217) at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:204) at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:347) at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeRequest(DispatcherInterceptor.java:163) at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(DispatcherInterceptor.java:195) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(PreferencesInterceptor.java:93) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:49) at org.jboss.portal.server.servlet.CommandServlet.doPost(CommandServlet.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:539) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499) at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor.invoke(ContextDispatcherInterceptor.java:58) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(AccessControlInterceptor.java:125) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(CacheInterceptor.java:74) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238) at org.jboss.portal.server.Component.invoke(Component.java:173) at org.jboss.portal.server.invocation.portal.MainDispatcherInterceptor.invoke(MainDispatcherInterceptor.java:93) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.StrategyInterceptor.invoke(StrategyInterceptor.java:184) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.ViewInterceptor.invoke(ViewInterceptor.java:118) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.invocation.portal.TargetInterceptor.invoke(TargetInterceptor.java:153) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:117) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserContextInterceptor.java:92) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238) at org.jboss.portal.server.PortalServer.invoke(PortalServer.java:186) at org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMainServlet.java:78) at org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMainServlet.java:71) at org.jboss.portal.server.servlet.AbstractMainServlet.doPost(AbstractMainServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionFilter.java:79) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:157) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into jbp_forums_posts (jbp_topic_id, jbp_edit_count, jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, jbp_poster_id, jbp_id) values (NULL, 0, NULL, 2005-09-24 20:36:07.888000-0600, Bad Query, 20:27:43,068 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? , 33, 172) was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2396) 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:2455) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:484) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:175) ... 92 more 20:36:07,988 ERROR [ForumsModuleImpl] Cannot find forums org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:182) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:75) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:151) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1910) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2287) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:48) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:284) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:49) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:731) at org.hibernate.impl.SessionImpl.prepareQueries(SessionImpl.java:915) at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:905) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:940) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at org.jboss.portlet.forums.impl.ForumsModuleImpl.findForumsByCategoryID(ForumsModuleImpl.java:259) at org.jboss.portlet.forums.ForumsPortlet.fillShowCategoryContext(ForumsPortlet.java:1957) at org.jboss.portlet.forums.ForumsPortlet.fillShowIndexContext(ForumsPortlet.java:1925) at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:325) at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:217) at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:204) at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:347) at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeRequest(DispatcherInterceptor.java:163) at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(DispatcherInterceptor.java:195) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(PreferencesInterceptor.java:93) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:49) at org.jboss.portal.server.servlet.CommandServlet.doPost(CommandServlet.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:539) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499) at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor.invoke(ContextDispatcherInterceptor.java:58) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(AccessControlInterceptor.java:125) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(CacheInterceptor.java:74) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238) at org.jboss.portal.server.Component.invoke(Component.java:173) at org.jboss.portal.server.invocation.portal.MainDispatcherInterceptor.invoke(MainDispatcherInterceptor.java:93) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.StrategyInterceptor.invoke(StrategyInterceptor.java:184) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.ViewInterceptor.invoke(ViewInterceptor.java:118) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.invocation.portal.TargetInterceptor.invoke(TargetInterceptor.java:153) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:117) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserContextInterceptor.java:92) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238) at org.jboss.portal.server.PortalServer.invoke(PortalServer.java:186) at org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMainServlet.java:78) at org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMainServlet.java:71) at org.jboss.portal.server.servlet.AbstractMainServlet.doPost(AbstractMainServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionFilter.java:79) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:157) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into jbp_forums_posts (jbp_topic_id, jbp_edit_count, jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, jbp_poster_id, jbp_id) values (NULL, 0, NULL, 2005-09-24 20:36:07.888000-0600, Bad Query, 20:27:43,068 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? , 33, 172) was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2396) 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:2455) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:484) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:175) ... 92 more 20:36:07,998 INFO [STDOUT] org.jboss.portal.core.modules.ModuleException: Cannot find forums 20:36:08,000 INFO [STDOUT] at org.jboss.portlet.forums.impl.ForumsModuleImpl.findForumsByCategoryID(ForumsModuleImpl.java:266) 20:36:08,002 INFO [STDOUT] at org.jboss.portlet.forums.ForumsPortlet.fillShowCategoryContext(ForumsPortlet.java:1957) 20:36:08,002 INFO [STDOUT] at org.jboss.portlet.forums.ForumsPortlet.fillShowIndexContext(ForumsPortlet.java:1925) 20:36:08,003 INFO [STDOUT] at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:325) 20:36:08,003 INFO [STDOUT] at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:217) 20:36:08,003 INFO [STDOUT] at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:204) 20:36:08,004 INFO [STDOUT] at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:347) 20:36:08,005 INFO [STDOUT] at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeRequest(DispatcherInterceptor.java:163) 20:36:08,005 INFO [STDOUT] at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(DispatcherInterceptor.java:195) 20:36:08,006 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,006 INFO [STDOUT] at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(PreferencesInterceptor.java:93) 20:36:08,006 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,007 INFO [STDOUT] at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94) 20:36:08,007 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 20:36:08,007 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 20:36:08,008 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 20:36:08,008 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 20:36:08,009 INFO [STDOUT] at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:49) 20:36:08,010 INFO [STDOUT] at org.jboss.portal.server.servlet.CommandServlet.doPost(CommandServlet.java:98) 20:36:08,010 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 20:36:08,011 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 20:36:08,011 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) 20:36:08,012 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 20:36:08,013 INFO [STDOUT] at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672) 20:36:08,013 INFO [STDOUT] at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:539) 20:36:08,014 INFO [STDOUT] at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499) 20:36:08,015 INFO [STDOUT] at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor.invoke(ContextDispatcherInterceptor.java:58) 20:36:08,016 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,017 INFO [STDOUT] at org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(AccessControlInterceptor.java:125) 20:36:08,017 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,018 INFO [STDOUT] at org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(CacheInterceptor.java:74) 20:36:08,018 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,019 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238) 20:36:08,019 INFO [STDOUT] at org.jboss.portal.server.Component.invoke(Component.java:173) 20:36:08,019 INFO [STDOUT] at org.jboss.portal.server.invocation.portal.MainDispatcherInterceptor.invoke(MainDispatcherInterceptor.java:93) 20:36:08,020 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,020 INFO [STDOUT] at org.jboss.portal.core.invocation.StrategyInterceptor.invoke(StrategyInterceptor.java:184) 20:36:08,020 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,021 INFO [STDOUT] at org.jboss.portal.core.invocation.ViewInterceptor.invoke(ViewInterceptor.java:118) 20:36:08,021 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,021 INFO [STDOUT] at org.jboss.portal.server.invocation.portal.TargetInterceptor.invoke(TargetInterceptor.java:153) 20:36:08,022 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,022 INFO [STDOUT] at org.jboss.portal.core.invocation.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:117) 20:36:08,022 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,023 INFO [STDOUT] at org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserContextInterceptor.java:92) 20:36:08,023 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) 20:36:08,023 INFO [STDOUT] at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238) 20:36:08,024 INFO [STDOUT] at org.jboss.portal.server.PortalServer.invoke(PortalServer.java:186) 20:36:08,024 INFO [STDOUT] at org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMainServlet.java:78) 20:36:08,024 INFO [STDOUT] at org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMainServlet.java:71) 20:36:08,025 INFO [STDOUT] at org.jboss.portal.server.servlet.AbstractMainServlet.doPost(AbstractMainServlet.java:62) 20:36:08,025 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 20:36:08,025 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 20:36:08,026 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) 20:36:08,026 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 20:36:08,027 INFO [STDOUT] at org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionFilter.java:79) 20:36:08,027 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) 20:36:08,028 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 20:36:08,028 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) 20:36:08,029 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) 20:36:08,029 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 20:36:08,030 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) 20:36:08,030 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) 20:36:08,031 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) 20:36:08,032 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:157) 20:36:08,033 INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) 20:36:08,033 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) 20:36:08,033 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) 20:36:08,034 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) 20:36:08,035 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) 20:36:08,035 INFO [STDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) 20:36:08,035 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) 20:36:08,036 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) 20:36:08,036 INFO [STDOUT] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) 20:36:08,037 INFO [STDOUT] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) 20:36:08,038 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595) 20:36:08,039 INFO [STDOUT] Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update 20:36:08,039 INFO [STDOUT] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82) 20:36:08,040 INFO [STDOUT] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70) 20:36:08,041 INFO [STDOUT] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) 20:36:08,042 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:182) 20:36:08,043 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:75) 20:36:08,043 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:70) 20:36:08,044 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:151) 20:36:08,045 INFO [STDOUT] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1910) 20:36:08,046 INFO [STDOUT] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2287) 20:36:08,047 INFO [STDOUT] at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:48) 20:36:08,047 INFO [STDOUT] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) 20:36:08,048 INFO [STDOUT] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227) 20:36:08,048 INFO [STDOUT] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) 20:36:08,049 INFO [STDOUT] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:284) 20:36:08,050 INFO [STDOUT] at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:49) 20:36:08,051 INFO [STDOUT] at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:731) 20:36:08,051 INFO [STDOUT] at org.hibernate.impl.SessionImpl.prepareQueries(SessionImpl.java:915) 20:36:08,052 INFO [STDOUT] at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:905) 20:36:08,052 INFO [STDOUT] at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:940) 20:36:08,053 INFO [STDOUT] at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) 20:36:08,053 INFO [STDOUT] at org.jboss.portlet.forums.impl.ForumsModuleImpl.findForumsByCategoryID(ForumsModuleImpl.java:259) 20:36:08,054 INFO [STDOUT] ... 75 more 20:36:08,055 INFO [STDOUT] Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into jbp_forums_posts (jbp_topic_id, jbp_edit_count, jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, jbp_poster_id, jbp_id) values (NULL, 0, NULL, 2005-09-24 20:36:07.888000-0600, Bad Query, 20:27:43,068 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? , 33, 172) was aborted. Call getNextException to see the cause. 20:36:08,056 INFO [STDOUT] at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2396) 20:36:08,057 INFO [STDOUT] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1257) 20:36:08,058 INFO [STDOUT] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:334) 20:36:08,059 INFO [STDOUT] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2455) 20:36:08,059 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:484) 20:36:08,060 INFO [STDOUT] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57) 20:36:08,061 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:175) 20:36:08,061 INFO [STDOUT] ... 92 more 20:36:08,081 INFO [STDOUT] Hibernate: insert into jbp_forums_posts (jbp_topic_id, jbp_edit_count, jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, jbp_poster_id, jbp_id) values (?, ?, ?, ?, ?, ?, ?, ?) 20:36:08,094 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null 20:36:08,094 ERROR [JDBCExceptionReporter] Batch entry 0 insert into jbp_forums_posts (jbp_topic_id, jbp_edit_count, jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, jbp_poster_id, jbp_id) values (NULL, 0, NULL, 2005-09-24 20:36:07.888000-0600, Bad Query, 20:27:43,068 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? , 33, 172) was aborted. Call getNextException to see the cause. 20:36:08,095 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 25P02 20:36:08,095 ERROR [JDBCExceptionReporter] ERROR: current transaction is aborted, commands ignored until end of transaction block 20:36:08,095 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:182) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:75) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:151) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1910) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2287) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:48) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:284) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:49) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:731) at org.hibernate.impl.SessionImpl.prepareQueries(SessionImpl.java:915) at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:905) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:940) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at org.jboss.portlet.forums.impl.ForumsModuleImpl.findForumsByCategoryID(ForumsModuleImpl.java:259) at org.jboss.portlet.forums.ForumsPortlet.fillShowCategoryContext(ForumsPortlet.java:1957) at org.jboss.portlet.forums.ForumsPortlet.fillShowIndexContext(ForumsPortlet.java:1925) at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:325) at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:217) at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:204) at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:347) at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeRequest(DispatcherInterceptor.java:163) at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(DispatcherInterceptor.java:195) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(PreferencesInterceptor.java:93) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:49) at org.jboss.portal.server.servlet.CommandServlet.doPost(CommandServlet.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:539) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499) at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor.invoke(ContextDispatcherInterceptor.java:58) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(AccessControlInterceptor.java:125) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(CacheInterceptor.java:74) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238) at org.jboss.portal.server.Component.invoke(Component.java:173) at org.jboss.portal.server.invocation.portal.MainDispatcherInterceptor.invoke(MainDispatcherInterceptor.java:93) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.StrategyInterceptor.invoke(StrategyInterceptor.java:184) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.ViewInterceptor.invoke(ViewInterceptor.java:118) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.invocation.portal.TargetInterceptor.invoke(TargetInterceptor.java:153) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:117) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserContextInterceptor.java:92) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238) at org.jboss.portal.server.PortalServer.invoke(PortalServer.java:186) at org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMainServlet.java:78) at org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMainServlet.java:71) at org.jboss.portal.server.servlet.AbstractMainServlet.doPost(AbstractMainServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionFilter.java:79) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:157) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into jbp_forums_posts (jbp_topic_id, jbp_edit_count, jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, jbp_poster_id, jbp_id) values (NULL, 0, NULL, 2005-09-24 20:36:07.888000-0600, Bad Query, 20:27:43,068 INFO [STDOUT] Hibernate: select children0_.jbp_parent_id as jbp2_1_, children0_.jbp_id as jbp1_1_, children0_.jbp_id as jbp1_6_0_, children0_.jbp_parent_id as jbp2_6_0_, children0_.name as name6_0_ from jbp_user_pref_set children0_ where children0_.jbp_parent_id=? , 33, 172) was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2396) 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:2455) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:484) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5