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
------------------------------------------------------------------------------
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
