[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_url

-- 
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.


[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 DBIFactory();
this.dbi = factory.build(environment, config.getH2Database(), "h2");
this.dbi.setTimingCollector(new 
InstrumentedTimingCollector(environment.metrics()));

this.extendedConversationH2Dao = 
this.dbi.onDemand(ExtendedConversationH2Dao.class);


*my questions:*
1. how to fix this behavior? is there a configuration i miss?
2. how to know and catch the situation?
3. are there known limitation for the database size? known bugs?
4. is there more advanced version of dropwizard with jdbi that can help to 
resolve it?
5. should I use batch inserts? will it help? if do then please send me an 
example.

Best Regards

Elad Wertzberger

-- 
This message may contain confidential and/or privileged information. 
If you are not the addressee or authorized to receive this on behalf of the 
addressee you must not use, copy, disclose or take action based on this 
message or any information herein. 
If you have received this message in error, please advise the sender 
immediately by reply email and delete this message. Thank you.

-- 
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.