[h2] H2 AUTO_SERVER failed when using two JVM's

2016-04-20 Thread Jijo AC
We want to connect to H2 database from our two applications(2 JVM), So we appand AUTO_SERVER=TRUE with the database URL. It works fine if we run both applications. But when we stop the first started application, the second application failed to connect and throws Connection is broken: "session

Re: [h2] mail flow analytics for a company

2016-04-20 Thread Valentin Popov
Ryan, thanks. As I read about data warehouse proper way do it is a star scheme, question is H2 (RDBMS) are designed for that and can handle it? I have experience with graph DB, but load, like for a one day is very slow. Here is my thinking about H2 tables. Have a couple of tables for (30

Re: [h2] mail flow analytics for a company

2016-04-20 Thread Ryan How
Hi, You could make it work with that, but it would depend massively on how you architect your system. You won't just be able to put the records in a database and then query it with any kind of scalability and performance expectations. Ryan On 20/04/2016 10:12 PM, Valentin Popov wrote:

[h2] mail flow analytics for a company

2016-04-20 Thread Valentin Popov
Hello everyone. I need write analytics of mail flow in a company for domains and users. Analytics should contains traffic size/count, attachments size/count, attachments type, with directions (in/out/internal) with granularity threshold of 30 minutes. Company with 50 000 employers 50 messages

Re: [h2] Problem executing parametrized subqueries

2016-04-20 Thread Iago Tomas
Thanks, in fact a colleague pointed me out that it's a documented limitation of h2. http://www.h2database.com/html/advanced.html#recursive_queries I don't know if I'll have time to check the nighlty builds, in case i'm able to i'll try to share findings with you. Thx El dimarts, 19 abril de