Child pages
  • Database Connections

Versions Compared

Key

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

...

(warning)  Note that JDBC 3.0 and JDBC 4.0 should not be mistaken for JDBC type 3 or 4: JDBC types (1 through 4) are an indication how the communication between the Java process and the database is implemented, whereas JDBC 3.0 or JDBC 4.0 says something about the Java API exposed by the JDBC driver itself.

Connecting

...

to Databases

Connections to databases can be made from the Database Server page of the Servoy Admin page. The JDBC driver for the database to which the connection needs to be made has to be loaded into the Servoy Application Server already, see the JDBC Drivers paragraph above.

...

The Database Servers page on the Servoy Admin page shows per database the number of Active and idle connections, compared to their respective maximum value

Dimensioning

...

the Connection Pool

By default, the maximum active connections setting is set to 10. This could be too low when serving may clients from one Application Server or when the clients do many requests to the database or use long running transactions. As rule of thumb, if the actual used active connection regularly goes above 70% of the maximum a higher number of maximum active connections should be configured.

...