Hi Hugh,

Indeed, I was attempting to upload the .nt files using WebDAV. Perhaps this
is a restriction of WebDav? I'm pretty sure it's not the client (curl), as
I've already looked into that. 

Thanks for your suggestion regarding the TTLP functions. I tried out the one
suggested with that link, but I'm having trouble with the simple matter of
specifying the path of the local file. All the .nt files for the DBpedia
dataset are currently contained in a 'DBpedia' dir under the Virtuoso root
installation dir.

The following is my console log (from isql):

SQL> DB.DBA.TTLP_MT_LOCAL_FILE ('DBpedia/articlecategories_en.nt', '',
'http://l
ocalhost/');

*** Error 42000: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]SR598:
TURTLE
parser has failed to open file 'DBpedia\articlecategories_en.nt' for reading
at line 37 of Top-Level:
DB.DBA.TTLP_MT_LOCAL_FILE ('DBpedia/articlecategories_en.nt', '',
'http://localh
ost/')

Am I doing something obviously wrong here? Clearly, I'm trying to specify a
relative path, but an absolute path gives me no better results:

SQL> DB.DBA.TTLP_MT_LOCAL_FILE
('C:\virtuoso-opensource\DBpedia\articlecategorie
s_en.n3', '', 'http://localhost/');

*** Error 42000: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]SR598:
TURTLE
parser has failed to open file 'C:♂
irtuoso-opensourceDBpediarticlecategories_en.
n3' for reading
at line 38 of Top-Level:
DB.DBA.TTLP_MT_LOCAL_FILE
('C:\virtuoso-opensource\DBpedia\articlecategories_en.
n3', '', 'http://localhost/')

Any suggestions here would be appreciated. I'm still very new to the
Virtuoso server, so I may be overlooking something major here.

Regards,
Alex

-----Original Message-----
From: Hugh Williams [mailto:hwilli...@openlinksw.com] 
Sent: 05 September 2009 02:06
To: Alex
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] File Size Limit

Hi Alex,

Are you uploaded these 4GB files via WebDAV ? You might want to try  
the Virtuoso TTLP family of functions for uploading such large  
datasets as detailed at:

        http://docs.openlinksw.com/virtuoso/fn_ttlp_mt_local_file.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 5 Sep 2009, at 01:12, Alex wrote:

> Hello,
>
> I've recently been experimenting with using Virtuoso OSE as an RDF
> store/SPARQL server, and seem to have things mainly set up now. I have
> uploaded various N3 files to rdf_sink via WebDAV (the DBpedia store,  
> to
> be specific), and all files have succeeded except for the two largest
> ones. These files are the only two over 4GB, so it would seem to be a
> file size issue. Indeed, the sizes of the files when uploaded are
> perfectly consistent with a 32-bit integer overflow.
>
> My question is: is the limitation with which we have to live regarding
> the Virtuoso DB/server, or is there a way to get around this? Would  
> the
> recommended solution simple be to split up the files into smaller (<
> 4GB) chunks?
>
> Thanks,
> Alex
>
>
----------------------------------------------------------------------------
--
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008  
> 30-Day
> trial. Simplify your report design, integration and deployment - and  
> focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users



Reply via email to