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.
> 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 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.
