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 databases different names.
On 31/12/2013 7:50 AM, Laird Nelson wrote:
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: Suppose that each of them now issues a
CREATE TABLE Fred statement. Suppose further that each of them now
inserts one row into the Fred table.
If t1 then issues a SELECT COUNT(*) FROM Fred, and if no other
database activity takes place, will the result be /guaranteed/ to be
1? Or will it be 2?
Thanks,
Best,
Laird
--
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 http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
--
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 http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
