XSQL in V55

[gvasu2]

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)

[josephliang]

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.

[gvasu2]

Re: XSQL in V55

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

Regards, Vasu