4 Replies Latest reply on Mar 25, 2006 10:19 AM by Ken Nung

    jBPM deployment in JBoss ALL config (web services included)

    Ken Nung Newbie

      Hello,

      I need the following JBoss 4.0.X configuration:
      - JBoss AS
      - JBPM 3.1 deployed in AS
      - Execution of Web Services (JBossWS?)

      My problem so far: The Jboss jbpm config of the starter Kit makes problems deploying Web Services (it seems to deploy them as servlet not as web service). The JBoss AS ALL config deploys and runs my Web Services but hasnt jBPM deployed...
      When Im deploying jBPM to JBoss all config, it throws errors..

      How can I got on - I dont want to run two instances of JBoss (jBPM, Web Services)

      regrads ken

        • 1. Re: jBPM deployment in JBoss ALL config (web services includ
          Koen Aers Master

          The jbpm configuration is basically a stripped default JBoss configuration. So you should simply deploy the jbpm service archive and the webapp in the all configuration.

          Regards,
          Koen

          • 2. Re: jBPM deployment in JBoss ALL config (web services includ
            Ken Nung Newbie

            Thank you for your help, koen. Im in trouble because Im running out of time.

            I copyed jbpm.sar and the jpm.war into JBoss-ALL depoly dir. That gives me the following output - I shortened some INFO messages:

            12:55:58,334 INFO [JbpmConfiguration] using jbpm configuration resource 'jbpm.cfg.xml'
            12:55:59,415 INFO [TomcatDeployer] deploy, ctxPath=/jbpm, warUrl=.../tmp/deploy/tmp56533jbpm-exp.war/
            12:56:12,544 INFO [SettingsFactory] Statistics: disabled
            12:56:12,544 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
            12:56:12,544 INFO [SettingsFactory] Default entity-mode: pojo
            12:56:12,685 INFO [SessionFactoryImpl] building session factory
            12:56:13,826 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node]; using defaults.
            12:56:14,127 WARN [EhCacheProvider] Could not find configuration [org.jbpm.instantiation.Delegation]; using defaults.
            12:56:16,160 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task]; using defaults.
            12:56:16,981 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition]; using defaults.
            12:56:17,632 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler]; using defaults.
            12:56:17,722 WARN [EhCacheProvider] Could not find configuration [org.jbpm.module.def.ModuleDefinition]; using defaults.
            12:56:19,374 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Action]; using defaults.
            12:56:19,975 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Event]; using defaults.
            12:56:20,686 WARN [EhCacheProvider] Could not find configuration [org.jbpm.context.def.VariableAccess]; using defaults.
            12:56:21,848 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition]; using defaults.
            12:56:23,280 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController]; using defaults.
            12:56:23,480 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks]; using defaults.
            12:56:23,490 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.node.ProcessState.variableAccesses]; using defaults.
            12:56:23,490 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.events]; using defaults.
            12:56:23,490 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Swimlane.tasks]; using defaults.
            12:56:23,490 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.leavingTransitions]; using defaults.
            12:56:23,490 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController.variableAccesses]; using defaults.
            12:56:23,490 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers]; using defaults.
            12:56:23,500 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.node.Decision.decisionConditions]; using defaults.
            12:56:23,510 WARN [EhCacheProvider] Could not find configuration [org.jbpm.file.def.FileDefinition.processFiles]; using defaults.
            12:56:23,520 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.actions]; using defaults.
            12:56:23,520 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition.exceptionHandlers]; using defaults.
            12:56:23,520 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.nodes]; using defaults.
            12:56:23,530 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.arrivingTransitions]; using defaults.
            12:56:23,530 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.node.TaskNode.tasks]; using defaults.
            12:56:23,530 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.definitions]; using defaults.
            12:56:23,540 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Event.actions]; using defaults.
            12:56:23,540 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task.events]; using defaults.
            12:56:23,540 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.events]; using defaults.
            12:56:23,540 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes]; using defaults.
            12:56:23,540 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.SuperState.nodes]; using defaults.
            12:56:23,540 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.action.Script.variableAccesses]; using defaults.
            12:56:23,540 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler.actions]; using defaults.
            12:56:23,540 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task.exceptionHandlers]; using defaults.
            12:56:23,550 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.exceptionHandlers]; using defaults.
            12:56:23,550 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition.events]; using defaults.
            12:56:24,331 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
            12:56:26,244 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
            12:56:26,244 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
            12:56:26,264 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
            12:56:26,264 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
            12:56:26,264 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
            12:56:26,274 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
            12:56:26,274 INFO [SchedulerThread] runtime exception while executing timers
            org.jbpm.JbpmException: couldn't find timers from the database
             at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
             at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
             at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
            Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
             at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
             at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
             at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:420)
             at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:318)
             at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:177)
             at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1177)
             at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:46)
             at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
             ... 2 more
            Caused by: java.sql.SQLException: Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
             at org.hsqldb.jdbc.Util.throwError(Unknown Source)
             at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
             at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
             at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:346)
             at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:334)
             at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)
             at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
             at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
             at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
             at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
             at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:392)
             ... 7 more
            


            What did I miss?
            regards ken

            • 3. Re: jBPM deployment in JBoss ALL config (web services includ
              Koen Aers Master

              The database was not created. Either create the database (in hsqldb or your database of preference that you have configured as datasource in JBoss) or simply copy the hsqldb script files from the jbpm configuration in the right directory of the all configuration.

              Regards,
              Koen