org.apache.servicemix.bundles.poi 4.0.0_1 not osgi deployable can't resolve all dependencies

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

org.apache.servicemix.bundles.poi 4.0.0_1 not osgi deployable can't resolve all dependencies

gmills
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&amp;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

Reply | Threaded
Open this post in threaded view
|

RE: org.apache.servicemix.bundles.poi 4.0.0_1 not osgi deployable can't resolve all dependencies

gmills
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: [hidden email]
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&amp;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

Reply | Threaded
Open this post in threaded view
|

Re: org.apache.servicemix.bundles.poi 4.0.0_1 not osgi deployable can't resolve all dependencies

Freeman-2
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) <[hidden email]> 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: [hidden email]
> 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&amp;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
>

Reply | Threaded
Open this post in threaded view
|

org.apache.servicemix.bundles.poi 4.0.0_1 not osgi deployable can't resolve all dependencies

gmills
Awesome, thank you Freeman!  Greatly appreciate your response and help. I bet this does the trick.  Was having a difficult time find that.  

Happy New Year!

-----Original Message-----
From: Freeman Fang <[hidden email]>
Sent: Sunday, December 23, 2018 6:24 PM
To: [hidden email]
Subject: EXT: Re: org.apache.servicemix.bundles.poi 4.0.0_1 not osgi deployable can't resolve all dependencies

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) <[hidden email]> 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: [hidden email]
> 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.or
> g/POM/4.0.0%20http:/maven.apache.org/maven-v4_0_0.xsd%3chttp:/maven.ap
> ache.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.servicem
> ix.bundles.dom4j/1.6.1_5</bundle>
>
>                               <bundle
> start-level="61">wrap:mvn:org.apache.poi/poi-ooxml-schemas/4.0.1$Dynam
> icImport-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</bu
> ndle>
>
>                               <bundle
> start-level="63">wrap:mvn:org.apache.commons/commons-math3/3.6.1</bund
> le>
>
>                               <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</bun
> dle>
>
>                                <bundle
> start-level="85">wrap:mvn:com.mchange/c3p0/0.9.5.2$Bundle-SymbolicName
> =c3p0-0.9.5.2&amp;Import-package=*;resolution:=optional;version=0</bun
> dle>
>
>                                <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
>