Connect a database

In the DATALINK tab you can connect your database with CLOUDFLOW.

To connect a database, follow these steps:

1. Activate the JAVA WEB APPS HOST Worker.

This Worker hosts java web archives. Go to SETTINGS > WORK SERVERS to activate it. See JAVA WEB APPS HOST for more information on the Worker and on how to deploy war files.

2. Add your database

  1. Go to DATALINK > DBs.
  2. Select ADD A DATABASE.
  3. Complete the following fields:
    • Name: here you can define a name for the connection.
    • Driver: here you can define the driver. The driver depends on the type of database you want to connect. You can copy the correct driver from the table below.
    • JDBC URL: here you can enter the JDBC URL. This also depends on the type of database and can be copied from the table below. Make sure to replace host and dbname by the correct values.

      Example

      You have a postgress database called mydba and your host is 127.0.0.1. In that case, the JDBC URL would be jdbc:postgresql://127.0.0.1:5432/mydba. If you're using a local host, jdbc:postgresql://localhost:5432/mydba is also possible.

      Note: Postgres uses 5432 as the default port. If you change the port, you also need to change it in the JDBC URL.
    • Username: here you can enter the username.
    • Password: here you can enter the password.
    • Max Total: here you define the maximum number of database connections that can be opened at any time.
    • Max Idle: here you can define the maximum number of idle database connections.
    • Min Idle: here you can define the minimum number of idle database connections.
    • Test Query: here you can enter a test query.
    • Default Transaction Isolation: here you can select the default transaction isolation.
  4. Select SAVE.
All connected databases appear in an overview list.
  • To edit an existing connection, select the connection.
  • To test the connection, select .
  • To delete the connection, select .