Thanks for your explanation. Obviously, syntax check has been more lenient
in previous releases.
Evgenij Ryazanov schrieb am Donnerstag, 3. Februar 2022 um 01:34:40 UTC+1:
> Hello!
>
> INT GENERATED BY DEFAULT AS IDENTITY should be used for identity column of
> INT (INTEGER) data type.
Greetings.
To my best knowledge, H2 database does not support Named Parameters.
Furthermore, Oracle does not support Parameters in DDL Statements (not
even in CTAS).
I have started writing a small
library https://github.com/manticore-projects/MJdbcUtils in order to
handle Named Parameter
Hello!
INT GENERATED BY DEFAULT AS IDENTITY should be used for identity column of
INT (INTEGER) data type. Additional NOT NULL clause isn't needed, but may
be specified. H2 intentionally supports this standard-compliant syntax in
all compatibility modes to have possibility to use the same
Thanks! That's exactly what I needed.
On Wednesday, February 2, 2022 at 1:26:10 PM UTC-6 Noel Grandin wrote:
> You'd have to modify how the java VM chooses where to put temporary files.
> There are various ways to do that depending on how you want to control it,
> but at minimum it would have
You'd have to modify how the java VM chooses where to put temporary files.
There are various ways to do that depending on how you want to control it,
but at minimum it would have to apply to that whole java process,
--
You received this message because you are subscribed to the Google Groups "H2
You can specify a column as either INT or IDENTITY but not both.
On Wed, 2 Feb 2022 at 20:38, Helmut Leininger wrote:
> This was not the case in 200
>
> Syntax error in SQL statement "create table persons (mstb_per_no int
> [*]identity not null, mstb_father int, mstb_mother int, mstb_last_edit
I have several script creating tables in a database. Was ok in 200, broken
in 1056/210.
a Syntax Error is thrown:
Syntax error in SQL statement "create table persons (mstb_per_no int
[*]identity not null, mstb_father int, mstb_mother int, mstb_last_edit
date, mstb_dsid int, mstb_ref_id int,
This was not the case in 200
Syntax error in SQL statement "create table persons (mstb_per_no int
[*]identity not null, mstb_father int, mstb_mother int, mstb_last_edit
date, mstb_dsid int, mstb_ref_id int, mstb_reference varchar(12),
mstb_spoulast int, mstb_scbuff varchar(10), mstb_pbirth
I am using an embedded H2 DB (v2.1.210) in a Windows Server 2016
environment.
I have the database configured to use a jdbc URL with a relative path from
a location on the D: drive (jdbc:h2:../data).
I have a query with a large result set that seemed to be hanging. Upon
further investigation, i