ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Access an XLS inside a JAR file

Post new topic  Reply to topic
 Access an XLS inside a JAR file « View previous topic :: View next topic » 
Author Message
naio
PostPosted: Wed Oct 30, 2013 11:20 am    Post subject: Access an XLS inside a JAR file Reply with quote

Voyager

Joined: 08 Nov 2012
Posts: 82

Hi to all,


I have a set of XSLs that lives inside a Jar File, they are there because several applications access them.

The scenario is the following:

BarFile deployed in a WMB V7 Execution Group with:
FLOW that access test.xls
JAR field with tests.xls


So far, I am only getting the famouse:

UserTrace BIP4445I



Is there a way to acess an XSL that lives inside a Jar?


Thanks you all in advice!
_________________
"God is in his heaven all's right with the world"
Back to top
View user's profile Send private message
naio
PostPosted: Wed Oct 30, 2013 11:37 am    Post subject: Reply with quote

Voyager

Joined: 08 Nov 2012
Posts: 82

To give more details, the Jar file with the XSLs deployed in the execution group, is place here:

C:\ProgramData\IBM\MQSI\components\BK1\4f00bceb-4101-0000-0080-f2efa593e724\config\JAR


And the Trace from the XSL engine, shows that is looking for it in another path:

Code:

XSL Request Wed Oct 30 16:26:35 ART 2013 com.ibm.xsl.exmlt.StylesheetSelector performSelection An embedded stylesheet was found:
XSL Request Wed Oct 30 16:26:35 ART 2013 com.ibm.xsl.exmlt.StylesheetSelector performSelection The stylesheet derived from Node Attribute/Local Environment specification was not found in the deployed storage: ./templates/test.xsl.
XSL Request Wed Oct 30 16:26:35 ART 2013 com.ibm.xsl.exmlt.StylesheetSelector performSelection The stylesheet derived from Node Attribute/Local Environment specification was not found: file://C:\ProgramData\Application Data\IBM\MQSI/XSL/external/./templates/test.xsl.
XSL Request Wed Oct 30 16:26:35 ART 2013 com.ibm.xsl.exmlt.EnhancedXMLTransform transformDocument No se ha encontrado ninguna hoja de estilo para la transformación.
XSL Request Wed Oct 30 16:26:35 ART 2013 com.ibm.xsl.mqsi.XMLTransformData transformData caught exception
XSL Request Wed Oct 30 16:26:35 ART 2013 com.ibm.xsl.mqsi.XMLTransformData transformData Exit





Is there any way to configure the XSL transformation node, to look for the XSL inside the Jar?


Thanks in advance!
_________________
"God is in his heaven all's right with the world"
Back to top
View user's profile Send private message
Simbu
PostPosted: Thu Oct 31, 2013 1:40 am    Post subject: Reply with quote

Master

Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India

As per my knowledge, it is not possible to retrieve the XSLT in the jar file using XSL Transform node.

I found one use case on Dynamic XSL Transform which may be useful to implement your scenario but XSLT cache is not possible.

Quote:
The Java Compute node retrieves the style-sheet(from jar, if possible), and copies it into the message payload. This is then processed by the XSL Transform node, using the embedded style-sheet processing.
Back to top
View user's profile Send private message
naio
PostPosted: Thu Oct 31, 2013 5:20 am    Post subject: Reply with quote

Voyager

Joined: 08 Nov 2012
Posts: 82

Simbu,

Thanks you for your reply.
I have thougth of that option, the problem is that some XSLs have dependencies with other XSLs.
I mean, there are common xls routines, If I do:

SET LocalEnvironment.ComIbmXslXmltStylesheetname = '<style sheet name>';


That won´t consider the dependencies XSL.

I will try to figure it out with a maven routine.


Thanks you again
_________________
"God is in his heaven all's right with the world"
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Access an XLS inside a JAR file
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.