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>"> <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
