Code: Select all
Hibernate: select adminuseri0_.ADMIN_USER_ID as ADMIN1_101_, adminuseri0_.ACTIVE_STATUS_FLAG as ACTIVE2_101_, adminuseri0_.EMAIL as EMAIL101_, adminuseri0_.LOGIN as LOGIN101_, adminuseri0_.NAME as NAME101_, adminuseri0_.PASSWORD as PASSWORD101_, adminuseri0_.PHONE_NUMBER as PHONE7_101_, adminuseri0_1_.SANDBOX_ID as SANDBOX1_102_ from BLC_ADMIN_USER adminuseri0_ left outer join BLC_ADMIN_USER_SANDBOX adminuseri0_1_ on adminuseri0_.ADMIN_USER_ID=adminuseri0_1_.ADMIN_USER_ID where adminuseri0_.LOGIN=?
[TRACE] 21:41:03 BasicBinder - binding parameter [1] as [VARCHAR] - admin
[TRACE] 21:41:03 BasicExtractor - found [1] as column [ADMIN1_101_]
[TRACE] 21:41:03 BasicExtractor - found [false] as column [ACTIVE2_101_]
[TRACE] 21:41:03 BasicExtractor - found [admin@yourdomain.com] as column [EMAIL101_]
[TRACE] 21:41:03 BasicExtractor - found [admin] as column [LOGIN101_]
[TRACE] 21:41:03 BasicExtractor - found [Administrator] as column [NAME101_]
[TRACE] 21:41:03 BasicExtractor - found [admin] as column [PASSWORD101_]
[TRACE] 21:41:03 BasicExtractor - found [null] as column [PHONE7_101_]
[TRACE] 21:41:03 BasicExtractor - found [null] as column [SANDBOX1_102_]
it's return false for ACTIVE2_101_ always , but i have tried to run the querry in mysql client , this is the querry i run :
select adminuseri0_.ADMIN_USER_ID as ADMIN1_101_, adminuseri0_.ACTIVE_STATUS_FLAG as ACTIVE2_101_, adminuseri0_.EMAIL as EMAIL101_, adminuseri0_.LOGIN as LOGIN101_, adminuseri0_.NAME as NAME101_, adminuseri0_.PASSWORD as PASSWORD101_, adminuseri0_.PHONE_NUMBER as PHONE7_101_, adminuseri0_1_.SANDBOX_ID as SANDBOX1_102_ from BLC_ADMIN_USER adminuseri0_ left outer join BLC_ADMIN_USER_SANDBOX adminuseri0_1_ on adminuseri0_.ADMIN_USER_ID=adminuseri0_1_.ADMIN_USER_ID where adminuseri0_.LOGIN='admin' and adminuseri0_.ACTIVE_STATUS_FLAG=true;
and it return 1 record .
I hope that you guys can help me .