I have been exploring a number of configurations to install a bean that converts both an XSL and an XSLX to CSV as a bundle in ServiceMix (with Camel). The code works correctly from command-line maven and passes my unit tests plus a Camel integration test using the Java DSL. And the code works correctly in ServiceMix (with Camel) to convert XSL files to CSV. But I have not been able to convert XSLT to CSV for different reasons with the various configurations. For now I am not looking to use more advanced POI functionality just trying to solve my immediate problem, especially since the POI project has gotten very active again.
ServiceMix 5.4, Java 1.7.75, RHEL 6.x and Ubuntu 14.04 Attempted POI 3.9, 3.11 and 3.12-beta1 Tried a build using my bean and: <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.12-beta1</version> <scope>compile</scope> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.12-beta1</version> <scope>compile</scope> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml-schemas</artifactId> <version>3.12-beta1</version> <scope>compile</scope> </dependency> I also tried building just the bean then using exports from 3.9 and the yet to be released 3.11 bundles. As noted above, the XSL to CSV conversion works in all of the configurations. The XSLT conversion does not. It seems like 3.11 is missing a jar (also reported by another user) so I concentrated on 3.9 and 3.12-beta1. With 3.9, I get a org.apache.poi.openxml4j.exceptions.InvalidFormatException when trying to convert an XSLT to CSV. With 3.12-beta1, the issue I am facing now is: Unable to resolve 242.154: missing requirement [242.154] osgi.wiring.package; (osgi.wiring.package=javax.xml.stream.XMLEventFactory). I have looked in ServiceMix using osgi:headers including bundle 0 and I cannot find the package. I tried adding the javax.xml.stream.XMLEventFactory package to the Java 7 section of etc/jre.properties and restarting ServiceMix, but it does not show. I have read a lot of good information online to suspect that, on the command-line, I am finding the package in the Java 7 JDK usually leading to a suggestion to modify etc/jre.properties or work with one of the Stax bundles. But I am missing something. Does anyone have any insight? I am glad to supply more details but this email is already long enough. -- Daniel Davis Technical Manager - Office of Research Information Services Smithsonian Institution
