Dialect « MySQL « JPA Q&A

1. Hibernate mysql innodb stackoverflow.com

I wanted to force hibernate to use innodb. So, i changed the "hibernate.dialect" in order to have innodb, but i can connect to mysql, but when i do some transactions i have ...

2. What Hibernate 3.5.1 Dialect is best for accessing MySQL 5.1 stackoverflow.com

Right now I am using InnoDB tables but what confuses me is what if I am using more than one engine in the DB? Since I used 'best' in the title it ...

3. MySQL JPA Dialect forum.hibernate.org

4. Hibernate using reserved word Group with MySQL dialect forum.hibernate.org

Hibernate version: 2.1.6 Mapping documents: Full stack trace of any exception that occurs: [Syntax error ...

5. MySQL dialect generating underscores in table name - error forum.hibernate.org

The generated SQL code is putting underscores in the query which causes a table not found exception. I've put my mapping info below. I searched the forum and found similar problems from other users, but I didn't see a clear way to fix it. I don't have a schema name specified anywhere. Any ideas on how to get these underscores out? ...

6. MySQL 5 dialect and hibernate3 forum.hibernate.org

Here is the first set of issues. I think the problem is more with the latest MySQL jdbc driver for MySQL5 database. "mysql-connector-java-3.1.10-bin.jar". If you install latest MySQL5 DB, and map any primitive and I am testing with boolean, here is what I found out so far. ============================ 12:24:41.187 ERROR - Null value was assigned to a property of primitive type ...

7. Hash sign in column names / MySQL5 dialect forum.hibernate.org

16:36:46,468 DEBUG [JDBCExceptionReporter] could not execute query [select count(compound0_.FLLAG#) as col_0_0_ from H_HOEDTA.FZLLAGP compound0_] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) ...