[h2] Erroraccessingdatabase

[Carson]

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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[h2] Unique index or primary key violation: PRIMARY KEY ON .PAGE_INDEX error

[Carson]

Hi,

I'm new to H2, and I'm working with an already existing H2 database. When I 
first run H2 Console and access the database, I manage to get in. However, 
after I disconnect, and try to re-access the database, the following error 
occurs:

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] 

I would need to get a fresh copy of the db from my git to be able to 
're-access' the database.


My URL is the following: jdbc:h2:C:\Users\carson\.db\PPT_DB;CIPHER=AES

My H2 version is, I think 1.3.176 (it's the version I see on the H2 console 
tab)

Do you guys know why this is occurring?

-- 
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.