Changeset 945 for trunk


Ignore:
Timestamp:
05/24/11 12:54:27 (8 years ago)
Author:
gav
Message:

Introduce appNameLowerCase variable for production database naming convention, part 2.
Also change default production SQL host to 'sql01'.

Location:
trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/gnuMims-config.groovy

    r943 r945  
    5353//             password = "${appNameLowerCase}admin" 
    5454//             dbCreate = "update" 
    55 //             url = "jdbc:sqlserver://${appNameLowerCase}sql01:1433;databaseName=${appNameLowerCase}_prod" 
     55//             url = "jdbc:sqlserver://sql01:1433;databaseName=${appNameLowerCase}_prod" 
    5656            /** MySQL */ 
    5757            dialect = org.hibernate.dialect.MySQL5InnoDBDialect 
     
    6060            password = "${appNameLowerCase}admin" 
    6161            dbCreate = "update" 
    62             url = "jdbc:mysql://${appNameLowerCase}sql01:3306/${appNameLowerCase}_prod?autoReconnect=true&sessionVariables=storage_engine=InnoDB" 
     62            url = "jdbc:mysql://sql01:3306/${appNameLowerCase}_prod?autoReconnect=true&sessionVariables=storage_engine=InnoDB" 
    6363        } 
    6464    } 
  • trunk/grails-app/conf/DataSource.groovy

    r923 r945  
    1515// If nothing specified then do nothing to database schema. 
    1616 
     17def appNameLowerCase = appName.toLowerCase() 
     18 
    1719// Environment specific settings. 
    1820// All production config is in external config. 
     
    2931//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect 
    3032//             driverClassName = "com.mysql.jdbc.Driver" 
    31 //             username = "gnumimsadmin" 
    32 //             password = "gnumimsadmin" 
     33//             username = "${appNameLowerCase}admin" 
     34//             password = "${appNameLowerCase}admin" 
    3335//             dbCreate = "create-drop" 
    34 //             url = "jdbc:mysql://host:3306/gnumims_dev?autoReconnect=true&sessionVariables=storage_engine=InnoDB" 
     36//             url = "jdbc:mysql://host:3306/${appNameLowerCase}_dev?autoReconnect=true&sessionVariables=storage_engine=InnoDB" 
    3537        } 
    3638    } 
     
    4648//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect 
    4749//             driverClassName = "com.mysql.jdbc.Driver" 
    48 //             username = "gnumimsadmin" 
    49 //             password = "gnumimsadmin" 
     50//             username = "${appNameLowerCase}admin" 
     51//             password = "${appNameLowerCase}admin" 
    5052//             dbCreate = "update" 
    51 //             url = "jdbc:mysql://host:3306/gnumims_test?autoReconnect=true&sessionVariables=storage_engine=InnoDB" 
     53//             url = "jdbc:mysql://host:3306/${appNameLowerCase}_test?autoReconnect=true&sessionVariables=storage_engine=InnoDB" 
    5254        } 
    5355    } 
Note: See TracChangeset for help on using the changeset viewer.