MV_Store

27 views
Skip to first unread message

Ronit

unread,
Jul 11, 2022, 11:43:46 AMJul 11
to H2 Database
Hello ,

I am trying to connect to the H2 2.1.214 and I want to add MV_Store= FALSE in the 
JDBC connection string . 
I have created the DataSource object , then 
try {
Connection conn = dataSource.getConnection()
   } catch (SQLException sqle) {
                log.error("Error : " + sqle);
        }


jdbc:h2:file:databsePath\databseName;MV_STORE=FALSE;MODE=PostgreSQL;LOCK_TIMEOUT=1800000;MAX_COMPACT_TIME=10000

Here I am getting 'org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.UnsupportedOperationException" '.

am I making any mistake in here !?

Thanks.

Evgenij Ryazanov

unread,
Jul 11, 2022, 11:54:19 AMJul 11
to H2 Database
Hello.

Legacy PageStore backend was removed from H2, so you cannot specify MV_STORE=FALSE any more. This backend is only available in old unsupported versions, it was introduced somewhere in 1.1.* releases and the last release with this backend is 1.4.200.
Reply all
Reply to author
Forward
0 new messages