MV_Store

[Ronit]

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]

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.