Discussions

EJB programming & troubleshooting: texis.jdbc.TexisSQLException: Texis: Bad Data

  1. texis.jdbc.TexisSQLException: Texis: Bad Data (1 messages)

    Hi there

    I am Using taxis database for text searching but I am getting an error..

     

     

    When I am using the query like this “

     

                            StrSQL = "SELECT SUM($rank) AS RANK, COUNT(CATEGORY_PATH) AS DCOUNT, HRDIVID, MAX(DIVISION_NAME)

    DIVNAME, MAX(DIVISION_ID) DIVID ";

                            StrSQL = StrSQL+ "FROM CAT_PATH, DIV_BU_REL ";

                            StrSQL = StrSQL + "WHERE CAT_PATH.DIVISION_ID=DIV_BU_REL.EBUSBUID AND CATEGORY_PATH LIKEP '";

                            StrSQL = StrSQL + searchString ;

                            StrSQL = StrSQL + "'gc' GROUP BY HRDIVID ORDER BY RANK DESC";

     

     

    The error Message is……………

     

    got into exeptioncom.thunderstone.texis.jdbc.TexisSQLException: Texis: Bad Data (table)null
    Start MaterTOPFR page: Tue Jan 28 11:13:47 EST 2003
    End MaterTOPFR page: Tue Jan 28 11:13:47 EST 2003
    [03.01.28 11:14:47:369 EST] b94979 ServletInstan X Uncaught service() exception thrown by servlet {0}: {1}
                                     "JSP 1.1 Processor"
                                     org.apache.jasper.JasperException: Unable to compile class for JSP "/TN_Applications/AskThermo/ProductSearch/CDA/findProduct.jsp" /opt/WebSphere/AppServer/temp/default_host/V5jsp/TN_5F_Applications/AskThermo/ProductSearch/CDA/_findProduct_jsp_0.java:235: ')' expected.
                _jspx_writeString(out, _jspx_html_data[4]);
                                                          ^
    /opt/WebSphere/AppServer/temp/default_host/V5jsp/TN_5F_Applications/AskThermo/ProductSearch/CDA/_findProduct_jsp_0.java:389: 'try' without 'catch' or 'finally'.
                _jspx_writeString(out, _jspx_html_data[28]);
                ^
    /opt/WebSphere/AppServer/temp/default_host/V5jsp/TN_5F_Applications/AskThermo/ProductSearch/CDA/_findProduct_jsp_0.java:391: Type expected.
            } catch (Exception ex) {
              ^
    3 errors
            at java.lang.Throwable.fillInStackTrace(Native Method)
            at java.lang.Throwable.fillInStackTrace(Compiled Code)
            at java.lang.Throwable.<init>(Compiled Code)
            at java.lang.Exception.<init>(Compiled Code)
            at javax.servlet.ServletException.<init>(ServletException.java:107)
            at org.apache.jasper.JasperException.<init>(JasperException.java:73)
            at org.apache.jasper.compiler.Compiler.compile(Compiled Code)
            at org.apache.jasper.runtime.JspServlet.loadJSP(Compiled Code)
            at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(Compiled Code)
            at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(Compiled Code)
            at org.apache.jasper.runtime.JspServlet.serviceJspFile(Compiled Code)
            at org.apache.jasper.runtime.JspServlet.service(Compiled Code)
            at javax.servlet.http.HttpServlet.service(Compiled Code)
            at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(Compiled Code)
            at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(Compiled Code)
            at com.ibm.servlet.engine.webapp.IdleServletState.service(Compiled Code)
            at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(Compiled Code)
            at com.ibm.servlet.engine.webapp.ServletInstance.service(Compiled Code)
            at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Compiled Code)
            at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(Compiled Code)
            at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(Compiled Code)
            at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(Compiled Code)
            at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(Compiled Code)
            at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(Compiled Code)
            at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(Compiled Code)
            at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Compiled Code)
            at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Compiled Code)
            at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(Compiled Code)
            at com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(Compiled Code)
            at com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(Compiled Code)
            at com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(Compiled Code)
            at com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRunnable.notifyService(Compiled Code)
            at com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRunnable.run(Compiled Code)
            at com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.run(Compiled Code)
            at java.lang.Thread.run(Compiled Code)
     

    I will Really Appreciate if you can help me to solve this issue..

    Regards

    Buchanna Gajula
    buchanna.gajula@thermo.com
  2. Using $$ instead of $ it works fine..
    The strange thing is $ sign is used as a escape character in Texis...
    Any way it works now :)

    Cheers!!

    Buchanna Gajula