4 Replies Latest reply on Jan 6, 2012 3:04 PM by dex chen

    SQL Exception with JDBC cache loader with H2 in memory DB

    dex chen Novice

      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