Hi I am getting following exception while deploying hello bpel example. The exception says that there are any too many tables in the query. The maximum allowable tables is 50. I want if any one else has similar exception. I know this seems to be database limitation. But is there any way that I can change hibernate setting to reduce the number of tables .

Below is the exception thanks for your help.

2006-03-21 17:21:39,950 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not initialize a collection: [org.jbpm.graph.def.ProcessDefinition.nodes#1] [select nodes0_.PROCESSDEFINITION_ as PROCESSD4_52_, nodes0_.ID_ as ID1_52_, nodes0_.NODECOLLECTIONINDEX_ as NODECOL34_52_, nodes0_.ID_ as ID1_1_51_, nodes0_.NAME_ as NAME3_1_51_, nodes0_.PROCESSDEFINITION_ as PROCESSD4_1_51_, nodes0_.ACTION_ as ACTION5_1_51_, nodes0_.SUPERSTATE_ as SUPERSTATE6_1_51_, nodes0_.SUBPROCESSDEFINITION_ as SUBPROCE7_1_51_, nodes0_.DECISIONDELEGATION as DECISION8_1_51_, nodes0_.SIGNAL_ as SIGNAL9_1_51_, nodes0_.CREATETASKS_ as CREATET10_1_51_, nodes0_.SUPRJOINFAILURE_ as SUPRJOI11_1_51_, nodes0_.COMPOSITEACTIVITY_ as COMPOSI12_1_51_, nodes0_.JOINCONDITION_ as JOINCON13_1_51_, nodes0_.RECEIVER_ as RECEIVER14_1_51_, nodes0_.CREATEINSTANCE_ as CREATEI15_1_51_, nodes0_.REPLIER_ as REPLIER16_1_51_, nodes0_.INVOKER_ as INVOKER17_1_51_, nodes0_.FAULTNAMELOCALPART_ as FAULTNA18_1_51_, nodes0_.FAULNAMETPATH_ as FAULNAM19_1_51_, nodes0_.FAULTVARIABLE_ as FAULTVA20_1_51_, nodes0_.ALARM_ as ALARM21_1_51_, nodes0_.SCOPE_ as SCOPE22_1_51_, nodes0_.CONDITION_ as CONDITION23_1_51_, nodes0_.WHILE_ as WHILE24_1_51_, nodes0_.STARTSTRUCTURE_ as STARTST25_1_51_, nodes0_.ENDSTRUCTURE_ as ENDSTRU26_1_51_, nodes0_.IMPLICIT_ as IMPLICIT27_1_51_, nodes0_.ISOLATED_ as ISOLATED28_1_51_, nodes0_.ACTIVITY_ as ACTIVITY29_1_51_, nodes0_.FAULTLOCALPART_ as FAULTLO30_1_51_, nodes0_.FAULTPATH_ as FAULTPATH31_1_51_, nodes0_.HDLRRECEIVER_ as HDLRREC32_1_51_, nodes0_.HDLRALARM_ as HDLRALARM33_1_51_, nodes0_.CLASS_ as CLASS2_1_51_, action1_.ID_ as ID1_4_0_, action1_.NAME_ as NAME3_4_0_, action1_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_0_, action1_.REFERENCEDACTION_ as REFERENC5_4_0_, action1_.ACTIONDELEGATION_ as ACTIONDE6_4_0_, action1_.EVENT_ as EVENT7_4_0_, action1_.PROCESSDEFINITION_ as PROCESSD8_4_0_, action2_.ID_ as ID1_4_1_, action2_.NAME_ as NAME3_4_1_, action2_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_1_, action2_.REFERENCEDACTION_ as REFERENC5_4_1_, action2_.ACTIONDELEGATION_ as ACTIONDE6_4_1_, action2_.EVENT_ as EVENT7_4_1_, action2_.PROCESSDEFINITION_ as PROCESSD8_4_1_, delegation3_.ID_ as ID1_6_2_, delegation3_.CLASSNAME_ as CLASSNAME2_6_2_, delegation3_.CONFIGURATION_ as CONFIGUR3_6_2_, delegation3_.CONFIGTYPE_ as CONFIGTYPE4_6_2_, delegation3_.PROCESSDEFINITION_ as PROCESSD5_6_2_, processdef4_.ID_ as ID1_0_3_, processdef4_.NAME_ as NAME3_0_3_, processdef4_.VERSION_ as VERSION4_0_3_, processdef4_.ISTERMINATIONIMPLICIT_ as ISTERMIN5_0_3_, processdef4_.STARTSTATE_ as STARTSTATE6_0_3_, processdef4_.TARGETNAMESPACE_ as TARGETNA7_0_3_, processdef4_.ENABLECOMPENSATION_ as ENABLECO8_0_3_, processdef4_.EXPRESSIONLANG_ as EXPRESSI9_0_3_, processdef4_.QUERYLANG_ as QUERYLANG10_0_3_, processdef4_.ABSTRACT_ as ABSTRACT11_0_3_, processdef4_.CLASS_ as CLASS2_0_3_, startstate5_.ID_ as ID1_1_4_, startstate5_.NAME_ as NAME3_1_4_, startstate5_.PROCESSDEFINITION_ as PROCESSD4_1_4_, startstate5_.ACTION_ as ACTION5_1_4_, startstate5_.SUPERSTATE_ as SUPERSTATE6_1_4_, superstate6_.ID_ as ID1_1_5_, superstate6_.NAME_ as NAME3_1_5_, superstate6_.PROCESSDEFINITION_ as PROCESSD4_1_5_, superstate6_.ACTION_ as ACTION5_1_5_, superstate6_.SUPERSTATE_ as SUPERSTATE6_1_5_, event7_.ID_ as ID1_3_6_, event7_.EVENTTYPE_ as EVENTTYPE2_3_6_, event7_.TYPE_ as TYPE3_3_6_, event7_.GRAPHELEMENT_ as GRAPHELE4_3_6_, processdef8_.ID_ as ID1_0_7_, processdef8_.NAME_ as NAME3_0_7_, processdef8_.VERSION_ as VERSION4_0_7_, processdef8_.ISTERMINATIONIMPLICIT_ as ISTERMIN5_0_7_, processdef8_.STARTSTATE_ as STARTSTATE6_0_7_, processdef8_.TARGETNAMESPACE_ as TARGETNA7_0_7_, processdef8_.ENABLECOMPENSATION_ as ENABLECO8_0_7_, processdef8_.EXPRESSIONLANG_ as EXPRESSI9_0_7_, processdef8_.QUERYLANG_ as QUERYLANG10_0_7_, processdef8_.ABSTRACT_ as ABSTRACT11_0_7_, processdef8_.CLASS_ as CLASS2_0_7_, processdef9_.ID_ as ID1_0_8_, processdef9_.NAME_ as NAME3_0_8_, processdef9_.VERSION_ as VERSION4_0_8_, processdef9_.ISTERMINATIONIMPLICIT_ as ISTERMIN5_0_8_, processdef9_.STARTSTATE_ as STARTSTATE6_0_8_, processdef9_.TARGETNAMESPACE_ as TARGETNA7_0_8_, processdef9_.ENABLECOMPENSATION_ as ENABLECO8_0_8_, processdef9_.EXPRESSIONLANG_ as EXPRESSI9_0_8_, processdef9_.QUERYLANG_ as QUERYLANG10_0_8_, processdef9_.ABSTRACT_ as ABSTRACT11_0_8_, processdef9_.CLASS_ as CLASS2_0_8_, delegation10_.ID_ as ID1_6_9_, delegation10_.CLASSNAME_ as CLASSNAME2_6_9_, delegation10_.CONFIGURATION_ as CONFIGUR3_6_9_, delegation10_.CONFIGTYPE_ as CONFIGTYPE4_6_9_, delegation10_.PROCESSDEFINITION_ as PROCESSD5_6_9_, compositea11_.ID_ as ID1_1_10_, compositea11_.NAME_ as NAME3_1_10_, compositea11_.PROCESSDEFINITION_ as PROCESSD4_1_10_, compositea11_.ACTION_ as ACTION5_1_10_, compositea11_.SUPERSTATE_ as SUPERSTATE6_1_10_, compositea11_.SUPRJOINFAILURE_ as SUPRJOI11_1_10_, compositea11_.COMPOSITEACTIVITY_ as COMPOSI12_1_10_, compositea11_.JOINCONDITION_ as JOINCON13_1_10_, compositea11_.CREATEINSTANCE_ as CREATEI15_1_10_, compositea11_.CONDITION_ as CONDITION23_1_10_, compositea11_.IMPLICIT_ as IMPLICIT27_1_10_, compositea11_.ISOLATED_ as ISOLATED28_1_10_, compositea11_.SCOPE_ as SCOPE22_1_10_, compositea11_.ACTIVITY_ as ACTIVITY29_1_10_, compositea11_.FAULTVARIABLE_ as FAULTVA20_1_10_, compositea11_.FAULTLOCALPART_ as FAULTLO30_1_10_, compositea11_.FAULTPATH_ as FAULTPATH31_1_10_, compositea11_.HDLRRECEIVER_ as HDLRREC32_1_10_, compositea11_.HDLRALARM_ as HDLRALARM33_1_10_, compositea11_.CLASS_ as CLASS2_1_10_, snippet12_.ID_ as ID1_37_11_, snippet12_.TEXT_ as TEXT2_37_11_, snippet12_.LANGUAGE_ as LANGUAGE3_37_11_, snippet12_.USE_ as USE4_37_11_, structured13_.ID_ as ID1_1_12_, structured13_.NAME_ as NAME3_1_12_, structured13_.PROCESSDEFINITION_ as PROCESSD4_1_12_, structured13_.ACTION_ as ACTION5_1_12_, structured13_.SUPERSTATE_ as SUPERSTATE6_1_12_, structured13_.SUPRJOINFAILURE_ as SUPRJOI11_1_12_, structured13_.COMPOSITEACTIVITY_ as COMPOSI12_1_12_, structured13_.JOINCONDITION_ as JOINCON13_1_12_, structured13_.STARTSTRUCTURE_ as STARTST25_1_12_, structured14_.ID_ as ID1_1_13_, structured14_.NAME_ as NAME3_1_13_, structured14_.PROCESSDEFINITION_ as PROCESSD4_1_13_, structured14_.ACTION_ as ACTION5_1_13_, structured14_.SUPERSTATE_ as SUPERSTATE6_1_13_, structured14_.SUPRJOINFAILURE_ as SUPRJOI11_1_13_, structured14_.COMPOSITEACTIVITY_ as COMPOSI12_1_13_, structured14_.JOINCONDITION_ as JOINCON13_1_13_, structured14_.ENDSTRUCTURE_ as ENDSTRU26_1_13_, snippet15_.ID_ as ID1_37_14_, snippet15_.TEXT_ as TEXT2_37_14_, snippet15_.LANGUAGE_ as LANGUAGE3_37_14_, snippet15_.USE_ as USE4_37_14_, while_loop16_.ID_ as ID1_1_15_, while_loop16_.NAME_ as NAME3_1_15_, while_loop16_.PROCESSDEFINITION_ as PROCESSD4_1_15_, while_loop16_.ACTION_ as ACTION5_1_15_, while_loop16_.SUPERSTATE_ as SUPERSTATE6_1_15_, while_loop16_.SUPRJOINFAILURE_ as SUPRJOI11_1_15_, while_loop16_.COMPOSITEACTIVITY_ as COMPOSI12_1_15_, while_loop16_.JOINCONDITION_ as JOINCON13_1_15_, while_loop16_.WHILE_ as WHILE24_1_15_, scope17_.ID_ as ID1_1_16_, scope17_.NAME_ as NAME3_1_16_, scope17_.PROCESSDEFINITION_ as PROCESSD4_1_16_, scope17_.ACTION_ as ACTION5_1_16_, scope17_.SUPERSTATE_ as SUPERSTATE6_1_16_, scope17_.SUPRJOINFAILURE_ as SUPRJOI11_1_16_, scope17_.COMPOSITEACTIVITY_ as COMPOSI12_1_16_, scope17_.JOINCONDITION_ as JOINCON13_1_16_, scope17_.IMPLICIT_ as IMPLICIT27_1_16_, scope17_.ISOLATED_ as ISOLATED28_1_16_, scope17_.CLASS_ as CLASS2_1_16_, activity18_.ID_ as ID1_1_17_, activity18_.NAME_ as NAME3_1_17_, activity18_.PROCESSDEFINITION_ as PROCESSD4_1_17_, activity18_.ACTION_ as ACTION5_1_17_, activity18_.SUPERSTATE_ as SUPERSTATE6_1_17_, activity18_.SUPRJOINFAILURE_ as SUPRJOI11_1_17_, activity18_.COMPOSITEACTIVITY_ as COMPOSI12_1_17_, activity18_.JOINCONDITION_ as JOINCON13_1_17_, activity18_.RECEIVER_ as RECEIVER14_1_17_, activity18_.CREATEINSTANCE_ as CREATEI15_1_17_, activity18_.REPLIER_ as REPLIER16_1_17_, activity18_.INVOKER_ as INVOKER17_1_17_, activity18_.FAULTNAMELOCALPART_ as FAULTNA18_1_17_, activity18_.FAULNAMETPATH_ as FAULNAM19_1_17_, activity18_.FAULTVARIABLE_ as FAULTVA20_1_17_, activity18_.ALARM_ as ALARM21_1_17_, activity18_.SCOPE_ as SCOPE22_1_17_, activity18_.CONDITION_ as CONDITION23_1_17_, activity18_.WHILE_ as WHILE24_1_17_, activity18_.STARTSTRUCTURE_ as STARTST25_1_17_, activity18_.ENDSTRUCTURE_ as ENDSTRU26_1_17_, activity18_.IMPLICIT_ as IMPLICIT27_1_17_, activity18_.ISOLATED_ as ISOLATED28_1_17_, activity18_.ACTIVITY_ as ACTIVITY29_1_17_, activity18_.FAULTLOCALPART_ as FAULTLO30_1_17_, activity18_.FAULTPATH_ as FAULTPATH31_1_17_, activity18_.HDLRRECEIVER_ as HDLRREC32_1_17_, activity18_.HDLRALARM_ as HDLRALARM33_1_17_, activity18_.CLASS_ as CLASS2_1_17_, receiver19_.id as id48_18_, receiver19_.messageExchange as messageE2_48_18_, receiver19_.CORRELATIONS_ as CORRELAT3_48_18_, receiver19_.OPERATION_ as OPERATION4_48_18_, receiver19_.PARTNERLINKDEFINITION_ as PARTNERL5_48_18_, receiver19_.VARIABLEDEFINITION_ as VARIABLE6_48_18_, receiver19_.LISTENERTYPE_ as LISTENER7_48_18_, receiver19_.LISTENER_ as LISTENER8_48_18_, correlatio20_.id as id46_19_, operationi21_.id as id59_20_, operationi21_.NAME_ as NAME2_59_20_, operationi21_.STYLE_ as STYLE3_59_20_, operationi21_.INPUT_ as INPUT4_59_20_, operationi21_.OUTPUT_ as OUTPUT5_59_20_, inputimpl22_.id as id61_21_, inputimpl22_.NAME_ as NAME3_61_21_, inputimpl22_.MESSAGE_ as MESSAGE4_61_21_, messageimp23_.id as id62_22_, messageimp23_.NAMELOCALPART_ as NAMELOCA2_62_22_, messageimp23_.NAMEPATH_ as NAMEPATH3_62_22_, outputimpl24_.id as id61_23_, outputimpl24_.NAME_ as NAME3_61_23_, outputimpl24_.MESSAGE_ as MESSAGE4_61_23_, partnerlin25_.ID_ as ID1_45_24_, partnerlin25_.NAME_ as NAME2_45_24_, partnerlin25_.PARTNERROLEISFIRST_ as PARTNERR3_45_24_, partnerlin25_.PARTNERLINKTYPE_ as PARTNERL4_45_24_, partnerlin26_.id as id56_25_, partnerlin26_.NAMELOCALPART_ as NAMELOCA2_56_25_, partnerlin26_.NAMEPATH_ as NAMEPATH3_56_25_, partnerlin26_.FIRSTROLE_ as FIRSTROLE4_56_25_, partnerlin26_.SECONDROLE_ as SECONDROLE5_56_25_, partnerlin27_.id as id57_26_, partnerlin27_.NAME_ as NAME2_57_26_, partnerlin27_.PORTTYPE_ as PORTTYPE3_57_26_, porttypeim28_.id as id60_27_, porttypeim28_.LOCALPART_ as LOCALPART2_60_27_, porttypeim28_.PATH_ as PATH3_60_27_, partnerlin29_.id as id57_28_, partnerlin29_.NAME_ as NAME2_57_28_, partnerlin29_.PORTTYPE_ as PORTTYPE3_57_28_, variablede30_.ID_ as ID1_35_29_, variablede30_.NAME_ as NAME2_35_29_, variablede30_.TYPE_ as TYPE3_35_29_, variablety31_.ID_ as ID1_36_30_, variablety31_.MESSAGE_ as MESSAGE3_36_30_, variablety31_.LOCALPART_ as LOCALPART4_36_30_, variablety31_.PATH_ as PATH5_36_30_, variablety31_.CLASS_ as CLASS2_36_30_, messageimp32_.id as id62_31_, messageimp32_.NAMELOCALPART_ as NAMELOCA2_62_31_, messageimp32_.NAMEPATH_ as NAMEPATH3_62_31_, replier33_.id as id49_32_, replier33_.MESSAGEEXCHANGE_ as MESSAGEE2_49_32_, replier33_.FAULTLOCALPART_ as FAULTLOC3_49_32_, replier33_.FAULTPATH_ as FAULTPATH4_49_32_, replier33_.CORRELATIONS_ as CORRELAT5_49_32_, replier33_.OPERATION_ as OPERATION6_49_32_, replier33_.PARTNERLINKDEFINITION_ as PARTNERL7_49_32_, replier33_.VARIABLEDEFINITION_ as VARIABLE8_49_32_, correlatio34_.id as id46_33_, operationi35_.id as id59_34_, operationi35_.NAME_ as NAME2_59_34_, operationi35_.STYLE_ as STYLE3_59_34_, operationi35_.INPUT_ as INPUT4_59_34_, operationi35_.OUTPUT_ as OUTPUT5_59_34_, partnerlin36_.ID_ as ID1_45_35_, partnerlin36_.NAME_ as NAME2_45_35_, partnerlin36_.PARTNERROLEISFIRST_ as PARTNERR3_45_35_, partnerlin36_.PARTNERLINKTYPE_ as PARTNERL4_45_35_, variablede37_.ID_ as ID1_35_36_, variablede37_.NAME_ as NAME2_35_36_, variablede37_.TYPE_ as TYPE3_35_36_, invoker38_.id as id50_37_, invoker38_.OPERATION_ as OPERATION2_50_37_, invoker38_.PARTNERLINKDEFINITION_ as PARTNERL3_50_37_, invoker38_.INCORRELATIONS_ as INCORREL4_50_37_, invoker38_.OUTCORRELATIONS_ as OUTCORRE5_50_37_, invoker38_.INVARIABLEDEFINITION_ as INVARIAB6_50_37_, invoker38_.OUTVARIABLEDEFINITION_ as OUTVARIA7_50_37_, operationi39_.id as id59_38_, operationi39_.NAME_ as NAME2_59_38_, operationi39_.STYLE_ as STYLE3_59_38_, operationi39_.INPUT_ as INPUT4_59_38_, operationi39_.OUTPUT_ as OUTPUT5_59_38_, partnerlin40_.ID_ as ID1_45_39_, partnerlin40_.NAME_ as NAME2_45_39_, partnerlin40_.PARTNERROLEISFIRST_ as PARTNERR3_45_39_, partnerlin40_.PARTNERLINKTYPE_ as PARTNERL4_45_39_, correlatio41_.id as id46_40_, correlatio42_.id as id46_41_, variablede43_.ID_ as ID1_35_42_, variablede43_.NAME_ as NAME2_35_42_, variablede43_.TYPE_ as TYPE3_35_42_, variablede44_.ID_ as ID1_35_43_, variablede44_.NAME_ as NAME2_35_43_, variablede44_.TYPE_ as TYPE3_35_43_, variablede45_.ID_ as ID1_35_44_, variablede45_.NAME_ as NAME2_35_44_, variablede45_.TYPE_ as TYPE3_35_44_, alarmdefin46_.ID_ as ID1_42_45_, alarmdefin46_.ALARMKIND_ as ALARMKIND2_42_45_, alarmdefin46_.FOREXPR_ as FOREXPR3_42_45_, alarmdefin46_.UNTILEXPR_ as UNTILEXPR4_42_45_, alarmdefin46_.REPEATEXPR_ as REPEATEXPR5_42_45_, alarmdefin46_.LISTENERTYPE_ as LISTENER6_42_45_, alarmdefin46_.LISTENER_ as LISTENER7_42_45_, snippet47_.ID_ as ID1_37_46_, snippet47_.TEXT_ as TEXT2_37_46_, snippet47_.LANGUAGE_ as LANGUAGE3_37_46_, snippet47_.USE_ as USE4_37_46_, snippet48_.ID_ as ID1_37_47_, snippet48_.TEXT_ as TEXT2_37_47_, snippet48_.LANGUAGE_ as LANGUAGE3_37_47_, snippet48_.USE_ as USE4_37_47_, snippet49_.ID_ as ID1_37_48_, snippet49_.TEXT_ as TEXT2_37_48_, snippet49_.LANGUAGE_ as LANGUAGE3_37_48_, snippet49_.USE_ as USE4_37_48_, receiver50_.id as id48_49_, receiver50_.messageExchange as messageE2_48_49_, receiver50_.CORRELATIONS_ as CORRELAT3_48_49_, receiver50_.OPERATION_ as OPERATION4_48_49_, receiver50_.PARTNERLINKDEFINITION_ as PARTNERL5_48_49_, receiver50_.VARIABLEDEFINITION_ as VARIABLE6_48_49_, receiver50_.LISTENERTYPE_ as LISTENER7_48_49_, receiver50_.LISTENER_ as LISTENER8_48_49_, alarmdefin51_.ID_ as ID1_42_50_, alarmdefin51_.ALARMKIND_ as ALARMKIND2_42_50_, alarmdefin51_.FOREXPR_ as FOREXPR3_42_50_, alarmdefin51_.UNTILEXPR_ as UNTILEXPR4_42_50_, alarmdefin51_.REPEATEXPR_ as REPEATEXPR5_42_50_, alarmdefin51_.LISTENERTYPE_ as LISTENER6_42_50_, alarmdefin51_.LISTENER_ as LISTENER7_42_50_ from BPEL_JBPM_NODE nodes0_ left outer join BPEL_JBPM_ACTION action1_ on nodes0_.ACTION_=action1_.ID_ left outer join BPEL_JBPM_ACTION action2_ on action1_.REFERENCEDACTION_=action2_.ID_ left outer join BPEL_JBPM_DELEGATION delegation3_ on action2_.ACTIONDELEGATION_=delegation3_.ID_ left outer join BPEL_JBPM_PROCESSDEFINITION processdef4_ on delegation3_.PROCESSDEFINITION_=processdef4_.ID_ left outer join BPEL_JBPM_NODE startstate5_ on processdef4_.STARTSTATE_=startstate5_.ID_ left outer join BPEL_JBPM_NODE superstate6_ on startstate5_.SUPERSTATE_=superstate6_.ID_ left outer join BPEL_JBPM_EVENT event7_ on action2_.EVENT_=event7_.ID_ left outer join BPEL_JBPM_PROCESSDEFINITION processdef8_ on action2_.PROCESSDEFINITION_=processdef8_.ID_ left outer join BPEL_JBPM_PROCESSDEFINITION processdef9_ on nodes0_.SUBPROCESSDEFINITION_=processdef9_.ID_ left outer join BPEL_JBPM_DELEGATION delegation10_ on nodes0_.DECISIONDELEGATION=delegation10_.ID_ left outer join BPEL_JBPM_NODE compositea11_ on nodes0_.COMPOSITEACTIVITY_=compositea11_.ID_ left outer join BPEL_SNIPPET snippet12_ on compositea11_.JOINCONDITION_=snippet12_.ID_ left outer join BPEL_JBPM_NODE structured13_ on compositea11_.ID_=structured13_.STARTSTRUCTURE_ and structured13_.CLASS_='Y' left outer join BPEL_JBPM_NODE structured14_ on compositea11_.ID_=structured14_.ENDSTRUCTURE_ and structured14_.CLASS_='Z' left outer join BPEL_SNIPPET snippet15_ on compositea11_.CONDITION_=snippet15_.ID_ left outer join BPEL_JBPM_NODE while_loop16_ on compositea11_.ID_=while_loop16_.WHILE_ and while_loop16_.CLASS_='L' left outer join BPEL_JBPM_NODE scope17_ on compositea11_.SCOPE_=scope17_.ID_ left outer join BPEL_JBPM_NODE activity18_ on compositea11_.ACTIVITY_=activity18_.ID_ left outer join BPEL_RECEIVER receiver19_ on activity18_.RECEIVER_=receiver19_.id left outer join BPEL_CORRELATIONS correlatio20_ on receiver19_.CORRELATIONS_=correlatio20_.id left outer join WSDL_OPERATION operationi21_ on receiver19_.OPERATION_=operationi21_.id left outer join WSDL_OPERATIONMEMBER inputimpl22_ on operationi21_.INPUT_=inputimpl22_.id left outer join BPEL_WSDLMESSAGE messageimp23_ on inputimpl22_.MESSAGE_=messageimp23_.id left outer join WSDL_OPERATIONMEMBER outputimpl24_ on operationi21_.OUTPUT_=outputimpl24_.id left outer join BPEL_PARTNERLINKDEFINITION partnerlin25_ on receiver19_.PARTNERLINKDEFINITION_=partnerlin25_.ID_ left outer join BPEL_PARTNERLINKTYPE partnerlin26_ on partnerlin25_.PARTNERLINKTYPE_=partnerlin26_.id left outer join WSDL_ROLE partnerlin27_ on partnerlin26_.FIRSTROLE_=partnerlin27_.id left outer join WSDL_PORTTYPE porttypeim28_ on partnerlin27_.PORTTYPE_=porttypeim28_.id left outer join WSDL_ROLE partnerlin29_ on partnerlin26_.SECONDROLE_=partnerlin29_.id left outer join BPEL_VARIABLEDEFINITION variablede30_ on receiver19_.VARIABLEDEFINITION_=variablede30_.ID_ left outer join BPEL_VARIABLETYPE variablety31_ on variablede30_.TYPE_=variablety31_.ID_ left outer join BPEL_WSDLMESSAGE messageimp32_ on variablety31_.MESSAGE_=messageimp32_.id left outer join BPEL_REPLIER replier33_ on activity18_.REPLIER_=replier33_.id left outer join BPEL_CORRELATIONS correlatio34_ on replier33_.CORRELATIONS_=correlatio34_.id left outer join WSDL_OPERATION operationi35_ on replier33_.OPERATION_=operationi35_.id left outer join BPEL_PARTNERLINKDEFINITION partnerlin36_ on replier33_.PARTNERLINKDEFINITION_=partnerlin36_.ID_ left outer join BPEL_VARIABLEDEFINITION variablede37_ on replier33_.VARIABLEDEFINITION_=variablede37_.ID_ left outer join BPEL_INVOKER invoker38_ on activity18_.INVOKER_=invoker38_.id left outer join WSDL_OPERATION operationi39_ on invoker38_.OPERATION_=operationi39_.id left outer join BPEL_PARTNERLINKDEFINITION partnerlin40_ on invoker38_.PARTNERLINKDEFINITION_=partnerlin40_.ID_ left outer join BPEL_CORRELATIONS correlatio41_ on invoker38_.INCORRELATIONS_=correlatio41_.id left outer join BPEL_CORRELATIONS correlatio42_ on invoker38_.OUTCORRELATIONS_=correlatio42_.id left outer join BPEL_VARIABLEDEFINITION variablede43_ on invoker38_.INVARIABLEDEFINITION_=variablede43_.ID_ left outer join BPEL_VARIABLEDEFINITION variablede44_ on invoker38_.OUTVARIABLEDEFINITION_=variablede44_.ID_ left outer join BPEL_VARIABLEDEFINITION variablede45_ on activity18_.FAULTVARIABLE_=variablede45_.ID_ left outer join BPEL_ALARMDEFINITION alarmdefin46_ on activity18_.ALARM_=alarmdefin46_.ID_ left outer join BPEL_SNIPPET snippet47_ on alarmdefin46_.FOREXPR_=snippet47_.ID_ left outer join BPEL_SNIPPET snippet48_ on alarmdefin46_.UNTILEXPR_=snippet48_.ID_ left outer join BPEL_SNIPPET snippet49_ on alarmdefin46_.REPEATEXPR_=snippet49_.ID_ left outer join BPEL_RECEIVER receiver50_ on activity18_.HDLRRECEIVER_=receiver50_.id left outer join BPEL_ALARMDEFINITION alarmdefin51_ on activity18_.HDLRALARM_=alarmdefin51_.ID_ where nodes0_.PROCESSDEFINITION_=?]com.sybase.jdbc2.jdbc.SybSQLException: Too many table names in the query. The maximum allowable is 50.

at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2697) at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2045) at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187) at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1562) at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1547) at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.loadCollection(Loader.java:1919) at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:71) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520) at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60) at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1627) at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344) at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86) at org.hibernate.collection.AbstractPersistentCollection.readElementByIndex(AbstractPersistentCollection.java:161) at org.hibernate.collection.PersistentList.get(PersistentList.java:248) at org.jbpm.bpel.def.BpelDefinition.getScope(BpelDefinition.java:125) at org.jbpm.bpel.application.ScopeMatcher.match(ScopeMatcher.java:30) at org.jbpm.bpel.service.messager.Messager.buildMessager(Messager.java:155) at org.jbpm.bpel.service.messager.MessagerServlet.init(MessagerServlet.java:88) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4118) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) 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.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503) at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644) at org.apache.catalina.core.StandardContext.init(StandardContext.java:5005) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2

I am also trying the example with CVS download of jbpm.bpel extension. Here the samples seem to still have old build files. The Messager Servlet used in alpha 4 version does not exist in beta version. Any one throw light on how I can use the beta version with hello example

The object/relational mapping files included in alpha 4 explicitly turned off lazy loading, which causes Hibernate to craft graceful queries such as the one you posted.

However, no other database has had trouble handling them (I've used Hypersonic, MySQL, Oracle and SQL Server).

Beta 1 comes with lazy loading turned on. The messager package has been refactored as a jBPM 3.1 service. It resolves a number of issues associated with the former implementation. The servlet is now called org.jbpm.bpel.relation.jms.RelationServlet. The code is not completely stable yet, so please be careful when you play with the CVS head.

Yeah I did not have any problem with Hypersonic but Sybase seems to have this problem. For using beta 1 just by replacing the messager servlet with RelationServlet is enough or there many more changes ?. If there is any documentation on beta 1 hello example it would be great. How long would it take to get the BPEL version to get stabilized.

There are some other changes. I just got all the unit tests running yesterday on beta 1. The remaining tasks are getting the examples working and updating the documentation accordingly. This might take 1-2 weeks.