Re: [h2] Will a H2 v1.4.200 jar file read/open a database created by H2 V1.3.x ?

[Noel Grandin]

you best bet is to do a full backup and restore.

It is quite possible you have latent corruption that only newer versions
will complain about.

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/CAFYHVnU9KgXEq7Ex5bbxN1vPoj_QpzNzLFvVabzCcz4HF860sg%40mail.gmail.com.

[h2] Will a H2 v1.4.200 jar file read/open a database created by H2 V1.3.x ?

[Michael Earl]

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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/81681b25-cfec-4730-a960-d8f2e34a3cceo%40googlegroups.com.