hi

i am new to Grails application development.

i have developed a application and it is in production server a problem in my datasource connection


I tried the access the application and it threw a grails exception (unable to connect to sql).

I guess the sql server went to sleep mode .. I kept hitting the url for sometime and it worked.

So i used autoReConnect=true in the sql connection code

production {
dataSource {
dbCreate = "update"
url = "jdbc:mysql://ipaddress/kfg?autoReconnect=true"
}
}

can anybody will help me in this.

thanks in advance.