Awesome! This is about the best I could hope for.

I would recommend making this information easier to find somewhere in the 
documentation.

Thanks!
- Mark

-----Original Message-----
From: Andy Seaborne [mailto:[email protected]] On Behalf Of Andy 
Seaborne
Sent: Monday, March 12, 2012 3:19 PM
To: [email protected]
Subject: Re: SDB threading questions

On 12/03/12 18:49, Mark Roth wrote:
> I have some questions about SDB threading. Forgive me if these are addressed 
> in the documentation - I tried to search but didn't find what I was looking 
> for:
>

A Store is a wrapper around a JDBC connection ....


> 1.       Can I have multiple Store objects in the same VM attached to the 
> same SQL back-end?

Yes


> 2.       Can multiple threads access the same Store instance simultaneously, 
> or does access need to be synchronized?

Yes

>
> 3.       Can multiple VMs attach to the same SDB SQL back-end and can they 
> read simultaneously while another VM is performing a transactional commit?

Yes

Related:

http://incubator.apache.org/jena/documentation/sdb/javaapi.html#connection_management


The only thing to be careful about is if the two Store object are 
sharing a JDBC connection (a common SDBConnection object).  Then, there 
is no transactional separation; it's just like using the same JDBC 
connection across threads.

        Andy

Reply via email to