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 "(D) ? ? (i) ? ? ?".
}
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 "(D) ? ? (i) ? ? ?" ", 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
