SQL Exception with JDBC cache loader with H2 in memory DB

[dex80526]

I configured the cache loader with H2 in memory DB as the following:              

                                                                                                                                                                                                                         When I start the cache, I get SQL exceptions below because the DB instance is not created. >>2011-12-23 09:14:10,517 DEBUG [NewPooledConnection] (pool-1-thread-1) com.mchange.v2.c3p0.impl.NewPooledConnection@3a2fd721 handling a throwable. org.h2.jdbc.JdbcSQLException: Table "ISPN_STRING_TABLE_TESTSTORE" not found; SQL statement: SELECT count(*) FROM ISPN_STRING_TABLE_testStore [42102-158] << It seems "createTableOnStart=true" does not work.  However, it works if I switch to filesystem based DB with the following:   Do I miss something in the configuration?  IPSN version: 5.1.0 CR1

[galder.zamarreno]

Is this related to https://issues.jboss.org/browse/ISPN-1649 ?

[dex80526]

It is related, but is different.

ISPN-1649 is on 'dropTablesOnExit". This one is on failures in creating tables when using H2 mem configuration.

[galder.zamarreno]

Hmmmm, we use createTableOnStart=true in our testsuite with in-memory H2 database without problems:

https://github.com/galderz/infinispan/blob/master/cachestore/jdbc/src/test/resources/configs/string-based.xml#L85

In spite of the message showing an exception, the message is a DEBUG message, so maybe this can be expected by H2/C3P0 ? What matters is whether the app then works as expected or not.

[dex80526]

I rerun my tests with latest ISPN code, I do not see this problem anymore. I'll mark this as "Answered".

Thanks for taking time to look into this.