Re: Concurrency in Jena/SDB

2013-04-17 Thread Andy Seaborne
Seaborne [mailto:a...@apache.org] Sent: Monday, April 15, 2013 10:10 AM To: users@jena.apache.org Subject: Re: Concurrency in Jena/SDB On 15/04/13 14:51, Lebling, David (US SSA) wrote: Andy, Which part of that document is the part that might help? My code already creates a new Store for each

RE: Concurrency in Jena/SDB

2013-04-15 Thread David Jordan
@jena.apache.org Subject: RE: Concurrency in Jena/SDB Andy, I was hoping you might have some guidance as to what you mean by You need to control the JDBC transaction in your code to get isolation between JVMs. Is there some interface in SDB that will accomplish this, or does this require SQL

RE: Concurrency in Jena/SDB

2013-04-15 Thread Lebling, David (US SSA)
As Joshua Bloch says, concurrency is hard. David Jordan, The model.begin/model.commit/model.abort trio seems to work okay for all operations within a single JVM, although if you look at the code I included with my original question you'll a lot of decoration that may or may not be required.

Re: Concurrency in Jena/SDB

2013-04-15 Thread Andy Seaborne
to access the needed JDBC objects. -Original Message- From: Damian Steer [mailto:cm...@bristol.ac.uk] On Behalf Of Damian Steer Sent: Monday, April 15, 2013 9:27 AM To: users@jena.apache.org Subject: Re: Concurrency in Jena/SDB On 15 Apr 2013, at 12:35, Lebling, David (US SSA) david.lebl

RE: Concurrency in Jena/SDB

2013-04-15 Thread Lebling, David (US SSA)
...@apache.org] Sent: Monday, April 15, 2013 9:42 AM To: users@jena.apache.org Subject: Re: Concurrency in Jena/SDB This might help: http://jena.apache.org/documentation/sdb/javaapi.html#connection-management Andy On 15/04/13 14:38, David Jordan wrote: So every call to a method of Model

Re: Concurrency in Jena/SDB

2013-04-15 Thread Damian Steer
On 15 Apr 2013, at 14:38, David Jordan david.jor...@sas.com wrote: So every call to a method of Model or OntModel is done in a separate transaction? This could easily explain the poor performance I am getting, and those of others who have complained about SDB performance in this group.

Re: Concurrency in Jena/SDB

2013-04-15 Thread Andy Seaborne
. -Original Message- From: Andy Seaborne [mailto:a...@apache.org] Sent: Monday, April 15, 2013 9:42 AM To: users@jena.apache.org Subject: Re: Concurrency in Jena/SDB This might help: http://jena.apache.org/documentation/sdb/javaapi.html#connection-management Andy

RE: Concurrency in Jena/SDB

2013-04-15 Thread Lebling, David (US SSA)
suggesting something different? Dave -Original Message- From: Andy Seaborne [mailto:a...@apache.org] Sent: Monday, April 15, 2013 10:10 AM To: users@jena.apache.org Subject: Re: Concurrency in Jena/SDB On 15/04/13 14:51, Lebling, David (US SSA) wrote: Andy, Which part of that document

Re: Concurrency in Jena/SDB

2013-04-11 Thread Andy Seaborne
David, Your not executing inside a database level (JDBC) transaction. I'm afraid model.begin/commit does not know about JDBC properly. You need to control the JDBC transaction in your code to get isolation between JVMs. Which SQL database are you using? Andy On 10/04/13 16:12,

RE: Concurrency in Jena/SDB

2013-04-11 Thread Lebling, David (US SSA)
Andy, It has been used with Postgres and MySQL. Dave -Original Message- From: Andy Seaborne [mailto:a...@apache.org] Sent: Thursday, April 11, 2013 8:16 AM To: users@jena.apache.org Subject: Re: Concurrency in Jena/SDB David, Your not executing inside a database level (JDBC