Whether the JBPM4.0 support informix

[superjoo]

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

[kukeltje]

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

[superjoo]

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?

[kukeltje]

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

[superjoo]

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>

[superjoo]

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>

[kukeltje]

:-)....

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....

[kukeltje]

http://www.snailshell.de/blog/archives/2007/06/entry_108.html

[superjoo]

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.

[falko.menge]

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?