Not a problem... I rebuilt my database using *MEMORY* on each table. What is the difference between mem in the url and MEMORY on the tables? Is there an advantage to one over the other?
On Tuesday, March 24, 2015 at 2:42:23 AM UTC-4, Thomas Mueller wrote: > > 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] <javascript:>> > 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]. >> 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. >> > -- 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.
