Hi, i'm trying to use DB2 instead of Derby, alredy did the creation of the database on a DB2 Express v9.5 server running on opensuse 10.2, the database configuration (geronimo-ds.xm), Update Database Connection Pool ( ./deploy.sh.. ), the Redeploy processes and everything was ok, but when run the ./startup of intalio server the geronimo.out shows this error:

Module 26/33 com.intalio.bpms/pxe/5.1.2/war 12:47:15,428 ERROR [BpelDAOConnectionFactoryImpl] Unable to detect Hibernate dialect!
12:47:18,792 ERROR [ODEServer] Error instantiating DAO Connection Factory class org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl.
org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: DB2/LINUX
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:62)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
...
so i ensure that the charset of the BPMSDB on DB2 is ISO-8859-1 and the next configuration files in intalio-bpms-server-5.1.0.019/var/config were fine:

-console-db.properties
hibernate.dialect=org.hibernate.dialect.DB2Dialect
-connector.xml
[



]
-connection.properties
com.intalio.bpms.connector.jdbc.db.type=DB295

but didn't work, doe s anyone knows what else have to configurate?..
Please i need help.

Best regards.

DB2 is not permitted for use with the CE. Please contact for support.

Thanks,

Antoine

Antoine wrote:
DB2 is not permitted for use with the CE. Please contact for support.

Thanks,

Antoine

What exactly do you mean by "DB2 is not not permitted for use with CE"? Do you mean it's not supported by your company or not allowed by the license? What about the use of other application servers?

Thanks

You can only use the Geromino app server with either MySql or Derby as a backing database.

You can consult this page if you are interested into more options.

Thanks,

Antoine

Thank your for your response, Antoine.

I eventually found the CE license here - the license file contained in the Intalio server CE zip file is a bit different though.