Page History
...
The Tables & views do not show up in Servoy Developer/errors on the server about missing tables/views while the connection itself seems to work
Check that the schema and catalog properties of the database server settings are set correctly. These two properties are send to the database and based on those the database/JDBC driver filters the visible Tables/views for the connection
Errors because the connection to the database is lost
...
Servoy doesn't see the tables in the database
Most likely cause is the 'Schema' property for the connection. This property must be set to the appropriate 'Schema' in the Oracle database. The value for the 'Schema' property must be all uppercase when connecting to an Oracle Database.
SQL Server
Failed to establish a connection
...
System tables and Views show up in Servoy Developer, despite the "Skip System Tables" in the Database Server definition
This is a known issue with the SQL Server driver
MySQL
Connection to database lost
MySQL is notorious for dropping idle connections after a certain timeout. This can be prevented by using the following "validation query" for the Database Server connection: "select 1", at the cost of a little overhead. It's preferred to configure MySQL to use longer timeouts.