Hibernate Custom dialect

 Customizing a dialect class--hibernate dialectTags: hibernatesqlserverjdbcmysql database java2012-07-04 18:46 2847 people read Comments (1) favorite reports Classification:Hibernate (+)

The class needs to inherit the dialect class corresponding to the database we are using. For example: If we are using MySQL (version 5.x.x), we need to inherit "Org.hibernate". dialect. Mysql5dialect "; If we are using DB2, then we should inherit" Org.hibernate.dialect.DB2Dialect "; I use SqlServer2008, so I will inherit" Org.hibernate.dialect.SQLServerDialect "

[Java]View Plaincopy

2. Import Java.sql.Types;
6. Import Org.hibernate.Hibernate;
8. Import Org.hibernate.dialect.MySQL5Dialect;
10. /**
12. * Rewrite Mysql5dialect class, register types
16. * @author LZ
18. *
20. */
22. Public class Mydialect extends Mysql5dialect {
24. Public Mydialect () {
26. super ();
30. Registerhibernatetype (Types.decimal, Hibernate.BIG_DECIMAL.getName ());
32. Registerhibernatetype (Types.longvarchar,hibernate.string.getname ());
34. Registerhibernatetype (Types.binary,hibernate.string.getname ());
36. Registerhibernatetype (-1, Hibernate.STRING.getName ());
38. }
40. }

Note: If your database is MySQL and the decimal type is used, the error should be No dialect mapping for JDBC type:3. Note This 3, which indicates that hibernate cannot map this data type to your Java class. It needs to be used in a custom dialect: Description:

If your database is MySQL and the decimal type is used, the error should be No dialect mapping for JDBC type:3. Note This 3, which indicates that hibernate cannot map this data type to your Java class. It needs to be used in custom dialects:

Registerhibernatetype (Types.decimal, Hibernate.BIG_DECIMAL.getName ());

If you use the text data type, hibernate does not know this data type at all, so it returns no dialect mapping for JDBC type: 1

In this case, it is necessary to include in the dialect:

Registerhibernatetype ( -1,hibernate.string.getname ());

[HTML]View Plaincopy

1. <property name="Hibernate.dialect">
2. Com.yourcompany.MyDialect
3. </Property>

Hibernate Custom dialect