Hibernate Dialect -must be explicitly set
anamica_r Dec 2, 2005 5:12 AMHi,
While trying to deploy the par file from eclipse3.1 (using JBPM 3.0.2), i am getting the exception as
[deploypar] 15:34:47,129 [main] INFO Environment : Hibernate 3.1 beta 3
[deploypar] 15:34:47,161 [main] INFO Environment : loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.c3p0.max_size=3, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.c3p0.min_size=1, hibernate.connection.username=sa, hibernate.connection.url=jdbc:hsqldb:hsql://localhost:9001;sql.enforce_strict_size=true, hibernate.show_sql=true, hibernate.connection.password=****}
[deploypar] 15:34:47,161 [main] INFO Environment : using CGLIB reflection optimizer
[deploypar] 15:34:47,176 [main] INFO Environment : using JDK 1.4 java.sql.Timestamp handling
[deploypar] 15:34:47,442 [main] INFO Configuration : configuring from resource: hibernate.cfg.xml
[deploypar] 15:34:47,457 [main] INFO Configuration : Configuration resource: hibernate.cfg.xml
[deploypar] 15:34:47,692 [main] INFO Configuration : Reading mappings from resource: org/jbpm/identity/User.hbm.xml
[deploypar] 15:34:48,082 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.User -> JBPM_ID_USER
-------
---------
----------
15:34:51,378 [main] INFO Configuration : processing foreign key constraints
[deploypar] 15:34:51,612 [main] WARN UserSuppliedConnectionProvider : No connection properties specified - the user must supply JDBC connections
[deploypar] org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
[deploypar] at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
[deploypar] at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
[deploypar] at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:378)
[deploypar] at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:110)
[deploypar] at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1797)
[deploypar] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1125)
[deploypar] at org.jbpm.db.JbpmSessionFactory.buildSessionFactory(JbpmSessionFactory.java:138)
[deploypar] at org.jbpm.db.JbpmSessionFactory.(JbpmSessionFactory.java:77)
[deploypar] at org.jbpm.ant.AntTaskJbpmSessionFactory.createJbpmSessionFactory(AntTaskJbpmSessionFactory.java:77)
[deploypar] at org.jbpm.ant.AntTaskJbpmSessionFactory.getJbpmSessionFactory(AntTaskJbpmSessionFactory.java:38)
[deploypar] at org.jbpm.ant.DeployParTask.execute(DeployParTask.java:32)
[deploypar] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[deploypar] at org.apache.tools.ant.Task.perform(Task.java:364)
[deploypar] at org.apache.tools.ant.Target.execute(Target.java:341)
[deploypar] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[deploypar] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[deploypar] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[deploypar] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[deploypar] at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
[deploypar] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[deploypar] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
[deploypar] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
[deploypar] couldn't create JbpmSessionFactory: Hibernate Dialect must be explicitly set
[deploypar] at org.jbpm.ant.AntTaskJbpmSessionFactory.createJbpmSessionFactory(AntTaskJbpmSessionFactory.java:81)
[deploypar] at org.jbpm.ant.AntTaskJbpmSessionFactory.getJbpmSessionFactory(AntTaskJbpmSessionFactory.java:38)
[deploypar] at org.jbpm.ant.DeployParTask.execute(DeployParTask.java:32)
[deploypar] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[deploypar] at org.apache.tools.ant.Task.perform(Task.java:364)
[deploypar] at org.apache.tools.ant.Target.execute(Target.java:341)
[deploypar] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[deploypar] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[deploypar] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[deploypar] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[deploypar] at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
[deploypar] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[deploypar] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
[deploypar] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
I verified the hibernate.properties. it contains,
hibernate.dialect=org.hibernate.dialect.HSQLDialect
also the hibernate.cfg.xml contains
<property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
Can anyone help me to resolve the above issue.
Thanks,
Anamica