Many thanks. Will try again when the spring version is available. On Wednesday, 12 January 2022 at 12:52:09 UTC [email protected] wrote:
> The problem is in Spring JDBC: > https://github.com/spring-projects/spring-framework/pull/27870 > > It will be fixed in release 5.3.15 which should be released latest next > week. > > Am Mi., 12. Jan. 2022 um 13:16 Uhr schrieb Paul Denby <[email protected] > >: > >> Overriding Spring Boot h2.version to 2.0.206 (from 1.4.200) throws an >> error >> >> Column \"TABLE1_ID_SEQ.NEXTVAL\" not found >> >> in the following SQL which worked previously: >> >> CREATE SEQUENCE table1_id_seq; >> >> CREATE TABLE table1 ( >> id integer default table1_id_seq.nextval NOT NULL UNIQUE, >> versionid integer NOT NULL, >> table2id integer, >> externalid character varying(255), >> value character varying(255) >> ); >> >> Neither of the documented alternate forms worked either: >> >> ... default nextval('table1_id_seq') ... >> >> or >> >> ... default next value for table1_id_seq ... >> >> Is there a preferred version of getting nextval in h2 v2.0.206, or any >> other way of getting an id from a sequence (for various reasons this is a >> requirement)? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/h2-database/6dc31aec-89ff-45cf-a3fc-d7a8a2830727n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/h2-database/6dc31aec-89ff-45cf-a3fc-d7a8a2830727n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/03dc01d8-b9ae-4f50-ab0a-0f7035104779n%40googlegroups.com.
