column « MySQL « JPA Q&A

1. Filtering on calculated columns in hibernate? (HAVING)

Say I have a table with two columns, X and Y. I would like to run the following query via hibernate:

SELECT X*X + Y*Y AS Distance, POINTS.* from POINTS 
WHERE X > ...

2. Is it possible to detect unused columns in my DB using Hibernate?

I've got a MySQL database with a hundred or more tables, which is used with Hibernate, and I've come across a couple of columns that are no longer in use. That ...

4. Reserved words in MySQL column names

5. Using reserved words as column names for MySQL.

While learning how to use Hybernate I'm working on a small order system. One of the classes within this system is the credit of a customer and I implemented this as follows: This caused ...