How to attach database file from Grails to STS datasource
Hi all,
I want to be able to browse and edit my dev-datasource through STS.
I am using standard Grails setup with the h2 driver, however i changed it to update and file - why it how looks like this:
Code:
dataSource {
pooled = true
driverClassName = "org.h2.Driver"
username = "sa"
password = ""
}
environments {
development {
dataSource {
dbCreate = "update" // one of 'create', 'create-drop', 'update', 'validate', ''
url = "jdbc:h2:file:devDb;MVCC=TRUE"
}
}
}
How can I attach this database file to STS so I can browse it, run queries and etc.? It seems I cant find the right jar for the job, and STS limits my possible connection types...
Hope you can point me in the right direction!