Re: [Virtuoso-users] [UTF-8 Encoding] Problems with utf-8 encoding while doing full text search in sparql query

[Hugh Williams]

Hi Taemo,

Does this error occur when the query is run against the /sparql endpoint 
directly ?

Note also the following documentation on wide char support in the Free-Text 
index when handling accented characters:


http://docs.openlinksw.com/virtuoso/virtuosotipsandtrickscontrolunicode3/

Note of if this will help with you oriental char sets though, but you can try 
setting the:

[I18N]
XAnyNormalization=3

in the INI file as it is not set current and thus defaulting to 0 …

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 24 Oct 2016, at 07:41, 손태모  wrote:
> 
> Dear all , 
> I just made a sparql query which functions like text search, 
> the query i made is shown bellow , 
> ===
> PREFIX rdf: 
> PREFIX rdfs: 
> PREFIX bif:  
> SELECT ?s ?p ?o ?label 
> WHERE {?s ?p ?o . ?s rdf:type 
>  . ?o 
> bif:contains '"박근혜"' . ?s rdfs:label ?label .} 
> ORDER BY ?s 
> LIMIT 5 
> OFFSET 0
> 
> 
> but when i tried to run this query utilizing virt-jena java programming ,  i 
> got this kind of error message from virtuoso server opensource edition . 
> 
> org.apache.jena.shared.JenaException: Can not create 
> ResultSet.:virtuoso.jdbc4.VirtuosoException: XM028: Free-text expression, 
> line 1: phrase consists of noise words exclusively
> in the following expression:
> [ __enc "UTF-8" ] "???"
> at 
> virtuoso.jena.driver.VirtuosoQueryExecution.execSelect(VirtuosoQueryExecution.java:103)
> at 
> kr.or.knps.lod.app.access.dao.VirtuosoDAO.textSearch(VirtuosoDAO.java:197)
> at 
> kr.or.knps.lod.app.access.service.virtuoso.VirtuosoService.textSearch(VirtuosoService.java:63)
> at 
> kr.or.knps.lod.app.controller.DataController.doTextSearch(DataController.java:601)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at 
> org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
> at 
> org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
> at 
> org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
> at 
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
> at 
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
> at 
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
> at 
> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at 
> egovframework.rte.ptl.mvc.filter.HTMLTagFilter.doFilter(HTMLTagFilter.java:52)
> at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at 
> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
> at 
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
> at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:12

[Virtuoso-users] [UTF-8 Encoding] Problems with utf-8 encoding while doing full text search in sparql query

[손태모]

Dear all ,

I just made a sparql query which functions like text search,

the query i made is shown bellow ,

===

PREFIX rdf: 
PREFIX rdfs: 
PREFIX bif: 
SELECT ?s ?p ?o ?label
WHERE {?s ?p ?o . ?s rdf:type 
 . 
?o bif:contains '"*박근혜*"' . ?s rdfs:label ?label .}

ORDER BY ?s
LIMIT 5
OFFSET 0


but when i tried to run this query utilizing virt-jena java programming 
,  i got this kind of error message from virtuoso server opensource 
edition .



org.apache.jena.shared.JenaException: Can not create 
ResultSet.:virtuoso.jdbc4.VirtuosoException: XM028: Free-text 
expression, line 1: phrase consists of noise words exclusively

in the following expression:
[ __enc "UTF-8" ] "???"
at 
virtuoso.jena.driver.VirtuosoQueryExecution.execSelect(VirtuosoQueryExecution.java:103)
at 
kr.or.knps.lod.app.access.dao.VirtuosoDAO.textSearch(VirtuosoDAO.java:197)
at 
kr.or.knps.lod.app.access.service.virtuoso.VirtuosoService.textSearch(VirtuosoService.java:63)
at 
kr.or.knps.lod.app.controller.DataController.doTextSearch(DataController.java:601)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at 
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
at 
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
at 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at 
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at 
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at 
egovframework.rte.ptl.mvc.filter.HTMLTagFilter.doFilter(HTMLTagFilter.java:52)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at 
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at 
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442)
at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1083)
at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:640)
at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at 
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)


I a