Forgot to clarify the configuration:
Ubuntu 16.04 (64bit)
Virtuoso 7.2.4.2
Virtuoso Jean: virt_jena3
Virtuodo JDBC: virtjdbc4
Java: openjdk version "1.8.0_151"
Thank you.
With regards,
Jason Koh
cseweb.ucsd.edu/~jbkoh
On Tue, Jan 23, 2018 at 12:46 PM, Jason Koh <jb...@eng.ucsd.edu> wrote:
> 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
