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.
   • The database editor window will open that allows you to specify properties for the database connection.
3. Save the new database connection using the File>Save File > Save menu.
   • The new database connection will appear under the Database Servers list.
   • This step is only required when you first add a new type of database connection to Resources project. Additional database connections to the same database type will be saved to the project automatically.

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 database > Create PostgreSQL database from the list.
   • The database editor window will open that allows you to specify properties for the database connection.

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:

...