Re: [h2] jdbc:h2:mem: threadsafe?

2013-12-30 Thread Ryan How
It will be 2. and the second create table will fail because the table already exists. But I don't see how that has anything to do with being thread safe? The in memory database is per process, so all threads access the same database. If you want a separate database per thread then give the data

Re: [h2] jdbc:h2:mem: threadsafe?

2013-12-30 Thread Laird Nelson
On Tuesday, October 8, 2013 10:24:12 AM UTC-7, Thomas Mueller wrote: > > I think the documentation is quite clear. > Let me rephrase the question (and sorry for just now noticing the timely reply): Suppose I have two threads, t1 and t2. Suppose each of them opens a connection to jdbc:h2:mem:

Re: [h2] Re: Corrupted Database

2013-12-30 Thread Geren White
Hello, This issue happened again. The database was recovered with the recovery tool and was working fine for a few days. I am seeing an array index out of bounds exception. Stack trace: SELECT * FROM MRKMAGDTA.FMTSPF80 WHERE FMNAM = 'SHLBL131' AND FMMODL = 'ZTZ170XI3' [5-162] at org.h2.m