Set Up a Database

When accessing Joget for the first time, the platform will require the initialization of your database. A setup screen will be presented to set up Joget with your chosen database type, such as:

• MySQL
• MSSQL
• Oracle
• PostgreSQL

See the following image for an example of the setup screen:

When setting up a database, you need to provide the following information:

• Database Type: Lists the available databases from which to choose.
  
  • MySQL
  • Oracle
  • MS SQL Server
  • PostgreSQL
  • Custom
• Database Host: Name of the database server.
• Database Port: The port number of the database.
• Database User: The account username used to connect to the database.
• Database Password: The account password used to connect to the database.
• Include Sample Apps: Check to pre-load the sample Joget apps.
• Include Sample Users: Check to pre-load the sample Joget users.

Once all the fields are filled in, you can click Save to finish the database integration, you will be presented with the default login information. See the following image for an example:

Troubleshooting

If you are upgrading from another edition or from a previous version of the Enterprise Edition, please refer to the Upgrade Guide.

You may get the error above or a similar one if you attempt to set up a database with existing data. Do not use existing database to avoid data loss. To resolve this error, change the "Database Name" to another name. E.g. jwdb2, etc.

You may get the error above if Joget fails to connect to the database due to failed authentication. Check your database connection parameters and try again.

INFO  09 Oct 2015 15:39:03 org.joget.commons.util.DynamicDataSource  - datasourceName=workflow, url=jdbc:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=jwdb, user=sa
ERROR 09 Oct 2015 15:39:18 org.joget.commons.spring.web.CustomContextLoaderListener  - ===== Error initializing WebApplicationContext =====

You may get an Error initializing WebApplicationContext after successful set up of database. In this scenario, you will need to check your database connectivity from the app server to the database server.