9 Replies Latest reply on Aug 7, 2009 6:21 AM by Falko Menge

    Whether the JBPM4.0 support informix

    zhu zhanping Newbie

      When i deployed the JBPM4.0 version to informix,the eclipse IDE tell me some exceptions like that:
      15:26:17,437 INF | [DefaultCommandService] exception while executing command org.jbpm.pvm.internal.cmd.DeployCmd@10c3a08
      org.jbpm.pvm.internal.wire.WireException: couldn't initialize object 'org.jbpm.pvm.internal.repository.RepositorySessionImpl': No Dialect mapping for JDBC type: 2005
      at org.jbpm.pvm.internal.wire.descriptor.ObjectDescriptor.initialize(ObjectDescriptor.java:233)
      at org.jbpm.pvm.internal.wire.WireContext.performInitialization(WireContext.java:537)
      at org.jbpm.pvm.internal.wire.WireContext.initialize(WireContext.java:499)
      at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:453)
      at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:441)
      at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:421)
      at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:331)
      at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:707)
      at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:153)
      at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:144)
      at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:46)
      at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:33)
      at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
      at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:54)
      at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
      at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
      at org.jbpm.pvm.internal.repository.DeploymentImpl.deploy(DeploymentImpl.java:90)
      at test.superjoo.deploy.DeployProcessDefinition.main(DeployProcessDefinition.java:22)
      Caused by: org.hibernate.MappingException: No Dialect mapping for JDBC type: 2005
      at org.hibernate.dialect.TypeNames.get(TypeNames.java:79)
      at org.hibernate.dialect.TypeNames.get(TypeNames.java:104)
      at org.hibernate.dialect.Dialect.getTypeName(Dialect.java:314)
      at org.hibernate.mapping.Column.getSqlType(Column.java:205)
      at org.hibernate.mapping.Table.sqlCreateString(Table.java:420)
      at org.hibernate.cfg.Configuration.generateSchemaCreationScript(Configuration.java:881)
      at org.hibernate.tool.hbm2ddl.SchemaExport.(SchemaExport.java:105)
      at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:343)
      at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)
      at org.jbpm.pvm.internal.wire.descriptor.HibernateSessionFactoryDescriptor.construct(HibernateSessionFactoryDescriptor.java:64)
      at org.jbpm.pvm.internal.wire.WireContext.construct(WireContext.java:473)
      at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:452)
      at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:441)
      at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:421)
      at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:331)
      at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:707)
      at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:153)
      at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:144)
      at org.jbpm.pvm.internal.wire.descriptor.HibernateSessionDescriptor.construct(HibernateSessionDescriptor.java:63)
      at org.jbpm.pvm.internal.wire.WireContext.construct(WireContext.java:473)
      at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:452)
      at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:441)
      at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:421)
      at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:331)
      at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:707)
      at org.jbpm.pvm.internal.wire.descriptor.ObjectDescriptor.autoWire(ObjectDescriptor.java:294)
      at org.jbpm.pvm.internal.wire.descriptor.ObjectDescriptor.initialize(ObjectDescriptor.java:225)
      ... 17 more

        • 1. Re: Whether the JBPM4.0 support informix
          Ronald van Kuijk Master

          This is a question for the userforum.

          But in short: If hibernate supports your database and your hibernate config is correct, there is a bigchance jBPM does support it to. Sometimes it needs some tweeking, but then you first have to give us the details on what you configured.

          But please use the userforum for this

          • 2. Re: Whether the JBPM4.0 support informix
            zhu zhanping Newbie

            I'm sorry.i'm anxious that made the wrong place.
            The hibernate mapping file like that:

            <?xml version="1.0" encoding="utf-8"?>

            <!DOCTYPE hibernate-configuration PUBLIC
            "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
            "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

            <hibernate-configuration>
            <session-factory>


            org.hibernate.dialect.InformixDialect


            com.informix.jdbc.IfxDriver


            jdbc:informix-sqli://192.251.1.150:1528/xjtcyy:informixserver=vseal

            xwj
            xwj123
            create-drop
            true
            informix
            jdbc:informix-sqli://192.251.1.150:1528/xjtcyy:informixserver=vseal
            xwj
            xwj123
            com.informix.jdbc.IfxDriver
            org.hibernate.dialect.InformixDialect








            </session-factory>
            </hibernate-configuration>


            Yesterday i used it to deploy JBPM3.2.6 and it's succeed.Shoud I need to change some configuration?

            • 3. Re: Whether the JBPM4.0 support informix
              Ronald van Kuijk Master

              please put the xml in [ c o d e] tags (use preview)

              • 4. Re: Whether the JBPM4.0 support informix
                zhu zhanping Newbie

                sorry,sorry.

                <session-factory>


                org.hibernate.dialect.InformixDialect


                com.informix.jdbc.IfxDriver


                jdbc:informix-sqli://192.251.1.150:1528/xjtcyy:informixserver=vseal

                xwj
                xwj123
                create-drop
                true
                informix
                jdbc:informix-sqli://192.251.1.150:1528/xjtcyy:informixserver=vseal
                xwj
                xwj123
                com.informix.jdbc.IfxDriver
                org.hibernate.dialect.InformixDialect







                </session-factory>

                • 5. Re: Whether the JBPM4.0 support informix
                  zhu zhanping Newbie

                  Oh,my god!I'm so sorry.

                  <session-factory>
                  
                   <property name="hibernate.dialect">
                   org.hibernate.dialect.InformixDialect
                   </property>
                   <property name="hibernate.connection.driver_class">
                   com.informix.jdbc.IfxDriver
                   </property>
                   <property name="hibernate.connection.url">
                   jdbc:informix-sqli://192.251.1.150:1528/xjtcyy:informixserver=vseal
                   </property>
                   <property name="hibernate.connection.username">xwj</property>
                   <property name="hibernate.connection.password">xwj123</property>
                   <property name="hibernate.hbm2ddl.auto">create-drop</property>
                   <property name="hibernate.format_sql">true</property>
                   <property name="myeclipse.connection.profile">informix</property>
                   <property name="connection.url">jdbc:informix-sqli://192.251.1.150:1528/xjtcyy:informixserver=vseal</property>
                   <property name="connection.username">xwj</property>
                   <property name="connection.password">xwj123</property>
                   <property name="connection.driver_class">com.informix.jdbc.IfxDriver</property>
                   <property name="dialect">org.hibernate.dialect.InformixDialect</property>
                  
                   <mapping resource="jbpm.repository.hbm.xml" />
                   <mapping resource="jbpm.execution.hbm.xml" />
                   <mapping resource="jbpm.history.hbm.xml" />
                   <mapping resource="jbpm.task.hbm.xml" />
                   <mapping resource="jbpm.jpdl.hbm.xml" />
                   <mapping resource="jbpm.identity.hbm.xml" />
                  
                  </session-factory>


                  • 6. Re: Whether the JBPM4.0 support informix
                    Ronald van Kuijk Master

                    :-)....

                    There does not seem much wrong with this. Searching in google does not lead to much either. I guess this is one of those cases where you have to start investigating deeply yourself. Sorry...

                    Maybe try another dialect (if there is any), or try an even newer version of hibernate, or....

                    • 8. Re: Whether the JBPM4.0 support informix
                      zhu zhanping Newbie

                      Thanks for your help.Few days ago,I used JBPM 3.2.6 and informix 9.4 to deploy my application.I made 30 Processes start the ProcessInstance at the same time,Then the aplication throw database Deadlock Exceptions.Then I asked the informix technology support,he told me that some sessions operated the JBPM_TOKEN table at the same time and two sessions made the Deadlock error.So I use 4.0version to test whether there are same questions between JBPM3.0 and informix.It's a pity that I'm not success.I'll try again later and thank you again.

                      • 9. Re: Whether the JBPM4.0 support informix
                        Falko Menge Newbie

                        Are there any new findings regarding jBPM 4 on Informix?

                        We store application data in an Informix database and are now going to start two jBPM 4 projects, which need to work on the data. In case jBPM 4 turns out not to work with Informix, are there any workarounds, e.g. with two different databases (one for jBPM and one for the data), that still ensure transaction safety?