[Virtuoso-users] locking down sparql endpoint

[Erich Bremer]

How do I disable /sparql and thus restrict access to only /sparql-auth and
/sparql-graph-crud?  - Erich
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Unicode in Virtuoso

[Erich Bremer]

 The fault was mine.  I forgot to specify the "UTF-8" encoding in the file
writer:

writer = new OutputStreamWriter(new GZIPOutputStream(output));

to

writer = new OutputStreamWriter(new GZIPOutputStream(output), "UTF-8");

Although the file looks near identical and even looks correct in some
programs, it wasn't until the encoding is added that the resultant file is
correctly uploaded into Virtuoso.  - Erich

On Tue, Mar 27, 2018 at 7:29 PM, Hugh Williams <hwilli...@openlinksw.com>
wrote:

> Hi Erich,
>
> When you say bulk update method I presume you mean with the Virtuoso RDF
> Bulk Loader ie https://virtuoso.openlinksw.com/dataspace/doc/
> dav/wiki/Main/VirtBulkRDFLoader  ?
>
> If so are you able to provide a sample NT file for upload to recreate
> locally , as we have not had such complaints and Virtuoso is used for
> hosting datasets in many languages with unicode chars which are uploaded
> using the bulk loader ?
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc.  //  http://www.openlinksw.com/
> Weblog   -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter  -- http://twitter.com/OpenLink
> Google+  -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
>
>
> On 27 Mar 2018, at 21:41, Erich Bremer <er...@ebremer.com> wrote:
>
> I've uploaded some Unicode characters via sparql-auth endpoint using:
>
> prefix : <http://www.stonybrook.edu/ns/>
> insert data {graph <http://www.ebremer.com> { :status
> "卩尺乇ᐯ丨乇山 ㄒ乇乂ㄒ"}}
>
> which will display fine:
> urn:sbu:test http://www.stonybrook.edu/ns/status
>
> "Yay!"
>
> urn:sbu:test http://www.stonybrook.edu/ns/status
>
> "Ω"
>
> urn:sbu:test http://www.stonybrook.edu/ns/status
>
> "卩尺乇ᐯ丨乇山 ㄒ乇乂ㄒ"
>
>
> It seems the unicode data uploaded via the bulk update method ala isql is
> not uploading the characters correctly.  They get converted to question
> marks.  - E
>
> On Thu, Mar 22, 2018 at 8:07 PM, Erich Bremer <er...@ebremer.com> wrote:
>
>> I've uploaded some N-Triples files using the bulk uploader method to my
>> Virtuoso instance (07.20.3217).  The NT files look fine, but when I query
>> the data via the SPARQL endpoint, the Unicode characters are all converted
>> to question marks.  How do I properly upload Unicode data into Virtuoso?  -
>> Erich Bremer
>>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot__
> _
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Unicode in Virtuoso

[Erich Bremer]

I've uploaded some Unicode characters via sparql-auth endpoint using:

prefix : <http://www.stonybrook.edu/ns/>
insert data {graph <http://www.ebremer.com> { :status
"卩尺乇ᐯ丨乇山 ㄒ乇乂ㄒ"}}

which will display fine:
urn:sbu:test http://www.stonybrook.edu/ns/status

"Yay!"

urn:sbu:test http://www.stonybrook.edu/ns/status

"Ω"

urn:sbu:test http://www.stonybrook.edu/ns/status

"卩尺乇ᐯ丨乇山 ㄒ乇乂ㄒ"


It seems the unicode data uploaded via the bulk update method ala isql is
not uploading the characters correctly.  They get converted to question
marks.  - E

On Thu, Mar 22, 2018 at 8:07 PM, Erich Bremer <er...@ebremer.com> wrote:

> I've uploaded some N-Triples files using the bulk uploader method to my
> Virtuoso instance (07.20.3217).  The NT files look fine, but when I query
> the data via the SPARQL endpoint, the Unicode characters are all converted
> to question marks.  How do I properly upload Unicode data into Virtuoso?  -
> Erich Bremer
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Maximum http post size

[Erich Bremer]

Hi,

I'm trying to use the graph management protocol to post large amounts of RDF 
data to my Virtuoso instance.  What is the limit of the size of the posts 
that Virtuoso will handle and how can this maximum post size be increased?

Thanks,

      Erich Bremer


--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785231=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

[Erich Bremer]

On the link http://localhost:8890/sparql-graph-crud, I noticed the 
following text:


"This page is designed to help you test support forSPARQL 1.1 Graph 
Store HTTP Protocol in 
OpenLink Virtuoso."


Does this imply that SPARQL 1.1 Graph Store HTTP Protocol is only 
experimental in Virtuoso or is it actually fully supported?  - Erich
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Virtuoso LDP

[Erich Bremer]

Can Virtuoso return JSON-LD using it's LDP interface?  I tried 
using application/ld+json for content neg. but that didn't work. - Erich



--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Virtuoso LDP

[Erich Bremer]

I was actually working with the Chrome REST client, but this would be the 
curl equivalent I believe:

curl -iH Accept: application/ld+json, */*;q=0.1 -u dba 
http://crux.bmi.stonybrook.edu:8890/DAV/home/dba;


On Mon, 08 Dec 2014 14:20:28 -0500
  Kingsley Idehen kide...@openlinksw.com wrote:
 On 12/8/14 1:50 PM, Erich Bremer wrote:
 Can Virtuoso return JSON-LD using it's LDP interface?  I 
tried
 using application/ld+json for content neg. but that 
didn't work. - Erich


 cURL example?
 
 -- 
 Regards,
 
 Kingsley Idehen   
Founder  CEO
 OpenLink Software
 Company Web: http://www.openlinksw.com
 Personal Weblog 1: http://kidehen.blogspot.com
 Personal Weblog 2: 
http://www.openlinksw.com/blog/~kidehen
 Twitter Profile: https://twitter.com/kidehen
 Google+ Profile: 
https://plus.google.com/+KingsleyIdehen/about
 LinkedIn Profile: http://www.linkedin.com/in/kidehen
 Personal WebID: 
http://kingsley.idehen.net/dataspace/person/kidehen#this
 
 



--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Virtuoso LDP

[Erich Bremer]

That works for me.  The version I am running is a vanilla v7.1.  If you 
think the dev version is stable enough, I will upgrade it tomorrow.  - Erich


On Mon, 08 Dec 2014 17:24:38 -0500
  Kingsley Idehen kide...@openlinksw.com wrote:
 On 12/8/14 3:44 PM, Erich Bremer wrote:
 I was actually working with the Chrome REST client, but 
this would be the curl equivalent I believe:

 curl -iH Accept: application/ld+json, */*;q=0.1 -u dba 
