Servoy 3.5.2: Can't search dates using SQL with PostgreSQL

Classic Servoy
1 
var query = "SELECT book_id FROM books WHERE date_1 < ?";
var args = new Array()
args[0] = new Date();
controller.loadRecords(query,args);

This works fine when testing against a MySQL database. But when using PostgreSQL, it fails with an error

Error loading primary key data, Can't infer the SQL type to use for an instance of java.util.Date. Use setObject() with an explicit Types value to specify the type to use.
com.servoy.j2db.dataprocessing.DataException: Can't infer the SQL type to use for an instance of java.util.Date. Use setObject() with an explicit Types value to specify the type to use.

Test case submitted already.

2

This issue is solved in 3.5.3, see my post in http://forum.servoy.com/viewtopic.php?p=47061#47061

Rob

3

Thanks Rob.

C.