Re: [h2] Remote connection hangs while debugging

Yep, that was the problem. I'd only worked with Eclipse in the past, so I didn't realize that there was such a thing as a breakpoint that suspends all threads. Turns out that this is the default in IntelliJ, and can be changed in the breakpoint properties. Thanks Thomas. On Friday, October 1

[h2] data size inflation

I'm storing a bunch of 400 byte varbinary objects in a table like so: CREATE CACHED TABLE PUBLIC.SCORES( ID INT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_0D2CC30B_0ED7_4EB5_A0D4_6448B031FC02) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_0D2CC30B_0ED7_4EB5_A0D4_6448B031FC02

Re: [h2] Remote connection hangs while debugging

Hi, There are two types of breakpoints: those that only pause the current thread (in Eclipse this is the default), and those that pause all threads. You might want to check which type your breakpoint is. Other than that, I'm not sure what could be the problem. Regards, Thomas On Fri, Oct 11,

Re: [h2] Data transfer From and To Postgres

Very true. :D Thank you, Sir. On Friday, October 11, 2013 10:52:27 AM UTC+2, Noel Grandin wrote: > > What I meant is that it's a lot more convenient to go: > > CREATE LINKED TABLE link1... > INSERT INTO my_local_table SELECT * from link1 > > than it is to copy things via an intermediate

[h2] Remote connection hangs while debugging

I'm debugging a unit test and would like to query my in-memory database while the debugger (IntelliJ IDEA, in case it matters) is stopped at a breakpoint. Before I hit the breakpoint, I start my web server with Server.createWebServer("-web", "-webAllowOthers", "-webPort", "8082", "-webDaemon")

Re: [h2] Data transfer From and To Postgres

What I meant is that it's a lot more convenient to go: CREATE LINKED TABLE link1... INSERT INTO my_local_table SELECT * from link1 than it is to copy things via an intermediate CSV file. On 2013-10-11 10:43, Tony Taylor wrote: Thanks! I'll check this out and definitely give it a go, thoug

Re: [h2] Data transfer From and To Postgres

Thanks! I'll check this out and definitely give it a go, though i'm a bit sceptical. What i want to achieve is to have the load on H2 until the processing goes on and only merge the results into my main, PG db. As far as i understand, using linked tables just puts H2 in the middle. I have two t

Re: [h2] Data transfer From and To Postgres

For DB to DB copying, you might have more joy using linked tables: http://h2database.com/html/grammar.html#create_linked_table http://h2database.com/html/advanced.html#linked_tables On 2013-10-10 17