Child pages
  • Troubleshooting

Versions Compared

Key

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

...

Servoy Application Server

Server doesn't start

When the Servoy Application Server will not start, there are two likely reasons for it:

  • Is the database containing the Servoy Repository running? Note that the Servoy Application Server doesn't start a database, not even the bundled PostgreSQL database.
  • Does the application Server fail to start after disabling or updating the SSL settings? The passwords of the database connectiosn defined of the server and stored in the servoy.properties file are encrypted using the SSL settings. due to the update to the SSL settings, the passwords cannot be decrypted anymore. Remedy: manually reset the passwords in the servoy.properties file
  • javax.crypto.BadPaddingException: Given final block not properly padded: see previous item

...

  • ../application_server/servoy_log.txt
  •  

Network errors

Some Java environments start with IPv6 Stack. If this happens, while actually running IPv4, the result might be network errors. In order to prevent errors, the Servoy Application Server can be started with a preference to use the IPv4 Stack.

...

Is the required JDBC driver available?

Servoy comes bundled with a limited set of JDBC drivers, due to licensing. For example, it is not allowed to bundle JDBC drivers of Oracle or the official Microsoft SQL server JDBC driver. See the database section of the Servoy stack info for for a list of the shipped JDBC drivers. If no JDBC driver is listed for the database to which a connection needs to be made, it needs to be added manually. See Database Connectivity > JDBC Drivers for for more details on which JDBC driver to use and how to add it.

Is the database up and running?

While obvious that the database needs to be up and running in order for it to be used, it does happen quite often that the source of connectivity issues boils down to the database not being started. Note that the Servoy Application Server doesn't start any database!

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 heck 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
Oracle

When connecting to Oracle databases, make sure to use the correct version of the Oracle JDBC driver. Each Oracle database version has it's own version of a JDBC driver and when connecting to Oracle with a JDBC driver that was meant for another version of Oracle, the results can be mixed  

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.