Say I want to join across some tables, but the result I just care about the
fields for a particular Record class. So what I've been doing is something
like this
.select(ACCOUNT.fields())
.from(ACCOUNT)
.join(CREDENTIAL)
.on(CREDENTIAL.ACCOUNT_ID.eq(ACCOUNT.ID))
.where(
ACCOUNT.STATE.eq(CommonStatesConstants.ACTIVE)
.and(CREDENTIAL.STATE.eq(CommonStatesConstants.ACTIVE))
.and(CREDENTIAL.PUBLIC_VALUE.eq(access))
.and(CREDENTIAL.SECRET_VALUE.eq(secretKey)))
.and(CREDENTIAL.KIND.in(SUPPORTED_TYPES.get()))
.fetchOneInto(AccountRecord.class);
So what I just noticed is that if I do this it marks all fields as changed
in the record. Is there a difference syntax I'm supposed to be using?
Darren
--
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/groups/opt_out.
