SQL-Log

Hello,

I am currently trying to debug an Issue where a prepared query doesn't 
find the expected row. I enabled the SQL-Log using:
SET DATABASE EVENT LOG SQL LEVEL 3
In the query log i can find my query:

2017-08-25 11:38:02.861 DETAIL 3 select datapointd0_.DRAFT_ID as 
DRAFT_ID1_46_, datapointd0_.NAME as NAME2_46_, datapointd0_.VISIBILITY 
as VISIBILI3_46_, datapointd0_.TYPE as TYPE4_46_, datapointd0_.CATEGORY 
as CATEGORY5_46_, datapointd0_.DATA_POINT_ID as DATA_POI6_46_, 
datapointd0_.PARENT_ID as PARENT_I7_46_, datapointd0_.META_DRAFT_ID as 
META_DRA8_46_, datapointd0_.GLOBAL_ID as GLOBAL_I9_46_, 
datapointd0_.VERSION_ID as VERSION10_46_, datapointd0_.MODIFIER_ID as 
MODIFIE11_46_, datapointd0_.TIMESTAMP as TIMESTA12_46_, 
datapointd0_.DELETED as DELETED13_46_, datapointd0_.RESPONSIBILITY as 
RESPONS14_46_ from ULS_DRAFT_DATA_POINT datapointd0_ where 
datapointd0_.NAME=? ('GENERATED/GOM/SingletonHand ...)

So my theory is that the ellipses behind "SingletonHand" are part of the 
log format and have nothing to do with what is actually passed to 
hsqldb(?) Is this correct? If yes, is there a way to see the unshortened 
parameter? I somewhat expect the our application to mess up something 
about parameter.
If I Query the Database directly using:
2017-08-25 11:48:58.373 DETAIL 4 SELECT * FROM 
"PUBLIC"."ULS_DRAFT_DATA_POINT" where NAME = 
'GENERATED/GOM/SingletonHandle/"SYS:ROOT_system#1/SYS:GOM_1"'
the expected row will be returned.

Best regards,
Thorsten


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot