... sorry, and what SQL Server SQLDialect version? 2016-08-17 16:59 GMT+02:00 Lukas Eder <[email protected]>:
> Hello, > > Thank you very much for your messages. What jOOQ version are you using? > > Cheers, > Lukas > > 2016-08-17 9:05 GMT+02:00 'TheGPLOG' via jOOQ User Group < > [email protected]>: > >> 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. >> > > -- 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.
