Re: SQL-Log

The ellipsis is generated by HSQLDB.

There is a LEVEL 4 for logging which does not truncate long parameters.

Fred

On Fri, Aug 25, 2017, at 11:32, Thorsten Goetzke wrote:
> 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
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

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