Attributes | Values |
---|
type
| |
Date Created
| |
Date Modified
| |
label
| - VirtTipsAndTricksGuideShortenLongURIs
|
maker
| |
Title
| - VirtTipsAndTricksGuideShortenLongURIs
|
isDescribedUsing
| |
has creator
| |
content
| - %META:TOPICPARENT{name="VirtTipsAndTricksGuide"}%
---+ What is the ShortenLongURIs Virtuoso configuration parameter
---++What?
The <code>ShortenLongURIs</code> parameter is a Virtuoso configuration setting to shorten extremely long URIs in datasets when loading with the RDF Bulk Loader.
---++Why?
Some RDF datasets have long URIs that exceed the Virtuoso internal maximum size of 1900 bytes and thus need to be shortened to avoid errors like:
<verbatim>
SR133: Can not set NULL to not nullable column 'DB.DBA.RDF_QUAD.S' (or .O, or .P)
</verbatim>
which has been seen loading some of the DBpedia 3.7 datasets, for example.
---++How?
The Virtuoso <code>ShortenLongURIs</code> parameter needs to be set in the [[[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ini_SPARQL][SPARQL]]] section of the Virtuoso configuration file (virtuoso.ini by default) and restart the Virtuoso Server.
<verbatim>
[SPARQL]
.
.
.
ShortenLongURIs = 1
.
.
.
</verbatim>
<b>Note:</b> The <code>ShortenLongURIs</code> parameter is only in the Virtuoso 06.03.3131+ commercial builds, at the time of writing it is not included in the open source 6.1.4 archives but will be in the next 6.1.5 release. A patch to enable this feature is however available from the [[http://sourceforge.net/tracker/?func=detail&aid=3496331&group_id=161622&atid=820576][Virtuso patches page on source forge]], which can be applied to a 6.1.4 archive from source forge and the Virtuoso server binary rebuilt.
---++Related
* [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
* [[http://docs.openlinksw.com/virtuoso/rdfinsertmethods.html][RDF Insert Methods in Virtuoso]]
|
id
| - f44f48462b87687bd2499aea9e762086
|
link
| |
has container
| |
http://rdfs.org/si...ices#has_services
| |
atom:title
| - VirtTipsAndTricksGuideShortenLongURIs
|
links to
| |
atom:source
| |
atom:author
| |
atom:published
| |
atom:updated
| |
topic
| |
is made
of | |
is container of
of | |
is link
of | |
is http://rdfs.org/si...vices#services_of
of | |
is creator of
of | |
is atom:entry
of | |
is atom:contains
of | |