Hi Anastasia, This appears to be a SQL problem. I've seen, you've deleted your messages from the user group again. Were you able to solve the problem?
If not, it looks as though your email predicate is wrong. Perhaps, some email formatting issue? Cheers, Lukas 2017-05-13 20:02 GMT+02:00 Anastasia Kisel <[email protected]>: > This statement does not work. > > > return Optional.ofNullable(dslContext.select() > .from(USER) > .join(BOR) > .on(USER.ID.eq(BOR.USER_ID)) > .join(ADDRESS) > .on(BOR.ADDRESS_ID.eq(ADDRESS.ID)) > .where(USER.EMAIL.eq(email)) > .fetchOne()); > > > This statement works as well : > > > return Optional.ofNullable(dslContext.select() > .from(USER) > .join(BOR) > .on(USER.ID.eq(BOR.USER_ID)) > .join(ADDRESS) > .on(BOR.ADDRESS_ID.eq(ADDRESS.ID)) > .fetchAny()); > > > However the statement does not work: > > > return Optional.ofNullable(dslContext.select() > .from(USER) > .where(USER.EMAIL.eq(email)) > .fetchOne()); > > > Please help. > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
