1 Reply Latest reply on Sep 28, 2006 8:52 PM by lampli

    problem in jbpm1.3.2 with oracle9i backend

    lampli

      hi all,
      When i excute "ant create.db -buildfile build.deploy.xml",there are some exception like below, and my configuration in build.deploy.xml is:


      <target name="create.db" depends="declare.jbpm.tasks" description="creates a oracle database with the jbpm tables and loads the processes in there">
       <jbpmschema actions="create"
       cfg="${basedir}/src/config.files/hibernate.cfg.xml" />
       <loadidentities file="${basedir}/src/resources/oracle/identity.db.xml"
       cfg="${basedir}/src/config.files/hibernate.cfg.xml" />
       <ant antfile="build.xml" target="build.processes" inheritall="false" />
       <deployprocess cfg="${basedir}/src/config.files/hibernate.cfg.xml" >
       <fileset dir="build" includes="*.process" />
       </deployprocess>
       </target>


      the hibernate.cfg.xml content is:
      <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
       <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
       <property name="hibernate.connection.url">jdbc:oracle:thin:@172.18.13.11:1521:platform</property>
       <property name="hibernate.connection.username">epstar29</property>
       <property name="hibernate.connection.password">wiscom</property>
       <property name="hibernate.query.substitutions">true 1, false 0</property>


      exceptions:
      [loadidentities] 17:25:24,328 [main] INFO SessionFactoryObjectFactory : Not bin
      ding factory to JNDI, no JNDI name configured
      [loadidentities] 17:25:24,328 [main] INFO SessionFactoryImpl : Checking 28 name
      d HQL queries
      [loadidentities] 17:25:24,500 [main] INFO SessionFactoryImpl : Checking 0 named
      SQL queries
      [loadidentities] 17:25:24,500 [main] ERROR SessionFactoryImpl : Error in named q
      uery: GraphSession.findAllProcessDefinitionVersions
      [loadidentities] org.hibernate.QueryException: ClassNotFoundException: org.hiber
      nate.hql.ast.HqlToken [
      [loadidentities]
      [loadidentities] select pd
      [loadidentities] from org.jbpm.graph.def.ProcessDefinition as pd
      [loadidentities] where pd.name = :name
      [loadidentities] order by pd.version desC
      [loadidentities]
      [loadidentities] ]
      [loadidentities] at org.hibernate.hql.ast.HqlLexer.panic(HqlLexer.java:57
      )
      [loadidentities] at antlr.CharScanner.setTokenObjectClass(CharScanner.jav
      a:238)
      [loadidentities] at org.hibernate.hql.ast.HqlLexer.setTokenObjectClass(Hq
      lLexer.java:31)
      [loadidentities] at antlr.CharScanner.(CharScanner.java:42)
      [loadidentities] at antlr.CharScanner.(CharScanner.java:49)
      [loadidentities] at org.hibernate.hql.antlr.HqlBaseLexer.(HqlBaseLe
      xer.java:56)
      [loadidentities] at org.hibernate.hql.antlr.HqlBaseLexer.(HqlBaseLe
      xer.java:53)
      [loadidentities] at org.hibernate.hql.antlr.HqlBaseLexer.(HqlBaseLe
      xer.java:50)
      [loadidentities] at org.hibernate.hql.ast.HqlLexer.(HqlLexer.java:2
      6)
      [loadidentities] at org.hibernate.hql.ast.HqlParser.getInstance(HqlParser
      .java:44)
      [loadidentities] at org.hibernate.hql.ast.QueryTranslatorImpl.parse(Query
      TranslatorImpl.java:232)
      [loadidentities] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(Q
      ueryTranslatorImpl.java:155)
      [loadidentities] at org.hibernate.hql.ast.QueryTranslatorImpl.compile(Que
      ryTranslatorImpl.java:105)
      [loadidentities] at org.hibernate.engine.query.HQLQueryPlan.(HQLQue
      ryPlan.java:74)
      [loadidentities] at org.hibernate.engine.query.HQLQueryPlan.(HQLQue
      ryPlan.java:53)
      [loadidentities] at org.hibernate.engine.query.QueryPlanCache.getHQLQuery
      Plan(QueryPlanCache.java:71)
      [loadidentities] at org.hibernate.impl.SessionFactoryImpl.checkNamedQueri
      es(SessionFactoryImpl.java:363)
      [loadidentities] at org.hibernate.impl.SessionFactoryImpl.(SessionF
      actoryImpl.java:327)
      [loadidentities] at org.hibernate.cfg.Configuration.buildSessionFactory(C
      onfiguration.java:1154)
      [loadidentities] at org.jbpm.persistence.db.DbPersistenceServiceFactory.g
      etSessionFactory(DbPersistenceServiceFactory.java:90)
      [loadidentities] at org.jbpm.persistence.db.DbPersistenceService.getSessi
      onFactory(DbPersistenceService.java:74)
      [loadidentities] at org.jbpm.persistence.db.DbPersistenceService.getSessi
      on(DbPersistenceService.java:78)
      [loadidentities] at org.jbpm.JbpmContext.getSession(JbpmContext.java:464)

      [loadidentities] at org.jbpm.identity.ant.LoadIdentitiesTask.execute(Load
      IdentitiesTask.java:62)
      [loadidentities] at org.apache.tools.ant.UnknownElement.execute(UnknownEl
      ement.java:275)
      [loadidentities] at org.apache.tools.ant.Task.perform(Task.java:364)
      [loadidentities] at org.apache.tools.ant.Target.execute(Target.java:341)
      [loadidentities] at org.apache.tools.ant.Target.performTasks(Target.java:
      369)
      [loadidentities] at org.apache.tools.ant.Project.executeSortedTargets(Pro
      ject.java:1216)
      [loadidentities] at org.apache.tools.ant.Project.executeTarget(Project.ja
      va:1185)
      [loadidentities] at org.apache.tools.ant.helper.DefaultExecutor.executeTa
      rgets(DefaultExecutor.java:40)
      [loadidentities] at org.apache.tools.ant.Project.executeTargets(Project.j
      ava:1068)
      [loadidentities] at org.apache.tools.ant.Main.runBuild(Main.java:668)
      [loadidentities] at org.apache.tools.ant.Main.startAnt(Main.java:187)
      [loadidentities] at org.apache.tools.ant.launch.Launcher.run(Launcher.jav
      a:246)
      [loadidentities] at org.apache.tools.ant.launch.Launcher.main(Launcher.ja
      va:67)


        • 1. Re: problem in jbpm1.3.2 with oracle9i backend
          lampli

          I had fixed it without any change but below

          ,and when i ant it in eclipse, i got the right result!
          
          <target name="create.db" depends="declare.jbpm.tasks" description="creates a oracle database with the jbpm tables and loads the processes in there">
           <jbpmschema actions="create"
           cfg="${basedir}/src/config.files/hibernate.cfg.xml" />
           <loadidentities file="${basedir}/src/resources/oracle/identity.db.xml"
           cfg="${basedir}/src/config.files/hibernate.cfg.xml" />
           <ant antfile="build.xml" target="build.processes" inheritall="false" />
           <deployprocess cfg="${basedir}/src/config.files/hibernate.cfg.xml"
           properties="${basedir}/src/resources/oracle/create.db.hibernate.properties">
           <fileset dir="build" includes="*.process" />
           </deployprocess>
           </target>
          
          
          regards and thanks ,
          lamp