This chapter provides an overview of the procedures for connecting to a database, creating a new database, and other common functions when working with databases in Servoy. For more information, see also the Deployment Guide.

Connecting to a Database

Servoy can connect to any database that has a JDBC driver; common drivers come pre-installed with Servoy. To connect to an existing Database:

  1. In Solution Explorer, access the context menu for Database Servers under the Resources project node.
  2. Select Connect to an existing database and select your desired database from the list.
  3. Save the new database connection using the File > Save menu.

More information about database server connections can be found in the Database Connections chapter of the Deployment Guide.

Creating a New Database

Servoy comes with a pre-installed PostgreSQL database. To add a new PostgreSQL database to your Resources project:

  1. In Solution Explorer, access the context menu for Database Servers under the Resources project node.
  2. Select Create new database > Create PostgreSQL database from the list.

The new database connection will appear under the Database Servers list.

Interacting with the Database Server

The context menu on the Database Servers node provides the following actions for local and database server interaction:

The following actions are also available via the context menu on each server listed under the Database Servers node: