otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Branding, Screen Sets, XSL/CSS and Translations Customizing and Branding the UI of OTM / G-Log for your site, using Custom Screen Sets, Menu Managers, XSL/CSS customizations, Translations and more.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old August 29th, 2008, 14:40
Junior Member
 
Join Date: Feb 2007
Location: UK
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
gvasu2 is on a distinguished road
Send a message via Yahoo to gvasu2
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)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old October 16th, 2008, 00:32
Junior Member
 
Join Date: Apr 2008
Location: Taiwan
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
josephliang is on a distinguished road
Send a message via MSN to josephliang Send a message via Skype™ to 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.
__________________
--
Joseph Liang
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old October 16th, 2008, 17:59
Junior Member
 
Join Date: Feb 2007
Location: UK
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
gvasu2 is on a distinguished road
Send a message via Yahoo to gvasu2
Re: XSQL in V55

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

Regards, Vasu
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 19:30.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37