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® 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
>
--
Regards
Dhaval Thakker
