Annyce Davis

Davis Technology Consulting

Deploying a Grails Application to Production

by

Beware of a weird grails config option!

To create a war file that can be deployed to a web server you would use grails war file_name.war, however this by default includes any plugins (so it seems) that you have installed with the application that you would not necessarily want deployed and can cause serious issues when deployed to your web server. So the fix is to use grails prod war file_name.war and the plugins are not included.

Rendering XML from a Grails Controller

by

I have been trying to render a simple XML file from a Grails Controller and I’ve found tons of blogs that provided the most complicated examples or examples that were too basic. After much tinkering around this is the code that will generate an XML file in the following format based on the items contained in the list.

<resultset>
<result>happy</result>
<result>sad</result>
<result>angry</result>
</resultset>
inside the Controller action...
def finalList = ['happy', 'sad', 'angry']

render(contentType: 'application/xml') {           
  resultSet(){               
     finalList.each { item ->                   
       result(item)               
     }           
   }         
}

Configuring MySQL with Grails

by

Here are the steps to configure your Grails application to work with a MySQL database.

  1. Put the MySQL Connector J driver class in the lib folder of your Groovy App.
  2. In the DataSource.groovy file remove the default HSQLDB information and replace with MySQL specific configuration. (Sample file using a database called ‘books’ is shown below)

dataSource {
pooled = true
driverClassName = "com.mysql.jdbc.Driver"
username = "root"
password = "admin"
}

hibernate {
cache.use_second_level_cache=true
cache.use_query_cache=true
cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'
}

// environment specific settings
environments {
development {
dataSource {
dbCreate = "create-drop"
url = "jdbc:mysql://localhost:3306/books"
}
}
test {
dataSource {
dbCreate = "update"
url = "jdbc:mysql://localhost:3306/books"
}
}
production {
dataSource {
dbCreate = "update"
url = "jdbc:mysql://localhost:3306/books"
}
}
}

Follow Me

  • Bluesky