download the drizzle-jdbc package… here’s the maven repo

download the drizzle dialect (thanks to this guy)

create your tables based off of your grails domain classes…

setup your datasource, as such:

dataSource {
            pooled = true
            dbCreate = "update"
            url = "jdbc:drizzle://localhost:4427/database?autoReconnect=true"
            driverClassName = "org.drizzle.jdbc.DrizzleDriver"
            dialect = org.drizzle.hibernate.dialect.DrizzleDialect
            username = "root"
            password = ""
}

when you setup drizzle, it will let you connect as root with no password… i’ll post an update on how to add a user when i figure it out…

© 2013 Dan's Blog Suffusion theme by Sayontan Sinha