http://crux.bmi.stonybrook.edu:8890/DAV/home/dba;
 
 Could be a release issue.
 
 Try:
 curl -iH Accept: application/ld+json, */*;q=0.1 
http://ods-qa.openlinksw.com/DAV/home/kidehen/Public/profile2.ttl
 
 
 Kingsley


 On Mon, 08 Dec 2014 14:20:28 -0500
  Kingsley Idehen kide...@openlinksw.com wrote:
 On 12/8/14 1:50 PM, Erich Bremer wrote:
 Can Virtuoso return JSON-LD using it's LDP interface?  I 
tried
 using application/ld+json for content neg. but that 
didn't work. - Erich


 cURL example?

 -- 
 Regards,

 Kingsley Idehen
 Founder  CEO
 OpenLink Software
 Company Web: http://www.openlinksw.com
 Personal Weblog 1: http://kidehen.blogspot.com
 Personal Weblog 2: 
http://www.openlinksw.com/blog/~kidehen
 Twitter Profile: https://twitter.com/kidehen
 Google+ Profile: 
https://plus.google.com/+KingsleyIdehen/about
 LinkedIn Profile: http://www.linkedin.com/in/kidehen
 Personal WebID: 
http://kingsley.idehen.net/dataspace/person/kidehen#this


 -- 
 Regards,
 
 Kingsley Idehen   
Founder  CEO
 OpenLink Software
 Company Web: http://www.openlinksw.com
 Personal Weblog 1: http://kidehen.blogspot.com
 Personal Weblog 2: 
http://www.openlinksw.com/blog/~kidehen
 Twitter Profile: https://twitter.com/kidehen
 Google+ Profile: 
https://plus.google.com/+KingsleyIdehen/about
 LinkedIn Profile: http://www.linkedin.com/in/kidehen
 Personal WebID: 
http://kingsley.idehen.net/dataspace/person/kidehen#this
 
 



--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] multiple sparql update commands

[Erich Bremer]

Thanks Hugh! - Erich

On 12/7/2014 5:01 PM, Hugh Williams wrote:

Hi Erich,

A fix for this issue is available in the latest git  develop/7 branch …

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 9 Nov 2014, at 02:53, Hugh Williams hwilli...@openlinksw.com 
mailto:hwilli...@openlinksw.com wrote:


Hi Erich,

I have been able to recreate this locally , we shall look into this 
and get back to you …


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 9 Nov 2014, at 01:56, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:


Hi Kingsley,
​
Using sparql-auth and executing this on a vanilla V7.1 instance:
prefix foaf: http://xmlns.com/foaf/
with http://crux.ebremer.com http://crux.ebremer.com/ insert data
{http://www.ebremer.com/foaf.rdf foaf:lastName Bremer};
with http://crux.ebremer.com http://crux.ebremer.com/ insert data
{http://www.ebremer.com/foaf.rdf foaf:firstName Erich};
​
yields:
Virtuoso 37000 Error SP030: SPARQL compiler, line 5: syntax error at 
'with'

before 'http://crux.ebremer.com http://crux.ebremer.com/'
SPARQL query:
define sql:big-data-const 0
#output-format:text/html
define sql:signal-void-variables 1 prefix foaf: http://xmlns.com/foaf/
with http://crux.ebremer.com http://crux.ebremer.com/ insert data
{http://www.ebremer.com/foaf.rdf foaf:lastName Bremer};
with http://crux.ebremer.com http://crux.ebremer.com/ insert data
{http://www.ebremer.com/foaf.rdf foaf:firstName Erich};
​
However, either with-insert works fine by itself.  - Erich
​
​
​
On Sat, 08 Nov 2014 19:40:04 -0500
 Kingsley Idehen kide...@openlinksw.com 
mailto:kide...@openlinksw.com wrote:

On 11/8/14 6:25 PM, Erich Bremer wrote:

Hi,
Is Virtuoso supposed to be able to handle multiple
SPARQL update commands
such as a with-delete-insert separated with semi-colons
via sparql-auth
endpoint?  - Erich



Yes it is. What's failing?

--
Regards,

Kingsley Idehen
Founder  CEO
OpenLink Software
Company Web: http://www.openlinksw.com http://www.openlinksw.com/
Personal Weblog 1: http://kidehen.blogspot.com 
http://kidehen.blogspot.com/

Personal Weblog 2:
http://www.openlinksw.com/blog/~kidehen 
http://www.openlinksw.com/blog/%7Ekidehen

Twitter Profile: https://twitter.com/kidehen
Google+ Profile:
https://plus.google.com/+KingsleyIdehen/about
LinkedIn Profile: http://www.linkedin.com/in/kidehen
Personal WebID:
http://kingsley.idehen.net/dataspace/person/kidehen#this



​
​

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net 
mailto:Virtuoso-users@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/virtuoso-users






--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] multiple sparql update commands

[Erich Bremer]

Not yet, but I will try.  It looks like from the SPARQL specs it should 
work.  - E
​
​
On Sun, 9 Nov 2014 13:55:57 +
  Hugh Williams hwilli...@openlinksw.com wrote:
 Hi Erich,
 
 See also the following documentation on Executing 
Queries Combined in Single or Multiple Statements:
 
   
 http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideSPARQLSingleMultipleExecution
 
 Have you been able to use the with construct for 
executing multiple statements with other stores ?
 
 Best Regards
 Hugh Williams
 Professional Services
 OpenLink Software, Inc.  // 
 http://www.openlinksw.com/
 Weblog   -- http://www.openlinksw.com/blogs/
 LinkedIn -- 
http://www.linkedin.com/company/openlink-software/
 Twitter  -- http://twitter.com/OpenLink
 Google+  -- 
http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
 Universal Data Access, Integration, and Management 
Technology Providers
 
 On 9 Nov 2014, at 12:05, Kingsley Idehen 
kide...@openlinksw.com wrote:
 
 On 11/8/14 8:56 PM, Erich Bremer wrote:
 Hi Kingsley,
 
 Using sparql-auth and executing this on a vanilla V7.1 
instance:
 prefix foaf: http://xmlns.com/foaf/
 with http://crux.ebremer.com insert data
 {http://www.ebremer.com/foaf.rdf foaf:lastName 
Bremer};
 with http://crux.ebremer.com insert data
 {http://www.ebremer.com/foaf.rdf foaf:firstName 
Erich};
 This will work.
 
 prefix foaf: http://xmlns.com/foaf/
  insert data
 { graph http://crux.ebremer.com 
{http://www.ebremer.com/foaf.rdf foaf:lastName Bremer 
}};
 
 insert data {graph http://crux.ebremer.com
 {http://www.ebremer.com/foaf.rdf foaf:firstName 
Erich}};
 
 
 WITH is setting statement block. Whereas the revision 
above executes many statements delimited by semi-colons.
 
 
 Kingsley
 
 
 
 yields:
 Virtuoso 37000 Error SP030: SPARQL compiler, line 5: 
syntax error at 'with'
 before 'http://crux.ebremer.com'
 SPARQL query:
 define sql:big-data-const 0
 #output-format:text/html
 define sql:signal-void-variables 1 prefix foaf: 
http://xmlns.com/foaf/
 with http://crux.ebremer.com insert data
 {http://www.ebremer.com/foaf.rdf foaf:lastName 
Bremer};
 with http://crux.ebremer.com insert data
 {http://www.ebremer.com/foaf.rdf foaf:firstName 
Erich};
 
 However, either with-insert works fine by itself.  - 
Erich
 
 
 
 On Sat, 08 Nov 2014 19:40:04 -0500
   Kingsley Idehen kide...@openlinksw.com wrote:
 On 11/8/14 6:25 PM, Erich Bremer wrote:
 Hi,
 Is Virtuoso supposed to be able to handle multiple
 SPARQL update commands
 such as a with-delete-insert separated with semi-colons
 via sparql-auth
 endpoint?  - Erich
 
 Yes it is. What's failing?
 
 -- 
 Regards,
 
 Kingsley Idehen
 Founder  CEO
 OpenLink Software
 Company Web: http://www.openlinksw.com
 Personal Weblog 1: http://kidehen.blogspot.com
 Personal Weblog 2:
 http://www.openlinksw.com/blog/~kidehen
 Twitter Profile: https://twitter.com/kidehen
 Google+ Profile:
 https://plus.google.com/+KingsleyIdehen/about
 LinkedIn Profile: http://www.linkedin.com/in/kidehen
 Personal WebID:
 http://kingsley.idehen.net/dataspace/person/kidehen#this
 
 
 
 
 
 --
 ___
 Virtuoso-users mailing list
 Virtuoso-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/virtuoso-users
 
 
 -- 
 Regards,
 
 Kingsley Idehen  
 Founder  CEO
 OpenLink Software
 Company Web: http://www.openlinksw.com
 Personal Weblog 1: http://kidehen.blogspot.com
 Personal Weblog 2: 
http://www.openlinksw.com/blog/~kidehen
 Twitter Profile: https://twitter.com/kidehen
 Google+ Profile: 
https://plus.google.com/+KingsleyIdehen/about
 LinkedIn Profile: http://www.linkedin.com/in/kidehen
 Personal WebID: 
http://kingsley.idehen.net/dataspace/person/kidehen#this
 
 
 --
 ___
 Virtuoso-users mailing list
 Virtuoso-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/virtuoso-users
 
​
​

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] multiple sparql update commands

[Erich Bremer]

Thanks Kingsley, I can write my inserts in this style for what I need to do. 
 But, I wanted to try the WITH option out since most of what I do these days 
involves quads.  - E
​
​
On Sun, 09 Nov 2014 07:05:15 -0500
  Kingsley Idehen kide...@openlinksw.com wrote:
 On 11/8/14 8:56 PM, Erich Bremer wrote:
 Hi Kingsley,
 
 Using sparql-auth and executing this on a vanilla V7.1 
instance:
 prefix foaf: http://xmlns.com/foaf/
 with http://crux.ebremer.com insert data
 {http://www.ebremer.com/foaf.rdf foaf:lastName 
Bremer};
 with http://crux.ebremer.com insert data
 {http://www.ebremer.com/foaf.rdf foaf:firstName 
Erich};
 This will work.
 
 prefix foaf: http://xmlns.com/foaf/
  
  
 insert data
 { graph http://crux.ebremer.com 
{http://www.ebremer.com/foaf.rdf foaf:lastName Bremer 
}};
 
 insert data {graph http://crux.ebremer.com
 {http://www.ebremer.com/foaf.rdf foaf:firstName 
Erich}};
 
 
 WITH is setting statement block. Whereas the revision 
above executes many statements delimited by semi-colons.
 
 
 Kingsley
 
 
 
 yields:
 Virtuoso 37000 Error SP030: SPARQL compiler, line 5: 
syntax error at 'with'
 before 'http://crux.ebremer.com'
 SPARQL query:
 define sql:big-data-const 0
 #output-format:text/html
 define sql:signal-void-variables 1 prefix foaf: 
http://xmlns.com/foaf/
 with http://crux.ebremer.com insert data
 {http://www.ebremer.com/foaf.rdf foaf:lastName 
Bremer};
 with http://crux.ebremer.com insert data
 {http://www.ebremer.com/foaf.rdf foaf:firstName 
Erich};
 
 However, either with-insert works fine by itself.  - 
Erich
 
 
 
 On Sat, 08 Nov 2014 19:40:04 -0500
Kingsley Idehen kide...@openlinksw.com wrote:
 On 11/8/14 6:25 PM, Erich Bremer wrote:
 Hi,
 Is Virtuoso supposed to be able to handle multiple
 SPARQL update commands
 such as a with-delete-insert separated with semi-colons
 via sparql-auth
 endpoint?  - Erich

 Yes it is. What's failing?

 -- 
 Regards,

 Kingsley Idehen 
 Founder  CEO
 OpenLink Software
 Company Web: http://www.openlinksw.com
 Personal Weblog 1: http://kidehen.blogspot.com
 Personal Weblog 2:
 http://www.openlinksw.com/blog/~kidehen
 Twitter Profile: https://twitter.com/kidehen
 Google+ Profile:
 https://plus.google.com/+KingsleyIdehen/about
 LinkedIn Profile: http://www.linkedin.com/in/kidehen
 Personal WebID:
 http://kingsley.idehen.net/dataspace/person/kidehen#this


 
 

 --
 ___
 Virtuoso-users mailing list
 Virtuoso-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/virtuoso-users
 
 
 -- 
 Regards,
 
 Kingsley Idehen   
Founder  CEO
 OpenLink Software
 Company Web: http://www.openlinksw.com
 Personal Weblog 1: http://kidehen.blogspot.com
 Personal Weblog 2: 
http://www.openlinksw.com/blog/~kidehen
 Twitter Profile: https://twitter.com/kidehen
 Google+ Profile: 
https://plus.google.com/+KingsleyIdehen/about
 LinkedIn Profile: http://www.linkedin.com/in/kidehen
 Personal WebID: 
http://kingsley.idehen.net/dataspace/person/kidehen#this
 
 
​
​

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] multiple sparql update commands

[Erich Bremer]

Hi,
Is Virtuoso supposed to be able to handle multiple SPARQL update commands 
such as a with-delete-insert separated with semi-colons via sparql-auth 
endpoint?  - Erich
​
​

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Geometric Objects

[Erich Bremer]

Hi Hugh,

Stupid me on forgetting the double braces.  How can I change the 
default srid from 4326 to something else?  I just want a 2d Cartesian 
coordinate system (my data isn't WGS 84).  Although it seems I can 
change the srid with st_setsrid, ttlp will throw the same error as below 
when I try to load my non-4326 data (even with the extra braces).  - Erich


On 05/28/14 5:53 PM, Hugh Williams wrote:

Hi Erich,

You need to have double opening and closing braces around the 
POLYGON((...)) geometry type:


Fails:

SQL ttlp ('@prefix virtrdf: 
http://www.openlinksw.com/schemas/virtrdf# . @prefix geo: 
http://www.w3.org/2003/01/geo/wgs84_pos# . _:wow geo:geometry 
POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)^^virtrdf:Geometry 
.','','http://www.whatever.com',0 http://www.whatever.com%27,0);


*** Error 42000: VD [Virtuoso Server]RDFGE: rdf box with a geometry 
rdf type and a non geometry content

at line 1 of Top-Level:
ttlp ('@prefix virtrdf: http://www.openlinksw.com/schemas/virtrdf# . 
@prefix geo: http://www.w3.org/2003/01/geo/wgs84_pos# . _:wow 
geo:geometry POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)^^virtrdf:Geometry 
.','','http://www.whatever.com',0 http://www.whatever.com%27,0)

SQL

*Works:*

SQL ttlp ('@prefix virtrdf: 
http://www.openlinksw.com/schemas/virtrdf# . @prefix geo: 
http://www.w3.org/2003/01/geo/wgs84_pos# . _:wow geo:geometry 
POLYGON*((*1 2, 6 1, 9 3, 3 6, 1 2*))*^^virtrdf:Geometry 
.','','http://www.whatever.com',0 http://www.whatever.com%27,0);


Done. -- 1268 msec.
SQL sparql select * from http://www.whatever.com where {?s ?p ?o};
s   p   o
VARCHAR   VARCHAR 
  VARCHAR

___

nodeID://b10004 http://www.w3.org/2003/01/geo/wgs84_pos#geometry   
   POLYGON((1.00 2.00,6.00 
1.00,9.00 3.00,3.00 6.00,1.00 2.00))


1 Rows. -- 724 msec.
SQL
SQL
SQL status('');
REPORT
VARCHAR
___

OpenLink Virtuoso  Server
Version 07.10.3209-pthreads for Darwin as of May 22 2014

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 28 May 2014, at 20:57, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:



Hi Hugh,

  Awesome!  However, I tried adding a single triple as follows and 
got an error.  Am I missing something?


SQL ttlp ('@prefix virtrdf: 
http://www.openlinksw.com/schemas/virtrdf# . @prefix geo: 
http://www.w3.org/2003/01/geo/wgs84_pos# . _:wow geo:geometry 
POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)^^virtrdf:Geometry 
.','','http://www.whatever.com',0);


*** Error 42000: [Virtuoso Driver][Virtuoso Server]RDFGE: rdf box 
with a geometry rdf type and a non geometry content

at line 57 of Top-Level:
ttlp ('@prefix virtrdf: http://www.openlinksw.com/schemas/virtrdf# 
. @prefix geo: http://www.w3.org/2003/01/geo/wgs84_pos# . _:wow 
geo:geometry POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)^^virtrdf:Geometry 
.','','http://www.whatever.com',0)

SQL

- Erich


On 05/24/14 6:32 PM, Hugh Williams wrote:

Hi Erich,

Virtuoso open source and commercial does now have support for 
polygon geometry types and others as detailed on the 7.1 release 
notes at:


http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSNews#2014-02-17%20--%20Virtuoso%20Open-Source%20Edition%207.1.0%20Released

Live examples can also be found at:

http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_11/SPARQL_Tutorials_Part_11.html#(1) 
http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_11/SPARQL_Tutorials_Part_11.html#%281%29
http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(30) 
http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#%2830%29 



We are currently working on updates to the online docs to details 
the new types supported ...


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 24 May 2014, at 18:31, Erich Bremer er...@ebremer.com wrote:


Are there any plans to support other geometries like

Re: [Virtuoso-users] Geometric Objects

[Erich Bremer]

Hi Hugh,

  Awesome!  However, I tried adding a single triple as follows and got 
an error.  Am I missing something?


SQL ttlp ('@prefix virtrdf: 
http://www.openlinksw.com/schemas/virtrdf# . @prefix geo: 
http://www.w3.org/2003/01/geo/wgs84_pos# . _:wow geo:geometry 
POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)^^virtrdf:Geometry 
.','','http://www.whatever.com',0);


*** Error 42000: [Virtuoso Driver][Virtuoso Server]RDFGE: rdf box with a 
geometry rdf type and a non geometry content

at line 57 of Top-Level:
ttlp ('@prefix virtrdf: http://www.openlinksw.com/schemas/virtrdf# . 
@prefix geo: http://www.w3.org/2003/01/geo/wgs84_pos# . _:wow 
geo:geometry POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)^^virtrdf:Geometry 
.','','http://www.whatever.com',0)

SQL

- Erich


On 05/24/14 6:32 PM, Hugh Williams wrote:

Hi Erich,

Virtuoso open source and commercial does now have support for polygon 
geometry types and others as detailed on the 7.1 release notes at:


http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSNews#2014-02-17%20--%20Virtuoso%20Open-Source%20Edition%207.1.0%20Released

Live examples can also be found at:

http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_11/SPARQL_Tutorials_Part_11.html#(1) 
http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_11/SPARQL_Tutorials_Part_11.html#%281%29
http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(30) 
http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#%2830%29 



We are currently working on updates to the online docs to details the 
new types supported ...


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  //http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 24 May 2014, at 18:31, Erich Bremer er...@ebremer.com wrote:


Are there any plans to support other geometries like POLYGON besides
POINT in Virtuoso?

As per, 9.34.3. Geometric Objects - Only the 2D point is supported. at
the URL:
http://docs.openlinksw.com/virtuoso/sqlrefgeospatial.html

 - Erich

--
Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform 
available

Simple to use. Nothing to install. Get started now for free.
http://p.sf.net/sfu/SauceLabs
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users




--
Time is money. Stop wasting it! Get your web API in 5 minutes.
www.restlet.com/download
http://p.sf.net/sfu/restlet___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Geometric Objects

[Erich Bremer]

Are there any plans to support other geometries like POLYGON besides 
POINT in Virtuoso?

As per, 9.34.3. Geometric Objects - Only the 2D point is supported. at 
the URL:
http://docs.openlinksw.com/virtuoso/sqlrefgeospatial.html

  - Erich

--
Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free.
http://p.sf.net/sfu/SauceLabs
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Virtuoso version detection

[Erich Bremer]

With access to a Virtuoso sparql end-point only, is there any way to 
tell what major/minor version of Virtuoso is running from that sparql 
endpoint?  Thanks, Erich

--
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most 
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] creating indexes with Virtuoso 7.0.0

[Erich Bremer]

Hi,

 I tried creating the index as per the page:

http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning

CREATE BITMAP INDEX RDF_QUAD_PGOS ON DB.DBA.RDF_QUAD (G, P, O, S) PARTITION (O 
VARCHAR (-1, 0hex));

which successfully creates via ISQL (seemingly), but when I go to execute a 
bulk load across 8 cores, Virtuoso
dies with a segmentation core dump.  The same bulk load works fine without 
creating the above index.
Did I miss something in the creation of the index?  - Erich

Erich Bremer
http://www.ebremer.com



--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134071iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] creating indexes with Virtuoso 7.0.0

[Erich Bremer]

The default schema as per the below URL is:
CREATE DISTINCT NO PRIMARY KEY REF BITMAP INDEX RDF_QUAD_SP
   ON RDF_QUAD (S, P)
   PARTITION (S INT (0hex00));

CREATE BITMAP INDEX RDF_QUAD_POGS
   ON RDF_QUAD (P, O, G, S)
   PARTITION (O VARCHAR (-1, 0hex));

CREATE DISTINCT NO PRIMARY KEY REF BITMAP INDEX RDF_QUAD_GS
   ON RDF_QUAD (G, S)
   PARTITION (S INT (0hex00));

CREATE DISTINCT NO PRIMARY KEY REF INDEX RDF_QUAD_OP
   ON RDF_QUAD (O, P)
   PARTITION (O VARCHAR (-1, 0hex));

Given this, I noticed that the below index PGOS uses DB.DBA.RDF_QUAD (G, 
P, O, S), shouldn't that be DB.DBA.RDF_QUAD (P, G, O, S)?

- Erich

Hi,

 I tried creating the index as per the page:

http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning

CREATE BITMAP INDEX RDF_QUAD_PGOS ON DB.DBA.RDF_QUAD (G, P, O, S) 
PARTITION (O VARCHAR (-1, 0hex));

which successfully creates via ISQL (seemingly), but when I go to 
execute a bulk load across 8 cores, Virtuoso
dies with a segmentation core dump.  The same bulk load works fine 
without creating the above index.
Did I miss something in the creation of the index?  - Erich

Erich Bremer
http://www.ebremer.com



--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134071iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] creating indexes with Virtuoso 7.0.0

[Erich Bremer]

Either way, I get the following error when starting my bulk load:
*** glibc detected *** virtuoso-t: double free or corruption (out): 
0x7f6b710f2000 ***
Segmentation fault

- Erich

Erich Bremer
http://www.ebremer.com

The default schema as per the below URL is:
CREATE DISTINCT NO PRIMARY KEY REF BITMAP INDEX RDF_QUAD_SP
   ON RDF_QUAD (S, P)
   PARTITION (S INT (0hex00));

CREATE BITMAP INDEX RDF_QUAD_POGS
   ON RDF_QUAD (P, O, G, S)
   PARTITION (O VARCHAR (-1, 0hex));

CREATE DISTINCT NO PRIMARY KEY REF BITMAP INDEX RDF_QUAD_GS
   ON RDF_QUAD (G, S)
   PARTITION (S INT (0hex00));

CREATE DISTINCT NO PRIMARY KEY REF INDEX RDF_QUAD_OP
   ON RDF_QUAD (O, P)
   PARTITION (O VARCHAR (-1, 0hex));

Given this, I noticed that the below index PGOS uses DB.DBA.RDF_QUAD (G, 
P, O, S), shouldn't that be DB.DBA.RDF_QUAD (P, G, O, S)?

- Erich

Hi,

 I tried creating the index as per the page:

http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning

CREATE BITMAP INDEX RDF_QUAD_PGOS ON DB.DBA.RDF_QUAD (G, P, O, S) 
PARTITION (O VARCHAR (-1, 0hex));

which successfully creates via ISQL (seemingly), but when I go to 
execute a bulk load across 8 cores, Virtuoso
dies with a segmentation core dump.  The same bulk load works fine 
without creating the above index.
Did I miss something in the creation of the index?  - Erich

Erich Bremer
http://www.ebremer.com



--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134071iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] creating indexes with Virtuoso 7.0.0

[Erich Bremer]

Hi Hugh,

Reason #1: The Virtuoso tuning guide suggested:

If predicate and graph are given but subject is not, then it is 
sometimes useful to add:
CREATE BITMAP INDEX RDF_QUAD_PGOS ON DB.DBA.RDF_QUAD (G, P, O, S) 
PARTITION (O VARCHAR (-1, 0hex));

The instructions did not indicate for this index, that any prior indexes need 
to be dropped, so, I did not drop any.

SQL STATISTICS DB.DBA.RDF_QUAD;
Showing SQLStatistics of table(s) 'DB.DBA.RDF_QUAD'
TABLE_QUALIFIER  TABLE_OWNER  TABLE_NAME   NON_UNIQUE  INDEX_QUALIFIER  
INDEX_NAME   TYPESEQ_IN_INDEX  COLUMN_NAME  COLLATION  
CARDINALITY  PAGES   FILTER_CONDITION
VARCHAR  VARCHAR  VARCHAR  SMALLINTVARCHAR  
VARCHAR  SMALLINTSMALLINTVARCHAR  VARCHAR  INTEGER 
INTEGER VARCHAR
___

DB   DBA  RDF_QUAD NULLNULL 
NULL 0   NULLNULL NULL NULL
NULLNULL
DB   DBA  RDF_QUAD 0   DB   
RDF_QUAD 3   1   PNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 0   DB   
RDF_QUAD 3   2   SNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 0   DB   
RDF_QUAD 3   3   ONULL NULL
NULLNULL
DB   DBA  RDF_QUAD 0   DB   
RDF_QUAD 3   4   GNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_GS  3   1   GNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_GS  3   2   SNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_OP  3   1   ONULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_OP  3   2   PNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_POGS3   1   PNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_POGS3   2   ONULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_POGS3   3   SNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_POGS3   4   GNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_SP  3   1   SNULL NULL
NULLNULL
DB   DBA  RDF_QUAD 1   DB   
RDF_QUAD_SP  3   2   PNULL NULL
NULLNULL

Reason #2: The manual (the same URL actually) indicates that sometimes the 
indexes can become polluted and that Dropping and recreating the index will 
remedy this situation. So, therefore, I am
experimenting/hacking/playing so that I can become stronger with the Force. ;-)

In any event, was there anything I needed to do prior to adding the above 
index?  I had performed the test with a newly created database.  - Erich

Erich Bremer
http://www.ebremer.com



On 10/14/2013 10:53 PM, Hugh Williams wrote:
 Hi Erich,

 Why are you creating these additional indexes and if you did were the 
 defaults dropped first ? What does the the following query return:

   STATISTICS DB.DBA.RDF_QUAD;

 Which should return a list of indexes on the RDF_QUAD table ...

 As indicated in the performance tuning guide the default indexes should 
 suffice for most use cases, thus you should not have to create additional 
 indexes ...

 Best Regards
 Hugh Williams
 Professional Services
 OpenLink Software, Inc.  //  http://www.openlinksw.com/
 Weblog   -- http://www.openlinksw.com/blogs/
 LinkedIn -- http://www.linkedin.com/company/openlink-software/
 Twitter  -- http://twitter.com/OpenLink
 Google+  -- http://plus.google.com/100570109519069333827/
 Facebook -- http://www.facebook.com/OpenLinkSoftware
 Universal Data Access, Integration, and Management Technology Providers

 On 14 Oct 2013

Re: [Virtuoso-users] V7.0.0/Jena provider bug with SELECT/LIMIT Results off by one

[Erich Bremer]

Hi Hugh,

I had not tested it against 2.10.0, only 2.11.0.  I tried running the 
code again to get the bug to show, but now it won't, but, I had 
restarted V7.0.0 since the issue/bug first occurred.  I'll see if I can 
get the error to show again.  - Erich


On 10/6/2013 8:29 PM, Hugh Williams wrote:

Hi Erich,

Are you saying if the same query is run against Jena 2.10.x of Jena 
2.6.x the result set is correctly returned ? We are about to test this 
new Jena 2.11 release to see whats new and if there are issues with 
the current provider (particularly the 2.10.x provider) to determine 
compatibility or if a new provider needs to be created ...


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 7 Oct 2013, at 00:35, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:



Using Jena 2.11.0 and the jena providers off the Virtuoso web site, I've
executed the following query:

VirtGraph set = new VirtGraph (jdbc:virtuoso://localhost:, dba,
dba);
Query sparql = QueryFactory.create(SELECT * WHERE { GRAPH ?graph { ?s
?p ?o } . values ?graph {http://ips.ebremer.com}} limit 1);
VirtuosoQueryExecution vqe = VirtuosoQueryExecutionFactory.create
(sparql, set);
ResultSet results = vqe.execSelect();

results.hasNext() at the end of this code results in false. However,
there are numerous solutions.  If I set limit to 2, I will get one
result.  If I set it to 11, I will get 10 results, etc... The same
query, directly against the sparql endpoint works fine. The solutions
are all off by one.

- Erich

Erich Bremer
http://www.ebremer.com

--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the 
most from
the latest Intel processors and coprocessors. See abstracts and 
register 

http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users




--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] phantom graph V7.0.0.

[Erich Bremer]

Hi Hugh,

Explicitly or implicitly created, I would think that if a graph 
containing triples existed in the system, that:


select distinct ?g where {?graph ?g {?s ?p ?o}}

would list that graph.  Some of the triples make it in and those triples 
are query able such as in:


select ?g ?s ?o where {graph ?g  {?s :knownpredicateinphantomgraph ?o}}

will list the URI of the phantom graph with this query, just not in the 
first SPARQL query above.


Is there a table that keeps a list of named graphs or does 
DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() actually query the quad store to 
determine this list?


- Erich

On 10/06/13 8:24 PM, Hugh Williams wrote:

Hi Erich,

it seems as if the graph was not explicitly created as a result of the 
error in the turtle file, thus it was silently created. The following 
document details the use of create graph to explicitly create a graph:


http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideCreateGraph


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 6 Oct 2013, at 06:09, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:



After calling:

CREATE GRAPH http://www.ebremer.com/ips

The graph now shows up in the list of graphs (and the one triple). - 
Erich


On 10/4/2013 12:40 PM, Erich Bremer wrote:

Hi,

 I'm been loading and reloading graphs in V7.0.0 and on one
particular load, the graph would not load.  It turned out that I had an
error in the turtle file I was loading, but, it seems one triple from
the file loaded.  I can see this triple if I sparql for it, but, the
graph that I was loading it into does not show in the conductor list of
graphs, nor does it show up in the query:

select distinct ?g where {graph ?g {?s ?p o}}

but, it I query for the named graph:

select * where {graph http://www.ebremer.com/ips {?s ?p ?o}}

the one triple will show up.  - Erich

Erich Bremer
http://www.ebremer.com

--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the 
most from
the latest Intel processors and coprocessors. See abstracts and 
register 

http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users



--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the 
most from
the latest Intel processors and coprocessors. See abstracts and 
register 

http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users




--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] V7.0.0/Jena provider bug with SELECT/LIMIT Results off by one

[Erich Bremer]

Hi Hugh,

A similar case:
Using either 2.10.0 or 2.11.0 with the following code:

VirtGraph set = new VirtGraph (jdbc:virtuoso://localhost:, dba, 
dba);
Query sparql = QueryFactory.create(SELECT * WHERE { GRAPH ?graph { ?s 
?p ?o } . values ?graph {http://ips.ebremer.com} . filter not exists 
{graph http://connect.ebremer.com {?s ?j ?q}}});
VirtuosoQueryExecution vqe = VirtuosoQueryExecutionFactory.create 
(sparql, set);

ResultSet results = vqe.execSelect();

results.hasNext() after, evaluates false, but, if I execute the above 
sparql at the endpoint for the same server, it works fine and returns 
results.


- Erich

Erich Bremer
http://www.ebremer.com


On 10/7/2013 2:14 AM, Erich Bremer wrote:

Hi Hugh,

I had not tested it against 2.10.0, only 2.11.0.  I tried running the 
code again to get the bug to show, but now it won't, but, I had 
restarted V7.0.0 since the issue/bug first occurred. I'll see if I can 
get the error to show again.  - Erich


On 10/6/2013 8:29 PM, Hugh Williams wrote:

Hi Erich,

Are you saying if the same query is run against Jena 2.10.x of Jena 
2.6.x the result set is correctly returned ? We are about to test 
this new Jena 2.11 release to see whats new and if there are issues 
with the current provider (particularly the 2.10.x provider) to 
determine compatibility or if a new provider needs to be created ...


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 7 Oct 2013, at 00:35, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:


Using Jena 2.11.0 and the jena providers off the Virtuoso web site, 
I've

executed the following query:

VirtGraph set = new VirtGraph (jdbc:virtuoso://localhost:, dba,
dba);
Query sparql = QueryFactory.create(SELECT * WHERE { GRAPH ?graph { ?s
?p ?o } . values ?graph {http://ips.ebremer.com}} limit 1);
VirtuosoQueryExecution vqe = VirtuosoQueryExecutionFactory.create
(sparql, set);
ResultSet results = vqe.execSelect();

results.hasNext() at the end of this code results in false. However,
there are numerous solutions.  If I set limit to 2, I will get one
result.  If I set it to 11, I will get 10 results, etc... The same
query, directly against the sparql endpoint works fine. The solutions
are all off by one.

- Erich

Erich Bremer
http://www.ebremer.com

--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the 
most from
the latest Intel processors and coprocessors. See abstracts and 
register 

http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users






--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk


___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134071iu=/4140/ostg.clktrk___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] V7.0.0/Jena provider bug with SELECT/LIMIT Results off by one

[Erich Bremer]

Using Jena 2.11.0 and the jena providers off the Virtuoso web site, I've 
executed the following query:

VirtGraph set = new VirtGraph (jdbc:virtuoso://localhost:, dba, 
dba);
Query sparql = QueryFactory.create(SELECT * WHERE { GRAPH ?graph { ?s 
?p ?o } . values ?graph {http://ips.ebremer.com}} limit 1);
VirtuosoQueryExecution vqe = VirtuosoQueryExecutionFactory.create 
(sparql, set);
ResultSet results = vqe.execSelect();

results.hasNext() at the end of this code results in false. However, 
there are numerous solutions.  If I set limit to 2, I will get one 
result.  If I set it to 11, I will get 10 results, etc... The same 
query, directly against the sparql endpoint works fine. The solutions 
are all off by one.

 - Erich

Erich Bremer
http://www.ebremer.com

--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] phantom graph V7.0.0.

[Erich Bremer]

After calling:

CREATE GRAPH http://www.ebremer.com/ips

The graph now shows up in the list of graphs (and the one triple). - Erich

On 10/4/2013 12:40 PM, Erich Bremer wrote:
 Hi,

   I'm been loading and reloading graphs in V7.0.0 and on one
 particular load, the graph would not load.  It turned out that I had an
 error in the turtle file I was loading, but, it seems one triple from
 the file loaded.  I can see this triple if I sparql for it, but, the
 graph that I was loading it into does not show in the conductor list of
 graphs, nor does it show up in the query:

 select distinct ?g where {graph ?g {?s ?p o}}

 but, it I query for the named graph:

 select * where {graph http://www.ebremer.com/ips {?s ?p ?o}}

 the one triple will show up.  - Erich

 Erich Bremer
 http://www.ebremer.com

 --
 October Webinars: Code for Performance
 Free Intel webinars can help you accelerate application performance.
 Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
 the latest Intel processors and coprocessors. See abstracts and register 
 http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk
 ___
 Virtuoso-users mailing list
 Virtuoso-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/virtuoso-users


--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] phantom graph V7.0.0.

[Erich Bremer]

Hi,

 I'm been loading and reloading graphs in V7.0.0 and on one 
particular load, the graph would not load.  It turned out that I had an 
error in the turtle file I was loading, but, it seems one triple from 
the file loaded.  I can see this triple if I sparql for it, but, the 
graph that I was loading it into does not show in the conductor list of 
graphs, nor does it show up in the query:

select distinct ?g where {graph ?g {?s ?p o}}

but, it I query for the named graph:

select * where {graph http://www.ebremer.com/ips {?s ?p ?o}}

the one triple will show up.  - Erich

Erich Bremer
http://www.ebremer.com

--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Virtuoso 42000 Error FRVEC

[Erich Bremer]

Hi Hugh,
I have about 250 million triples over ten graphs.  I found a work around 
already, but I will keep this information handy.  Thank you much!  - Erich

==
Erich Bremer
http://www.ebremer.com


 On Sep 25, 2013, at 10:57 PM, Hugh Williams hwilli...@openlinksw.com 
 wrote:
 
 Hi Erich,
 
 The query runs for me against  local v7 open source build, but then I don't 
 have your data in my installation:
 
 SQL SPARQL prefix sno:   http://www.ebremer.com/sno/ with 
 http://www.maxmind.com delete {?range sno:hasStartip4Address ?ip} insert 
 {?range sno:hasStartip4AddressDotted ?ip} where {?range 
 sno:hasStartip4Address ?ip filter(!isnumeric(?ip))};
 
 Done. -- 1 msec.
 SQL
 
 In Virtuoso 7 there is a MaxVectorSize param in the virtuoso.ini file which 
 defaults to 100, you can try setting it to something higher than 200 
 , restart Virtuoso and see if it resolves the problem ...
 
 Best Regards
 Hugh Williams
 Professional Services
 OpenLink Software, Inc.  //  http://www.openlinksw.com/
 Weblog   -- http://www.openlinksw.com/blogs/
 LinkedIn -- http://www.linkedin.com/company/openlink-software/
 Twitter  -- http://twitter.com/OpenLink
 Google+  -- http://plus.google.com/100570109519069333827/
 Facebook -- http://www.facebook.com/OpenLinkSoftware
 Universal Data Access, Integration, and Management Technology Providers
 
 On 25 Sep 2013, at 16:46, Erich Bremer er...@ebremer.com wrote:
 
 Using Virtuoso 7.0.0, I tried to do a with-delete-insert query and the 
 following error was generated:
 
 Virtuoso 42000 Error FRVEC: array in for vectored over max vector length 
 200  100
 
 SPARQL query:
 define sql:big-data-const 0
 #output-format:text/html
 define sql:signal-void-variables 1 prefix sno:   
 http://www.ebremer.com/sno/
 with http://www.maxmind.com
 delete {?range sno:hasStartip4Address ?ip}
 insert {?range sno:hasStartip4AddressDotted ?ip}
 where {?range sno:hasStartip4Address ?ip filter(!isnumeric(?ip))}
 
- Erich
 
 Erich Bremer
 http://www.ebremer.com
 
 
 --
 October Webinars: Code for Performance
 Free Intel webinars can help you accelerate application performance.
 Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most 
 from 
 the latest Intel processors and coprocessors. See abstracts and register 
 http://pubads.g.doubleclick.net/gampad/clk?id=60133471iu=/4140/ostg.clktrk
 ___
 Virtuoso-users mailing list
 Virtuoso-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/virtuoso-users
 

--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60133471iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Odd behavior in Virtuoso 7.0.0

[Erich Bremer]

My original locked isql session just spit out the rest of the named 
graphs including the geonames graph:
http://localhost:8890/DAV/
http://www.w3.org/2002/07/owl#
http://www.geonames.org

5 Rows. -- 644278 msec.
SQL SQL DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS();

Running DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS(); again froze isql once 
more.  - Erich

On 09/23/13 10:28 AM, Erich Bremer wrote:
 Hi Hugh,

   The dataset is geonames.org's ~120million triple data set.  I
 converted the quasi-RDF/XML dump they have (URI, RDF/XML. URI, RDF/XML,
 URI, RDF/XML ...) and split the triples over 50 turtle files.
   I repeated the same experiement again for the third time (with what
 I thought was the same protocol I had followed), but the bug did not occur.
   I repeated the same experiment again but I remembered that I had
 hit Conductor--Linked Data--Graphs  while it was loading and conductor
 (at least the session I was in) locked.  I ran
 DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() in isql and it locked my isql
 session (apparently) but eventually this came out:
 SQL DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS();
 GRAPH_IRI
 VARCHAR
 ___

 http://www.openlinksw.com/schemas/virtrdf#

 ===
 I ran:
 select count(*) as ?cc where {?s ?p ?o}
 in a sparql session and it came back quick (ie the system is still loading)
 I did a status() in another isql and caught what looked like a bunch of
 errors in the form:
 24498: IER NO OWNER
 24499: IER NO OWNER
 24500: IER 1
 24501: IER NO OWNER
 24502: IER NO OWNER
 24503: IER NO OWNER
 24504: IER 1
 24505: IER 1
 62: ISR NO OWNER
 24506: IER NO OWNER
 24507: IER 1
 24508: IER NO OWNER
 24509: IER NO OWNER
 24510: IER NO OWNER
 24511: IER 1
 24512: IER 1
 40: ISR NO OWNER
 38: ISR NO OWNER
 39: ISR NO OWNER
 24513: IER NO OWNER
 24514: IER NO OWNER
 24515: IER 1
 79: ISR NO OWNER
 24516: IER NO OWNER
 24518: IER NO OWNER
 24519: IER NO OWNER
 24520: IER 1
 74: ISR NO OWNER
 24521: IER NO OWNER
 24522: IER NO OWNER
 24523: IER 1
 40: ISR NO OWNER
 41: ISR NO OWNER
 24524: IER NO OWNER
 24525: IER NO OWNER
 24526: IER 1
 50: ISR NO OWNER
 24527: IER NO OWNER
 24528: IER 1
 41: ISR NO OWNER
 24529: IER 1
 20: ISR NO OWNER
 19: ISR NO OWNER
 24530: IER NO OWNER
 24531: IER NO OWNER
 24532: IER 1
 50: ISR NO OWNER
 51: ISR NO OWNER
 24533: IER 1
 47: ISR NO OWNER

 Client :1:  Account: dba, 384 bytes in, 544 bytes out, 1 stmts.
 PID: 32488, OS: unix, Application: unknown, IP#: 127.0.0.1
 Transaction status: PENDING, 1 threads.
 Locks: 24382: IE, 24343: IS, 24404: IE, 24422: IE, 24483: IE, 24359: IE,
 24347: IS, 24410: IE, 24372: IE, 24520: IE, 24351: IE, 

 Client :10:  Account: dba, 550 bytes in, 942792 bytes out, 1 stmts.
 PID: 32510, OS: unix, Application: unknown, IP#: 127.0.0.1
 Transaction status: PENDING, 1 threads.
 Locks:


 Running Statements:
Time (msec) Text
165 status()
 418830 DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS()


 Hash indexes


 244 Rows. -- 167 msec.


 but most got clipped because my putty didn't show history.  Once the
 load finished, my conductor session had finally flipped to another
 screen (I had clicked on a different menu, but when I went back to the
 graph list it froze again.  I ran:

 select distinct ?g where {graph ?g {?s ?p ?o}}

 and it timed out like trials #1 and #2.  The currently locked isql
 session just spitted out the loader completions and then spit out two
 more lines of the DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() function:
 http://localhost:8890/DAV/
 http://www.w3.org/2002/07/owl#

 It seems, if you hit the graph listing during the 8 threaded load.
 something gums up, but, when you don't, it works fine.  I hope this
 helps.   - Erich



 On 09/23/13 7:26 AM, Hugh Williams wrote:
 Hi Erich,

 What does the  DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() function return if run as 
 this point:

  http://docs.openlinksw.com/virtuoso/fn_sparql_select_known_graphs.html

 What datasets are you loading when this issue occurs as if they can be 
 provided we would like to attempt to recreate in-house ?

 Best Regards
 Hugh Williams
 Professional Services
 OpenLink Software, Inc.  //  http://www.openlinksw.com/
 Weblog   -- http://www.openlinksw.com/blogs/
 LinkedIn -- http://www.linkedin.com/company/openlink-software/
 Twitter  -- http://twitter.com/OpenLink
 Google+  -- http://plus.google.com/100570109519069333827/
 Facebook -- http://www.facebook.com/OpenLinkSoftware
 Universal Data Access, Integration, and Management Technology Providers

 On 23 Sep 2013, at 02:16, Erich Bremer er...@ebremer.com wrote:

 The CPU utilization for the virtuoso-t process dropped

Re: [Virtuoso-users] Odd behavior in Virtuoso 7.0.0

[Erich Bremer]

Hi Hugh,

I shutdown virtuoso and deleted the database and re-ran the upload 
with 8 loaders the same way I did.  Low and behold, the problem 
re-occurred the same way.  Here is your status() below.  I also checked 
top and virtuoso-t is at 100% at the moment.  I'm not going to restart 
the server right since I need to go out for a bit.  I will check to see 
if it corrects itself without the restart.  I will let you know.  - Erich


SQL status();
REPORT
VARCHAR
___

OpenLink Virtuoso  Server
Version 07.00.3203-pthreads for Linux as of Sep 17 2013
Started on: 2013-09-22 18:19 GMT+0

Database Status:
  File size 9227468800, 1126400 pages, 304678 free.
  545 buffers, 821582 used, 819838 dirty 11 wired down, repl age 0 
0 w. io 1 w/crsr.

  Disk Usage: 60 reads avg 0 msec, 0% r 0% w last  583 s, 2158 writes,
0 read ahead, batch = 0.  Autocompact 290 in 213 out, 26% saved.
Gate:  0 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
Log = /mnt/link/disk1/virtuoso-7.0.0/var/lib/virtuoso/db/virtuoso.trx, 
21437 bytes

1796 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x-0x00-0x00
Last backup date: unknown
Clients: 10 connects, max 9 concurrent
RPC: 40 calls, -2 pending, 7 max until now, 0 queued, 21 burst reads 
(52%), 0 second 143M large, 2168M max

Checkpoint Remap 38 pages, 0 mapped back. 3 s atomic time.
DB master 1126400 total 304678 free 38 remap 7 mapped back
   temp  256 total 251 free

Lock Status: 0 deadlocks of which 0 2r1w, 3169 waits,
   Currently 2 threads running 0 threads waiting 0 threads in vdb.
Pending:
  820: IER 68.195.227.26
  1: IER 68.195.227.26
  101: ISR 68.195.227.26
  1: ISR NO OWNER
  2: ISR NO OWNER
  20395: ISR 68.195.227.26
  115: ISR NO OWNER

Client :2:  Account: dba, 357 bytes in, 325 bytes out, 1 stmts.
PID: 31218, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 1 threads.
Locks:


Running Statements:
 Time (msec) Text
 169 status()


Hash indexes


44 Rows. -- 170 msec.
SQL

- Erich

On 09/22/13 8:32 AM, Hugh Williams wrote:

Hi Erich,

Is this condition reproducible as a restart of the server seems to 
have resolved it  ? As it would be interesting to see what the 
status(); command reports as to the status of the Virtuoso server 
when in this state ...


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 22 Sep 2013, at 05:32, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:



Hi all,

I'm working with Virtuoso 7.0.0 open source edition and did a load of
geonames data using isql which was 123,020,822 triples into a named
graph http://www.geonames.org;.

I did a second load of 13,349,346 triples into a different named graph.
Both loads of turtle RDF completed quickly.  When I went to check to see
if Conductor could see the named graphs, Conductor hung when I clicked
on Linked Data--Graphs.  I then tried to do:

a) select distinct ?g where {graph ?g {?s ?p ?o}}

from the SPARQL endpoint and it timed out.

however, the following query against http://www.geonames.org would work
in a second:

b) select count(*) as ?cc where {?s ?p ?o}

I initiated a shutdown using isql which took a few moments and then I
restarted virtuoso.  Now, Conductor quickly shows all named graphs
including the new ones, and the above SPARQL query (a) runs nearly
instantly.

- Erich

--
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, 
SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack 
includes

Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users




--
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=64545871iu=/4140

Re: [Virtuoso-users] Odd behavior in Virtuoso 7.0.0

[Erich Bremer]

Hi Kingsley,

My statement about the triple count SPARQL query was only to state 
that my virtuoso wasn't frozen for other queries. Historically, for all 
of my virtuoso 6.x installs:


select distinct ?g where {graph ?g {?s ?p ?o}}
and
select count(*) as ?cc where {?s ?p ?o}

have always worked quick, so, I never bothered to optimize either as you 
specified :-)

And since:
select distinct ?g where {graph ?g {?s ?p ?o}}
has always worked quicked for me in virtuoso 6.X, it just seemed 
natural/reasonable to think something weird was going on when it didn't 
work quick in virutoso 7 as it has and does in virtuoso 6 - Erich


On 09/22/13 9:50 AM, Kingsley Idehen wrote:

On 9/22/13 8:32 AM, Hugh Williams wrote:

a) select distinct ?g where {graph ?g {?s ?p ?o}}

from the SPARQL endpoint and it timed out.

however, the following query against http://www.geonames.org would work
in a second:

b) select count(*) as ?cc where {?s ?p ?o}


The issue is that listing all the named graph IRIs in a quad store is 
much different from getting a count of all the triples in a named graph.


Count of named graph IRIs would be:

SELECT COUNT(*) WHERE {GRAPH ?g {?s ?p ?o}} .

You can reduce the cost of this quest using:

SELECT COUNT(*) WHERE {GRAPH ?g {?s a ?o}} .

Examples using the LOD cloud cache instance:


1. 
http://lod.openlinksw.com/sparql?default-graph-uri=query=SELECT+COUNT%28*%29+WHERE+%7BGRAPH+%3Fg+%7B%3Fs+%3Fp+%3Fo%7D%7D+format=text%2FhtmlCXML_redir_for_subjs=121CXML_redir_for_hrefs=timeout=3debug=on 
-- count of all named graphs associated with any triple


2. 
http://lod.openlinksw.com/sparql?default-graph-uri=query=SELECT+COUNT%28*%29+WHERE+%7BGRAPH+%3Fg+%7B%3Fs+a+%3Fo%7D%7D+format=text%2FhtmlCXML_redir_for_subjs=121CXML_redir_for_hrefs=timeout=3debug=on 
-- count of all name graphs associate with isA relation based triples.




--
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871iu=/4140/ostg.clktrk


___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


--
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=64545871iu=/4140/ostg.clktrk___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Odd behavior in Virtuoso 7.0.0

[Erich Bremer]

The CPU utilization for the virtuoso-t process dropped back down once I 
returned after a while.  As a quick experiment, I ran the SPARQL query:

select distinct ?g where {graph ?g {?s ?p ?o}}
which drove virtuoso-t to 100% utilization which then timed out 
returning the CPU back to baseline.  Trying to list the graphs in 
Conductor--Linked Data--Graphs which seems to be the same thing 
(listing all of the named graphs) but hangs conductor much longer.  
Perhaps, there is no timeout on this mechanism on this conductor 
mechanism.  Like before, shutting down virtuoso and then restarting, 
both the conductor listing of graphs and the above SPARQL query execute 
in approximately 1 second for the 120,000,000 triples and successfully 
list the 4 named graphs in the system which is the response time that I 
typically get with Virtuoso, but not until after the restart.  - Erich


Erich Bremer
http://www.ebremer.com
http://haylyn.io

On 9/22/2013 8:32 AM, Hugh Williams wrote:

Hi Erich,

Is this condition reproducible as a restart of the server seems to 
have resolved it  ? As it would be interesting to see what the 
status(); command reports as to the status of the Virtuoso server 
when in this state ...


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 22 Sep 2013, at 05:32, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:



Hi all,

I'm working with Virtuoso 7.0.0 open source edition and did a load of
geonames data using isql which was 123,020,822 triples into a named
graph http://www.geonames.org;.

I did a second load of 13,349,346 triples into a different named graph.
Both loads of turtle RDF completed quickly.  When I went to check to see
if Conductor could see the named graphs, Conductor hung when I clicked
on Linked Data--Graphs.  I then tried to do:

a) select distinct ?g where {graph ?g {?s ?p ?o}}

from the SPARQL endpoint and it timed out.

however, the following query against http://www.geonames.org would work
in a second:

b) select count(*) as ?cc where {?s ?p ?o}

I initiated a shutdown using isql which took a few moments and then I
restarted virtuoso.  Now, Conductor quickly shows all named graphs
including the new ones, and the above SPARQL query (a) runs nearly
instantly.

- Erich

--
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, 
SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack 
includes

Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871iu=/4140/ostg.clktrk
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users




--
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151iu=/4140/ostg.clktrk___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] strafter and strbefore

[Erich Bremer]

Are STRAFTER and STRBEFORE supported in Virtuoso 6.1.6 or is it time to 
go to Virtuoso 7?  - Erich

Erich Bremer
http://www.ebremer.com

--
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with 2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Bug in Graph Store HTTP protocol turtle uploads

[Erich Bremer]

Hi Hugh,

virtuoso-t -?
Virtuoso Open Source Edition (multi threaded)
Version 6.1.6.3127-pthreads as of Oct 26 2012
Compiled for Linux (x86_64-unknown-linux-gnu)
Copyright (C) 1998-2012 OpenLink Software

The command I use is:
 curl -v -T single.ttl -H Content-type:text/turtle 
http://localhost:8890/sparql-graph-crud?graph-uri=http://www.ebremer.com/log 
-X PUT


*** Results **
* About to connect() to localhost port 8890 (#0)
*   Trying 127.0.0.1...
* connected
* Connected to localhost (127.0.0.1) port 8890 (#0)
 PUT /sparql-graph-crud?graph-uri=http://www.ebremer.com/log HTTP/1.1
 User-Agent: curl/7.24.0 (x86_64-redhat-linux-gnu) libcurl/7.24.0 
NSS/3.13.5.0 zlib/1.2.5 libidn/1.18 libssh2/1.2.2

 Host: localhost:8890
 Accept: */*
 Content-type:text/turtle
 Content-Length: 72
 Expect: 100-continue

 HTTP/1.1 100 Continue
