Tried the following workaround and it worked (+ works reasonably fast):
 - reconnect ODBC connection after each SPARQL update

Yet it would be good to solve the problem itself.

Best,
Uldis

On Sat, Nov 24, 2012 at 11:15 PM, Uldis Bojars <[email protected]> wrote:
> Hi Hugh,
>
>> 1. The version of Virtuoso being used as last we spoke you were using 6.1.4 
>> shipped with Ubuntu 12.04 and were going to attempt to rebuild for source to 
>> update to the latest 6.1.6 version ?
>
> Still 6.1.4 shipped with Ubuntu. Will update, but did not get around
> to it yet. However, this problem appears to be client-side.
>
>> 2. The version of the Virtuoso ODBC Driver on windows being used ie how does 
>> it compare with the server version being used on Ubuntu ?
>
> Version 6.04.3132.01 from Virtuoso Connectivity Kit (guess that is the name).
>
>> 3. The query being run that is causing this error, which I assume runs 
>> successfully if run from isql or the /sparql endpoint ?
>
> It's a series of INSERT IN GRAPH <uri> { triples } statements. The
> failure does not happen on the first query, but takes some time (3 -
> 10 statements in a row) to build up. For some time it happened on
> every 3rd statement. It does not seem to be associated with any
> particular statement. It's a number of statements in a row that causes
> the problem.
>
>> You indicate a C# .Net 4.0 application is being used, in which case how does 
>> this application invoke the Virtuoso ODBC Driver does it use the ADO.Net 
>> ODBC Bridge Provider (System.Data.Odbc)  built-in or other method. Also have 
>> you
>
> Using the ODBC bridge (System.Data.Odbc):
>             _Conn = new OdbcConnection(ConnectionStrings.Sparql());
>             _Conn.Open();
>
>>considered using the Virtuoso ADO.Net Provider to make a direct connection to 
>>Virtuoso and invoke SPASQL queries via this means, see:
>
> How does this approach differ from the ODBC bridge?
>
> Could you show (or point to) an example of doing a SPASQL query via
> ADO.Net Provider? I got lost in the contents of
> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtAdoNet35Provider
> -- could not find a simple example how to run a SPARQL query.
>
> Thanks,
> Uldis

------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to