generate « MySQL « JPA Q&A

1. How to generate case sensitive columns with JPA in MySQL automatically

How can I order JPA to set a MySQL database column with text content as case sensitive by default upon creation?

2. A bug generating SQL for MySQL?

3. Invalid sql generated for Mysql.

Summary: Executed sql appears to be invalid for Mysql. Hibernate version: 3.1 Mapping documents: Code: ...

4. Error in generated SQL using MySQL's INTERVAL

I have a set with the 'where' property as: Code: where="even_inicio >= DATE_SUB(NOW(), INTERVAL 30 DAY)" But the generated SQL apparently interprets INTERVAL as a field in the table as seen in the generated SQL bellow. Is this a bug? Is there a workaround it? Thanks in advance Need help with Hibernate? Read this first: ... AskForHelp Hibernate version: 3.1 ...