Erro com SQL Server 2008
24/08/2012 07:53
dataSource {
pooled = true
dialect = "org.hibernate.dialect.SQLServerDialect"
driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
username = "*****"
password = "*****"
}
// environment specific settings
environments {
production {
dataSource {
dbCreate = "update"
url = "jdbc:sqlserver://<MEUENDPOINT>:1433;databaseName=<NOME_BANCO>"
}
}
}
class LembreteController {
static allowedMethods = [save: "POST", update: "POST", delete: "POST"]
def index = {
redirect(action: "list", params: params)
}
def list = {
params.max = Math.min(params.max ? params.int('max') : 15, 100)
def ordem = ""
if(params.order.equals("desc")){
ordem = "DESC"
}
if(params.order.equals("asc")){
ordem = "ASC"
}
def lembreteTotal = Lembrete.executeQuery("SELECT COUNT(id) from Lembrete as l where l.pessoa.id=:usuarioId and l.pessoa.escola.id= :id",[id:Long.valueOf(session.escola_id), usuarioId:Long.valueOf(session.user.id)])
def lembreteList = Lembrete.findAll("from Lembrete as l where l.pessoa.id=:usuarioId and l.pessoa.escola.id= :id ORDER BY "+params.sort+" "+ordem,[id:Long.valueOf(session.escola_id), usuarioId:Long.valueOf(session.user.id)], params)
[lembreteInstanceList:lembreteList, lembreteInstanceTotal: lembreteTotal[0]]
}
Para se registrar, clique aqui.