Thanks Dave, will do. Not getting any response on this at all. It's on stacktrace, here, stacktrace super, If there are any folks out there successfully implementing servicemix bundle poi for 4.0.0_1 your help would be greatly appreciated.
-----Original Message----- From: Dave Fisher <dave2w...@comcast.net> Sent: Wednesday, December 19, 2018 10:38 PM To: POI Users List <user@poi.apache.org> Subject: EXT: Re: how to instrument the apache bundles poi 4.0.0_1 I would suggest that you also reach out to the servicemix project. Take a look at https://github.com/apache/servicemix-bundles/tree/master/poi-4.0.0 where there is active work. Sent from my iPhone > On Dec 19, 2018, at 4:35 PM, Mills, Gary (GE Digital) <gary.l.mi...@ge.com> > wrote: > > 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.servicem > ix.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.RELEAS > E$Import-package=com.mysql.jdbc;resolution:=optional;version=0,javax.s > ql;resolution:=optional;version=0,org.apache.commons.logging;resolutio > n:=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 > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
