Database Configuration

Changing default datasource settings

1. Locate your datasource-default.properties file in your home directory (/home/myaccount in Linux and /Documents and Settings/myaccount in Windows)
2. Open file using any text editor
3. Make changes where necessary (anything from username, passwords. connection URLs, etc)
4. Save file and restart Joget

Additional note for MySQL 5.1.49: When using certain versions of MySQL e.g. 5.1.49, there might be exceptions during data insertions e.g. starting a process or creating a group. To solve this issue, add &useServerPrepStmts=false in the JDBC URLs e.g. jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8&useServerPrepStmts=false

Working with datasource profiles

If you're continually working with different datasource sets and don't want to keep commenting/uncommenting and/or renaming property files, you can make use of the profiles that are available. In your home directory, you'll (by default) find 2 files that deals with datasource settings. The datasource.properties file points to the current profile that should be used and you'll see a datasources-default.properties that should contain the details of your connection pools. To create a new profile, simply create a new properties file that is prefixed with "datasources-". If our new datasource profile is called "mynewprofile" then we're looking at:

1. Create new file called datasources-mynewprofile.properties in your home directory (/home/myaccount in Linux and /Documents and Settings/myaccount in Windows)
2. Edit the file using a text editor and specify your connection settings. Save file when done.
3. Open up datasources.properties and point your currentProfile to mynewprofile. Save file when done.
4. Restart Joget.