Hi, Sorry I only tested with the latest version of H2. I think in previous versions, paths were not supported for in-memory databases. That means, you would need to use a simple name, for example "jdbc:h2:mem:gpfp" or similar.
Regards, Thomas On Wednesday, March 18, 2015, Jason <[email protected]> wrote: > The datasource path resolves to >> > > jdbc:h2:mem:C:\Users\a2jagzz\workspace\Miscellaneous\.\src\main\resources\ > gpfp;MV_STORE=FALSE > > I was originally using 1.4.178. I've updated to use 1.4.186 and now it > seems to be able to connect, but there is no content within. The exception > I have is > > 0 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging > initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter. > 93 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - > Opening JDBC Connection > 280 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - > Setting autocommit to false on JDBC Connection [conn2: > url=jdbc:h2:mem:C:\Users\a2jagzz\workspace\Miscellaneous\.\src\main\resources\gpfp > user=SA] > 296 [main] DEBUG com.mmm.his.h2.SelectAllTester.allApgDx - ==> > Preparing: select * from APG_DX_DATA > Exception in thread "main" > org.apache.ibatis.exceptions.PersistenceException: > ### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Table > "APG_DX_DATA" not found; SQL statement: > select * from APG_DX_DATA [42102-186] > ### The error may exist in com/mmm/his/h2/SelectAllTester.java (best guess) > ### The error may involve com.mmm.his.h2.SelectAllTester.allApgDx > ### The error occurred while executing a query > ### SQL: select * from APG_DX_DATA > ### Cause: org.h2.jdbc.JdbcSQLException: Table "APG_DX_DATA" not found; > SQL statement: > select * from APG_DX_DATA [42102-186] > > I've tested the connections with and without mem using the web client and > found that the standard connection works just fine, but when I add "mem" I > get the error I noted above - *Error while creating file "mem:C:" > [90062-178]* > > > -- > 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 [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
