Sunday, March 30, 2008

Grails: errors.GrailsExceptionResolver org.hibernate.exception.SQLGrammarException: could not execute query解决办法

最近把我的Grails应用从0.4升级到1.0,发现我原来的domain对象的访问出现了一些问题,在执行查询的时候总是报errors.GrailsExceptionResolver org.hibernate.exception.SQLGrammarException: could not execute query错误,以前我的domain内容如下:
class User {
static withTable = "XX_USER"
String username
String password
static constraints = {
username(length:1..20,blank:false,unique:true)
password(length:1..20,blank:false)
}
}
后来我将static withTable = "XX_USER"改为
static mapping = {
table 'XX_USER'
}
然后重新启动grails,就OK了。