CallableStatementCallback; uncategorized SQLException for SQL [{? = call SEARCHDATA.DOSEARCH(?)}]; SQL state [72000]; error code [20000]; ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 1 ORA-06512: at "KAISA_ENCPOL.SYSTEMDATA", line 1782 ORA-06512: at "KAISA_ENCPOL.SEARCHDATA", line 2140 ORA-06512: at "KAISA_ENCPOL.SEARCHDATA", line 176 ORA-06512: at "KAISA_ENCPOL.SEARCHDATA", line 171 ORA-06512: at "KAISA_ENCPOL.SEARCHDATA", line 1314 ORA-06512: at line 1 ; nested exception is java.sql.SQLException: ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 1 ORA-06512: at "KAISA_ENCPOL.SYSTEMDATA", line 1782 ORA-06512: at "KAISA_ENCPOL.SEARCHDATA", line 2140 ORA-06512: at "KAISA_ENCPOL.SEARCHDATA", line 176 ORA-06512: at "KAISA_ENCPOL.SEARCHDATA", line 171 ORA-06512: at "KAISA_ENCPOL.SEARCHDATA", line 1314 ORA-06512: at line 1
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator(translate:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator(translate:80)
at org.springframework.jdbc.core.JdbcTemplate(execute:1030)
at org.springframework.jdbc.core.JdbcTemplate(call:1064)
at org.springframework.jdbc.core.simple.AbstractJdbcCall(executeCallInternal:388)
at org.springframework.jdbc.core.simple.AbstractJdbcCall(doExecute:362)
at org.springframework.jdbc.core.simple.SimpleJdbcCall(executeFunction:144)
at com.altsoft.kaisa_internet.kaisa_internet_core.DAO.KaisaInternetCoreDAO(doSearch:530)
at com.altsoft.kaisa_internet.kaisa_internet_core.DAO.KaisaInternetCoreDAO(doSearch:522)
at com.altsoft.kaisa_internet.kaisa_internet_core.service.KaisaInternetCoreServiceImpl(doSearch:356)
at com.altsoft.kaisa_internet.kaisa_internet_core.service.KaisaInternetCoreServiceImpl(getObjectListWithTabAndPageSearch:500)
at sun.reflect.GeneratedMethodAccessor222(invoke:-1)
at sun.reflect.DelegatingMethodAccessorImpl(invoke:43)
at java.lang.reflect.Method(invoke:497)
at org.springframework.aop.support.AopUtils(invokeJoinpointUsingReflection:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation(invokeJoinpoint:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation(proceed:150)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor(invoke:50)
at org.springframework.aop.framework.ReflectiveMethodInvocation(proceed:161)
at org.springframework.transaction.interceptor.TransactionInterceptor(invoke:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation(proceed:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor(invoke:90)
at org.springframework.aop.framework.ReflectiveMethodInvocation(proceed:172)
at org.springframework.aop.framework.JdkDynamicAopProxy(invoke:202)
at com.sun.proxy.$Proxy23(getObjectListWithTabAndPageSearch:-1)
at com.altsoft.kaisa_internet.instances.encpol.builder.data.SearchData(getObjectList:66)
at com.altsoft.kaisa_internet.instances.encpol.builder.data.SearchData(buildDataBlock:79)
at com.altsoft.kaisa_internet.instances.encpol.controller.SearchFormController(processSubmit:46)
at sun.reflect.GeneratedMethodAccessor219(invoke:-1)
at sun.reflect.DelegatingMethodAccessorImpl(invoke:43)
at java.lang.reflect.Method(invoke:497)
at org.springframework.web.method.support.InvocableHandlerMethod(invoke:212)
at org.springframework.web.method.support.InvocableHandlerMethod(invokeForRequest:126)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod(invokeAndHandle:96)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter(invokeHandlerMethod:617)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter(handleInternal:578)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter(handle:80)
at org.springframework.web.servlet.DispatcherServlet(doDispatch:900)
at org.springframework.web.servlet.DispatcherServlet(doService:827)
at org.springframework.web.servlet.FrameworkServlet(processRequest:882)
at org.springframework.web.servlet.FrameworkServlet(doGet:778)
at javax.servlet.http.HttpServlet(service:621)
at javax.servlet.http.HttpServlet(service:728)
at org.apache.catalina.core.ApplicationFilterChain(internalDoFilter:303)
at org.apache.catalina.core.ApplicationFilterChain(doFilter:208)
at org.springframework.web.filter.HiddenHttpMethodFilter(doFilterInternal:77)
at org.springframework.web.filter.OncePerRequestFilter(doFilter:76)
at org.apache.catalina.core.ApplicationFilterChain(internalDoFilter:241)
at org.apache.catalina.core.ApplicationFilterChain(doFilter:208)
at org.apache.tomcat.websocket.server.WsFilter(doFilter:52)
at org.apache.catalina.core.ApplicationFilterChain(internalDoFilter:241)
at org.apache.catalina.core.ApplicationFilterChain(doFilter:208)
at org.apache.catalina.core.StandardWrapperValve(invoke:219)
at org.apache.catalina.core.StandardContextValve(invoke:110)
at org.apache.catalina.authenticator.AuthenticatorBase(invoke:492)
at org.apache.catalina.core.StandardHostValve(invoke:165)
at org.apache.catalina.valves.ErrorReportValve(invoke:104)
at org.apache.catalina.valves.AccessLogValve(invoke:1025)
at org.apache.catalina.core.StandardEngineValve(invoke:116)
at org.apache.catalina.connector.CoyoteAdapter(service:451)
at org.apache.coyote.http11.AbstractHttp11Processor(process:1201)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler(process:654)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor(doRun:1782)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor(run:1741)
at java.util.concurrent.ThreadPoolExecutor(runWorker:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker(run:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable(run:61)
at java.lang.Thread(run:745)