Hi Enrico,
OK, I have reported this to development to check and advise how best this
can/should be done ...
Is your work part of the original Fusepool or the new Fusepool P3 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 14 Feb 2014, at 10:40, Enrico Daga <enricod...@gmail.com> wrote:
> 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-B1 http://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
------------------------------------------------------------------------------
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
