Re: [Virtuoso-users] MySQL -> Faceter

[Hugh Williams]

Cristian,

On 21 May 2009, at 03:30, Cristian Vasquez wrote:
On Wed, May 20, 2009 at 8:01 PM, Hugh Williams  
<hwilli...@openlinksw.com> wrote:
Cristian,
On 20 May 2009, at 21:00, Cristian Vasquez wrote:

On Wed, May 20, 2009 at 2:59 PM, Aldo Bucchi  
<aldo.buc...@univrz.com>
wrote:

Hello,

What's the fastest route to publish a MySQL database via V6  
faceter?

This is what we understand:
1) Connect the database via Virt-MySQL adapter
2) Configure, Generate and Install RDF Views

"We have some issues" related to each point ;)

Issue 1) How do we get/buy a Virt-MySQL adapter for V6? ( we  
have the
Tech Preview version )

Issue 2) RDF Views on large databases have given us trouble  
before. I
understand these are related to the size of the generated script. (
Cristián, can you please reproduce the error and attach it? )


The problem arises when I generate RDF Views, selecting a large  
number
of tables  using
 'Database' -> 'RDF Schema Objects'-> 'Generate Mappings' in  
conductor.

The RDF View Definition script is always generated, but an error is
thrown upon the excecution of the script.

The error is:

SQ074: Line 1820: SP031: SPARQL: Internal error: The length of
generated SQL text has exceeded 10000 lines of code

Is there a way to configure the SQL text limit?

[Hugh] What is the Virtuoso version and build date being used as  
their have
been a number of updates to the RDF Schema Object UI over the past  
week,
thus it would be best to get you running with this latest cut ?  
Are you
running on an EC2 AMI or local instance ?

Regards
Hugh

[Cristian]
I'm experiencing the same behaviour on a Virtuoso 5 EC2 AMI (Build
Date May 20 2009) and a Virtuoso 6 instance.

[Hugh] That is the latest  Virtuoso 5 build you are running with the  
latest updates. Can you please enable additional server tracing as  
detailed at:

        http://docs.openlinksw.com/virtuoso/fn_trace_on.html#(NULL)

Such that we can see what SQL is being generated when creating the  
Views and hence causing the error. This trace will probably be quite  
large thus email to me directly as the mailing list does not allow  
much more that 40K chars as I recall

Regards
Hugh


Thanks,

Cristian




[...]

_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users