Re: [h2] Re: MVCC problem with in-memory H2 in 1.4.200

2019-10-14 Thread Björn Schädlich
Yeah: Thanks for this great 1.4.200 H2 release: 
We had bugs in our tests, which weren't found because of bugs in H2. Now 
these bugs in H2 are fixed :)

Background: It seems that it could happen in 1.4.199, that being in a 
schema a select from a table which doesn't exist (being on the wrong 
schema) could receive a table with the desired name from another schema.

Thanks you very much

-- 
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/cb50b993-ffab-4447-bb4d-e5cca2d54c8d%40googlegroups.com.


Re: [h2] Re: MVCC problem with in-memory H2 in 1.4.200

2019-10-14 Thread Björn Schädlich
Thank you for your fast reply.

Without the MVCC param, I receive some test failures which I don't get with 
H2 1.4.199. I'll dive into this and post my results

-- 
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/58348a28-866a-48a2-9de9-a7f420d05d43%40googlegroups.com.


Re: [h2] Re: MVCC problem with in-memory H2 in 1.4.200

2019-10-14 Thread Noel Grandin

Just drop the MVCC param, it will use MVSTore by default, even for in-mem 
databases, which is naturally an MVCC engine

--
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/84288967-af6c-29d0-8e6c-a341b41a93f3%40gmail.com.


[h2] Re: MVCC problem with in-memory H2 in 1.4.200

2019-10-14 Thread Björn Schädlich
Hmm, [1] states that MVStore should support in-memory-usage and MVCC. 
Perhaps its only a usage problem with correct connection URL params for my 
case?


[1] 
http://www.h2database.com/html/mvstore.html?highlight=Mvcc&search=MVCC#inMemory

-- 
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/434e0068-f826-492d-853f-c3fdfd006703%40googlegroups.com.


[h2] MVCC problem with in-memory H2 in 1.4.200

2019-10-14 Thread Björn Schädlich

Upgrading our project from H2 1.4.199 to 1.4.200, we get an Exception

Caused by:
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datenbank-
Verbindungs Option "MVCC" nicht unterst³tzt
Unsupported connection setting "MVCC" [90113-200]

while using JDBC URL

jdbc:h2:mem:backendtests;MVCC=TRUE;MODE=PostgreSQL


I can not believe H2 dropped MCVV support for in-memory DBs, because H2 is 
first choice for unit tests (JUnit, TestNG) which run backend SQL in 
in-memory H2 for fast tests, but needs MVCC for several scenarios.
Is this a decision (which would be very sad), or an unwanted bug?

-- 
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/4b40912d-0c9a-49e2-a2ac-e45c8b235c64%40googlegroups.com.


Re: [h2] H2 Database Engine: New version released

2019-10-14 Thread Noel Grandin



Lots of great improvements in this release, performance and reliability is 
definitely much better,
and a ton of thanks to Evgenij Ryazanov  and Andrei Tokar  for all their hard 
work.

--
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/6edbe836-2b0e-9282-305f-cb93b43400e2%40gmail.com.


[h2] H2 Database Engine: New version released

2019-10-14 Thread Thomas Mueller Graf
Hello,

A new version of H2 is available at http://www.h2database.com
(you may have to click 'Refresh').

For details, see the 'Change Log' at
http://www.h2database.com/html/changelog.html

Please note the jar file may not yet be available in the
Maven central repository (synchronizing usually takes a few hours).

P.S. If you reply to this message please use a different subject.

Have fun,
Thomas

-- 
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/CAKpgiBY6HQ5r0UpjBOKV%2BXsTPtUjDEz8jXXChX4YnYf3%3D9FKaA%40mail.gmail.com.