[ http://jira.andromda.org/browse/HIB-198?page=comments#action_13981 ]
Manish Baxi commented on HIB-198: --------------------------------- My laptop suffered a crash a few days back due to which I lost all local changes. I am slowly re-constructing the code that I had before the crash. I have been able to attach the cartridge changes I had made for other issues I have uploaded. I have started (re)working on this one only now. This will is a little lengthier since there are changes to the Profile and the Namespace and hence the changes will take time. Will upload the changes shortly. > Support for quoted identifiers is required > ------------------------------------------ > > Key: HIB-198 > URL: http://jira.andromda.org/browse/HIB-198 > Project: Hibernate Cartridge > Type: New Feature > Versions: 3.2-RC1 > Reporter: Manish Baxi > Assignee: Carlos Cuenca > Priority: Critical > > We have a lot of objects in our domain model which share their names with > database keywords or system tables. One of the simplest examples is the > object called USER. We also have a restriction that we cannot change their > names to make them plural, etc. > In a default AndroMDA set up, the database creation scripts fail to create > these tables in the database as the relevant statements fail with a syntax > error. When we were not using AndroMDA to generate the HIBERNATE code, we > had all names specified in .hbm.xml classes with backticks. This syntax is > supported by HIBERNATE which then makes sure that the database creation > scripts use the correct SQL syntax, based on the database dialect selected. > Right now we are forced to go into the tagged values for the offending > objects and manually specify their table names with backticks. Therefore, > the table name for USER has been manually specified as `USER`. > My suggestion is that a property called 'enableQuotedIdentifiers' be added to > both the Profile and the Namespace which should be checked at the time of > generating .hbm.xml files and if its value is found to be true, the table > names be enclosed in backticks. > I have tested these changes locally on my machine by modifying the HIBERNATE > cartridge and they work fine. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.andromda.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
