{code:sql}
2018-09-17 11:16:20,508 org.hibernate.SQL DEBUG select this_.id as id1_11_0_, this_.attempts as attempts2_11_0_, this_.createDate as createDa3_11_0_, this_.
errorInfo as errorInf4_11_0_, this_.modifyDate as modifyDa5_11_0_, this_.status as status6_11_0_, this_.accountNo as accountN7_11_0_, this_.balance as balance8_11_0_ from sample_
balance_query this_ where this_.status=? and this_.attempts=? and this_.modifyDate<? order by this_.createDate asc limit ? for update skip locked
2018-09-17 11:16:20,512 org.hibernate.type.descriptor.sql.BasicBinder TRACE binding parameter [2] as [INTEGER] - [1]
2018-09-17 11:16:20,515 org.hibernate.type.descriptor.sql.BasicBinder TRACE binding parameter [3] as [TIMESTAMP] - [Mon Sep 17 11:15:20 CST 2018]
{code}
logging is start with index 2, because status is mapped as java Enum, hibernate will use EnumType wrapped by CustomType, it will not call BasicBinder.bind(),I have two immature suggestions:
1. add log.trace() in EnumType
2. Use AttributeConverter convert Enum to IntegerType or StringType base on @Enumerated |
|
