Hi, See the documentation at http://h2database.com/html/grammar.html#create_table
Regards, Thomas On Tue, Mar 24, 2015 at 5:24 PM, Jason <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > 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]> 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] > <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.
