]
Ramalingeswara Rao K V commented on HHH-6864:
---------------------------------------------
We have fixed the issue by making customized class as follows.............
import org.hibernate.dialect.DB2Dialect;
public class MyDB2Dialect extends DB2Dialect
{
public String getSelectGUIDString()
{
return "select GENERATE_UNIQUE() from DUAL";
}
}
Hibernate configuration issue with DB2Dialect
---------------------------------------------
Key: HHH-6864
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6864
Project: Hibernate Core
Issue Type: Improvement
Components: core
Affects Versions: 3.0 final
Environment: Hibernate 3.0, JBoss 4.2.3 and DB2 luw 9.7
Reporter: Ramalingeswara Rao K V
Labels: configuration, db2, generator, guid, hibernate
Our application is throwing the following error due to some incompatible issues with
DB2Dialect.
2011-11-29 11:03:10,638 ERROR java.lang.UnsupportedOperationException: dialect does not
support GUIDs
at org.hibernate.dialect.Dialect.getSelectGUIDString(Dialect.java:754)
at org.hibernate.id.GUIDGenerator.generate(GUIDGenerator.java:50)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:122)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
The issue seems to be related to the following entry in hibernate xml files.
<generator class="guid" />
*) We would like to know the common <generator> element which is compatible with
ORACLE and DB2, etc.
*) We would like to know how to separate the hbm configurations based on database
(ORACLE, DB2, MYSQL, etc.).
--
This message is automatically generated by JIRA.
For more information on JIRA, see: