Child pages
  • Troubleshooting

Versions Compared

Key

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

...

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.