Changes between Version 4 and Version 5 of ChangingTheDatabase


Ignore:
Timestamp:
Jan 11, 2010, 6:05:56 PM (10 years ago)
Author:
Gavin
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ChangingTheDatabase

    v4 v5  
    44 * Perform an anonymous checkout.
    55 * Change grails-app/conf/DataSource.groovy file to suite.
    6  * Build your custom war with "grails war" command.
     6 * Test or build your custom war with "grails run-app" or "grails war" commands.
    77
    88Most common databases are supported by Grails (via Hibernate), we test and run MySQL (InnoDB). [[BR]]
    99The database must support transactions and row locking. [[BR]]
    10 A jar matching the configuration needs to be placed in the projects lib dir (e.g. lib/mysql-connector-java-5.1.7-bin.jar [http://dev.mysql.com/downloads/connector/j/5.1.html Connector])
     10A jar matching the configuration needs to be placed in the projects lib dir (e.g. lib/mysql-connector-java-5.1.7-bin.jar [http://dev.mysql.com/downloads/connector/j/5.1.html Connector]) [[BR]]
     11See the headings bellow for more details on each database tested so far. [[BR]]
    1112
     13For more info see the DeveloperStartPage and [http://www.grails.org/Quick+Start#Configure%20a%20Data%20Source%20(Optional) Grails documentation].
    1214
    13 See the DeveloperStartPage and [http://www.grails.org/Quick+Start#Configure%20a%20Data%20Source%20(Optional) Grails documentation].
     15'''MySQL''
     16
     17MySQL is the database we use most often and therefore the most thoroughly test and highly recommended. [[BR]]
     18Also see [wiki:InstallationTips Installation Tips]. [[BR]]
     19
     20'''PostgreSQL''
     21
     22Not tested, please email us if you have tested against PostgreSQL. [[BR]]
     23We will run some tests against PostgreSQL when time permits or if requests are made. [[BR]]
     24
     25'''MSSQL'''
     26
     27Live deployment in progress (11-Jan-2010) no issues so far. [[BR]]
     28
     29'''Oracle DB'''
     30
     31Currently gnuMims will not run against an Oracle DB without some work. [[BR]]
     32The 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.
     34 * The default sequence generator does not create Id's as expected, a suitable hibernate sequence generator needs to be set.
     35 * 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:
     37 {{{
     38    static mapping = {
     39    columns {
     40        comment column:'entry_comment'
     41      }
     42    }
     43 }}}
     44