* We are completely uploaded and fine
 HTTP/1.1 500 Internal Server Error
 Server: Virtuoso/06.01.3127 (Linux) x86_64-unknown-linux-gnu
 Connection: Keep-Alive
 Content-Type: text/html; charset=UTF-8
 Date: Tue, 09 Apr 2013 12:09:21 GMT
 Accept-Ranges: bytes
 Content-Length: 298

!DOCTYPE HTML PUBLIC -//IETF//DTD HTML//EN
html
  head
titleError 22023/title
  /head
  body
h3Error 22023/h3pre
The PUT request for graph lt;http://www.ebremer.com/loggt; is 
rejected: the submitted resource is of unsupported type text/plain

  /pre/body
/html
* Connection #0 to host localhost left intact
* Closing connection #0

 END OF LINE ***







On 4/8/2013 10:06 PM, Hugh Williams wrote:

Hi Eric,

Please provide the specific command and complete output being 
returned, as if I perform the upload of the single.ttl file you 
provide using the /sparql-graph-crud  upload method as you provide in 
one of your examples back in January, then it uploads fine for me 
against the latest open source develop/6 or commercial builds:


$ virtuoso-t -?
Virtuoso Open Source Edition (Row Store) (multi threaded)
Version 6.1.7-rc1.3127-pthreads as of Apr  8 2013
Compiled for Linux (x86_64-unknown-linux-gnu)
Copyright (C) 1998-2013 OpenLink Software

