6 Replies Latest reply on Dec 16, 2006 4:02 AM by vamsikirankumar.k

    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:
      org.hibernate.dialect.Oracle9Dialect
      oracle.jdbc.driver.OracleDriver
      jdbc:oracle:thin:@172.18.13.11:1521:platform
      epstar29
      wiscom
      true 1, false 0

      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
          johngoodwin

          I am having the same issue. Did you ever come up with a resolution?

          I tried updating the hibernate and antlr jars to no avail.

          Thanks.

          • 2. Re: problem in jbpm1.3.2 with oracle9i backend
            clandestino_bgd

            Hi all,
            I have gone through JBPM porting to Oracle 9i and since there are several things needed to be done, I have collected them all in one "install" folder.
            There you can find various resources: config files, Oracle and c3p0 drivers, some patches for JSDK 1.4 compatibility. etc.

            You can download it at: http://www.geocities.com/clandestino_bgd/install.zip

            After you unzip the archive just open INSTALLATION.txt and follow the steps.
            The procedure is verified in our company.

            Cheers
            Milan

            • 3. Re: problem in jbpm1.3.2 with oracle9i backend
              dsrkreddy

              Hi Milan,

              The guide you provide is Excelent and really Thanks for that, and while following your instruction's i got an exceptions at 11 th step i mean running ant script for creating database tables (i.e"ant create.db -buildfile build.deploy.xml") as below

              BUILD FAILED
              C:\jbpm\jbpm-starters-kit-3.1.2\jbpm\build.deploy.xml:50: org.hibernate.exceptio
              n.GenericJDBCException: Cannot open connection
              

              so iam stuck up over here please can you suggest me how can i go from here

              Cheers
              Chutki

              • 4. Re: problem in jbpm1.3.2 with oracle9i backend
                clandestino_bgd

                Hello,
                it seems that either your DB is not running, or you have badly configured parameters.
                I am afraid I cannot help you on that subject.

                Regards
                Milan

                • 5. Re: problem in jbpm1.3.2 with oracle9i backend
                  dsrkreddy

                  Thanks Milan,

                  Again i reconfigured the database settings and now it is running fine .. with oracle database.. and i really thank you for this ... and can you suggest me now how i can i set it to run on tomcat server..please if you have any idea in configuring this .. help me...


                  Thanks & Regards
                  Chutki

                  • 6. Re: problem in jbpm1.3.2 with oracle9i backend
                    vamsikirankumar.k

                    Hi
                    I am begginer to the jbpm I want to replace my hsql-db to oracle-db i have done all configurations that are specfied in the documentation but i am getting Datasource not found and EntityMedia(jndi-name) not bound errors while running the server.I am unable to download u r Zip file.Help me pls.


                    Thanks
                    vamsikirankumar.