This may help:
https://stackoverflow.com/questions/29297043/on-delete-set-null-on-self-referencing-relationship
On 3/23/21 6:09 AM, John English wrote:
I have a table in which I want to include a self-referential foreign
key to the same table:
CREATE TABLE x (
id INTEGER GENERATED
The ij CONNECT command issues a DriverManager.getConnection(jdbcURL)
command. What does your connection logic look like?
Thanks,
-Rick
On 3/23/21 4:59 AM, Michael Remijan wrote:
I'll see if I can reproduce it with ij, but I'm not sure. The error is with the
Java client connecting to and
I have a table in which I want to include a self-referential foreign key
to the same table:
CREATE TABLE x (
id INTEGER GENERATED ALWAYS AS IDENTITY,
idY INTEGER,
idX INTEGER DEFAULT NULL,
CONSTRAINT x_pk PRIMARY KEY (id),
CONSTRAINT x_1FOREIGN KEY (idY)
I'll see if I can reproduce it with ij, but I'm not sure. The error is with the
Java client connecting to and starting an embedded database. There's no SQL at
play since it's the connecting and starting that's failing. If I can reproduce
it with ij I'll let you know.
-Original