$ more single.ttl
http:/www.ebremer.com/foaf.rdf http://www.ebremer.com/foaf.rdf a 
http://xmlns.com/foaf/0.1/Person .
$ curl -v -T single.ttl  -H Content-type:text/turtle 
http://localhost:8890/sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com%2F

* About to connect() to localhost port 8890 (#0)
*   Trying ::1...
* connected
* Connected to localhost (::1) port 8890 (#0)
 PUT /sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com 
http://2Fexample.com%2F HTTP/1.1
 User-Agent: curl/7.24.0 (x86_64-apple-darwin12.0) libcurl/7.24.0 
OpenSSL/0.9.8r zlib/1.2.5

 Host: localhost:8890
 Accept: */*
 Content-type:text/turtle
 Content-Length: 72
 Expect: 100-continue

 HTTP/1.1 100 Continue
* We are completely uploaded and fine
 HTTP/1.1 200 OK
 Server: Virtuoso/07.00.3202 (Linux) i686-generic-linux-glibc212-64  VDB
 Connection: Keep-Alive
 Content-Type: text/html; charset=UTF-8
 Date: Tue, 09 Apr 2013 01:46:57 GMT
 Accept-Ranges: bytes
 Content-Length: 0

* Connection #0 to host localhost left intact
* Closing connection #0
$
$ isql 
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL sparql select * from http://example.com/ where {?s ?p ?o};
s p   
o
VARCHAR VARCHAR   
VARCHAR

___

http:/www.ebremer.com/foaf.rdf http://www.ebremer.com/foaf.rdf 
http://www.w3.org/1999/02/22-rdf-syntax-ns#type 
http://xmlns.com/foaf/0.1/Person


1 Rows. -- 2 msec.
SQL

Thus please confirm the version of the Virtuoso build you are using 
and the load method being used ...

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 8 Apr 2013, at 15:39, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:



Hi Hugh,

Yes, the first file is single.ttl containing the one line:

http:/www.ebremer.com/foaf.rdf a http://xmlns.com/foaf/0.1/Person .

The second file is s2.ttl containing two lines:

@prefix foaf: http://xmlns.com/foaf/0.1/Person .
http:/www.ebremer.com/foaf.rdf a http://xmlns.com/foaf/0.1/Person .

The first file fails with the error message:
The PUT request for graph lt;http://www.ebremer.com/loggt; is 
rejected: the submitted resource is of unsupported type text/plain


The second file

Re: [Virtuoso-users] Bug in Graph Store HTTP protocol turtle uploads

[Erich Bremer]

Ah ok, so it was fixed.  I was using the latest version from Source 
Forge - 6.1.6.  Is there going to be a new release version?  If 7 ready 
for prime time?  - Erich


On 4/9/2013 9:48 AM, Hugh Williams wrote:

Hi Erich,

Your build is from the  stable/6 github branch,  you need to build 
with the latest develop/6 branch which were my build was made from ...


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 9 Apr 2013, at 13:10, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:



Hi Hugh,

virtuoso-t -?
Virtuoso Open Source Edition (multi threaded)
Version 6.1.6.3127-pthreads as of Oct 26 2012
Compiled for Linux (x86_64-unknown-linux-gnu)
Copyright (C) 1998-2012 OpenLink Software

The command I use is:
 curl -v -T single.ttl -H Content-type:text/turtle 
http://localhost:8890/sparql-graph-crud?graph-uri=http://www.ebremer.com/log 
-X PUT


*** Results **
* About to connect() to localhost port 8890 (#0)
*   Trying 127.0.0.1...
* connected
* Connected to localhost (127.0.0.1) port 8890 (#0)
 PUT /sparql-graph-crud?graph-uri=http://www.ebremer.com/log HTTP/1.1
 User-Agent: curl/7.24.0 (x86_64-redhat-linux-gnu) libcurl/7.24.0 
NSS/3.13.5.0 zlib/1.2.5 libidn/1.18 libssh2/1.2.2

 Host: localhost:8890
 Accept: */*
 Content-type:text/turtle
 Content-Length: 72
 Expect: 100-continue

 HTTP/1.1 100 Continue
* We are completely uploaded and fine
 HTTP/1.1 500 Internal Server Error
 Server: Virtuoso/06.01.3127 (Linux) x86_64-unknown-linux-gnu
 Connection: Keep-Alive
 Content-Type: text/html; charset=UTF-8
 Date: Tue, 09 Apr 2013 12:09:21 GMT
 Accept-Ranges: bytes
 Content-Length: 298

!DOCTYPE HTML PUBLIC -//IETF//DTD HTML//EN
html
  head
titleError 22023/title
  /head
  body
h3Error 22023/h3pre
The PUT request for graph lt;http://www.ebremer.com/loggt; is 
rejected: the submitted resource is of unsupported type text/plain

  /pre/body
/html
* Connection #0 to host localhost left intact
* Closing connection #0

 END OF LINE ***







On 4/8/2013 10:06 PM, Hugh Williams wrote:

Hi Eric,

Please provide the specific command and complete output being 
returned, as if I perform the upload of the single.ttl file you 
provide using the /sparql-graph-crud  upload method as you provide 
in one of your examples back in January, then it uploads fine for me 
against the latest open source develop/6 or commercial builds:


$ virtuoso-t -?
Virtuoso Open Source Edition (Row Store) (multi threaded)
Version 6.1.7-rc1.3127-pthreads as of Apr  8 2013
Compiled for Linux (x86_64-unknown-linux-gnu)
Copyright (C) 1998-2013 OpenLink Software

$ more single.ttl
http:/www.ebremer.com/foaf.rdf http://www.ebremer.com/foaf.rdf a 
http://xmlns.com/foaf/0.1/Person .
$ curl -v -T single.ttl  -H Content-type:text/turtle 
http://localhost:8890/sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com%2F

* About to connect() to localhost port 8890 (#0)
*   Trying ::1...
* connected
* Connected to localhost (::1) port 8890 (#0)
 PUT /sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com 
http://2fexample.com/%2F HTTP/1.1
 User-Agent: curl/7.24.0 (x86_64-apple-darwin12.0) libcurl/7.24.0 
OpenSSL/0.9.8r zlib/1.2.5

 Host: localhost:8890
 Accept: */*
 Content-type:text/turtle
 Content-Length: 72
 Expect: 100-continue

 HTTP/1.1 100 Continue
* We are completely uploaded and fine
 HTTP/1.1 200 OK
 Server: Virtuoso/07.00.3202 (Linux) i686-generic-linux-glibc212-64 
 VDB

 Connection: Keep-Alive
 Content-Type: text/html; charset=UTF-8
 Date: Tue, 09 Apr 2013 01:46:57 GMT
 Accept-Ranges: bytes
 Content-Length: 0

* Connection #0 to host localhost left intact
* Closing connection #0
$
$ isql 
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL sparql select * from http://example.com/ where {?s ?p ?o};
s   p o
VARCHAR   VARCHAR 
VARCHAR

___

http:/www.ebremer.com/foaf.rdf http://www.ebremer.com/foaf.rdf 
http://www.w3.org/1999/02/22-rdf-syntax-ns#type 
http://xmlns.com/foaf/0.1/Person


1 Rows. -- 2 msec.
SQL

Thus please confirm the version of the Virtuoso build you are using 
and the load method being used ...

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http

Re: [Virtuoso-users] Bug in Graph Store HTTP protocol turtle uploads

[Erich Bremer]

Hi Ivan,

 I have it set as text/turtle.  Hugh said it works fine in the pre 
6.1.7 (where it doesn't work in 6.1.6), the work-around is easy for now 
until I can upgrade to 6.1.7.  I had never noticed before since 
everything I had done to date had at least one prefix defined at the top 
of the turtle document.  In what I am doing now, I am sending Apache 
generated RDF http logs without prefixes to save a little bit of 
bandwidth by pre-defining the prefixes on the server.  Each http 
connection generates 23 triples.  It is just as easy to add the prefixes 
in the RDF log definition.   - Erich

On 4/9/2013 2:53 PM, Ivan Mikhailov wrote:
 Hello Erich,

 Was the MIME type of the file properly specified in request by the
 client? If it's specified as some default like text/plain or not
 specified at all then the server tries to guess the MIME by looking at
 keywords and/or XML structure.
 I guess that @prefix worked as a hint to understand that it's an Turtle
 whereas words like http:/www.ebremer.com/foaf.rdf were too ambiguous.

 Best Regards,

 Ivan Mikhailov
 OpenLink Software
 http://virtuoso.openlinksw.com

 On Mon, 2013-04-08 at 10:39 -0400, Erich Bremer wrote:
 Hi Hugh,

  Yes, the first file is single.ttl containing the one line:

 http:/www.ebremer.com/foaf.rdf a
 http://xmlns.com/foaf/0.1/Person .

 The second file is s2.ttl containing two lines:

 @prefix foaf: http://xmlns.com/foaf/0.1/Person .
 http:/www.ebremer.com/foaf.rdf a
 http://xmlns.com/foaf/0.1/Person .

 The first file fails with the error message:
 The PUT request for graph lt;http://www.ebremer.com/loggt; is
 rejected: the submitted resource is of unsupported type text/plain

 The second file succeeds and I am not even using the foaf: prefix in
 the one triple which is the same triple from the first file.  I used
 curl to do the upload using the PUT operation and sparql-graph-crud.

  - Erich

 Erich Bremer
 http://www.ebremer.com

 On 4/7/2013 7:06 PM, Hugh Williams wrote:

 Hi Erich,


 Are you able to provide a sample sparql-graph-crud upload query
 showing this problem ?

 Best Regards
 Hugh Williams
 Professional Services
 OpenLink Software, Inc.  //
   http://www.openlinksw.com/
 Weblog   -- http://www.openlinksw.com/blogs/
 LinkedIn -- http://www.linkedin.com/company/openlink-software/
 Twitter  -- http://twitter.com/OpenLink
 Google+  -- http://plus.google.com/100570109519069333827/
 Facebook -- http://www.facebook.com/OpenLinkSoftware
 Universal Data Access, Integration, and Management Technology
 Providers

 On 7 Apr 2013, at 16:52, Erich Bremer er...@ebremer.com wrote:

 When trying to upload data to sparql-graph-crud, the upload will
 fail if there are no PREFIX statements at the top of the file even
 though no prefixes are used anywhere in the turtle document.  The
 upload appears to succeed if any @prefix statement is added to
 the top of the file (even though none are needed).  I hadn't
 noticed the issue before in working with sparql-graph-crud since
 nearly everything I do has @prefix statements, but in a new
 project I am doing, I don't use them.  In looking over the turtle
 specification:
 http://www.w3.org/TeamSubmission/turtle/
 in section 2.1 RDF Terms, it states, URIs may also be abbreviated
 by using Turtle's @prefix directive.  may being optional.

   - Erich

 Erich Bremer
 http://www.ebremer.com
 ___ Virtuoso-users mailing list 
 Virtuoso-users@lists.sourceforge.net 
 https://lists.sourceforge.net/lists/listinfo/virtuoso-users



--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis  visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Bug in Graph Store HTTP protocol turtle uploads

[Erich Bremer]

Hi Hugh,

Yes, the first file is single.ttl containing the one line:

http:/www.ebremer.com/foaf.rdf a http://xmlns.com/foaf/0.1/Person .

The second file is s2.ttl containing two lines:

@prefix foaf: http://xmlns.com/foaf/0.1/Person .
http:/www.ebremer.com/foaf.rdf a http://xmlns.com/foaf/0.1/Person .

The first file fails with the error message:
The PUT request for graph lt;http://www.ebremer.com/loggt; is 
rejected: the submitted resource is of unsupported type text/plain


The second file succeeds and I am not even using the foaf: prefix in the 
one triple which is the same triple from the first file.  I used curl to 
do the upload using the PUT operation and sparql-graph-crud.


- Erich

Erich Bremer
http://www.ebremer.com

On 4/7/2013 7:06 PM, Hugh Williams wrote:

Hi Erich,

Are you able to provide a sample sparql-graph-crud upload query 
showing this problem ?


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 7 Apr 2013, at 16:52, Erich Bremer er...@ebremer.com 
mailto:er...@ebremer.com wrote:


When trying to upload data to sparql-graph-crud, the upload will fail 
if there are no PREFIX statements at the top of the file even though 
no prefixes are used anywhere in the turtle document.  The upload 
appears to succeed if any @prefix statement is added to the top of 
the file (even though none are needed).  I hadn't noticed the issue 
before in working with sparql-graph-crud since nearly everything I do 
has @prefix statements, but in a new project I am doing, I don't use 
them.  In looking over the turtle specification:

http://www.w3.org/TeamSubmission/turtle/
in section 2.1 RDF Terms, it states, URIs may also be abbreviated by 
using Turtle's |@prefix| directive.  may being optional.


 - Erich

Erich Bremer
http://www.ebremer.com

--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users




--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Bug in Graph Store HTTP protocol turtle uploads

[Erich Bremer]

When trying to upload data to sparql-graph-crud, the upload will fail if 
there are no PREFIX statements at the top of the file even though no 
prefixes are used anywhere in the turtle document.  The upload appears 
to succeed if any @prefix statement is added to the top of the file 
(even though none are needed).  I hadn't noticed the issue before in 
working with sparql-graph-crud since nearly everything I do has @prefix 
statements, but in a new project I am doing, I don't use them.  In 
looking over the turtle specification:

http://www.w3.org/TeamSubmission/turtle/
in section 2.1 RDF Terms, it states, URIs may also be abbreviated by 
using Turtle's |@prefix| directive.  may being optional.


 - Erich

Erich Bremer
http://www.ebremer.com

--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] HTTP Recording and SPARQL 1.1 Graph Store HTTP Protocol

[Erich Bremer]

Nevermind, it does.  :-)  - Erich

On 02/22/13 4:26 PM, Erich Bremer wrote:
 Will the HTTP Recording feature of Virtuoso also record http
 interactions of the SPARQL 1.1 Graph Store HTTP Protocol?  It would be
 handy to help debug things.  - Erich

 --
 Everyone hates slow websites. So do we.
 Make your web apps faster with AppDynamics
 Download AppDynamics Lite for free today:
 http://p.sf.net/sfu/appdyn_d2d_feb
 ___
 Virtuoso-users mailing list
 Virtuoso-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/virtuoso-users


--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

[Erich Bremer]

Hi Hugh,

Yes, the query works for me now, thanks!  I'm going to run some more 
tests before I weave it into my project.


6.1.6 is what I downloaded and is confirmed:

 virtuoso-t -?

Virtuoso Open Source Edition (multi threaded)
Version 6.1.6.3127-pthreads as of Oct 26 2012
Compiled for Linux (x86_64-unknown-linux-gnu)
Copyright (C) 1998-2012 OpenLink Software

- Erich

On 01/22/13 9:26 PM, Hugh Williams wrote:

Hi Erich,

Good to hear, thus I presume the query now runs successful for you ?

Also, what is the version of Virtuoso in use which can be obtained by 
running the command:


virtuoso-t -?

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers



--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

[Erich Bremer]

I'd appreciate any example of this working.  Is there a URL with sample 
curl commands?  Thanks!  - Erich


On 01/22/13 12:57 PM, Hugh Williams wrote:

Hi Alexey,

Can you provide the sample query and turtle file you are using when 
trying to perform such an insert/load please ?


Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  // http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 22 Jan 2013, at 08:05, Alexey Zakhlestin indey...@gmail.com 
mailto:indey...@gmail.com wrote:




On 22.01.2013, at 6:14, Hugh Williams hwilli...@openlinksw.com 
mailto:hwilli...@openlinksw.com wrote:



Hi Erich,

Yes, Virtuoso has supported the SPARQL 1.1 Graph Store HTTP Protocol 
since Nov 2011 as indicated at:


http://www.openlinksw.com/dataspace/dav/wiki/Main/VOSNews#2011-11-01:%20Announcing%20Virtuoso%20Open-Source%20Edition%20v6.1.4


I think support is incomplete

SPARQL1.1 GraphStore Protocol has this clause:
http://www.w3.org/TR/2012/CR-sparql11-http-rdf-update-20121108/#http-post

I tried to use this for sending Turtle file to virtuoso and didn't 
succeed


Server responses with:
Virtuoso 22023 Error The request does not contain text of SPARQL query



On 22 Jan 2013, at 00:29, Erich Bremer er...@ebremer.com wrote:


Is the SPARQL 1.1 Graph Store HTTP Protocol supported yet in Virtuoso?

http://www.w3.org/TR/sparql11-http-rdf-update/



--
Alexey Zakhlestin
https://github.com/indeyets






--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users




--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d


___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

[Erich Bremer]

Thanks, this was very helpful! Although, I am getting an error of:
SR575: No permission to execute DB.DBA.TTLP_EV_NEW_GRAPH as callback of 
rdf_load_turtle()


on your curl example using the dba uid/pw

- Erich

On 01/22/13 7:11 PM, Hugh Williams wrote:

Hi Alexey,

OK, good to hear you got it working.  We are going to publish some 
usage examples on how to perform such queries ...


I quickly got your sample data loaded using curl as follows:

$ more test.ttl
@prefix rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns# .
@prefix owl: http://www.w3.org/2002/07/owl# .
@prefix skos: http://www.w3.org/2004/02/skos/core# .
@prefix dcam: http://purl.org/dc/dcam/ .
@prefix dcterms: http://purl.org/dc/terms/ .
@prefix rdfs: http://www.w3.org/2000/01/rdf-schema# .

http://purl.org/dc/dcam/
dcterms:modified 
2012-06-14^^http://www.w3.org/2001/XMLSchema#date ;

dcterms:publisher http://purl.org/dc/aboutdcmi#DCMI ;
dcterms:title Metadata terms related to the DCMI Abstract Model@en .

dcam:VocabularyEncodingScheme
dcterms:hasVersion 
http://dublincore.org/usage/terms/history/#VocabularyEncodingScheme-001 
;

dcterms:issued 2008-01-14^^http://www.w3.org/2001/XMLSchema#date ;
a rdfs:Class ;
rdfs:comment An enumerated set of resources.@en ;
rdfs:isDefinedBy http://purl.org/dc/dcam/ ;
rdfs:label Vocabulary Encoding Scheme@en ;
rdfs:seeAlso 
http://dublincore.org/documents/2007/06/04/abstract-model/ .


dcam:memberOf
dcterms:hasVersion 
http://dublincore.org/usage/terms/history/#memberOf-002 ;

dcterms:issued 2008-01-14^^http://www.w3.org/2001/XMLSchema#date ;
dcterms:modified 
2010-10-11^^http://www.w3.org/2001/XMLSchema#date ;

a rdf:Property ;
rdfs:comment A relationship between a resource and a vocabulary 
encoding scheme which indicates that the resource is a member of a 
set.@en ;

rdfs:isDefinedBy http://purl.org/dc/dcam/ ;
rdfs:label Member Of@en ;
rdfs:range dcam:VocabularyEncodingScheme ;
rdfs:seeAlso 
http://dublincore.org/documents/2007/06/04/abstract-model/ .


$ curl -v -T test.ttl  -H Content-type:text/turtle 
http://localhost:8890/sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com%2F

* About to connect() to localhost port 8890 (#0)
*   Trying ::1...
* Connection refused
*   Trying 127.0.0.1...
* connected
* Connected to localhost (127.0.0.1) port 8890 (#0)
 PUT /sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com 
http://2Fexample.com%2F HTTP/1.1
 User-Agent: curl/7.24.0 (x86_64-apple-darwin12.0) libcurl/7.24.0 
OpenSSL/0.9.8r zlib/1.2.5

 Host: localhost:8890
 Accept: */*
 Content-type:text/turtle
 Content-Length: 1636
 Expect: 100-continue

 HTTP/1.1 100 Continue
* We are completely uploaded and fine
 HTTP/1.1 201 Created
 Server: Virtuoso/06.01.3127 (Darwin) x86_64-apple-darwin12.2.0
 Connection: Keep-Alive
 Content-Type: text/html; charset=UTF-8
 Date: Wed, 23 Jan 2013 00:05:07 GMT
 Accept-Ranges: bytes
 Content-Length: 0

* Connection #0 to host localhost left intact
* Closing connection #0

$ /usr/local/vos/bin/isql 
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL sparql select * from http://example.com/ where {?s ?p ?o};
s p   
o
VARCHAR VARCHAR   
LONG VARCHAR

___

http://purl.org/dc/dcam/ http://purl.org/dc/terms/modified 
2012-06-14
http://purl.org/dc/dcam/ http://purl.org/dc/terms/publisher 
http://purl.org/dc/aboutdcmi#DCMI
http://purl.org/dc/dcam/ http://purl.org/dc/terms/title   
 Metadata terms related to the 
DCMI Abstract Model
http://purl.org/dc/dcam/VocabularyEncodingScheme 
http://www.w3.org/1999/02/22-rdf-syntax-ns#type 
http://www.w3.org/2000/01/rdf-schema#Class
http://purl.org/dc/dcam/VocabularyEncodingScheme 
http://www.w3.org/2000/01/rdf-schema#label 
   Vocabulary Encoding Scheme
http://purl.org/dc/dcam/VocabularyEncodingScheme 
http://www.w3.org/2000/01/rdf-schema#isDefinedBy http://purl.org/dc/dcam/
http://purl.org/dc/dcam/VocabularyEncodingScheme 
http://www.w3.org/2000/01/rdf-schema#comment   
   An enumerated set of resources.
http://purl.org/dc/dcam/VocabularyEncodingScheme 
http://www.w3.org/2000/01/rdf-schema#seeAlso 
http://dublincore.org/documents/2007/06/04/abstract-model/
http://purl.org/dc/dcam/VocabularyEncodingScheme 
http://purl.org/dc/terms/hasVersion 
http://dublincore.org/usage/terms/history/#VocabularyEncodingScheme-001
http://purl.org/dc/dcam/VocabularyEncodingScheme 
http://purl.org/dc/terms/issued   
2008-01-14

[Virtuoso-users] SPARQL 1.1 Graph Store HTTP Protocol

[Erich Bremer]

Is the SPARQL 1.1 Graph Store HTTP Protocol supported yet in Virtuoso?

http://www.w3.org/TR/sparql11-http-rdf-update/

 Thanks,
 Erich

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Blank Nodes

[Erich Bremer]

  Hi,

I've used jena arq to execute some SPARQL against a Model that 
created a whole bunch of blank nodes.  When I serialize out the model, 
things also look good and I can see many blank nodes in the form 
_:AX2dX540193e9X3aX136602f3fdbX3aXX2dX7e91 which is what I expected.  
Now, playing around with SPARQL to query the in-memory Model I can get 
results back into a result set, but when I display the labels of the 
blank nodes, they have the form -540193e9:136602f3fdb:-7f42.  Is 
expected?  If so, if I build a query like:

select * where {-540193e9:136602f3fdb:-7f42 :somepredicate :someproperty}

will that work? or is there a different way to extract the blank node 
label so that the form looks like the RDF serialization form 
_:AX2dX540193e9X3aX136602f3fdbX3aXX2dX7e91?  Thanks for your time, Erich

[Virtuoso-users] Named Graph Weird Behavior

[Erich Bremer]

Hello all,

The following SPARQL query using Virtuoso 6.15's sparql end-point returns an 
empty result set:


select distinct ?g
where { graph ?g {?s ?p ?o} }

However, the following returns the expected results (even if the limit is 
set to 100 - thinking it was a perceived time-out issue)


select distinct ?g
where { graph ?g {?s ?p ?o} }
limit 1000

Does anyone have any advice on this?  Thanks, Erich

Erich Bremer
http://www.ebremer.com