wordnet hibernate support
|
wordnet hibernate support
|
|||
|
|
Hibernate supports a wide range of DBMS but only these were tested:
| problems | workaround | |
| MySQL | collation problem casedwords table where duplicate records may be raised if collation is not case-sensitive (does the probelm arise in read-only use ?) | use derived org.hibernate.dialect.MySQLBinDialect which defines case sensitive-tables |
| PostgreSQL | none, worked smoothly and gracefully | no need, use standard org.hibernate.dialect.PostgreSQL |
| HSQLDB | schema validation fails if hibernate.hbm2ddl.auto=validate error (see bug_HHH_1598) | turn off schema validation (not really necessary) or use org.hibernate.dialect.HSQLDialect2 |
| Derby | java.sql.Types.CLOB maps to clob(255) (the problem is actually in DB2 dialect from which Derby dialect is inherited) | use derived org.hibernate.dialect.DerbyDialect2 |
| SQlite | some drivers (like 3.6.20) are buggy dialect maps java.sql.Types.CLOB to clob, but there is no clob support in JDBC driver | use modified org.hibernate.dialect.SQLite which maps CLOB to longvarchar use newest drivers 3.6.20.1 |