[jboss-user] [EJB 3.0] - EJB3 for MySQL has Quote and errors.
don@inpowersoft.com
do-not-reply at jboss.com
Mon Oct 23 14:29:11 EDT 2006
I'm using jboss-4.0.4.GA with EJB3.
The JPA implementation in Hibernate generates quotes around the table name and cause MySql 5.0 version to error. I'm using mysql-connector-java-3.1.8-bin.jar JDBC driver.
The generated SQL is:
2006-10-23 09:33:52,615 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select roles0_.RO_SEQ_ID as RO1_96_, roles0_.code as code96_, roles0_.CREATED_BY as CREATED3_96_, roles0_.CREATED_TIME as CREATED4_96_, roles0_.MODIFIED_BY as MODIFIED5_96_, roles0_.MODIFIED_TIME as MODIFIED6_96_, roles0_.name as name96_, roles0_.version as version96_ from "lsapl_roles" roles0_]
Note if I take out the quote using lsapl_roles instead of "lsapl_roles", the query is fine.
thanks for any help
-dy
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3980130#3980130
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3980130
More information about the jboss-user
mailing list