Announcement

Collapse
No announcement yet.

XSQL in V55

Collapse
X
 
  • 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 10.1.3.0.0 - Production

    XSQL-017: Unexpected Error Occurred
    java.lang.NullPointerException
    at oracle.xml.xsql.XSQLDocHandler.valueOfConnectionAt tr(XSQLDocHandler.java:493)
    at oracle.xml.xsql.XSQLDocHandler.(XSQLDocHandler.jav a:84)
    at oracle.xml.xsql.XSQLPageProcessor.process(XSQLPage Processor.java:109)
    at oracle.xml.xsql.XSQLServlet.doGet(XSQLServlet.java :60)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
    at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:175)
    at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:17
    at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:14
    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyo teHandler.java:199)
    at org.apache.jk.common.HandlerRequest.invoke(Handler Request.java:282)
    at org.apache.jk.common.ChannelSocket.invoke(ChannelS ocket.java:754)
    at org.apache.jk.common.ChannelSocket.processConnecti on(ChannelSocket.java:684)
    at org.apache.jk.common.ChannelSocket$SocketConnectio n.runIt(ChannelSocket.java:876)
    at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
    at java.lang.Thread.run()V(Unknown 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 10.1.3.3 and the other for Web (in glog\gc3webapp\WEB-INF\lib\3rdparty) is 9.2.0.4

    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
    http://www.mavenwire.com/

    Comment


    • #3
      Re: XSQL in V55

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

      Regards, Vasu

      Comment

      Working...
      X