I also tried this
YYYRecord logEntry = create.fetchOne(XXX,
XXX.YYY
.equal(yyy));
logEntry.setZZZ(zzzz);
logEntry.store(); (or logEntry.update();)
Update/ Store works, but the "auto refresh" fails also
org.jooq.exception.NoDataFoundException: Exactly one row expected for
refresh. Record does not exist in database.
select ... where XXX.YYYY is null
I tried also to set settings.withUpdatablePrimaryKeys(false); manual to
false (default)
CREATE TABLE [dbo].[YYYY](
[XXXX] [int] IDENTITY(1,1) NOT NULL,
...
CONSTRAINT [PK_YYY] PRIMARY KEY CLUSTERED
(
[XXX] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
--
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.
