Hi all. I cannot create same table (self-referencing) foreign key using ucanaccess.
org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [15000] [15000]: UCAExc:::5.1.5 Failed to execute [ALTER TABLE [Table1] ADD CONSTRAINT fk_code FOREIGN KEY (base_code)
REFERENCES [Table1] (reference_code)]: UCAExc:::5.1.5 Could not find child entry in parent; childEntry NodeEntry[rowId=17:16,subPage=2042,bytes=(19) 7F 8F 00 00 02 7F 6F 6B 51 69 4F 51 53 59 62 51 4F 01 00]; parent NodeDataPage[7] 0, 0, (2714)[entries=[NodeEntry[rowId=18:13,subPage=20,bytes=(37) 7F 00 00 00 01 7F 6B 6F 4C 53 64 69 60 07 4C 69 64 73 6B 51...],NodeEntry[rowId=19:23,subPage=21,bytes=(57) 7F 00 00 00 03 7F 69 66 6D 07 66 64 59 62 6D 07 60 64 6D 59...],NodeEntry[rowId=24:1,subPage=23,bytes=(51) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 38 07 07 73 51 5E 4D...],NodeEntry[rowId=32:1,subPage=30,bytes=(82) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 4C 69 64 73 6B 51 07...],NodeEntry[rowId=41:2,subPage=42,bytes=(52) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 51 4F 59 6D 1E 4A 4F...],NodeEntry[rowId=49:4,subPage=50,bytes=(58) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 6B 6F 4C 53 64 69 60...],NodeEntry[rowId=55:8,subPage=58,bytes=(71) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 4D 57 4A...],NodeEntry[rowId=64:12,subPage=75,bytes=(61) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 4F 51 66...],NodeEntry[rowId=82:15,subPage=86,bytes=(75) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 55 51 64...],NodeEntry[rowId=92:21,subPage=97,bytes=(43) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 53 4C 69 64 73 6B 51 07...],NodeEntry[rowId=102:22,subPage=115,bytes=(55) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 53 6B 6F 4C 53 64 69 60...],NodeEntry[rowId=134:3,subPage=135,bytes=(37) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 69 6B 6F 4C 69 66 6D 07...],NodeEntry[rowId=147:7,subPage=148,bytes=(42) 7F 8F 00 00 01 7F 36 38 3C 07 68 4D 07 62 4A 60 59 62 55 07...],NodeEntry[rowId=174:9,subPage=182,bytes=(64) 7F 8F 00 00 01 7F 38 3C 3A 07 68 4D 07 4D 64 64 69 4F 59 62...],NodeEntry[rowId=210:10,subPage=223,bytes=(72) 7F 8F 00 00 01 7F 3A 38 3A 07 68 4D 07 4D 64 64 69 4F 59 62...],NodeEntry[rowId=207:18,subPage=250,bytes=(35) 7F 8F 00 00 01 7F 3C 3C 38 07 68 4D 07 6B 4D 64 66 51 07 4D...],NodeEntry[rowId=263:29,subPage=361,bytes=(27) 7F 8F 00 00 01 7F 4F 4A 6D 6F 60 51 62 6B 51 60 4C 5E 51 60...],NodeEntry[rowId=614:11,subPage=636,bytes=(25) 7F 8F 00 00 01 7F 60 6B 76 6B 4A 4D 4D 51 6B 6B 64 4C 5B 51...],NodeEntry[rowId=1864:18,subPage=1869,bytes=(40) 7F 8F 00 00 01 7F 68 4D 07 36 40 07 4D 69 6B 07 69 51 60 4A...],NodeEntry[rowId=1879:26,subPage=1892,bytes=(45) 7F 8F 00 00 01 7F 68 4D 07 3A 38 07 4D 6D 07 4F 6F 66 5E 59...],NodeEntry[rowId=1912:2,subPage=1914,bytes=(48) 7F 8F 00 00 01 7F 68 4D 07 3C 3A 07 4D 64 64 69 4F 6D 69 4A...],NodeEntry[rowId=1928:13,subPage=1936,bytes=(36) 7F 8F 00 00 01 7F 68 4D 07 3E 36 07 66 4A 69 4A 60 51 6D 51...],NodeEntry[rowId=1979:21,subPage=1995,bytes=(60) 7F 8F 00 00 01 7F 68 69 76 2B 03 55 62 44 3E 2B 03 4A 38 38...],NodeEntry[rowId=2713:3,subPage=2042,bytes=(35) 7F 8F 00 00 03 7F 53 5C 2B 03 4D 64 64 69 4F 2B 03 4A 75 59...]]] (Db=ChangeDatabase.mdb;Table=MSysObjects;Index=ParentIdName)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:136)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:714)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$executeSingleElement$1(SQLQueryJob.java:598)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:210)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleElement(SQLQueryJob.java:617)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:478)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:1102)
at org.jkiss.dbeaver.ui.editors.sql.QueryResultsContainer.readData(QueryResultsContainer.java:275)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$run$0(ResultSetJobDataRead.java:129)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:210)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:127)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5401)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:110)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: net.ucanaccess.exception.UcanaccessSQLException: UCAExc:::5.1.5 Failed to execute [ALTER TABLE [Table1] ADD CONSTRAINT fk_code FOREIGN KEY (base_code)
REFERENCES [Table1] (reference_code)]: UCAExc:::5.1.5 Could not find child entry in parent; childEntry NodeEntry[rowId=17:16,subPage=2042,bytes=(19) 7F 8F 00 00 02 7F 6F 6B 51 69 4F 51 53 59 62 51 4F 01 00]; parent NodeDataPage[7] 0, 0, (2714)[entries=[NodeEntry[rowId=18:13,subPage=20,bytes=(37) 7F 00 00 00 01 7F 6B 6F 4C 53 64 69 60 07 4C 69 64 73 6B 51...],NodeEntry[rowId=19:23,subPage=21,bytes=(57) 7F 00 00 00 03 7F 69 66 6D 07 66 64 59 62 6D 07 60 64 6D 59...],NodeEntry[rowId=24:1,subPage=23,bytes=(51) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 38 07 07 73 51 5E 4D...],NodeEntry[rowId=32:1,subPage=30,bytes=(82) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 4C 69 64 73 6B 51 07...],NodeEntry[rowId=41:2,subPage=42,bytes=(52) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 51 4F 59 6D 1E 4A 4F...],NodeEntry[rowId=49:4,subPage=50,bytes=(58) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 6B 6F 4C 53 64 69 60...],NodeEntry[rowId=55:8,subPage=58,bytes=(71) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 4D 57 4A...],NodeEntry[rowId=64:12,subPage=75,bytes=(61) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 4F 51 66...],NodeEntry[rowId=82:15,subPage=86,bytes=(75) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 55 51 64...],NodeEntry[rowId=92:21,subPage=97,bytes=(43) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 53 4C 69 64 73 6B 51 07...],NodeEntry[rowId=102:22,subPage=115,bytes=(55) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 53 6B 6F 4C 53 64 69 60...],NodeEntry[rowId=134:3,subPage=135,bytes=(37) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 69 6B 6F 4C 69 66 6D 07...],NodeEntry[rowId=147:7,subPage=148,bytes=(42) 7F 8F 00 00 01 7F 36 38 3C 07 68 4D 07 62 4A 60 59 62 55 07...],NodeEntry[rowId=174:9,subPage=182,bytes=(64) 7F 8F 00 00 01 7F 38 3C 3A 07 68 4D 07 4D 64 64 69 4F 59 62...],NodeEntry[rowId=210:10,subPage=223,bytes=(72) 7F 8F 00 00 01 7F 3A 38 3A 07 68 4D 07 4D 64 64 69 4F 59 62...],NodeEntry[rowId=207:18,subPage=250,bytes=(35) 7F 8F 00 00 01 7F 3C 3C 38 07 68 4D 07 6B 4D 64 66 51 07 4D...],NodeEntry[rowId=263:29,subPage=361,bytes=(27) 7F 8F 00 00 01 7F 4F 4A 6D 6F 60 51 62 6B 51 60 4C 5E 51 60...],NodeEntry[rowId=614:11,subPage=636,bytes=(25) 7F 8F 00 00 01 7F 60 6B 76 6B 4A 4D 4D 51 6B 6B 64 4C 5B 51...],NodeEntry[rowId=1864:18,subPage=1869,bytes=(40) 7F 8F 00 00 01 7F 68 4D 07 36 40 07 4D 69 6B 07 69 51 60 4A...],NodeEntry[rowId=1879:26,subPage=1892,bytes=(45) 7F 8F 00 00 01 7F 68 4D 07 3A 38 07 4D 6D 07 4F 6F 66 5E 59...],NodeEntry[rowId=1912:2,subPage=1914,bytes=(48) 7F 8F 00 00 01 7F 68 4D 07 3C 3A 07 4D 64 64 69 4F 6D 69 4A...],NodeEntry[rowId=1928:13,subPage=1936,bytes=(36) 7F 8F 00 00 01 7F 68 4D 07 3E 36 07 66 4A 69 4A 60 51 6D 51...],NodeEntry[rowId=1979:21,subPage=1995,bytes=(60) 7F 8F 00 00 01 7F 68 69 76 2B 03 55 62 44 3E 2B 03 4A 38 38...],NodeEntry[rowId=2713:3,subPage=2042,bytes=(35) 7F 8F 00 00 03 7F 53 5C 2B 03 4D 64 64 69 4F 2B 03 4A 75 59...]]] (Db=ChangeDatabase.mdb;Table=MSysObjects;Index=ParentIdName)
at net.ucanaccess.exception.UcanaccessSQLException.wrap(UcanaccessSQLException.java:133)
at net.ucanaccess.jdbc.UcanaccessStatement.lambda$executeImpl$3(UcanaccessStatement.java:131)
at net.ucanaccess.util.Try.orThrow(Try.java:313)
at net.ucanaccess.jdbc.UcanaccessStatement.tryCatch(UcanaccessStatement.java:398)
at net.ucanaccess.jdbc.UcanaccessStatement.executeImpl(UcanaccessStatement.java:127)
at net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:136)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:333)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:134)
... 13 more
Caused by: net.ucanaccess.exception.UcanaccessSQLException: UCAExc:::5.1.5 Could not find child entry in parent; childEntry NodeEntry[rowId=17:16,subPage=2042,bytes=(19) 7F 8F 00 00 02 7F 6F 6B 51 69 4F 51 53 59 62 51 4F 01 00]; parent NodeDataPage[7] 0, 0, (2714)[entries=[NodeEntry[rowId=18:13,subPage=20,bytes=(37) 7F 00 00 00 01 7F 6B 6F 4C 53 64 69 60 07 4C 69 64 73 6B 51...],NodeEntry[rowId=19:23,subPage=21,bytes=(57) 7F 00 00 00 03 7F 69 66 6D 07 66 64 59 62 6D 07 60 64 6D 59...],NodeEntry[rowId=24:1,subPage=23,bytes=(51) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 38 07 07 73 51 5E 4D...],NodeEntry[rowId=32:1,subPage=30,bytes=(82) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 4C 69 64 73 6B 51 07...],NodeEntry[rowId=41:2,subPage=42,bytes=(52) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 51 4F 59 6D 1E 4A 4F...],NodeEntry[rowId=49:4,subPage=50,bytes=(58) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 6B 6F 4C 53 64 69 60...],NodeEntry[rowId=55:8,subPage=58,bytes=(71) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 4D 57 4A...],NodeEntry[rowId=64:12,subPage=75,bytes=(61) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 4F 51 66...],NodeEntry[rowId=82:15,subPage=86,bytes=(75) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 55 51 64...],NodeEntry[rowId=92:21,subPage=97,bytes=(43) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 53 4C 69 64 73 6B 51 07...],NodeEntry[rowId=102:22,subPage=115,bytes=(55) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 53 6B 6F 4C 53 64 69 60...],NodeEntry[rowId=134:3,subPage=135,bytes=(37) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 69 6B 6F 4C 69 66 6D 07...],NodeEntry[rowId=147:7,subPage=148,bytes=(42) 7F 8F 00 00 01 7F 36 38 3C 07 68 4D 07 62 4A 60 59 62 55 07...],NodeEntry[rowId=174:9,subPage=182,bytes=(64) 7F 8F 00 00 01 7F 38 3C 3A 07 68 4D 07 4D 64 64 69 4F 59 62...],NodeEntry[rowId=210:10,subPage=223,bytes=(72) 7F 8F 00 00 01 7F 3A 38 3A 07 68 4D 07 4D 64 64 69 4F 59 62...],NodeEntry[rowId=207:18,subPage=250,bytes=(35) 7F 8F 00 00 01 7F 3C 3C 38 07 68 4D 07 6B 4D 64 66 51 07 4D...],NodeEntry[rowId=263:29,subPage=361,bytes=(27) 7F 8F 00 00 01 7F 4F 4A 6D 6F 60 51 62 6B 51 60 4C 5E 51 60...],NodeEntry[rowId=614:11,subPage=636,bytes=(25) 7F 8F 00 00 01 7F 60 6B 76 6B 4A 4D 4D 51 6B 6B 64 4C 5B 51...],NodeEntry[rowId=1864:18,subPage=1869,bytes=(40) 7F 8F 00 00 01 7F 68 4D 07 36 40 07 4D 69 6B 07 69 51 60 4A...],NodeEntry[rowId=1879:26,subPage=1892,bytes=(45) 7F 8F 00 00 01 7F 68 4D 07 3A 38 07 4D 6D 07 4F 6F 66 5E 59...],NodeEntry[rowId=1912:2,subPage=1914,bytes=(48) 7F 8F 00 00 01 7F 68 4D 07 3C 3A 07 4D 64 64 69 4F 6D 69 4A...],NodeEntry[rowId=1928:13,subPage=1936,bytes=(36) 7F 8F 00 00 01 7F 68 4D 07 3E 36 07 66 4A 69 4A 60 51 6D 51...],NodeEntry[rowId=1979:21,subPage=1995,bytes=(60) 7F 8F 00 00 01 7F 68 69 76 2B 03 55 62 44 3E 2B 03 4A 38 38...],NodeEntry[rowId=2713:3,subPage=2042,bytes=(35) 7F 8F 00 00 03 7F 53 5C 2B 03 4D 64 64 69 4F 2B 03 4A 75 59...]]] (Db=ChangeDatabase.mdb;Table=MSysObjects;Index=ParentIdName)
at net.ucanaccess.util.Try.orThrow(Try.java:313)
at net.ucanaccess.commands.CreateForeignKeyCommand.persist(CreateForeignKeyCommand.java:45)
at net.ucanaccess.jdbc.UcanaccessConnection.flushIO(UcanaccessConnection.java:264)
at net.ucanaccess.jdbc.UcanaccessConnection.commit(UcanaccessConnection.java:158)
at net.ucanaccess.jdbc.AbstractExecute.executeBase(AbstractExecute.java:225)
at net.ucanaccess.jdbc.Execute.execute(Execute.java:30)
at net.ucanaccess.jdbc.UcanaccessStatement.lambda$execute$4(UcanaccessStatement.java:136)
at net.ucanaccess.jdbc.UcanaccessStatement.lambda$executeImpl$2(UcanaccessStatement.java:130)
at net.ucanaccess.util.Try.<init>(Try.java:76)
at net.ucanaccess.util.Try.catching(Try.java:106)
... 18 more
Caused by: java.lang.IllegalStateException: Could not find child entry in parent; childEntry NodeEntry[rowId=17:16,subPage=2042,bytes=(19) 7F 8F 00 00 02 7F 6F 6B 51 69 4F 51 53 59 62 51 4F 01 00]; parent NodeDataPage[7] 0, 0, (2714)[entries=[NodeEntry[rowId=18:13,subPage=20,bytes=(37) 7F 00 00 00 01 7F 6B 6F 4C 53 64 69 60 07 4C 69 64 73 6B 51...],NodeEntry[rowId=19:23,subPage=21,bytes=(57) 7F 00 00 00 03 7F 69 66 6D 07 66 64 59 62 6D 07 60 64 6D 59...],NodeEntry[rowId=24:1,subPage=23,bytes=(51) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 38 07 07 73 51 5E 4D...],NodeEntry[rowId=32:1,subPage=30,bytes=(82) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 4C 69 64 73 6B 51 07...],NodeEntry[rowId=41:2,subPage=42,bytes=(52) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 51 4F 59 6D 1E 4A 4F...],NodeEntry[rowId=49:4,subPage=50,bytes=(58) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4D 6B 6F 4C 53 64 69 60...],NodeEntry[rowId=55:8,subPage=58,bytes=(71) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 4D 57 4A...],NodeEntry[rowId=64:12,subPage=75,bytes=(61) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 4F 51 66...],NodeEntry[rowId=82:15,subPage=86,bytes=(75) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 4F 69 66 6D 07 55 51 64...],NodeEntry[rowId=92:21,subPage=97,bytes=(43) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 53 4C 69 64 73 6B 51 07...],NodeEntry[rowId=102:22,subPage=115,bytes=(55) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 53 6B 6F 4C 53 64 69 60...],NodeEntry[rowId=134:3,subPage=135,bytes=(37) 7F 8F 00 00 01 7F 2B 0F 6B 68 2B 03 69 6B 6F 4C 69 66 6D 07...],NodeEntry[rowId=147:7,subPage=148,bytes=(42) 7F 8F 00 00 01 7F 36 38 3C 07 68 4D 07 62 4A 60 59 62 55 07...],NodeEntry[rowId=174:9,subPage=182,bytes=(64) 7F 8F 00 00 01 7F 38 3C 3A 07 68 4D 07 4D 64 64 69 4F 59 62...],NodeEntry[rowId=210:10,subPage=223,bytes=(72) 7F 8F 00 00 01 7F 3A 38 3A 07 68 4D 07 4D 64 64 69 4F 59 62...],NodeEntry[rowId=207:18,subPage=250,bytes=(35) 7F 8F 00 00 01 7F 3C 3C 38 07 68 4D 07 6B 4D 64 66 51 07 4D...],NodeEntry[rowId=263:29,subPage=361,bytes=(27) 7F 8F 00 00 01 7F 4F 4A 6D 6F 60 51 62 6B 51 60 4C 5E 51 60...],NodeEntry[rowId=614:11,subPage=636,bytes=(25) 7F 8F 00 00 01 7F 60 6B 76 6B 4A 4D 4D 51 6B 6B 64 4C 5B 51...],NodeEntry[rowId=1864:18,subPage=1869,bytes=(40) 7F 8F 00 00 01 7F 68 4D 07 36 40 07 4D 69 6B 07 69 51 60 4A...],NodeEntry[rowId=1879:26,subPage=1892,bytes=(45) 7F 8F 00 00 01 7F 68 4D 07 3A 38 07 4D 6D 07 4F 6F 66 5E 59...],NodeEntry[rowId=1912:2,subPage=1914,bytes=(48) 7F 8F 00 00 01 7F 68 4D 07 3C 3A 07 4D 64 64 69 4F 6D 69 4A...],NodeEntry[rowId=1928:13,subPage=1936,bytes=(36) 7F 8F 00 00 01 7F 68 4D 07 3E 36 07 66 4A 69 4A 60 51 6D 51...],NodeEntry[rowId=1979:21,subPage=1995,bytes=(60) 7F 8F 00 00 01 7F 68 69 76 2B 03 55 62 44 3E 2B 03 4A 38 38...],NodeEntry[rowId=2713:3,subPage=2042,bytes=(35) 7F 8F 00 00 03 7F 53 5C 2B 03 4D 64 64 69 4F 2B 03 4A 75 59...]]] (Db=ChangeDatabase.mdb;Table=MSysObjects;Index=ParentIdName)
at io.github.spannm.jackcess.impl.IndexPageCache.updateParentEntry(IndexPageCache.java:472)
at io.github.spannm.jackcess.impl.IndexPageCache.replaceParentEntry(IndexPageCache.java:423)
at io.github.spannm.jackcess.impl.IndexPageCache.updateEntry(IndexPageCache.java:341)
at io.github.spannm.jackcess.impl.IndexPageCache.addEntry(IndexPageCache.java:270)
at io.github.spannm.jackcess.impl.IndexPageCache$CacheDataPage.addEntry(IndexPageCache.java:1158)
at io.github.spannm.jackcess.impl.IndexData.commitAddRow(IndexData.java:598)
at io.github.spannm.jackcess.impl.IndexData$AddRowPendingChange.commit(IndexData.java:2570)
at io.github.spannm.jackcess.impl.IndexData.commitAll(IndexData.java:718)
at io.github.spannm.jackcess.impl.TableImpl.addRows(TableImpl.java:2063)
at io.github.spannm.jackcess.impl.TableImpl.addRow(TableImpl.java:1921)
at io.github.spannm.jackcess.impl.DatabaseImpl.addToSystemCatalog(DatabaseImpl.java:1674)
at io.github.spannm.jackcess.impl.DatabaseImpl.writeRelationship(DatabaseImpl.java:1318)
at io.github.spannm.jackcess.impl.RelationshipCreator.createRelationship(RelationshipCreator.java:87)
at io.github.spannm.jackcess.RelationshipBuilder.toRelationship(RelationshipBuilder.java:179)
at net.ucanaccess.converters.Persist2Jet.createForeignKey(Persist2Jet.java:735)
at net.ucanaccess.converters.Persist2Jet.createForeignKey(Persist2Jet.java:675)
at net.ucanaccess.commands.CreateForeignKeyCommand.lambda$persist$0(CreateForeignKeyCommand.java:44)
at net.ucanaccess.util.Try.lambda$catching$0(Try.java:119)
at net.ucanaccess.util.Try.<init>(Try.java:76)
at net.ucanaccess.util.Try.catching(Try.java:118)
at net.ucanaccess.commands.CreateForeignKeyCommand.persist(CreateForeignKeyCommand.java:44)
... 26 more
The query would success if ran on the Microsoft Access software.
Hi all. I cannot create same table (self-referencing) foreign key using ucanaccess.
Take this query for example:
Error:
UCanAccess version 5.1.5
The query would success if ran on the Microsoft Access software.