Is MS SQL Server and Oracle Supported?

22 views
Skip to first unread message

Jeffrey Spencer

unread,
Jul 18, 2013, 5:45:29 PM7/18/13
to grails-acti...@googlegroups.com
The Activiti library indicates it supports all major RDBMS systems including MS SQL, Oracle, DB2, etc. Does the plugin support connections to MS SQL via the extra properties in the Config file?

The documentation on the project page seems to indicate it's limited to H2, MySQL and Postgres SQL. Can someone please confirm the following?

1. If I were to connect to say MS SQL, how would I do it below?
2. Does the plugin utilize the Grails datasource instead so no extra db configuration is needed?

// Added by the Grails Activiti plugin:
activiti {
    processEngineName = "activiti-engine-default"
      databaseType = "h2"
      deploymentName = appName
      deploymentResources = ["file:./grails-app/conf/**/*.bpmn*.xml",
                             "file:./grails-app/conf/**/*.png",
                             "file:./src/taskforms/**/*.form"]
      jobExecutorActivate = false
      mailServerHost = "smtp.yourserver.com"
      mailServerPort = "25"
      mailServerUsername = ""
      mailServerPassword = ""
      mailServerDefaultFrom = "user...@yourserver.com"
      history = "audit" // "none", "activity", "audit" or "full"
      sessionUsernameKey = "username"
      useFormKey = true
}
Reply all
Reply to author
Forward
0 new messages