Hi Hugh,
I have installed Virtuoso 7 and trying the query from iSQL web interface
does not show errors.
But then, selecting the triple I got:
urn:x-temp:/doc/patent/EP-1010008-B1http://purl.org/dc/terms/description
"0"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral>
Doing some more tests via JDBC, it looks like this happens with any
XMLLiteral.
And yes, I am trying to setup a Virtuoso Open Source instance for the
Fusepool project, particularly I am developing the Clerezza module to use
Virtuoso as backend [1].
In Fusepool, users will load a huge amount of files containing many large
XML literals via Clerezza, and I am struggling now finding the right way of
pushing these via JDBC. Temporarily, I am using the db.dba.ttlp function as
shortcut/plan B when a triple contains a literal (serializing it as ttl
string). But this cannot be a solution since it can be only used for adding
triples and not for removing them (and in any case doesn't look very
elegant...).
Any feedback/help about this is really really appreciated, since I cannot
deliver this until these problems are solved.
Thank you,
Enrico
[1] https://github.com/apache/clerezza/tree/master/clerezza-virtuoso
On 13 February 2014 17:15, Hugh Williams <hwilli...@openlinksw.com> wrote:
> Hi Enrico,
>
> I just tried running your insert query by cutting and pasting the text int
> to the isql UI of the conductor and it load successfully for me. Running
> from the isql command tool directly failed as it is multi-line and the
> terminal shell interferes and quits isql before all the text is pasted to
> enable the query to be executed. Even trying to use the "load <sql-file>;"
> command which I was expecting to work failed from the isql command line
> tool:
>
> SQL> set blobs on;
> SQL> load debugSR478.txt;
>
> /Applications/Virtuoso 7.1 2.app/Contents/virtuoso/bin/isql: *** The
> statement has grown too long on lines 1 - 570.
> Already 233695 bytes read without encountering a semicolon or ampersand
> in the end of line! Goodbye!
> Hughs-MacBook-Pro-478:Downloads hwilliams$
>
> So will discuss with development as that should work, but inserting via
> the conductor isql UI's does work, so you should be able to pass this query
> to Virtuoso as a string in an application ...
>
> BTW, why was your graph call "FusepoolTest" , are you involved in the
> Fusepool EU project ?
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 11 Feb 2014, at 17:17, Enrico Daga <enricod...@gmail.com> wrote:
>
> Hi Hugh,
> just posted with the query in an attached file, thus waiting for
> moderation approval...
>
> Enrico
>
>
> On 11 February 2014 17:09, Enrico Daga <enricod...@gmail.com> wrote:
>
>> Hi Hugh,
>> thank you for your reply,
>> I rebuilt the query (attached as saved by the iSQL web interface).
>>
>> Our current version is:
>>
>> Virtuoso Open Source Edition (Row Store) (multi threaded)
>> Version 6.1.8-rc1.3127-pthreads as of Dec 7 2013
>> Compiled for Linux (x86_64-unknown-linux-gnu)
>> Copyright (C) 1998-2013 OpenLink Software
>>
>> Thank you!
>> Enrico
>>
>>
>>
>> On 10 February 2014 17:22, Hugh Williams <hwilli...@openlinksw.com>wrote:
>>
>>> Hi Enrico,
>>>
>>> This is strange, as XML literals should be serialised as an object
>>> inside a blob when being inserted. Thus can you please provide an actual
>>> query as is being executed via isql that demonstrates this problem, such
>>> that we can attempt to recreate in-house.
>>>
>>> Also please confirm the actual version and build date of the Virtuoso
>>> being used (virtuoso-t -?) ...
>>>
>>> Best Regards
>>> Hugh Williams
>>> Professional Services
>>> OpenLink Software, Inc. // http://www.openlinksw.com/
>>> Weblog -- http://www.openlinksw.com/blogs/
>>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>>> Twitter -- http://twitter.com/OpenLink
>>> Google+ -- http://plus.google.com/100570109519069333827/
>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>> Universal Data Access, Integration, and Management Technology Providers
>>>
>>> On 10 Feb 2014, at 14:30, Enrico Daga <enricod...@gmail.com> wrote:
>>>
>>> (just reply to this to be sure it has been dispatched because I was not
>>> subscribed to the list)
>>>
>>>
>>> On 7 February 2014 17:50, Enrico Daga <enricod...@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> I have a problem with my application and I hope to find someone here to
>>>> help me.
>>>>
>>>> I am using Virtuoso 6 (precisely Virtuoso Open Source 6.01.3127).
>>>> My application connects to it via JDBC.
>>>> I obtained the following error while trying to insert a triple
>>>> containing a large literal:
>>>>
>>>> SQLState: 22026
>>>> Message: SR478: Value of ANY type column too long
>>>>
>>>> The syntax I am using is:
>>>>
>>>> SPARQL INSERT INTO <RdfIOTest> { <urn:x-temp:/doc/12345678> <
>>>> http://purl.org/dc/terms/description> """here a 282065 characters long
>>>> XML"""^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> }
>>>>
>>>> I also tried executing the same query in iSQL (web interface) and it
>>>> returns the same error.
>>>>
>>>> The only way I have been able to insert it was by file upload using the
>>>> web admin console.
>>>> Reading that triple is not a problem neither via JDBC.
>>>>
>>>> In my application I will have several cases like this.
>>>>
>>>> Is this something I can do by configuration or changing the query
>>>> syntax?
>>>> Which method would you recommend to insert a large literal via
>>>> SPARQL/SQL query and JDBC?
>>>>
>>>> Thank you in advance for any help!
>>>>
>>>> Best,
>>>> Enrico
>>>>
>>>> --
>>>> Enrico Daga
>>>>
>>>> --
>>>> http://www.enridaga.net
>>>> skype: enri-pan
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Enrico Daga
>>>
>>> --
>>> http://www.enridaga.net
>>> skype: enri-pan
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Managing the Performance of Cloud-Based Applications
>>> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
>>> Read the Whitepaper.
>>>
>>> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk_______________________________________________
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>
>>>
>>>
>>
>>
>> --
>> Enrico Daga
>>
>> --
>> http://www.enridaga.net
>> skype: enri-pan
>>
>>
>>
>
>
> --
> Enrico Daga
>
> --
> http://www.enridaga.net
> skype: enri-pan
>
>
> ------------------------------------------------------------------------------
> Android apps run on BlackBerry 10
> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
> Now with support for Jelly Bean, Bluetooth, Mapview and more.
> Get your Android app in front of a whole new audience. Start now.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk_______________________________________________
>
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
--
Enrico Daga
--
http://www.enridaga.net
skype: enri-pan
------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
