Hi Lou,
The following section of the Virtuoso documentation details the use of the
"System.Data.IDbConnection.BeginTransaction Method (IsolationLevel)" to set
the appropriate isolation level for the type of transactions being performed
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ptune
The default Virtuoso transaction isolation level is repeatable read, whereas
for perform read/write operations an isolation level of "read committed" would
be more appropriate, as detailed in the following section on locking:
http://docs.openlinksw.com/virtuoso/coredbengine.html#Locking
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 3 Nov 2010, at 19:21, lou.sa...@kodak.com wrote:
> We are in the process of porting some .net database interface code that used
> to use the
> Microsoft SQL Express database as the backing store to use the Open Source
> Edition of Virtuoso.
> The code uses the Virtuoso Ado,net data provider to communicate with Virtuoso
> and
> has retry logic support for deadlock exceptions that are thrown from the
> database engine.
>
> Whenever we run a test that uses multiple threads Virtuoso throws a deadlock
> detected exception.
> There are about 10 threads in total. Some just read. Some read and write.
> Some just write.
>
> In response to a deadlock detected exception, our code delays a random amount
> of time, disposes the transaction, closes the database connection, and
> starts over.
>
> However a second deadlock is thrown when we make the transaction.Dispose()
> call.
> This code works with the Microsoft database.
>
> Does anyone have sample code for how to gracefully handle a deadlock
> exception from Virtuoso?
>
> Thanks in advance.
>
> Lou Sakey
> CDG WW DC+D R+D Software|
>
> lou.sa...@kodak.com
> 781-583-1453 (home office)
> ------------------------------------------------------------------------------
> The Next 800 Companies to Lead America's Growth: New Video Whitepaper
> David G. Thomson, author of the best-selling book "Blueprint to a
> Billion" shares his insights and actions to help propel your
> business during the next growth cycle. Listen Now!
> http://p.sf.net/sfu/SAP-dev2dev_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
