4 Replies Latest reply: Mar 23, 2006 11:52 AM by Alejandro Guizar RSS

Error while loading BPEL  Hello World  example using sybase

Mohammed Afzal Newbie

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