New Features in IJC Q2 2017

Customizable positioning of null values when sorting

The new functionality that allows custom ordering on columns that are marked for sorting in IJC. The settings for this is in Schema Settings -> Miscelanous with custom value of "Database default", ordering empty values "First" or empty values "Last".

Summarization of default values for most popular RDBMs:

RDBMs

ORDER BY .. ASC

ORDER BY .. DESC

Oracle

NULLs last

NULLs first

MySQL

NULLs first

NULLs last

SQL Server

NULLs last

NULLs first

PostgreSQL

NULLs last

NULLs first

Derby

NULLs last

NULLs first

Printing improvement

Printing performance and memory consumption improved. Especially noticeable while printing large data.