Re: [h2] H2 database in tomcat environment throwing RuntimeException “unexpected code path” on select sequence.nextval

2017-01-03 Thread 'Andreas Knees' via H2 Database
Is it OK to use this connections string in tomcat (i.e. multi threaded, using connection pool) environment? jdbc:h2:~/mydb;AUTO_SERVER=TRUE; May I access the database also from another JDBC-Tool with the same connection string while tomcat is running / not running? May the database become corr

Re: [h2] H2 database in tomcat environment throwing RuntimeException “unexpected code path” on select sequence.nextval

2017-01-03 Thread Noel Grandin
http://h2database.com/html/features.html?highlight=AUTO_SERVER&search=auto_server#auto_mixed_mode I'm one holiday, not likely to get to this bug for a couple of weeks ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this gro

[h2] CSVREAD not requiring admin rights

2017-01-03 Thread Chris Sunderland
It doesn't appear that CSVREAD is requiring admin rights per the documentation. However CSVWRITE properly throws an error if I try to execute this as a standard user: Exception in thread "main" org.h2.jdbc.JdbcSQLException: Admin rights are required for this operation; SQL statement: CALL *CSV

[h2] H2 in memory impl - restart after ~300000 inserts with empty database. why????

2017-01-03 Thread Elad Wertzberger
Hi, We encounter a case when H2 has restarted after 30 entries of insert. It started again , but empty. I'm using: <*dropwizard.version*>1.0.0 which depends on jdbi 2.7.3 my configuration is: jdbc:h2:mem:cqm;JMX=TRUE;MULTI_THREADED=1;LOG=0;DB_CLOSE_DELAY=-1 final DBIFactory factory = new

[h2] Use memory database and use file for persist and for next restart

2017-01-03 Thread Elad Wertzberger
Hi, I was wonder, In case I use the H2 memory impl, and I want still to have restore points. (for example save files) Does the H2(2.7.3) has some built in support for it? if does then could u please send me a sample config with guidelines? thx Elad Wertzberger -- This message may contain conf

[h2] H2 in memory impl - restart after ~300000 inserts with empty database. why????

2017-01-03 Thread Steve McLeod
Starting your JDBC URL with "jdbc:h2:mem:" tells H2 you want an in-memory non-persisted database. If you want a database persisted between sessions, use a URL that starts with jdbc:h2:file: The syntax of the H2 JDBC URL is explained here: http://www.h2database.com/html/features.html#database_ur

[h2] Use memory database and use file for persist and for next restart

2017-01-03 Thread Steve McLeod
I don't believe this is supported. Instead you can use a file URL, with a large value specified for CACHE_SIZE. Read more about cache size here: http://www.h2database.com/html/grammar.html#set_cache_size -- You received this message because you are subscribed to the Google Groups "H2 Database"