Hi, I'm new to H2, and I have to work with an pre-existing h2 database. So basically, when I first access the database through the console, I manage to log in. However, after disconnecting, and trying to re-access it, I get the following error:
Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement: ALTER TABLE PUBLIC.PPT_TEMPLATE ADD CONSTRAINT PUBLIC.CONSTRAINT_21 FOREIGN KEY(ID_TEMPLATE) REFERENCES PUBLIC.PPT_TEMPLATE(ID_TEMPLATE) NOCHECK [23505-176] The only way for to re-access it is to get a fresh copy in git, but everytime, after I access it, I won't be able to re-access it... Can anyone pinpoint me to where I may be able to solve this issue? My database version is 1.3.176 (I took the version shown on the tab when I open the database through the H2 console tab) My URL is: jdbc:h2:C:\Users\Carson\db\PPT_DB;CIPHER=AES -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
