2008-02-01 05:51:00,084 DEBUG [redaxScheduler_Worker-4] scheduler.AppCtxAwareWorkflowJob (AppCtxAwareWorkflowJob.java:55) - entering executeInternal
Hibernate: select this_.admin_id as admin1_11_0_, this_.active as active11_0_, this_.mail_address as mail3_11_0_, this_.name as name11_0_, this_.password as password11_0_ from administrator this_ where this_.name=?
Hibernate: select userbean0_.person_id as person1_10_0_, userbean0_.active as active10_0_, userbean0_.mail_address as mail3_10_0_, userbean0_.name as name10_0_ from person userbean0_ where userbean0_.person_id=?
Hibernate: select magazinebe0_.magazine_id as magazine1_3_, magazinebe0_.chief_editor_id as chief7_3_, magazinebe0_.default_category_id as default8_3_, magazinebe0_.description as descript2_3_, magazinebe0_.name as name3_, magazinebe0_.skin_name as skin4_3_, magazinebe0_.teaser_image_size as teaser5_3_, magazinebe0_.title as title3_ from magazine magazinebe0_, chief_editor chiefedito1_ where magazinebe0_.chief_editor_id=chiefedito1_.chief_editor_id and (chiefedito1_.person_id=? or ? in (select userbean3_.person_id from editor editors2_, person userbean3_ where magazinebe0_.magazine_id=editors2_.magazine_id and editors2_.person_id=userbean3_.person_id)) order by magazinebe0_.magazine_id
Hibernate: select chiefedito0_.chief_editor_id as chief1_12_1_, chiefedito0_.person_id as person2_12_1_, userbean1_.person_id as person1_10_0_, userbean1_.active as active10_0_, userbean1_.mail_address as mail3_10_0_, userbean1_.name as name10_0_ from chief_editor chiefedito0_ inner join person userbean1_ on chiefedito0_.person_id=userbean1_.person_id where chiefedito0_.chief_editor_id=?
Hibernate: select categorybe0_.category_id as category1_4_8_, categorybe0_.description as descript2_4_8_, categorybe0_.magazine_id as magazine6_4_8_, categorybe0_.name as name4_8_, categorybe0_.published_articles_limit as published4_4_8_, categorybe0_.title as title4_8_, magazinebe1_.magazine_id as magazine1_3_0_, magazinebe1_.chief_editor_id as chief7_3_0_, magazinebe1_.default_category_id as default8_3_0_, magazinebe1_.description as descript2_3_0_, magazinebe1_.name as name3_0_, magazinebe1_.skin_name as skin4_3_0_, magazinebe1_.teaser_image_size as teaser5_3_0_, magazinebe1_.title as title3_0_, chiefedito2_.chief_editor_id as chief1_12_1_, chiefedito2_.person_id as person2_12_1_, userbean3_.person_id as person1_10_2_, userbean3_.active as active10_2_, userbean3_.mail_address as mail3_10_2_, userbean3_.name as name10_2_, categorybe4_.category_id as category1_4_3_, categorybe4_.description as descript2_4_3_, categorybe4_.magazine_id as magazine6_4_3_, categorybe4_.name as name4_3_, categorybe4_.published_articles_limit as published4_4_3_, categorybe4_.title as title4_3_, documents5_.magazine_id as magazine5_10_, documents5_.article_id as article1_10_, documents5_.idx as idx10_, documents5_.article_id as article1_0_4_, documents5_1_.archived as archived0_4_, documents5_1_.author_id as author5_0_4_, documents5_1_.content_id as content6_0_4_, documents5_1_.last_modified as last3_0_4_, documents5_1_.schema_name as schema4_0_4_, documents5_.magazine_id as magazine5_5_4_, documents5_.name as name5_4_, documents5_.document_type as document3_5_4_, documents5_.visible as visible5_4_, userbean6_.person_id as person1_10_5_, userbean6_.active as active10_5_, userbean6_.mail_address as mail3_10_5_, userbean6_.name as name10_5_, articlecon7_.content_id as content1_13_6_, articlecon7_.xml_data as xml2_13_6_, articlecon7_.external_author as external3_13_6_, articlecon7_.teaser as teaser13_6_, articlecon7_.teaser_image_id as teaser5_13_6_, articlecon7_.title as title13_6_, editors8_.magazine_id as magazine1_11_, userbean9_.person_id as person2_11_, userbean9_.person_id as person1_10_7_, userbean9_.active as active10_7_, userbean9_.mail_address as mail3_10_7_, userbean9_.name as name10_7_ from category categorybe0_ left outer join magazine magazinebe1_ on categorybe0_.magazine_id=magazinebe1_.magazine_id left outer join chief_editor chiefedito2_ on magazinebe1_.chief_editor_id=chiefedito2_.chief_editor_id left outer join person userbean3_ on chiefedito2_.person_id=userbean3_.person_id left outer join category categorybe4_ on magazinebe1_.default_category_id=categorybe4_.category_id left outer join magazine_document documents5_ on magazinebe1_.magazine_id=documents5_.magazine_id left outer join article documents5_1_ on documents5_.article_id=documents5_1_.article_id left outer join person userbean6_ on documents5_1_.author_id=userbean6_.person_id left outer join content articlecon7_ on documents5_1_.content_id=articlecon7_.content_id left outer join editor editors8_ on magazinebe1_.magazine_id=editors8_.magazine_id left outer join person userbean9_ on editors8_.person_id=userbean9_.person_id where categorybe0_.category_id=?
Hibernate: select chiefedito0_.chief_editor_id as chief1_12_1_, chiefedito0_.person_id as person2_12_1_, userbean1_.person_id as person1_10_0_, userbean1_.active as active10_0_, userbean1_.mail_address as mail3_10_0_, userbean1_.name as name10_0_ from chief_editor chiefedito0_ inner join person userbean1_ on chiefedito0_.person_id=userbean1_.person_id where chiefedito0_.chief_editor_id=?
Hibernate: select categorybe0_.category_id as category1_4_8_, categorybe0_.description as descript2_4_8_, categorybe0_.magazine_id as magazine6_4_8_, categorybe0_.name as name4_8_, categorybe0_.published_articles_limit as published4_4_8_, categorybe0_.title as title4_8_, magazinebe1_.magazine_id as magazine1_3_0_, magazinebe1_.chief_editor_id as chief7_3_0_, magazinebe1_.default_category_id as default8_3_0_, magazinebe1_.description as descript2_3_0_, magazinebe1_.name as name3_0_, magazinebe1_.skin_name as skin4_3_0_, magazinebe1_.teaser_image_size as teaser5_3_0_, magazinebe1_.title as title3_0_, chiefedito2_.chief_editor_id as chief1_12_1_, chiefedito2_.person_id as person2_12_1_, userbean3_.person_id as person1_10_2_, userbean3_.active as active10_2_, userbean3_.mail_address as mail3_10_2_, userbean3_.name as name10_2_, categorybe4_.category_id as category1_4_3_, categorybe4_.description as descript2_4_3_, categorybe4_.magazine_id as magazine6_4_3_, categorybe4_.name as name4_3_, categorybe4_.published_articles_limit as published4_4_3_, categorybe4_.title as title4_3_, documents5_.magazine_id as magazine5_10_, documents5_.article_id as article1_10_, documents5_.idx as idx10_, documents5_.article_id as article1_0_4_, documents5_1_.archived as archived0_4_, documents5_1_.author_id as author5_0_4_, documents5_1_.content_id as content6_0_4_, documents5_1_.last_modified as last3_0_4_, documents5_1_.schema_name as schema4_0_4_, documents5_.magazine_id as magazine5_5_4_, documents5_.name as name5_4_, documents5_.document_type as document3_5_4_, documents5_.visible as visible5_4_, userbean6_.person_id as person1_10_5_, userbean6_.active as active10_5_, userbean6_.mail_address as mail3_10_5_, userbean6_.name as name10_5_, articlecon7_.content_id as content1_13_6_, articlecon7_.xml_data as xml2_13_6_, articlecon7_.external_author as external3_13_6_, articlecon7_.teaser as teaser13_6_, articlecon7_.teaser_image_id as teaser5_13_6_, articlecon7_.title as title13_6_, editors8_.magazine_id as magazine1_11_, userbean9_.person_id as person2_11_, userbean9_.person_id as person1_10_7_, userbean9_.active as active10_7_, userbean9_.mail_address as mail3_10_7_, userbean9_.name as name10_7_ from category categorybe0_ left outer join magazine magazinebe1_ on categorybe0_.magazine_id=magazinebe1_.magazine_id left outer join chief_editor chiefedito2_ on magazinebe1_.chief_editor_id=chiefedito2_.chief_editor_id left outer join person userbean3_ on chiefedito2_.person_id=userbean3_.person_id left outer join category categorybe4_ on magazinebe1_.default_category_id=categorybe4_.category_id left outer join magazine_document documents5_ on magazinebe1_.magazine_id=documents5_.magazine_id left outer join article documents5_1_ on documents5_.article_id=documents5_1_.article_id left outer join person userbean6_ on documents5_1_.author_id=userbean6_.person_id left outer join content articlecon7_ on documents5_1_.content_id=articlecon7_.content_id left outer join editor editors8_ on magazinebe1_.magazine_id=editors8_.magazine_id left outer join person userbean9_ on editors8_.person_id=userbean9_.person_id where categorybe0_.category_id=?
Hibernate: select chiefedito0_.chief_editor_id as chief1_12_1_, chiefedito0_.person_id as person2_12_1_, userbean1_.person_id as person1_10_0_, userbean1_.active as active10_0_, userbean1_.mail_address as mail3_10_0_, userbean1_.name as name10_0_ from chief_editor chiefedito0_ inner join person userbean1_ on chiefedito0_.person_id=userbean1_.person_id where chiefedito0_.chief_editor_id=?
Hibernate: select categorybe0_.category_id as category1_4_8_, categorybe0_.description as descript2_4_8_, categorybe0_.magazine_id as magazine6_4_8_, categorybe0_.name as name4_8_, categorybe0_.published_articles_limit as published4_4_8_, categorybe0_.title as title4_8_, magazinebe1_.magazine_id as magazine1_3_0_, magazinebe1_.chief_editor_id as chief7_3_0_, magazinebe1_.default_category_id as default8_3_0_, magazinebe1_.description as descript2_3_0_, magazinebe1_.name as name3_0_, magazinebe1_.skin_name as skin4_3_0_, magazinebe1_.teaser_image_size as teaser5_3_0_, magazinebe1_.title as title3_0_, chiefedito2_.chief_editor_id as chief1_12_1_, chiefedito2_.person_id as person2_12_1_, userbean3_.person_id as person1_10_2_, userbean3_.active as active10_2_, userbean3_.mail_address as mail3_10_2_, userbean3_.name as name10_2_, categorybe4_.category_id as category1_4_3_, categorybe4_.description as descript2_4_3_, categorybe4_.magazine_id as magazine6_4_3_, categorybe4_.name as name4_3_, categorybe4_.published_articles_limit as published4_4_3_, categorybe4_.title as title4_3_, documents5_.magazine_id as magazine5_10_, documents5_.article_id as article1_10_, documents5_.idx as idx10_, documents5_.article_id as article1_0_4_, documents5_1_.archived as archived0_4_, documents5_1_.author_id as author5_0_4_, documents5_1_.content_id as content6_0_4_, documents5_1_.last_modified as last3_0_4_, documents5_1_.schema_name as schema4_0_4_, documents5_.magazine_id as magazine5_5_4_, documents5_.name as name5_4_, documents5_.document_type as document3_5_4_, documents5_.visible as visible5_4_, userbean6_.person_id as person1_10_5_, userbean6_.active as active10_5_, userbean6_.mail_address as mail3_10_5_, userbean6_.name as name10_5_, articlecon7_.content_id as content1_13_6_, articlecon7_.xml_data as xml2_13_6_, articlecon7_.external_author as external3_13_6_, articlecon7_.teaser as teaser13_6_, articlecon7_.teaser_image_id as teaser5_13_6_, articlecon7_.title as title13_6_, editors8_.magazine_id as magazine1_11_, userbean9_.person_id as person2_11_, userbean9_.person_id as person1_10_7_, userbean9_.active as active10_7_, userbean9_.mail_address as mail3_10_7_, userbean9_.name as name10_7_ from category categorybe0_ left outer join magazine magazinebe1_ on categorybe0_.magazine_id=magazinebe1_.magazine_id left outer join chief_editor chiefedito2_ on magazinebe1_.chief_editor_id=chiefedito2_.chief_editor_id left outer join person userbean3_ on chiefedito2_.person_id=userbean3_.person_id left outer join category categorybe4_ on magazinebe1_.default_category_id=categorybe4_.category_id left outer join magazine_document documents5_ on magazinebe1_.magazine_id=documents5_.magazine_id left outer join article documents5_1_ on documents5_.article_id=documents5_1_.article_id left outer join person userbean6_ on documents5_1_.author_id=userbean6_.person_id left outer join content articlecon7_ on documents5_1_.content_id=articlecon7_.content_id left outer join editor editors8_ on magazinebe1_.magazine_id=editors8_.magazine_id left outer join person userbean9_ on editors8_.person_id=userbean9_.person_id where categorybe0_.category_id=?
Hibernate: select categories0_.magazine_id as magazine6_1_, categories0_.category_id as category1_1_, categories0_.idx as idx1_, categories0_.category_id as category1_4_0_, categories0_.description as descript2_4_0_, categories0_.magazine_id as magazine6_4_0_, categories0_.name as name4_0_, categories0_.published_articles_limit as published4_4_0_, categories0_.title as title4_0_ from category categories0_ where categories0_.magazine_id=?
Hibernate: select categories0_.magazine_id as magazine6_1_, categories0_.category_id as category1_1_, categories0_.idx as idx1_, categories0_.category_id as category1_4_0_, categories0_.description as descript2_4_0_, categories0_.magazine_id as magazine6_4_0_, categories0_.name as name4_0_, categories0_.published_articles_limit as published4_4_0_, categories0_.title as title4_0_ from category categories0_ where categories0_.magazine_id=?
Hibernate: select categories0_.magazine_id as magazine6_1_, categories0_.category_id as category1_1_, categories0_.idx as idx1_, categories0_.category_id as category1_4_0_, categories0_.description as descript2_4_0_, categories0_.magazine_id as magazine6_4_0_, categories0_.name as name4_0_, categories0_.published_articles_limit as published4_4_0_, categories0_.title as title4_0_ from category categories0_ where categories0_.magazine_id=?
Hibernate: select magazinebe0_.magazine_id as magazine1_3_, magazinebe0_.chief_editor_id as chief7_3_, magazinebe0_.default_category_id as default8_3_, magazinebe0_.description as descript2_3_, magazinebe0_.name as name3_, magazinebe0_.skin_name as skin4_3_, magazinebe0_.teaser_image_size as teaser5_3_, magazinebe0_.title as title3_ from magazine magazinebe0_, chief_editor chiefedito1_ where magazinebe0_.chief_editor_id=chiefedito1_.chief_editor_id and (chiefedito1_.person_id=? or ? in (select userbean3_.person_id from editor editors2_, person userbean3_ where magazinebe0_.magazine_id=editors2_.magazine_id and editors2_.person_id=userbean3_.person_id)) order by magazinebe0_.magazine_id
Hibernate: select chiefedito0_.chief_editor_id as chief1_12_1_, chiefedito0_.person_id as person2_12_1_, userbean1_.person_id as person1_10_0_, userbean1_.active as active10_0_, userbean1_.mail_address as mail3_10_0_, userbean1_.name as name10_0_ from chief_editor chiefedito0_ inner join person userbean1_ on chiefedito0_.person_id=userbean1_.person_id where chiefedito0_.chief_editor_id=?
Hibernate: select categorybe0_.category_id as category1_4_8_, categorybe0_.description as descript2_4_8_, categorybe0_.magazine_id as magazine6_4_8_, categorybe0_.name as name4_8_, categorybe0_.published_articles_limit as published4_4_8_, categorybe0_.title as title4_8_, magazinebe1_.magazine_id as magazine1_3_0_, magazinebe1_.chief_editor_id as chief7_3_0_, magazinebe1_.default_category_id as default8_3_0_, magazinebe1_.description as descript2_3_0_, magazinebe1_.name as name3_0_, magazinebe1_.skin_name as skin4_3_0_, magazinebe1_.teaser_image_size as teaser5_3_0_, magazinebe1_.title as title3_0_, chiefedito2_.chief_editor_id as chief1_12_1_, chiefedito2_.person_id as person2_12_1_, userbean3_.person_id as person1_10_2_, userbean3_.active as active10_2_, userbean3_.mail_address as mail3_10_2_, userbean3_.name as name10_2_, categorybe4_.category_id as category1_4_3_, categorybe4_.description as descript2_4_3_, categorybe4_.magazine_id as magazine6_4_3_, categorybe4_.name as name4_3_, categorybe4_.published_articles_limit as published4_4_3_, categorybe4_.title as title4_3_, documents5_.magazine_id as magazine5_10_, documents5_.article_id as article1_10_, documents5_.idx as idx10_, documents5_.article_id as article1_0_4_, documents5_1_.archived as archived0_4_, documents5_1_.author_id as author5_0_4_, documents5_1_.content_id as content6_0_4_, documents5_1_.last_modified as last3_0_4_, documents5_1_.schema_name as schema4_0_4_, documents5_.magazine_id as magazine5_5_4_, documents5_.name as name5_4_, documents5_.document_type as document3_5_4_, documents5_.visible as visible5_4_, userbean6_.person_id as person1_10_5_, userbean6_.active as active10_5_, userbean6_.mail_address as mail3_10_5_, userbean6_.name as name10_5_, articlecon7_.content_id as content1_13_6_, articlecon7_.xml_data as xml2_13_6_, articlecon7_.external_author as external3_13_6_, articlecon7_.teaser as teaser13_6_, articlecon7_.teaser_image_id as teaser5_13_6_, articlecon7_.title as title13_6_, editors8_.magazine_id as magazine1_11_, userbean9_.person_id as person2_11_, userbean9_.person_id as person1_10_7_, userbean9_.active as active10_7_, userbean9_.mail_address as mail3_10_7_, userbean9_.name as name10_7_ from category categorybe0_ left outer join magazine magazinebe1_ on categorybe0_.magazine_id=magazinebe1_.magazine_id left outer join chief_editor chiefedito2_ on magazinebe1_.chief_editor_id=chiefedito2_.chief_editor_id left outer join person userbean3_ on chiefedito2_.person_id=userbean3_.person_id left outer join category categorybe4_ on magazinebe1_.default_category_id=categorybe4_.category_id left outer join magazine_document documents5_ on magazinebe1_.magazine_id=documents5_.magazine_id left outer join article documents5_1_ on documents5_.article_id=documents5_1_.article_id left outer join person userbean6_ on documents5_1_.author_id=userbean6_.person_id left outer join content articlecon7_ on documents5_1_.content_id=articlecon7_.content_id left outer join editor editors8_ on magazinebe1_.magazine_id=editors8_.magazine_id left outer join person userbean9_ on editors8_.person_id=userbean9_.person_id where categorybe0_.category_id=?
Hibernate: select chiefedito0_.chief_editor_id as chief1_12_1_, chiefedito0_.person_id as person2_12_1_, userbean1_.person_id as person1_10_0_, userbean1_.active as active10_0_, userbean1_.mail_address as mail3_10_0_, userbean1_.name as name10_0_ from chief_editor chiefedito0_ inner join person userbean1_ on chiefedito0_.person_id=userbean1_.person_id where chiefedito0_.chief_editor_id=?
Hibernate: select categorybe0_.category_id as category1_4_8_, categorybe0_.description as descript2_4_8_, categorybe0_.magazine_id as magazine6_4_8_, categorybe0_.name as name4_8_, categorybe0_.published_articles_limit as published4_4_8_, categorybe0_.title as title4_8_, magazinebe1_.magazine_id as magazine1_3_0_, magazinebe1_.chief_editor_id as chief7_3_0_, magazinebe1_.default_category_id as default8_3_0_, magazinebe1_.description as descript2_3_0_, magazinebe1_.name as name3_0_, magazinebe1_.skin_name as skin4_3_0_, magazinebe1_.teaser_image_size as teaser5_3_0_, magazinebe1_.title as title3_0_, chiefedito2_.chief_editor_id as chief1_12_1_, chiefedito2_.person_id as person2_12_1_, userbean3_.person_id as person1_10_2_, userbean3_.active as active10_2_, userbean3_.mail_address as mail3_10_2_, userbean3_.name as name10_2_, categorybe4_.category_id as category1_4_3_, categorybe4_.description as descript2_4_3_, categorybe4_.magazine_id as magazine6_4_3_, categorybe4_.name as name4_3_, categorybe4_.published_articles_limit as published4_4_3_, categorybe4_.title as title4_3_, documents5_.magazine_id as magazine5_10_, documents5_.article_id as article1_10_, documents5_.idx as idx10_, documents5_.article_id as article1_0_4_, documents5_1_.archived as archived0_4_, documents5_1_.author_id as author5_0_4_, documents5_1_.content_id as content6_0_4_, documents5_1_.last_modified as last3_0_4_, documents5_1_.schema_name as schema4_0_4_, documents5_.magazine_id as magazine5_5_4_, documents5_.name as name5_4_, documents5_.document_type as document3_5_4_, documents5_.visible as visible5_4_, userbean6_.person_id as person1_10_5_, userbean6_.active as active10_5_, userbean6_.mail_address as mail3_10_5_, userbean6_.name as name10_5_, articlecon7_.content_id as content1_13_6_, articlecon7_.xml_data as xml2_13_6_, articlecon7_.external_author as external3_13_6_, articlecon7_.teaser as teaser13_6_, articlecon7_.teaser_image_id as teaser5_13_6_, articlecon7_.title as title13_6_, editors8_.magazine_id as magazine1_11_, userbean9_.person_id as person2_11_, userbean9_.person_id as person1_10_7_, userbean9_.active as active10_7_, userbean9_.mail_address as mail3_10_7_, userbean9_.name as name10_7_ from category categorybe0_ left outer join magazine magazinebe1_ on categorybe0_.magazine_id=magazinebe1_.magazine_id left outer join chief_editor chiefedito2_ on magazinebe1_.chief_editor_id=chiefedito2_.chief_editor_id left outer join person userbean3_ on chiefedito2_.person_id=userbean3_.person_id left outer join category categorybe4_ on magazinebe1_.default_category_id=categorybe4_.category_id left outer join magazine_document documents5_ on magazinebe1_.magazine_id=documents5_.magazine_id left outer join article documents5_1_ on documents5_.article_id=documents5_1_.article_id left outer join person userbean6_ on documents5_1_.author_id=userbean6_.person_id left outer join content articlecon7_ on documents5_1_.content_id=articlecon7_.content_id left outer join editor editors8_ on magazinebe1_.magazine_id=editors8_.magazine_id left outer join person userbean9_ on editors8_.person_id=userbean9_.person_id where categorybe0_.category_id=?
Hibernate: select chiefedito0_.chief_editor_id as chief1_12_1_, chiefedito0_.person_id as person2_12_1_, userbean1_.person_id as person1_10_0_, userbean1_.active as active10_0_, userbean1_.mail_address as mail3_10_0_, userbean1_.name as name10_0_ from chief_editor chiefedito0_ inner join person userbean1_ on chiefedito0_.person_id=userbean1_.person_id where chiefedito0_.chief_editor_id=?
Hibernate: select categorybe0_.category_id as category1_4_8_, categorybe0_.description as descript2_4_8_, categorybe0_.magazine_id as magazine6_4_8_, categorybe0_.name as name4_8_, categorybe0_.published_articles_limit as published4_4_8_, categorybe0_.title as title4_8_, magazinebe1_.magazine_id as magazine1_3_0_, magazinebe1_.chief_editor_id as chief7_3_0_, magazinebe1_.default_category_id as default8_3_0_, magazinebe1_.description as descript2_3_0_, magazinebe1_.name as name3_0_, magazinebe1_.skin_name as skin4_3_0_, magazinebe1_.teaser_image_size as teaser5_3_0_, magazinebe1_.title as title3_0_, chiefedito2_.chief_editor_id as chief1_12_1_, chiefedito2_.person_id as person2_12_1_, userbean3_.person_id as person1_10_2_, userbean3_.active as active10_2_, userbean3_.mail_address as mail3_10_2_, userbean3_.name as name10_2_, categorybe4_.category_id as category1_4_3_, categorybe4_.description as descript2_4_3_, categorybe4_.magazine_id as magazine6_4_3_, categorybe4_.name as name4_3_, categorybe4_.published_articles_limit as published4_4_3_, categorybe4_.title as title4_3_, documents5_.magazine_id as magazine5_10_, documents5_.article_id as article1_10_, documents5_.idx as idx10_, documents5_.article_id as article1_0_4_, documents5_1_.archived as archived0_4_, documents5_1_.author_id as author5_0_4_, documents5_1_.content_id as content6_0_4_, documents5_1_.last_modified as last3_0_4_, documents5_1_.schema_name as schema4_0_4_, documents5_.magazine_id as magazine5_5_4_, documents5_.name as name5_4_, documents5_.document_type as document3_5_4_, documents5_.visible as visible5_4_, userbean6_.person_id as person1_10_5_, userbean6_.active as active10_5_, userbean6_.mail_address as mail3_10_5_, userbean6_.name as name10_5_, articlecon7_.content_id as content1_13_6_, articlecon7_.xml_data as xml2_13_6_, articlecon7_.external_author as external3_13_6_, articlecon7_.teaser as teaser13_6_, articlecon7_.teaser_image_id as teaser5_13_6_, articlecon7_.title as title13_6_, editors8_.magazine_id as magazine1_11_, userbean9_.person_id as person2_11_, userbean9_.person_id as person1_10_7_, userbean9_.active as active10_7_, userbean9_.mail_address as mail3_10_7_, userbean9_.name as name10_7_ from category categorybe0_ left outer join magazine magazinebe1_ on categorybe0_.magazine_id=magazinebe1_.magazine_id left outer join chief_editor chiefedito2_ on magazinebe1_.chief_editor_id=chiefedito2_.chief_editor_id left outer join person userbean3_ on chiefedito2_.person_id=userbean3_.person_id left outer join category categorybe4_ on magazinebe1_.default_category_id=categorybe4_.category_id left outer join magazine_document documents5_ on magazinebe1_.magazine_id=documents5_.magazine_id left outer join article documents5_1_ on documents5_.article_id=documents5_1_.article_id left outer join person userbean6_ on documents5_1_.author_id=userbean6_.person_id left outer join content articlecon7_ on documents5_1_.content_id=articlecon7_.content_id left outer join editor editors8_ on magazinebe1_.magazine_id=editors8_.magazine_id left outer join person userbean9_ on editors8_.person_id=userbean9_.person_id where categorybe0_.category_id=?
Hibernate: select categories0_.magazine_id as magazine6_1_, categories0_.category_id as category1_1_, categories0_.idx as idx1_, categories0_.category_id as category1_4_0_, categories0_.description as descript2_4_0_, categories0_.magazine_id as magazine6_4_0_, categories0_.name as name4_0_, categories0_.published_articles_limit as published4_4_0_, categories0_.title as title4_0_ from category categories0_ where categories0_.magazine_id=?
Hibernate: select categories0_.magazine_id as magazine6_1_, categories0_.category_id as category1_1_, categories0_.idx as idx1_, categories0_.category_id as category1_4_0_, categories0_.description as descript2_4_0_, categories0_.magazine_id as magazine6_4_0_, categories0_.name as name4_0_, categories0_.published_articles_limit as published4_4_0_, categories0_.title as title4_0_ from category categories0_ where categories0_.magazine_id=?
Hibernate: select categories0_.magazine_id as magazine6_1_, categories0_.category_id as category1_1_, categories0_.idx as idx1_, categories0_.category_id as category1_4_0_, categories0_.description as descript2_4_0_, categories0_.magazine_id as magazine6_4_0_, categories0_.name as name4_0_, categories0_.published_articles_limit as published4_4_0_, categories0_.title as title4_0_ from category categories0_ where categories0_.magazine_id=?
Hibernate: select editedarti0_.article_id as article1_0_2_, editedarti0_1_.archived as archived0_2_, editedarti0_1_.author_id as author5_0_2_, editedarti0_1_.content_id as content6_0_2_, editedarti0_1_.last_modified as last3_0_2_, editedarti0_1_.schema_name as schema4_0_2_, editedarti0_.approval_time_limit as approval2_2_2_, editedarti0_.author_approval as author3_2_2_, editedarti0_.base_article_id as base11_2_2_, editedarti0_.category_id as category10_2_2_, editedarti0_.comment_policy as comment4_2_2_, editedarti0_.editor_id as editor13_2_2_, editedarti0_.expiration_date as expiration5_2_2_, editedarti0_.magazine_id as magazine12_2_2_, editedarti0_.publication_date as publicat6_2_2_, editedarti0_.published as published2_2_, editedarti0_.superseded_article_id as superseded14_2_2_, editedarti0_.temporarily_offline_date as temporar8_2_2_, editedarti0_.temporarilyOffline as temporar9_2_2_, userbean1_.person_id as person1_10_0_, userbean1_.active as active10_0_, userbean1_.mail_address as mail3_10_0_, userbean1_.name as name10_0_, articlecon2_.content_id as content1_13_1_, articlecon2_.xml_data as xml2_13_1_, articlecon2_.external_author as external3_13_1_, articlecon2_.teaser as teaser13_1_, articlecon2_.teaser_image_id as teaser5_13_1_, articlecon2_.title as title13_1_ from edited_article editedarti0_ inner join article editedarti0_1_ on editedarti0_.article_id=editedarti0_1_.article_id left outer join person userbean1_ on editedarti0_1_.author_id=userbean1_.person_id left outer join content articlecon2_ on editedarti0_1_.content_id=articlecon2_.content_id where editedarti0_.article_id=?
Hibernate: update content set xml_data=?, external_author=?, teaser=?, teaser_image_id=?, title=? where content_id=?
2008-02-01 05:51:00,342 WARN [redaxScheduler_Worker-4] util.JDBCExceptionReporter (JDBCExceptionReporter.java:77) - SQL Error: 0, SQLState: null
2008-02-01 05:51:00,343 ERROR [redaxScheduler_Worker-4] util.JDBCExceptionReporter (JDBCExceptionReporter.java:78) - Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.
2008-02-01 05:51:00,344 WARN [redaxScheduler_Worker-4] util.JDBCExceptionReporter (JDBCExceptionReporter.java:77) - SQL Error: 0, SQLState: 25006
2008-02-01 05:51:00,344 ERROR [redaxScheduler_Worker-4] util.JDBCExceptionReporter (JDBCExceptionReporter.java:78) - ERROR: transaction is read-only
2008-02-01 05:51:00,349 ERROR [redaxScheduler_Worker-4] def.AbstractFlushingEventListener (AbstractFlushingEventListener.java:301) - 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:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:578)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:104)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy53.getEditedArticle(Unknown Source)
at com.scanplus.redax.scheduler.AutoPublishJob.executeWorkflowAction(AutoPublishJob.java:28)
at com.scanplus.redax.scheduler.AppCtxAwareWorkflowJob.executeInternal(AppCtxAwareWorkflowJob.java:83)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.BatchUpdateException: Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 22 more
2008-02-01 05:51:00,379 INFO [redaxScheduler_Worker-4] xml.XmlBeanDefinitionReader (XmlBeanDefinitionReader.java:303) - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2008-02-01 05:51:00,430 INFO [redaxScheduler_Worker-4] support.SQLErrorCodesFactory (SQLErrorCodesFactory.java:128) - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2008-02-01 05:51:00,445 ERROR [redaxScheduler_Worker-4] core.JobRunShell (JobRunShell.java:212) - Job DEFAULT.autoPublishJob:1 threw an unhandled Exception:
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [update content set xml_data=?, external_author=?, teaser=?, teaser_image_id=?, title=? where content_id=?]; SQL state [null]; error code [0]; Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.; nested exception is java.sql.BatchUpdateException: Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.
Caused by:
java.sql.BatchUpdateException: Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:578)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:104)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy53.getEditedArticle(Unknown Source)
at com.scanplus.redax.scheduler.AutoPublishJob.executeWorkflowAction(AutoPublishJob.java:28)
at com.scanplus.redax.scheduler.AppCtxAwareWorkflowJob.executeInternal(AppCtxAwareWorkflowJob.java:83)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
2008-02-01 05:51:00,447 ERROR [redaxScheduler_Worker-4] core.ErrorLogger (QuartzScheduler.java:2015) - Job (DEFAULT.autoPublishJob:1 threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [update content set xml_data=?, external_author=?, teaser=?, teaser_image_id=?, title=? where content_id=?]; SQL state [null]; error code [0]; Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.; nested exception is java.sql.BatchUpdateException: Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.]
at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
* Nested Exception (Underlying Cause) ---------------
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [update content set xml_data=?, external_author=?, teaser=?, teaser_image_id=?, title=? where content_id=?]; SQL state [null]; error code [0]; Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.; nested exception is java.sql.BatchUpdateException: Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.
Caused by:
java.sql.BatchUpdateException: Batch entry 0 update content set xml_data=
yxcvyxcvyxcv
, external_author=, teaser=sdfgsdfgsdfg, teaser_image_id=cf04b1c996c94194b9741901761b1e20, title=ygsadfgsdfg where content_id=1 was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:578)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:104)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy53.getEditedArticle(Unknown Source)
at com.scanplus.redax.scheduler.AutoPublishJob.executeWorkflowAction(AutoPublishJob.java:28)
at com.scanplus.redax.scheduler.AppCtxAwareWorkflowJob.executeInternal(AppCtxAwareWorkflowJob.java:83)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)