The problem is that the data is stored on a per-session basis, not on a
per-table basis.
In general, JDBC is not guaranteed to be thread-safe, so calling the
same connection from multiple threads is going to cause you more
problems elsewhere eventually.
I seriously suggest you use a connection pool.
On 2012-04-17 11:18, Thomas wrote:
Understood.
So I'm currently synchronizing the methods that modify this particular
table. (It would make perfect sense to have concurrency issues without
this).
Multiple concurrent reads shouldn't be an issue I presume, or do these
also require locking and is that causing my issue?
Thanks.
On Tuesday, April 17, 2012 11:14:33 AM UTC+2, Noel Grandin wrote:
If you are sharing a session/connection between 2 threads, and two
of those threads try to execute statements at the same time, then
you might see this kind of problem.
You probably need to either (a) use a connection pool or (b)
synchronise your entire access to the DB.
On 2012-04-17 11:05, Thomas wrote:
Class.forName("org.h2.Driver");
this.con = DriverManager.getConnection("jdbc:h2:"+dbname,
"sa", "");
con.setAutoCommit(true);
I just set it once when getting the connection.
That's it, nothing fancy.
Op dinsdag 17 april 2012 11:00:30 UTC+2 schreef Noel Grandin het
volgende:
What does your JDBC URL looks like?
ie. what parameters are you using.
--
You received this message because you are subscribed to the
Google Groups "H2 Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/93IGWW7-65sJ
<https://groups.google.com/d/msg/h2-database/-/93IGWW7-65sJ>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
<http://groups.google.com/group/h2-database?hl=en>.
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/16KF_dXhg5EJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
