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
