Thanks Noel. I'll give that a try. On Friday, June 26, 2020 at 2:25:48 PM UTC-7, Michael Earl wrote: > > Hello All, > > I am attempting to upgrade our H2 jar to 1.4.200. We are currently using > 1.3.164. > > Using the 1.4.200 jar, I can't successfully open a database created by > 1.3.164. Is this expected? > > When simply opening the database I get the following: > > The specified database user/password combination is rejected: > [23505][23505] Unique index or primary key violation: "PRIMARY KEY ON > """".PAGE_INDEX"; SQL statement: ALTER TABLE PUBLIC.SITE_PERMISSION ADD > CONSTRAINT PUBLIC.ACCESS_NAME_FK FOREIGN KEY(ACCESS_NAME) REFERENCES > PUBLIC.ACCESS(ACCESS_NAME) NOCHECK [23505-200] > > The database opens successfully using the 1.3.164 jar. > > This is my connection string: jdbc:h2:file:C:/Projects/FlexIDS 4.9 - H2 > Upgrade/FlexDB/FlexDB;MV_STORE=false > > Thanks for any help > Mike. > >
-- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/c105e302-1de2-43f6-ae4d-59d7fce7ddc9o%40googlegroups.com.
