Hi Gary, org.apache.xml.security.signature package is from xmlsec bundle, so your feature should include <bundle>mvn:org.apache.santuario/xmlsec/2.0.10</bundle>
Cheers －－－－－－－－－－－－－ Freeman(Yue) Fang Red Hat, Inc. > On Dec 22, 2018, at 10:24 AM, Mills, Gary (GE Digital) <gary.l.mi...@ge.com> > wrote: > > Am I on the right forum? I would like to issue a bug report now, these poi > servicemix osgi bundles are not osgi compliant. They are undeployable in > JBoss Fuse Karaf OSGI container. And there are dependencies that cannot be > resolved. One will need to create their own osgi bundle because I haven't > found 1 that works except 3.9_2, however, there is no workbook.close() method. > > Will you be making an osgi deployable, workable, out of box bundle? Or should > I fumble through it? I've not done this before so any help would be great. > Thanks so much > > From: Mills, Gary (GE Digital) > Sent: Thursday, December 20, 2018 5:07 PM > To: users@servicemix.apache.org > Subject: org.apache.servicemix.bundles.poi 4.0.0_1 not osgi deployable can't > resolve all dependencies > > > Hello, I am trying to upgrade from org.apache.servicemix.buncles.poi.3.9_2 to > 4.0.0_1 (*thanks > > in advance) > > > > I inherited an application that used 3.9_2, simply to read xlsx spreadsheets > and update a > > database. > > > > I needed to write an app to read in a template, update the template with > message exchange > > data, then send the xlsx workbook to some destination. I had it all working > with 3.9_2, however, > > there is no workbook.close() method in 3.9_2. So, I opted to upgrade to > 4.0.0_1. On my journey > > I tried each release up to 4.0.0_1 unsuccessfully. I then just settled on > 4.0.0_1 to try > > to get it working. > > > > I'm almost there, however, I cannot resolve alll the dependencies. > > > > Error executing command: Could not start bundle > mvn:com.ge.ip.infra/delta-fadec-prod/3.0.1-SNAPSHOT > > in feature(s) fadec-application-1.0.0: Unresolved constraint in bundle > delta-fadec-prod [348]: > > Unable to resolve 348.0: missing requirement [348.0] osgi.wiring.package; > (&(osgi.wiring.package=org.apache.poi.ss.usermodel)(version>=4.0.0)(!(version>=5.0.0))) > > [caused by: Unable to resolve 319.0: missing requirement [319.0] > osgi.wiring.package; (osgi.wiring.package=org.apache.xml.security.signature)] > > > > I'm pretty close, stuck here... the bottom of the manifest for 4.0.0_1, the > rest starting > > at org.apache.xml.security.signature, the org.w3c.dom, etc... > > > > l.extensions;version="[4.0,5)",org.apache.poi.xssf.util;version="[4.0 > > ,5)",org.apache.xml.security.signature,org.ietf.jgss,org.w3c.dom,org. > > w3c.dom.events,org.w3c.dom.ls,org.xml.sax,org.xml.sax.ext,org.xml.sax > > .helpers,junit.framework;resolution:=optional > > > > I've been at this for 3 days now, very frustrating, needing you expertise, > thank you. > > > > POM > > <?xml version="1.0" encoding="UTF-8"?> > > <project xmlns="http://maven.apache.org/POM/4.0.0"; > > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > > > xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 > http://maven.apache.org/maven-v4_0_0.xsd<http://maven.apache.org/POM/4.0.0%20http:/maven.apache.org/maven-v4_0_0.xsd><http://maven.apache.org/POM/4.0.0%20http:/maven.apache.org/maven-v4_0_0.xsd%3chttp:/maven.apache.org/POM/4.0.0%20http:/maven.apache.org/maven-v4_0_0.xsd%3e>"> > > > > <modelVersion>4.0.0</modelVersion> > > > > <parent> > > <groupId>com.ge.ip.infra</groupId> > > <artifactId>ge.ip.infra.parent</artifactId> > > <version>3.0.1-SNAPSHOT</version> > > </parent> > > > > <artifactId>delta-fadec-prod</artifactId> > > <packaging>bundle</packaging> > > > > <name>GE-IP Delta FADEC PROD ENV</name> > > > > <dependencies> > > > > <!-- IBM MQ Dependencies --> > > <dependency> > > <groupId>com.ibm.dhbcore</groupId> > > <artifactId>dhbcore</artifactId> > > <version>7.5.0.2</version> > > </dependency> > > <dependency> > > <groupId>com.ibm.mq.jmqi</groupId> > > <artifactId>jmqi</artifactId> > > <version>7.5.0.2</version> > > </dependency> > > <dependency> > > <groupId>com.ibm.mq</groupId> > > <artifactId>mq</artifactId> > > <version>7.5.0.2</version> > > </dependency> > > <dependency> > > <groupId>com.ibm.mqjms</groupId> > > <artifactId>mqjms</artifactId> > > <version>7.5.0.2</version> > > </dependency> > > > > <!-- Camel Spring Dependencies --> > > <dependency> > > <groupId>org.springframework</groupId> > > <artifactId>spring-jdbc</artifactId> > > </dependency> > > <!-- C3P0 database management--> > > <dependency> > > <groupId>com.mchange</groupId> > > <artifactId>c3p0</artifactId> > > </dependency> > > <!-- Java Apache POI Excel dependencies --> > > <dependency> > > <groupId>org.apache.servicemix.bundles</groupId> > > <artifactId>org.apache.servicemix.bundles.poi</artifactId> > > <version>4.0.0_1</version> <!-- 3.9_2, 3.14_1 --> > > </dependency> > > <dependency> > > <groupId>org.apache.poi</groupId> > > <artifactId>poi</artifactId> > > <version>4.0.1</version> > > </dependency> > > <dependency> > > <groupId>org.apache.poi</groupId> > > <artifactId>poi-ooxml</artifactId> > > <version>4.0.1</version> <!-- 3.9, 3.14--> > > </dependency> > > <dependency> > > <groupId>org.apache.poi</groupId> > > <artifactId>poi-ooxml-schemas</artifactId> > > <version>4.0.1</version> > > </dependency> > > <dependency> > > <groupId>org.apache.commons</groupId> > > <artifactId>commons-collections4</artifactId> > > <version>4.2</version> > > </dependency> > > <dependency> > > <groupId>org.apache.poi</groupId> > > <artifactId>ooxml-schemas</artifactId> > > <version>1.4</version> > > </dependency> > > <dependency> > > <groupId>org.apache.commons</groupId> > > <artifactId>commons-math3</artifactId> > > <version>3.6.1</version> > > </dependency> > > <dependency> > > <groupId>commons-codec</groupId> > > <artifactId>commons-codec</artifactId> > > <version>1.11</version> > > </dependency> > > <dependency> > > <groupId>org.apache.commons</groupId> > > <artifactId>commons-compress</artifactId> > > <version>1.18</version> > > </dependency> > > <dependency> > > <groupId>org.apache.poi</groupId> > > <artifactId>ooxml-security</artifactId> > > <version>1.1</version> > > </dependency> > > <dependency> > > <groupId>com.enterprisemath</groupId> > > <artifactId>em-utils</artifactId> > > <version>2.4.0</version> > > </dependency> > > <!-- <dependency> > > <groupId>org.apache.poi</groupId> > > <artifactId>poi</artifactId> > > </dependency> --> > > > > <!-- MySQL dependencies --> > > <dependency> > > <groupId>mysql</groupId> > > <artifactId>mysql-connector-java</artifactId> > > </dependency> > > <!-- Camel Dependencies --> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-core</artifactId> > > </dependency> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-sql</artifactId> > > </dependency> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-jms</artifactId> > > </dependency> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-ftp</artifactId> > > </dependency> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-blueprint</artifactId> > > </dependency> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-csv</artifactId> > > </dependency> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-xmlbeans</artifactId> > > </dependency> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-velocity</artifactId> > > </dependency> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-ognl</artifactId> > > </dependency> > > <dependency> > > <groupId>commons-io</groupId> > > <artifactId>commons-io</artifactId> > > </dependency> > > <dependency> > > <groupId>joda-time</groupId> > > <artifactId>joda-time</artifactId> > > </dependency> > > <dependency> > > <groupId>org.apache.camel</groupId> > > <artifactId>camel-jdbc</artifactId> > > </dependency> > > > > <!-- logging --> > > <dependency> > > <groupId>org.slf4j</groupId> > > <artifactId>slf4j-api</artifactId> > > </dependency> > > <dependency> > > <groupId>org.slf4j</groupId> > > <artifactId>slf4j-log4j12</artifactId> > > </dependency> > > <dependency> > > <groupId>org.slf4j</groupId> > > <artifactId>jcl-over-slf4j</artifactId> > > </dependency> > > <dependency> > > <groupId>log4j</groupId> > > <artifactId>log4j</artifactId> > > </dependency> > > > > </dependencies> > > <!-- Build definition --> > > <build> > > <defaultGoal>install</defaultGoal> > > <plugins> > > <plugin> > > <groupId>org.codehaus.mojo</groupId> > > <artifactId>build-helper-maven-plugin</artifactId> > > <version>1.8</version> > > <executions> > > <execution> > > <id>attach-artifacts</id> > > <phase>package</phase> > > <goals> > > <goal>attach-artifact</goal> > > </goals> > > <configuration> > > <artifacts> > > <artifact> > > <file>target/classes/features.xml</file> > > <type>xml</type> > > <classifier>features</classifier> > > </artifact> > > </artifacts> > > </configuration> > > </execution> > > </executions> > > </plugin> > > <plugin> > > <groupId>org.apache.maven.plugins</groupId> > > <artifactId>maven-resources-plugin</artifactId> > > <version>2.4.3</version> > > <executions> > > <execution> > > <id>copy-resources</id> > > <phase>validate</phase> > > <goals> > > <goal>copy-resources</goal> > > </goals> > > <configuration> > > <outputDirectory>${basedir}/target</outputDirectory> > > <resources> > > <resource> > > <directory>src/main/resources</directory> > > <filtering>true</filtering> > > </resource> > > </resources> > > </configuration> > > </execution> > > </executions> > > </plugin> > > <!-- to generate the MANIFEST-FILE of the bundle --> > > <plugin> > > <groupId>org.apache.felix</groupId> > > <artifactId>maven-bundle-plugin</artifactId> > > <version>${bundle-plugin-version}</version> > > <extensions>true</extensions> > > <configuration> > > <instructions> > > <Bundle-SymbolicName>${project.artifactId}</Bundle-SymbolicName> > > <Private-Package>com.ge.ip.infra.fadec.*</Private-Package> > > <Import-Package> > > org.springframework.jdbc, > > org.springframework.jdbc.core, > > * > > </Import-Package> > > </instructions> > > </configuration> > > </plugin> > > </plugins> > > </build> > > </project> > > > > FEATURES.XML > > > > <?xml version="1.0" encoding="UTF-8"?> > > <features xmlns="http://karaf.apache.org/xmlns/features/v1.0.0";> > > <feature name="fadec-application" version="1.0.0" description="Delta FADEC > Route and dependencies"> > > <feature>camel-core</feature> > > <feature>camel-blueprint</feature> > > <feature>camel-csv</feature> > > <feature>camel-sql</feature> > > <feature>camel-jdbc</feature> > > <feature>camel-velocity</feature> > > <feature>camel-xmlbeans</feature> > > > > <bundle > start-level="60">mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.dom4j/1.6.1_5</bundle> > > <bundle > start-level="61">wrap:mvn:org.apache.poi/poi-ooxml-schemas/4.0.1$DynamicImport-package=*</bundle> > > <!-- 3.9, 3.14 $DynamicImport-package=*--> > > <bundle > start-level="61">wrap:mvn:org.apache.commons/commons-collections4/4.2</bundle> > > <bundle > start-level="62">wrap:mvn:org.apache.commons/commons-compress/1.18</bundle> > > <bundle > start-level="63">wrap:mvn:org.apache.commons/commons-math3/3.6.1</bundle> > > <bundle > start-level="64">wrap:mvn:org.apache.poi/ooxml-security/1.1</bundle> > > > > <bundle > start-level="65">mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi/4.0.0_1</bundle> > > <!-- 3.9_2 3.13_1 3.14--> > > > > > <bundle>mvn:com.ibm.msg.client.osgi/osgi-jms/7.5.0.2</bundle> > > <bundle>mvn:com.ibm.msg.client.osgi/osgi-wmq-prereq/7.5.0.2</bundle> > > <bundle>mvn:com.ibm.msg.client.osgi/osgi-nls/7.5.0.2</bundle> > > <bundle>mvn:com.ibm.msg.client.osgi/osgi-wmq-nls/7.5.0.2</bundle> > > <bundle>mvn:com.ibm.msg.client.osgi/osgi-wmq/7.5.0.2</bundle> > > > <bundle>mvn:com.ibm.msg.client.osgi/osgi-commonservices-j2se/7.5.0.2</bundle> > > <bundle>mvn:com.ibm.msg.client.osgi/jms-prereq/7.5.0.2</bundle> > > <bundle>mvn:com.ibm.mq.osgi/osgi-directip/7.5.0.2</bundle> > > > > <bundle > start-level="80">wrap:mvn:com.enterprisemath/em-utils/2.4.0</bundle> > > <bundle > start-level="80">wrap:mvn:mysql/mysql-connector-java/5.1.45</bundle> > > <bundle > start-level="84">wrap:mvn:com.mchange/mchange-commons-java/0.2.11</bundle> > > <bundle > start-level="85">wrap:mvn:com.mchange/c3p0/0.9.5.2$Bundle-SymbolicName=c3p0-0.9.5.2&Import-package=*;resolution:=optional;version=0</bundle> > > <bundle > start-level="85">wrap:mvn:org.springframework/spring-jdbc/4.0.4.RELEASE$Import-package=com.mysql.jdbc;resolution:=optional;version=0,javax.sql;resolution:=optional;version=0,org.apache.commons.logging;resolution:=optional;version=0,org.springframework.util;resolution:=0;version=0</bundle> > > > > <bundle > start-level="90">mvn:com.ge.ip.infra/delta-fadec-prod/3.0.1-SNAPSHOT</bundle> > > </feature> > > </features> > > > > I'm ready to just give up and go back to 3.9_2 however, I fear resource > issues is I do not > > close the workbook when done. > > > > Gary Mills > > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 >
