Servoy 2020 Documentation
Child pages
  • Database Connections

Versions Compared

Old Version 28

changes.mady.by.user Paul Bakker

Saved on

compared with

New Version 29

changes.mady.by.user Paul Bakker

Saved on

Key

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

...

Table of Contents
filter^((?!Table of Contents).)*$

High level overview

The Servoy Application Server connects to databases through JDBC. In order to connect to a database, Servoy requires the right JDBC driver to be placed in the {servoyInstall}/application_server/drivers directory, after which a restart of the Application Server is required.

Connections to databases can be configured through the Servoy Admin page and all settings are stored in the servoy.properties file located in {servoyInstall}/application_server. 

Servoy Clients send their query requests to the Servoy Application Server, which in turn connects to the database to execute the query and return the result to the Client

The Servoy Application Server manages a pool of database connections for each database server, in order to minimize the overhead of creating new connections for each request. 

JDBC Drivers

In order to be able to connect to a database, the Servoy Application Server requires the JDBC Driver for the specific database. JDBC drivers usually come with the database or are provided separately by the database vendor or third party vendors.

...