Page History

Almost all Servoy applications utilize a database to store user data and application metadata.  Servoy can connect to any database that has a JDBC driver available. Servoy provides a database, Sybase SQL AnywherePostgreSQL, for you if you do not already have a database management system (DBMS).

Creating a New Database in

...

PostgreSQL

In Servoy Developer, you may create a new SQL Anywhere PostgreSQL database from the Solution Explorer tree.

1. In the Servoy Developer Solution Explorer tab, expand the Database Servers node (under Resources) and right click on a SQL Anywhere any PostgreSQL database (all the example databases provided by Servoy are SQL AnywherePostgreSQL) to show the popup menu.
2. Select Create Sybase PostGreSQL Database.
3. Enter a name for the database in the dialog window.
4. A dialog will appear indicating a Sybase as the database restart is requiredbeing created.
5. A Another dialog will recommend to restart Servoy Developer.  Click OK. and close Servoy Developer.
6. Close Sybase SQLAnywhere.
   1. On Windows - Look for the orange lighting bolt in the system tray, right click, and select Shut down "servoy_repository"
   2. On Mac and Linux - find the dbsrv11 process and shut it down.
7. Restart Servoy Developer.
8. Your database will appear in the Database Servers nodealert you that the creation is finished. Click OK.

Connecting to an Existing Database

...