search

mahamuniraviraj / parancoe

Automatically exported from code.google.com/p/parancoe
Other
0 stars 0 forks source link

plugin security: table PSEC_USER in uppercase has issue when DB is MySQL #13

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
In the plugin-security the entity User defines the associated mapped table with 
the name PSEC_USER.
When the plugin is used in Linux with MySQL DB the hibernate generated query is 
not able to handle the LC/UC related to the name PSEC_USER;
At runtime I got this error (application was jugevents)

nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
Table 'jugevents.psec_user' doesn't exist

Solution:
Change the table name in the entity User from PSEC_USER to psec_user. 
In the meantime a possible workaround to manage case sensitive issues in 
MySQL/Linux is described  at this link:

http://enricogi.blogspot.com/2008/05/mysql-case-sensitive-in-linux.html

Original issue reported on code.google.com by enricogi...@gmail.com on 6 Oct 2010 at 4:23