Low We currently have a mix of upper-case and lower-case table names in Crowd. For example, ApplicationDirectoryPermission.hbm.xml contains no backticks in the table name:
<class name="com.atlassian.crowd.model.permission.ApplicationDirectoryPermission" table="APPLICATIONDIRECTORYPERMISSION">
while Application.hbm.xml does:
<class name="com.atlassian.crowd.model.application.Application" table="`APPLICATION`">
We should default on one convention as case-sensitive databases like Postgres will require you to wrap all queries that reference the tables or columns in quotes or the query won't be recognized. For people that might be interested in querying the database, or for times when we need to pass some queries to users to run, it would be nice not to have to worry about this.
- is incorporated by
-
CWD-1507 Crowd Schema + Domain Model update to improve performance and cross-database compliance
- Closed
[CWD-1411] Make Crowd database schema lowercase
BTW, in the final 2.0 release all tables should be lowercase, right? As per CWD-1574.
Hi Justin,
Using MySQL 5.0.45 on a Mac with mysql-connector-java-5.0.6-bin.jar. I get the same behavior from both the standalone and the source distribution. I'll give another try with a fresh installation to collect the logs.
Cheers,
Aggelos
Justin Koke
added a comment - Hi Aggelos,
When crowd starts up I get the attached statements being executed by hibernate.
The only table that is lowercase is the hibernate_unique_key for hilo generation.
What version of MySQL (including JDBC driver version) are you using?
I am currently using: MySQL 5.1.30 and JDBC driver 5.1.7.
Cheers,
Justin
Justin Koke
added a comment - Hi Aggelos,
When crowd starts up I get the attached statements being executed by hibernate.
The only table that is lowercase is the hibernate_unique_key for hilo generation.
What version of MySQL (including JDBC driver version) are you using?
I am currently using: MySQL 5.1.30 and JDBC driver 5.1.7.
Cheers,
Justin
Justin,
trying out the Beta2 installation I've noticed that some of the tables are lowercase and the majority is uppercase. I'm Attaching a screenshot of the created schema in MySQL. Is this expected?
Cheers,
Aggelos
Justin Koke
added a comment - Fixed as part of our Schema upgrade/improvements 
David O'Flynn [Atlassian]
added a comment - Will be fixed as part of the schema update we're working on right now.
David O'Flynn [Atlassian]
added a comment - Will be fixed as part of the schema update we're working on right now. 
yes, we did this to resolve the irregularity you have seen here and to generally be inline with JIRA/Confluence/Bamboo etc.