Wysmedia.com

Here is a little tips to let grails create using innodb engine on mysql, everytime grails create a domain/table.

1
2
3
4
5
6
7

 dataSource {
      pooled = true
      driverClassName = "com.mysql.jdbc.Driver"
      username = "wysmedia"
      password = "password"
      dialect = org.hibernate.dialect.MySQLInnoDBDialect
 }

dialect = org.hibernate.dialect.MySQLInnoDBDialect that’s the main idea to set mysql using innodb. With InnoDB you can use service transaction or database transaction

Yesterday I got a headache problem with a checkbox. I wrote like this on GSP

1
2
3
4
5
6

<g:form action="save">
... table ... 
<g:checkBox name="myCheckbox" value="" />
... other element ... 
<input type='submit' value='Save'/>
</g:form>

did you know what the happened ? myCheckbox always returned empty or null value everytime I saved the form. I thought Grails has bug at first, I did check and create a checkbox using scaffold and I found that value=”" makes the null value everytime I saved the form
The solution was simple enough:

1
2
3
4
5
6

<g:form action="save">
... table ... 
<g:checkBox name="myCheckbox"/>
... other element ... 
<input type='submit' value='Save'/>
</g:form>

Just eliminate value=”" and it all solved. I learned that using value=”somethingHere” can be useful if we want to save a value into our database. I hope my tricks can save you from headache. Be aware of checkbox .. hahaha…

Sometimes, we need to refactor our domain / database table.  For example, our first domain looks like this :

1
2
3
4

class Person {
String personName ;
BigDecimal monthlyIncome ;
}

Now we want to eliminate/change the monthlyIncome and replace it with BigDecimal weeklyIncome

we type

1
2
3
4

class Person {
String personName ;
BigDecimal weeklyIncome;
}

But, when we look at the table, it still have monthlyIncome field. That’s why we need to eliminate it. If we works as a team, this could be a messy and troublesome, because monthlyIncome is not nullable. So it produce error (JDBC errors) when someone tried to update or save into that table.

That’s why we need Autobase for this dirty job. Autobase is Grails plugin that created base on Liquibase. Liquibase, however using xml format to do database migration. I hate to write on xml actually.
Luckily, Robert Fischer, wrote this useful Grails’s plugin, so that we can write it using Groovy DSL.
Read the rest of this entry »