Re: [Virtuoso-users] jdbc error

Tue, 22 Sep 2009 08:53:33 +0000 

Hi Dhaval,
Have you been able to enable tracing as requested previously using the trace_on() function as detailed at: 

        http://docs.openlinksw.com/virtuoso/fn_trace_on.html


You could also enable call stack tracing which may provide more  
information as detailed at:


        http://docs.openlinksw.com/virtuoso/handlingplcondit.html#stacktracesql


If  you could provide a compilable sample program that demonstrates  
the problem then we could compile and run it here againt the DBpedia  
instance we host or an DBpedia Virtuoso EC2 AMI to try an recreate.  
What DBpedia dataset are you using 3.3 or 3.2 ?


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 21 Sep 2009, at 11:58, Dhaval Thakker wrote:


Hi
More information on the settings we have here:

The virtuoso.ini file has the following:

NumberOfBuffers      = 100000
MaxDirtyBuffers      = 40000
MaxCheckpointRemap   = 3000000
MaxQueryExecutionTime      = 600000000000000
MaxQueryCostEstimationTime = 400000000000000


and the snippet of the java program that runs construct query (using  
latest JDBC Driver) is as follows:


//


public void executeQuery(String query, FileOutputStream outputfile,  
String format )

        {

            String url = "jdbc:virtuoso://localhost:1111";

            VirtGraph set = new VirtGraph ("http:// 
mydbpedia.org",url, "dba", "dba");

            Query  sparql = QueryFactory.create(query);

            VirtuosoQueryExecution vqe =  
VirtuosoQueryExecutionFactory.create (sparql, set);

             Model model = vqe.execConstruct();

            //outputfile is where the resultant triples are stored,  
format = //N-TRIPLE, RDF/XML etc. from Jena

            model.write(outputfile,format);


//


The same query (see my earlier email) works from the endpoint while  
through the program it complains :



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 Mon, Sep 21, 2009 at 11:08 AM, Dhaval Thakker <dhavalkumar.thak...@googlemail.com 
> wrote:

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&reg; 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&#45;12, 2009. Register  
now&#33;

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&reg; 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&#45;12, 2009. Register  
now&#33;

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



--
Regards

Dhaval Thakker
------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; 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&#45;12, 2009. Register  
now&#33;

http://p.sf.net/sfu/devconf_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users



























					Reply via email to