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
