Changes between Version 5 and Version 6 of ChangingTheDatabase
- Timestamp:
- Jan 11, 2010, 6:16:13 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ChangingTheDatabase
v5 v6 31 31 Currently gnuMims will not run against an Oracle DB without some work. [[BR]] 32 32 The known issues should be surmountable and are listed bellow: 33 * 30 Char limit, several gnuMims domain classes and attributes exceed this limit, this is possibly the biggest issue. 33 * 30 Char limit: 34 * Several gnuMims domain classes and attributes exceed this limit . 35 * This is possibly the biggest issue since Grails will create join tables for classes '!MyDomainClassName1' and '!MyDomainClassName2' as 'my_domain_class_name1_my_domain_class_name2'. 36 * Table mappings may be of use here? 37 * Abbreviated names would make building reports directly from the database much less intuitive. 34 38 * The default sequence generator does not create Id's as expected, a suitable hibernate sequence generator needs to be set. 35 39 * To store empty strings the IS_NULLABLE metadata for the column needs to be set. 36 * [http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96540/ap_keywd.htm Oracle reserved words] ("comment" and "date") this can be solved with a mapping in the appropriate classes:40 * [http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96540/ap_keywd.htm Oracle reserved words] ("comment" and "date") this can be solved with a mapping in the appropriate domain classes: 37 41 {{{ 38 42 static mapping = {