Hi Aldo,
Their are no real differences under the "hood" particularly between
iSQL and JDBC with both should be firing exactly the same query
against Virtuoso. The only difference I can think of with the SPARQL
endpoint is that queries get executed as the special "SPARQL" user.
Having said that with test queries of the same construct as yours I
have ran locally I get the same number of rows consistently returned
across the SPARQL endpoint, iSQL and JDBC
What is the JDBC application you are using to run your SPARQL queries
as I simply used a Interactive SQL equivalent program we have in-
house called JDBCDemo which simply fires the query at Virtuoso and
displays the results ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 26 Apr 2009, at 15:23, Aldo Bucchi wrote:
Hi,
I have noticed that SPARQLing via the web interface ( iSQL or any
other ) will return more results than doing the same via JDBC.
Same user, same query.
Before getting into any detail. Is there any difference under the
hood?
Maybe access policies are being bypassed in one scenario and not in
another?
For example, the following query:
SELECT DISTINCT ?p WHERE {
<http://www.univrz.com/dataspace/person/aldo.bucchi#this> ?p ?o }
LIMIT 20
returns 5 rows via jdbc and 13 rows via iSQL, /sparql, etc.
I tried "dba" and normal users.
The difference is consistent.
Am I missing something?
Thanks!
A
--
Aldo Bucchi
U N I V R Z
Office: +56 2 795 4532
Mobile:+56 9 7623 8653
skype:aldo.bucchi
http://www.univrz.com/
http://aldobucchi.com/
PRIVILEGED AND CONFIDENTIAL INFORMATION
This message is only for the use of the individual or entity to
which it is
addressed and may contain information that is privileged and
confidential. If
you are not the intended recipient, please do not distribute or
copy this
communication, by e-mail or otherwise. Instead, please notify us
immediately by
return e-mail.
INFORMACIÓN PRIVILEGIADA Y CONFIDENCIAL
Este mensaje está destinado sólo a la persona u organización al
cual está
dirigido y podría contener información privilegiada y confidencial.
Si usted no
es el destinatario, por favor no distribuya ni copie esta
comunicación, por
email o por otra vía. Por el contrario, por favor notifíquenos
inmediatamente
vía e-mail.
----------------------------------------------------------------------
--------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally
facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users