hi Hugh,

it seems to work now! i was trying to execute a very simple
SELECT DISTINCT ?p WHERE {?s ?p ?o}

i have since tried other things and it seems to be doing the right thing
now. thanks for all this.

in the end i had to repackage sesame with all the dependant virtuoso jars
into a war file ... and redeployed. i also restarted virtuoso - i dont
think this was necesary. then created another repo in sesame but this time
i used dba user.

also i found in my logs lots of these errors:
SQ033: SELECT access denied for column GI_SUPER of table
DB.DBA.SYS_ROLE_GRANTS, user ID 107
(ie when i was not using dba. my user has all permissions, ie
select/update/sponge. has DAV permissions as well).


last question: how do i determine the directType of a subject in a triple?
sorry i keep mentioning sesame but anyway.. sesame generated a "x
directType y" triple; how can i achieve similar with vituoso? i dont see
it in the workbench and querying it doesnt find anything.

at the moment it seems i am getting back the super class only which is
valid but sometimes i want the direct type.

thanks.





> Hi
>
> What is the query you are attempting to run that is resulting in this
> "unsupport query type" error ?
>
> Have you been able to confirm basic connectivity of the Sesame HTTP
> Repository to Virtuoso and its ability to run a simple query and explore
> the Virtuoso server as detailed in the documentation at [1] ?
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software
> Web: http://www.openlinksw.com
> Support: http://support.openlinksw.com
> Forums: http://boards.openlinksw.com/support
> Twitter: http://twitter.com/OpenLink
>
> [1]
> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSesame2HttpRepository
>
> On 5 Jun 2010, at 07:20, bluestar wrote:
>
>> hi Hugh,
>>
>> thanks for this. i got somewhere at least.
>>
>> it seems sesame does not know about virtouso queries.
>>
>> i get this exception trying execute a query via sesame workbench.
>>
>> any suggestions?
>>
>> javax.servlet.ServletException:
>> org.openrdf.repository.http.HTTPQueryEvaluationException: Unsupported
>> query type: virtuoso.sesame2.driver.VirtuosoQuery
>>      
>> org.openrdf.workbench.base.TransformationServlet.service(TransformationServlet.java:80)
>>      org.openrdf.workbench.base.BaseServlet.service(BaseServlet.java:40)
>>      
>> org.openrdf.workbench.proxy.ProxyRepositoryServlet.service(ProxyRepositoryServlet.java:93)
>>      
>> org.openrdf.workbench.proxy.WorkbenchServlet.service(WorkbenchServlet.java:131)
>>      
>> org.openrdf.workbench.proxy.WorkbenchServlet.service(WorkbenchServlet.java:90)
>>      
>> org.openrdf.workbench.proxy.WorkbenchGateway.service(WorkbenchGateway.java:97)
>>      org.openrdf.workbench.base.BaseServlet.service(BaseServlet.java:40)
>>      
>> org.openrdf.workbench.proxy.CookieCacheControlFilter.doFilter(CookieCacheControlFilter.java:52)
>>
>> root cause
>>
>> org.openrdf.repository.http.HTTPQueryEvaluationException: Unsupported
>> query type: virtuoso.sesame2.driver.VirtuosoQuery
>>      
>> org.openrdf.repository.http.HTTPTupleQuery.evaluate(HTTPTupleQuery.java:48)
>>      
>> org.openrdf.workbench.commands.QueryServlet.evaluateTupleQuery(QueryServlet.java:208)
>>      
>> org.openrdf.workbench.commands.QueryServlet.service(QueryServlet.java:146)
>>      
>> org.openrdf.workbench.commands.QueryServlet.service(QueryServlet.java:99)
>>      
>> org.openrdf.workbench.commands.QueryServlet.service(QueryServlet.java:72)
>>      
>> org.openrdf.workbench.base.TransformationServlet.doPost(TransformationServlet.java:87)
>>      
>> org.openrdf.workbench.base.TransformationServlet.service(TransformationServlet.java:70)
>>      org.openrdf.workbench.base.BaseServlet.service(BaseServlet.java:40)
>>      
>> org.openrdf.workbench.proxy.ProxyRepositoryServlet.service(ProxyRepositoryServlet.java:93)
>>      
>> org.openrdf.workbench.proxy.WorkbenchServlet.service(WorkbenchServlet.java:131)
>>      
>> org.openrdf.workbench.proxy.WorkbenchServlet.service(WorkbenchServlet.java:90)
>>      
>> org.openrdf.workbench.proxy.WorkbenchGateway.service(WorkbenchGateway.java:97)
>>      org.openrdf.workbench.base.BaseServlet.service(BaseServlet.java:40)
>>      
>> org.openrdf.workbench.proxy.CookieCacheControlFilter.doFilter(CookieCacheControlFilter.java:52)
>>
>> root cause
>>
>> org.openrdf.repository.RepositoryException: Unsupported query type:
>> virtuoso.sesame2.driver.VirtuosoQuery
>>      
>> org.openrdf.http.client.HTTPClient.getTupleQueryResult(HTTPClient.java:992)
>>      org.openrdf.http.client.HTTPClient.sendTupleQuery(HTTPClient.java:414)
>>      org.openrdf.http.client.HTTPClient.sendTupleQuery(HTTPClient.java:397)
>>      
>> org.openrdf.repository.http.HTTPTupleQuery.evaluate(HTTPTupleQuery.java:41)
>>      
>> org.openrdf.workbench.commands.QueryServlet.evaluateTupleQuery(QueryServlet.java:208)
>>      
>> org.openrdf.workbench.commands.QueryServlet.service(QueryServlet.java:146)
>>      
>> org.openrdf.workbench.commands.QueryServlet.service(QueryServlet.java:99)
>>      
>> org.openrdf.workbench.commands.QueryServlet.service(QueryServlet.java:72)
>>      
>> org.openrdf.workbench.base.TransformationServlet.doPost(TransformationServlet.java:87)
>>      
>> org.openrdf.workbench.base.TransformationServlet.service(TransformationServlet.java:70)
>>      org.openrdf.workbench.base.BaseServlet.service(BaseServlet.java:40)
>>      
>> org.openrdf.workbench.proxy.ProxyRepositoryServlet.service(ProxyRepositoryServlet.java:93)
>>      
>> org.openrdf.workbench.proxy.WorkbenchServlet.service(WorkbenchServlet.java:131)
>>      
>> org.openrdf.workbench.proxy.WorkbenchServlet.service(WorkbenchServlet.java:90)
>>      
>> org.openrdf.workbench.proxy.WorkbenchGateway.service(WorkbenchGateway.java:97)
>>      org.openrdf.workbench.base.BaseServlet.service(BaseServlet.java:40)
>>      
>> org.openrdf.workbench.proxy.CookieCacheControlFilter.doFilter(CookieCacheControlFilter.java:52)
>>
>> note The full stack trace of the root cause is available in the Apache
>> Tomcat/6.0.24 logs.
>>
>>
>>
>>> Hi
>>>
>>> As indicated in the examples in the Virtuoso inferencing documentation
>>> at
>>> [1] you would need to load your OWL files into Virtuoso, which being in
>>> RDF/XML can be done with the Virtuoso RDF_LOAD_RDFXML() function as
>>> detailed at [2]. Once the data is loaded into Virtuoso you can then
>>> used
>>> the rdfs_rule_set() function to create the rule sets in Virtuoso, at
>>> which
>>> point when creating the Virtuoso Sesame HTTP Repository you can then
>>> set
>>> the "Inference RuleSet name" parameter to the name of the rule set to
>>> be
>>> used ie "upper" in your example below.  Note also when using the SPARQL
>>> query interface of the OpenRDF Workbench, you also need to check the
>>> "Include inferred statements" check box of the rule set to be applied
>>> against the query being run.
>>>
>>> I hope this answers your question, as that is how I got this to work in
>>> the OpenRDF Workbench using the first example in section 16.8.8.1 of
>>> the
>>> the documentation at [1] ...
>>>
>>> Best Regards
>>> Hugh Williams
>>> Professional Services
>>> OpenLink Software
>>> Web: http://www.openlinksw.com
>>> Support: http://support.openlinksw.com
>>> Forums: http://boards.openlinksw.com/support
>>> Twitter: http://twitter.com/OpenLink
>>>
>>> [1]
>>> http://docs.openlinksw.com/virtuoso/rdfsparqlrule.html#rdfsparqlruleexamples
>>> [2] http://docs.openlinksw.com/virtuoso/fn_rdf_load_rdfxml.html
>>>
>>> On 4 Jun 2010, at 04:13, bluestar wrote:
>>>
>>>> Hi Hugh,
>>>>
>>>> thanks for this. it confirms what i was thinking. and yes i am using
>>>> the
>>>> sesame provider as outlined in the link you gave me.
>>>>
>>>> however my next question is; how do i do it using this rdfs_rule_set
>>>> function; i am not really sure about this.
>>>>
>>>> for example my owl files are very similar to
>>>> http://proton.semanticweb.org/2005/04/protonu,
>>>> http://proton.semanticweb.org/2005/04/protont,
>>>> http://proton.semanticweb.org/2005/04/protons
>>>>
>>>> how would i do this using these owl files?
>>>>
>>>> like this:
>>>>
>>>> rdfs_rule_set ("upper",
>>>> "http://proton.semanticweb.org/2005/04/protonu";)?
>>>>
>>>> if so this seems to have no effect at all.
>>>>
>>>> Please let me know.
>>>>
>>>> cheers.
>>>>
>>>>
>>>>> Hi
>>>>>
>>>>> If using the Virtuoso Sesame HTTP repository as detailed at [1], then
>>>>> you
>>>>> can create your inference rules in Virtuoso using the rdfs_rule_set
>>>>> function as detailed at [2], then you can use the "Inference RuleSet
>>>>> name"
>>>>> parameter of the created Virtuoso Sesame HTTP repository to specify
>>>>> the
>>>>> inference rule set name to be used.created with the rdfs_rule_set
>>>>> function.
>>>>>
>>>>> Best Regards
>>>>> Hugh Williams
>>>>> Professional Services
>>>>> OpenLink Software
>>>>> Web: http://www.openlinksw.com
>>>>> Support: http://support.openlinksw.com
>>>>> Forums: http://boards.openlinksw.com/support
>>>>> Twitter: http://twitter.com/OpenLink
>>>>>
>>>>> [1]
>>>>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSesame2HttpRepository
>>>>> [2]
>>>>> http://docs.openlinksw.com/virtuoso/rdfsparqlrule.html#rdfsparqlrulemake
>>>>>
>>>>> On 3 Jun 2010, at 15:32, bluestar wrote:
>>>>>
>>>>>> hi,
>>>>>>
>>>>>> i am trying to use the  Virtuoso sesame provider. how do i achieve
>>>>>> inferencing through this?
>>>>>>
>>>>>> I have been using sesame in-mem with direct type hierarchy, but now
>>>>>> moving
>>>>>> to Virtuoso. i want the same behaviour in virtuoso.
>>>>>>
>>>>>> i have 3 different owl files with the hierachy of all my classes;
>>>>>> plus
>>>>>> thousands of triples based on this.
>>>>>>
>>>>>> i can see there is a "Inference RuleSet name" field in the repo
>>>>>> creation
>>>>>> screen of Virtuoso sesame provider; what do i put in there?
>>>>>> will this enable inferencing?
>>>>>>
>>>>>> any suggestions will be greatly appreciated.
>>>>>>
>>>>>> thanks
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> ThinkGeek and WIRED's GeekDad team up for the Ultimate
>>>>>> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
>>>>>> lucky parental unit.  See the prize list and enter to win:
>>>>>> http://p.sf.net/sfu/thinkgeek-promo
>>>>>> _______________________________________________
>>>>>> Virtuoso-users mailing list
>>>>>> Virtuoso-users@lists.sourceforge.net
>>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> ThinkGeek and WIRED's GeekDad team up for the Ultimate
>>>> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
>>>> lucky parental unit.  See the prize list and enter to win:
>>>> http://p.sf.net/sfu/thinkgeek-promo
>>>> _______________________________________________
>>>> Virtuoso-users mailing list
>>>> Virtuoso-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>
>>>
>>
>>
>
>



Reply via email to