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: [email protected] 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
