[hibernate-dev] Form-feed (\f 0x0C) in generated SQL

Mark Rotteveel mark at lawinegevaar.nl
Sat Feb 4 09:05:46 EST 2017


Firebird has a problem with some of the SQL generated by Hibernate, in 
some queries Hibernate appends StringHelper.WHITESPACE between 
conditions (specifically in CollectionBinder.bindFilters(boolean)).

The problem is that StringHelper.WHITESPACE contains a formfeed (\f, 
0x0C), and Firebird does not accept a formfeed as whitespace.

It looks like the usage of StringHelper.WHITESPACE is wrong; the other 
places this constant is used is for splitting/tokenizing strings, and 
not for adding whitespace.

Is there any objection if I replace the usage in 
CollectionBinder.bindFilters(boolean) with a single space (or maybe with 
" \n\t" to produce more similar SQL as previous)?

Mark
-- 
Mark Rotteveel


More information about the hibernate-dev mailing list