Externalizing Grails Datasource configuration

by

You can use a properties file specified in the grails.config.locations as a way to externalize the datasource configuration. Below is how I typically set up a Grails project:

In my DataSource.groovy I specify this for the production environment:

  ....
  ....
  production {
    dataSource {
        dbCreate = "update"
        driverClassName = "com.myorg.jdbcDriverNotExists"
        url = ""
        username = ""
        password = ""
    }
  }
  ....
  ....

I specify an external properties file in my Config.groovy:

grails.config.locations = [ "classpath:app-config.properties"]

In the properties file (stored in grails-app/conf/) I specify the actual datasource info:

dataSource.driverClassName=oracle.jdbc.OracleDriver
dataSource.url=jdbc:oracle:thin:@host:port:sid
dataSource.username=sa
dataSource.password=secret

I also use the properties file as a way to override other values that are in Config.groovy. When the app is deployed, if I have to modify the datasource info I just edit the /WEB-INF/classes/app-config.properties file and restart.

More Related Contents:

  1. Nginx 403 error: directory index of [folder] is forbidden
  2. How to set default PyCharm interpreter?
  3. What’s the difference of $host and $http_host in Nginx
  4. Adding a build configuration in Xcode
  5. Given URL is not permitted by the application configuration
  6. How do I prevent a Gateway Timeout with FastCGI on Nginx
  7. Turning off eslint rule for a specific file
  8. Disable Maven central repository
  9. How to share common properties among several maven projects?
  10. Enable tcp\ip remote connections to sql server express already installed database with code or script(query)
  11. How to change Vagrant ‘default’ machine name?
  12. notepad++ user defined regions with folding
  13. Is there a way to specify Doctrine2 Entitymanager implementation class in Symfony2?
  14. Getting CMake to build out of source without wrapping scripts
  15. Log4Net config in external file does not work
  16. Disable “Auto ID elements” in Visual Studio 2013
  17. How to properly install and configure JSF libraries via Maven?
  18. HttpWebRequest using Basic authentication
  19. How to use JNDI DataSource provided by Tomcat in Spring?
  20. ASP.NET web.config: configSource vs. file attributes
  21. Grails unable to install plugin
  22. How can I find all beans with the custom annotation @Foo?
  23. Spring Data JPA – Multiple EnableJpaRepositories
  24. Hadoop cluster setup – java.net.ConnectException: Connection refused
  25. JPA 2.0: Adding entity classes to PersistenceUnit *from different jar* automatically
  26. Annotation Configuration Replacement for mvc:resources – Spring
  27. How to resolve Node.js ES6 (ESM) Modules with the TypeScript Compiler (TSC). TSC doesn’t emit the correct file-ext
  28. How to get config parameters in Symfony2 Twig Templates
  29. Why do we use a DataSource instead of a DriverManager?
  30. Does Grails 2.3.x Support JDK 8

Leave a Comment