5 Replies Latest reply on Sep 25, 2005 10:38 AM by svan9420

Postgresql

svan9420 Sep 24, 2005 10:56 PM

I 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

1. Re: jboss jboss-4.0.3RC2/Portal Forum/Postgresql

svan9420 Sep 24, 2005 10:59 PM (in response to svan9420)

jdbc driver = postgresql-8.0-312.jdbc3.jar
Actions
2. Re: jboss jboss-4.0.3RC2/Portal Forum/Postgresql

svan9420 Sep 24, 2005 11:54 PM (in response to svan9420)

I believe that that the initial setup script for postgresql does not correctly define the table types for the jpb_forums_posts table in the databse. First of all the jpb_text field which contains the posts from the end user is defined as varchar(255). So I changed this to the postgresql datatype of text. The text datatype does not have a limit on the length of text that can be stored, except for the 32 TB limit that each table has.

So far everything is working now. I just hope someone else is able to use this information to get up and running with their forum.

By the way, the forum and portal seem a little shaky in terms of stability, but I hope that my efforts will make it a solid product that everyone can use. And special thanks goes out to the JBOSS team and everyone else who contributes for their hard work.

Thanks,

Randall
Actions
3. Re: jboss jboss-4.0.3RC2/Portal Forum/Postgresql

julien1 Sep 25, 2005 4:54 AM (in response to svan9420)

that is fixed in the latest release 2.0.1 RC2, you should use that release.

beside that, the forum is much more complete feature wise, a real pleasure.
Actions
4. Re: jboss jboss-4.0.3RC2/Portal Forum/Postgresql

julien1 Sep 25, 2005 4:55 AM (in response to svan9420)

by the way, could you give us the comomand you executed to migrate the column with the postegres specific sql ?
Actions
5. Re: jboss jboss-4.0.3RC2/Portal Forum/Postgresql

svan9420 Sep 25, 2005 10:38 AM (in response to svan9420)
Certainly!!

ALTER TABLE portal.jbp_forums_posts ALTER jbp_text TYPE text;

I have my all my portal tables in the schema called portal.

Thanks
Actions

Go to original post