No announcement yet.

XSQL in V55

  • Filter
  • Time
  • Show
Clear All
new posts

  • XSQL in V55

    1. In our version 4.0 environment, we have created few XSQLs (along with xsls) for displaying the track and trace information of the order. It is working fine without any issues.

    2. once we migrate to V55, XSQL pages are throwing exception:

    3. Any clues how to resolve this ?

    Oracle XML Developers Kit - Production

    XSQL-017: Unexpected Error Occurred
    at oracle.xml.xsql.XSQLDocHandler.valueOfConnectionAt tr(
    at oracle.xml.xsql.XSQLDocHandler.(XSQLDocHandler.jav a:84)
    at oracle.xml.xsql.XSQLPageProcessor.process(XSQLPage
    at oracle.xml.xsql.XSQLServlet.doGet( :60)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
    at ternalDoFilter(
    at Filter(
    at org.apache.catalina.core.StandardWrapperValve.invo ke(
    at org.apache.catalina.core.StandardContextValve.invo ke(
    at org.apache.catalina.core.StandardHostValve.invoke(
    at org.apache.catalina.valves.ErrorReportValve.invoke (
    at org.apache.catalina.core.StandardEngineValve.invok e(
    at org.apache.catalina.connector.CoyoteAdapter.servic e(
    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyo
    at org.apache.jk.common.HandlerRequest.invoke(Handler
    at org.apache.jk.common.ChannelSocket.invoke(ChannelS
    at org.apache.jk.common.ChannelSocket.processConnecti on(
    at org.apache.jk.common.ChannelSocket$SocketConnectio n.runIt(
    at org.apache.tomcat.util.threads.ThreadPool$ControlR
    at Source)

  • #2
    Re: XSQL in V55

    Apparently in 5.5, XSQL library (oraclexsql.jar) versions are different in App and Web.
    The one used for App (in oas\lib) is and the other for Web (in glog\gc3webapp\WEB-INF\lib\3rdparty) is

    If you copy oraclexsql.jar from App to Web, then XSQL should be working. But I am not sure whether any other parts may fall apart.
    Joseph Liang
    MavenWire APAC


    • #3
      Re: XSQL in V55

      Thanks a lot Josep. I will test and let you know the outcome.

      Regards, Vasu