JOOQ 3.8.4. After your question I tried (not all) but many combination of the variants of my 2 post with SQLDialect.SQLSERVER2012, SQLDialect.SQLSERVER2008 and SQLSERVER. I can’t see differences in this fast test. Maybe there is a problem with the generated classes or I use them wrong. I am not sure what is the normal behavior.
here are some other setting which I have added after testing. jooqConfiguration.set(SQLDialect.SQLSERVER); Settings settings = new Settings(); settings.withExecuteWithOptimisticLocking(false); settings.withUpdatablePrimaryKeys(false); // http://www.jooq.org/doc/3.8/manual-single-page/#statement-type settings.withStatementType(StatementType.PREPARED_STATEMENT); jooqConfiguration.setSettings(settings); Am Mittwoch, 17. August 2016 16:59:49 UTC+2 schrieb Lukas Eder: > > ... sorry, and what SQL Server SQLDialect version? > > 2016-08-17 16:59 GMT+02:00 Lukas Eder <[email protected] <javascript:>>: > >> 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] <javascript:>>: >> >>> 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] <javascript:>. >>> 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.
