Child pages
  • Working with Database Servers

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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, consult the Databases chapter in the Deployment guidesee 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.

...

  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.

...