Hi Cristian, Good to hear you have this working. Setting CHARSET=UTF-8 is a pre-requisite for querying RDF via the JDBC Driver as detailed in one the document link I provided originally:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtODBCJDBCUTF8Set
and has been the case since Virtuoso 5, so I don’t see how this would not have
worked with a 6.1.3 build as this is a core requirement others users of the
JDBC driver and Sesame & Jena Provider (which use the JDBC Driver) would have
reported. Perhaps there was a problem with your 6.1.3 build ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
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 6 Apr 2012, at 14:25, Cristian Lai wrote:
> Hi Hugh,
> i think to have the solution. Eventually, it was not necessary to modify the
> file virtuoso.ini
> On the contrary i modified the db url string to
> jdbc:virtuoso://<server>:<port>/CHARSET=UTF-8
> It had no effect with the previous version of the server. I already tryed it.
> So i think that the new installation solves the problem, but it is necessary
> to keep
> SQL_UTF8_EXECS = 0
>
> Hope to go on trustful.
> Keep in touch.
>
> cristian
>
>
> Il 4/6/12 9:04 AM, Cristian Lai ha scritto:
>>
>> Hi Hugh,
>> i'm back with bad news.
>> I have the new version of Virtuoso, the latest 6.1.5.
>> Anyway my problemas are not solved.
>> Setting SQL_UTF8_EXECS = 1 i always get the error
>> "Malformed data received from IP [xxx] : Box length too large. Disconnecting
>> the client" from the virtuoso.log file.
>> While though the console i get
>> "virtuoso.jdbc3.VirtuosoException: Virtuoso Communications Link Failure
>> (timeout) : Connection to the server lost".
>>
>> Let me say you that the query string i try so send is the following:
>>
>> sparql PREFIX foaf:<http://xmlns.com/foaf/0.1/>
>> PREFIX ex:<http://example/>
>> PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
>> PREFIX dbpedia:<http://dbpedia.org/ontology/>
>> PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
>>
>> insert into graph <http://example> {
>>
>> <_:i_first> ex:name "First".
>>
>> <_:i_second> ex:name "Ⓓ α и ⓘ є ι ★".
>>
>> }
>>
>> Moreover, if i insert it through the Interactive SQL tool of the web
>> application, there is no problem.
>> May you help me please?
>>
>> Thanks in advance.
>>
>> cristian
>>
>>
>> Il 3/29/12 8:39 AM, Cristian Lai ha scritto:
>>>
>>> Hi Hugh,
>>> i already checked the version. In fact the command virtuoso-t -? returns:
>>>
>>> Virtuoso Open Source Edition (multi threaded)
>>> Version 6.1.3.3127-pthreads as of Oct 6 2011
>>> Compiled for Linux (x86_64-unknown-linux-gnu)
>>> Copyright (C) 1998-2011 OpenLink Software
>>>
>>> Anyway i remember i asked the system administrtors to install the new
>>> version some months ago. I hope they upgraded the latest. Then there could
>>> be more than one file .ini
>>> I think to ask to clean and install the latest 6.1.5.
>>> Hope to give you more news sooner.
>>> Thanks.
>>> Best regards.
>>>
>>> cristian
>>>
>>>
>>>
>>>
>>> Il 3/28/12 6:05 PM, Hugh Williams ha scritto:
>>>>
>>>> Hi Cristian,
>>>>
>>>> What is the version of Virtuoso being used as we have seen this issue
>>>> before, which was fixed in the 6.1.3+ open source builds. Please provide
>>>> the output of running the command:
>>>>
>>>> virtuoso-t -?
>>>>
>>>> to confirm your version.
>>>>
>>>> Actually looking at your reported INI file location
>>>> "/etc/virtuoso-opensource-6.0/virtuoso.ini” this looks like a Virtuoso
>>>> 6.0.x open source release being used, thus you definitely need to update
>>>> to resolve this issue. The latest 6.1.5 can be downloaded from:
>>>>
>>>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload
>>>>
>>>> Best Regards
>>>> Hugh Williams
>>>> Professional Services
>>>> OpenLink Software, Inc. // http://www.openlinksw.com/
>>>> 10 Burlington Mall Road, Suite 265, Burlington MA 01803
>>>> 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 28 Mar 2012, at 15:47, Cristian Lai wrote:
>>>>
>>>>> Hugh, after setting SQL_UTF8_EXECS = 1 the appliation fails.
>>>>> I get the following exception virtuoso.jdbc3.VirtuosoException: Virtuoso
>>>>> Communications Link Failure (timeout) : Connection to the server lost
>>>>> The log file reports: Malformed data received from IP [xxx] : Box length
>>>>> too large. Disconnecting the client
>>>>>
>>>>> While, if i comment back ;SQL_UTF8_EXECS = 1 the application runs, but
>>>>> with the starting encoding problem.
>>>>> Thanks in advance.
>>>>>
>>>>> cristian
>>>>>
>>>>>
>>>>> Il 3/28/12 3:09 PM, Cristian Lai ha scritto:
>>>>>>
>>>>>> Hi Hugh,
>>>>>> thank you for your response.
>>>>>> I checked/etc/virtuoso-opensource-6.0/virtuoso.ini :
>>>>>> Charset = UTF-8 is ok.
>>>>>> I also use the JDBC URL as follows:
>>>>>> jdbc:virtuoso://<server>:<port>/CHARSET=UTF-8
>>>>>>
>>>>>> Unfortunatly the configuration
>>>>>> SQL_UTF8_EXECS = 1
>>>>>> is commented. I post a request to system administrators for the right
>>>>>> configuration.
>>>>>> Hope to ferify sooner.
>>>>>> Best regards.
>>>>>> cristian
>>>>>>
>>>>>>
>>>>>> Il 3/28/12 12:34 PM, Hugh Williams ha scritto:
>>>>>>>
>>>>>>> Hi Cristian,
>>>>>>>
>>>>>>> Have you configured your Virtuoso server to handle wide character sets
>>>>>>> as detailed in the following links:
>>>>>>>
>>>>>>>
>>>>>>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSPARQLConfWideCharUnicodeUTF
>>>>>>>
>>>>>>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtODBCJDBCUTF8Set
>>>>>>> http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html#jdbcurl4mat
>>>>>>>
>>>>>>> Best Regards
>>>>>>> Hugh Williams
>>>>>>> Professional Services
>>>>>>> OpenLink Software, Inc. // http://www.openlinksw.com/
>>>>>>> 10 Burlington Mall Road, Suite 265, Burlington MA 01803
>>>>>>> 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 28 Mar 2012, at 09:28, Cristian Lai wrote:
>>>>>>>
>>>>>>>> Hi All,
>>>>>>>> i'm working on creating a knowledge base and storing in Virtuoso via
>>>>>>>> JDBC. I pick up data from many datasources. Sometimes i find cyrillic
>>>>>>>> characters.
>>>>>>>> If the string is "Ⓓ α и ⓘ є ι ★" ", the error i get is
>>>>>>>> virtuoso.jdbc4.VirtuosoException: SQ074: Line 7: Bad escape sequence
>>>>>>>> in
>>>>>>>> a SPARQL short double-quoted string at '\'
>>>>>>>> Anybody may help me, please?
>>>>>>>>
>>>>>>>> Thanks in advance.
>>>>>>>> Cheers.
>>>>>>>>
>>>>>>>> cristian
>>>>>>>>
>>>>>>>> ------------------------------------------------------------------------------
>>>>>>>> This SF email is sponsosred by:
>>>>>>>> Try Windows Azure free for 90 days Click Here
>>>>>>>> http://p.sf.net/sfu/sfd2d-msazure
>>>>>>>> _______________________________________________
>>>>>>>> Virtuoso-devel mailing list
>>>>>>>> [email protected]
>>>>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> This SF email is sponsosred by:
>>>>>> Try Windows Azure free for 90 days Click Here
>>>>>> http://p.sf.net/sfu/sfd2d-msazure
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Virtuoso-devel mailing list
>>>>>> [email protected]
>>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> This SF email is sponsosred by:
>>>>> Try Windows Azure free for 90 days Click Here
>>>>> http://p.sf.net/sfu/sfd2d-msazure_______________________________________________
>>>>> Virtuoso-devel mailing list
>>>>> [email protected]
>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
>>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> This SF email is sponsosred by:
>>> Try Windows Azure free for 90 days Click Here
>>> http://p.sf.net/sfu/sfd2d-msazure
>>>
>>>
>>> _______________________________________________
>>> Virtuoso-devel mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
>>
>>
>>
>> ------------------------------------------------------------------------------
>> For Developers, A Lot Can Happen In A Second.
>> Boundary is the first to Know...and Tell You.
>> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
>> http://p.sf.net/sfu/Boundary-d2dvs2
>>
>>
>> _______________________________________________
>> Virtuoso-devel mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
>
> ------------------------------------------------------------------------------
> For Developers, A Lot Can Happen In A Second.
> Boundary is the first to Know...and Tell You.
> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
> http://p.sf.net/sfu/Boundary-d2dvs2_______________________________________________
> Virtuoso-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
smime.p7s
Description: S/MIME cryptographic signature
