Hi, I get this error: java.sql.SQLException: select command denied to user... when I want to make any consult to my mysql database (sesion.createQuery). I can connect without any problems to the db.

I'm getting crazy because the configuration data of the hibernate.properties and hibernate.cfg.xml are ok. I see these data in the log and they are correct.

I have another java aplication (with the same user, passwd and host data) which access to the same mysql database without hibernate and I can make: selects, updates, delele and so on. Also, the data in the user table are correct in mysql database.

I am very very lost. Can somebody help me???

Thanks a lot.

This problem occured for me when I was coding in a test and production environment with the mysql database named different in each ('userstest' in test environment, 'usersprod' in production.)

When generating the hibernate code, it hardcoded the catalog into Java objects like:

So, when deploying to production, hibernate was looking for the table in 'userstest' database which didn't exist.

The quick fix was just to name all the databases the same across the different environments, then regenerate the hibernate java objects to use the proper database name.