Here's the Java code snippet not working:
```java
String nameStr = "test_sensor1";
String BASE = "http://base.org#";;
String uuid = "xxxxx";
Node name = NodeFactory.createLiteralByValue(nameStr, XSDstring);
Node point = NodeFactory.createURI(BASE + uuid);
Node hasName = NodeFactory.createURI(BASE + "name");
graph.add(new Triple(point, hasName, name));
String qStr =
"PREFIX base: <http://base.org#>\n" +
"SELECT ?s WHERE {\n" +
"?s base:name \"test_sensor1\" . \n" +
"}";
Query sparql = QueryFactory.create(qStr);
VirtuosoQueryExecution vqd = VirtuosoQueryExecutionFactory.create(sparql,
graph);
ResultSet results = vqd.execSelect();
while (results.hasNext()) {
QuerySolution result = results.nextSolution();
System.out.println(result.get("s").toString());
}
System.out.println("Done");
}
```
The value ``results`` is empty and this code does not print anything. I can
make a regenerator. Let me know if that helps.
With regards,
Jason Koh
cseweb.ucsd.edu/~jbkoh
On Tue, Jan 23, 2018 at 12:16 PM, Jason Koh <jb...@eng.ucsd.edu> wrote:
> Hi Hugh,
>
> I inserted the tripled through *Virtuoso Jena* and I can see triples like
> ``ex:xxxx base:name test_sensor0``
> when I query just with ?s ?p ?o. However, I don't get any result with ``?s
> base:name "test_sensor0"``.
>
> As you showed, it works with command line insertions. Let me verify the
> source of the problem once again and come back.
>
> Thank you!
>
>
> With regards,
> Jason Koh
> cseweb.ucsd.edu/~jbkoh
>
> On Tue, Jan 23, 2018 at 3:17 AM, Hugh Williams <hwilli...@openlinksw.com>
> wrote:
>
>> Hi Jason,
>>
>> What exactly is not working for you ? As the following works for me:
>>
>> SQL> SPARQL PREFIX base: <base> INSERT DATA { GRAPH <koh> { <1> base:name
>> "sensor1" . } };
>>
>> Done. -- 1 msec.
>> SQL> SPARQL SELECT * FROM <koh> WHERE {?s ?p ?o};
>> s
>> p
>> o
>> LONG VARCHAR
>> LONG VARCHAR
>> LONG VARCHAR
>> ____________________________________________________________
>> ___________________
>>
>> 1
>> basename
>> sensor1
>>
>> 1 Rows. -- 2 msec.
>> SQL> SPARQL PREFIX base: <base> SELECT ?s {?s base:name "sensor1"};
>> s
>> LONG VARCHAR
>> ____________________________________________________________
>> ___________________
>>
>> 1
>>
>> 1 Rows. -- 1 msec.
>> SQL> SPARQL PREFIX base: <base> SELECT ?g ?s {GRAPH ?g {?s base:name
>> "sensor1"}};
>> g
>> s
>> LONG VARCHAR
>> LONG VARCHAR
>> ____________________________________________________________
>> ___________________
>>
>> koh
>> 1
>>
>> 1 Rows. -- 1 msec.
>> SQL>
>>
>>
>> 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 Jan 2018, at 09:58, Jason Koh <jb...@eng.ucsd.edu> wrote:
>> >
>> > Hi Kingsley,
>> >
>> > Thanks for the prompt response. I just tried it and it works well. I
>> haven't compared the performance yet but wish the string match is faster.
>> >
>> > However, I am having trouble querying with the String Literal with
>> SPARQL. The following query does not work for Virtuoso.
>> > ```sparql
>> > select ?s {
>> > ?s base:name "sensor1". # also tried "sensor1"^^xsd:string but the
>> same result.
>> > }
>> > ```
>> > This query returns empty result.
>> >
>> > If I query with no pattern (?s ?p ?o), I can see the following triple:
>> > :xxxx base:name "sensor1",
>> >
>> > Can't sort out the problem. Do you have any ideas on this?
>> >
>> > Thank you!
>> >
>> >
>> >
>> >
>> >
>> > With regards,
>> > Jason Koh
>> > cseweb.ucsd.edu/~jbkoh
>> >
>> > On Mon, Jan 22, 2018 at 2:52 PM, Kingsley Idehen <
>> kide...@openlinksw.com> wrote:
>> > On 1/22/18 5:11 PM, Jason Koh wrote:
>> >> Hi there,
>> >>
>> >> I am trying to use Virtuoso for metadata of city-scale sensor
>> database. (metroinsight.io).
>> >>
>> >> I wonder if there is a way to optimize certain SPARQL query pattern. I
>> often query this:
>> >> ```sparql
>> >> select ?s where {
>> >> ?s base:name ex:mySensor1 .
>> >> }
>> >> ```
>> >>
>> >> I could optimize it by caching those with Redis or else, but I wonder
>> if I can force indexing "name" properties in Virtuoso.
>> >>
>> >> Thank you!
>> >>
>> >>
>> >> With regards,
>> >> Jason Koh
>> >> cseweb.ucsd.edu/~jbkoh
>> >
>> > Have you looked at text indexing in Virtuoso with regards to SPARQL?
>> > [1] http://docs.openlinksw.com/virtuoso/rdfsparqlrulefulltext/ .
>> > --
>> > Regards,
>> >
>> > Kingsley Idehen
>> > Founder & CEO
>> > OpenLink Software (Home Page:
>> > http://www.openlinksw.com
>> > )
>> >
>> > Weblogs (Blogs):
>> > Legacy Blog:
>> > http://www.openlinksw.com/blog/~kidehen/
>> >
>> > Blogspot Blog:
>> > http://kidehen.blogspot.com
>> >
>> > Medium Blog:
>> > https://medium.com/@kidehen
>> >
>> >
>> > Profile Pages:
>> > Pinterest:
>> > https://www.pinterest.com/kidehen/
>> >
>> > Quora:
>> > https://www.quora.com/profile/Kingsley-Uyi-Idehen
>> >
>> > Twitter:
>> > https://twitter.com/kidehen
>> >
>> > Google+:
>> > https://plus.google.com/+KingsleyIdehen/about
>> >
>> > LinkedIn:
>> > http://www.linkedin.com/in/kidehen
>> >
>> >
>> > Web Identities (WebID):
>> > Personal:
>> > http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i
>> >
>> > :
>> > http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/k
>> ingsley.ttl#this
>> >
>> >
>> >
>> >
>> > ------------------------------------------------------------
>> ------------------
>> > 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
>>
>>
>
------------------------------------------------------------------------------
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
