Hi Hugh I will try the trace on now. Meanwhile, following is one of the queries that returns with the JDBC error. I have a copy of DBpedia running on my virtuoso server and I am executing this query against DBPedia graph: ===
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX dbp2: <http://mydbpedia.org/ontology/> PREFIX dbpprop: <http://dbpedia.org/property/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> CONSTRUCT { ?newLoc a dbp2:Country. ?newLoc dbp2:capital ?capital. ?newLoc rdfs:label ?label . ?newLoc rdfs:comment ?comment . ?newLoc dbp2:abstract ?abstract } WHERE { ?newLoc a dbpedia-owl:Country. OPTIONAL { ?newLoc dbpedia-owl:capital ?capital . ?capital a dbpedia-owl:City } OPTIONAL { ?newLoc rdfs:label ?label . } OPTIONAL { ?newLoc rdfs:comment ?comment . } OPTIONAL { ?newLoc dbpprop:abstract ?abstract . } } == thanks Dhaval On Fri, Sep 18, 2009 at 5:48 PM, Hugh Williams <hwilli...@openlinksw.com>wrote: > Hi Dhaval, > You indicate the error occurs when running complex queries can you provide > an example of such queries in comparison with those that work. If you could > provide a sample program we could compile in house to recreate the issue > that would be even better. It might also be useful to set trace_on() to > enable more detailed trace on the server (virtuoso.log) so we can see what > queries and an errors that might be occurring server side when the problem > occurs Details on setting trace_on are available at: > > http://docs.openlinksw.com/virtuoso/fn_trace_on.html > > 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 18 Sep 2009, at 16:34, Dhaval Thakker wrote: > > Hi Hugh, > I have tried with the latest jdbc driver from the link you had sent. Still > the same error: > > com.hp.hpl.jena.shared.JenaException: Convert results are > FAILED.:virtuoso.jdbc3.VirtuosoException: Bad column number : 2 not in 1<n<1 > at > virtuoso.jena.driver.VirtuosoQueryExecution.execConstruct(Unknown Source) > at > virtuoso.jena.driver.VirtuosoQueryExecution.execConstruct(Unknown Source) > > > thanks > Dhaval > > On Fri, Sep 18, 2009 at 2:31 PM, Hugh Williams > <hwilli...@openlinksw.com>wrote: > >> Hi Dhaval, >> >> What is the version number of the Virtuoso JDBC Driver being used ( java >> virtuoso.jdbc3.Driver) ? Can you please re-try with the latest cut available >> from: >> >> ftp://download.openlinksw.com/support/vos/virtjdbc3.jar >> >> 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 18 Sep 2009, at 10:27, Dhaval Thakker wrote: >> >> Hi, >>> >>> I have a program to run the construct queries from API ( snippet below). >>> For complex queries, while executed it complains with the following: >>> >>> Convert results are FAILED.:virtuoso.jdbc3.VirtuosoException: Bad column >>> number : 2 not in 1<n<1 >>> >>> It is occuring at line no 4 of the following.. >>> >>> 1. VirtGraph set = new VirtGraph (url, "dba", "dba"); >>> 2. VirtuosoQueryExecution vqe = VirtuosoQueryExecutionFactory.create >>> (sparql, set); >>> 3. vqe = VirtuosoQueryExecutionFactory.create (sparql, set); >>> 4. Model model = vqe.execConstruct(); >>> >>> I am assuming that the result of the construct query execution generates >>> certain type of data that is creating problem...anybody had similar >>> problem/error? >>> >>> thanks >>> >>> Dhaval >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Come build with us! The BlackBerry® Developer Conference in SF, CA >>> is the only developer event you need to attend this year. Jumpstart your >>> developing skills, take BlackBerry mobile applications to market and stay >>> ahead of the curve. Join us from November 9-12, 2009. Register >>> now! >>> >>> http://p.sf.net/sfu/devconf_______________________________________________ >>> Virtuoso-users mailing list >>> Virtuoso-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >>> >> >> > > > -- > Regards > > Dhaval Thakker > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry® Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9-12, 2009. Register now! > http://p.sf.net/sfu/devconf_______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > -- Regards Dhaval Thakker
