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
