Different types of Query Validation

Classic Servoy
1

In the server settings there are 3 different types of Query Validations:
Exception Validation
Meta Data Validation
Query Vaildation

The default is Exception, which I am currently using.

Can someone please explain the difference between these three? Also how and when should each be used?

Thanks.

2

Hi,

This has been covered pretty extensively on the forum, just search for query validation. Also see the Network Settings page in the Servoy Server administration pages, it has an explanation there too. I would recommend query validation with a simple query (select 1) for production servers.