In This Chapter
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, PostgreSQL, for you if you do not already have a database management system (DBMS).
In Servoy Developer, you may create a new PostgreSQL database from the Solution Explorer tree.
You may also connect to an existing database in Servoy Developer.
Create a new Database Server connection by right clicking on Database Servers node (under Resources) and selecting New Server. A submenu will provide choices of different popular database choices that will fill in some of the connection information to make setup easier, or you may choose empty.
NOTE
Even though a database is listed here, you must still install a driver in the drivers folder in order to connect to the database.
Fill in the Server Name, User Name, Password, URL, and Driver for your database. You can find the correct values for the URL and Driver from your database documentation, or suggested values will be already entered if you selected your database in the New Server menu.
NOTE
The user account should be of administrator level so you have full access to database objects in Servoy.
It is best practice to create your data model (tables, primary keys, foreign keys, and fields) before you create your solution. You can create objects in the database with database tools built to administer the database, or you may create objects within Servoy Developer.
To create a table in Servoy Developer:
The table editor view will appear allowing new columns to be entered.
NOTE
When a new table is created, Servoy will add a column in the table editor for the primary key. All tables used in Servoy must have a primary key or a row identifier.
To create columns in Servoy Developer: