6 Replies Latest reply on May 20, 2014 11:05 AM by Steven Hawkins

    File source xml importer - TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from

    lightsail pro Newbie

      I am testing importing a xml "http://www.w3schools.com/xml/plant_catalog.xml" using the importer tool. I got the following error when doing preview. I have teiid 8.7 with designer 8.5 apha2 on Windows. Does anyone know what is missing here? Thanks

       

      select * from "SampleXml"."SampleXml"

      org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from [Module "javax.ws.rs.api:main" from local module loader @6d667cff (finder: local module finder @63988175 (roots: C:\Teiid87\jboss-eap-6.1\modules,C:\Teiid87\jboss-eap-6.1\modules\system\layers\base))]


      Elapsed Time:  0 hr, 0 min, 0 sec, 140 ms.

       

      SELECT

       

      A.COMMON AS COMMON, A.BOTANICAL AS BOTANICAL, A.ZONE AS ZONE, A.LIGHT AS LIGHT, A.PRICE AS PRICE, A.AVAILABILITY AS AVAILABILITY

       

      (EXEC SampleXmlSource.invokeHttp('GET', null, 'http://www.w3schools.com/xml/plant_catalog.xml', 'TRUE')) AS f, XMLTABLE('/CATALOG/PLANT' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS COMMON string PATH 'COMMON/text()', BOTANICAL string PATH 'BOTANICAL/text()', ZONE string PATH 'ZONE/text()', LIGHT string PATH 'LIGHT/text()', PRICE string PATH 'PRICE/text()', AVAILABILITY string PATH 'AVAILABILITY/text()') AS A

        • 1. Re: File source xml importer - TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from
          Steven Hawkins Master

          Is this still the same issue as Teiid 8.6 flat file remote url error?

           

          It seems somewhat related to CXF.  Does the same error occur with Teiid 8.6?  Are you running with the EAP 6.1 Alpha?

          • 2. Re: File source xml importer - TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from
            lightsail pro Newbie

            Basically similar issue as in 8.6, but it is better. The local XML file works fine. But remote xml file always gives me the above "ClassNotFoundException" exception. I have Windows 7 x64, jdk 1.6.37, Teiid 8.7, designer 8.5 alpha 2 with latest nightly build, EAP6.1 alpha, JBDS 7.1.1. From what I tested, I have not been able to find a remote file working combination on Windows platform. Does the CXF comes with EAP 6.1 alpha, or do I need install separately. Thanks a lot.

            • 3. Re: File source xml importer - TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from
              lightsail pro Newbie

              I do have two failed service when stating Teiid 8.7 on windows 7. I am not if it is related to the remote file exception.

               

              ======================================================================================================

              08:36:18,326 ERROR [org.apache.catalina.core] (ServerService Thread Pool -- 53)  JBWEB001103: Error detected during cont
              ext /odata start, will stop it
              08:36:18,342 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 53)  MSC00001: Failed to start service jbo
              ss.web.deployment.default-host./odata: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host
              ./odata: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context
                      at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96)
                      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) [rt.jar:1.6.0_37]
                      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_37]
                      at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_37]
                      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_37]
                      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_37]
                      at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_37]
                      at org.jboss.threads.JBossThread.run(JBossThread.java:122)
              Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context
                      at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:161)
                      at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60)
                      at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93)
                      ... 7 more

              08:36:18,358 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1)  TEIID40003 VDB SalesforceVDB.1 is set to ACTIVE
              08:36:18,592 INFO  [org.jboss.as.server] (Controller Boot Thread)  JBAS018559: Deployed "OverdriveVDB.vdb" (runtime-name
              : "OverdriveVDB.vdb")
              08:36:18,592 INFO  [org.jboss.as.server] (Controller Boot Thread)  JBAS018559: Deployed "SalesforceVDB.vdb" (runtime-nam
              e : "SalesforceVDB.vdb")
              08:36:18,592 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 44)  JBAS018559: Deployed "teiid-odata-8.7.0.Fina
              l.war" (runtime-name : "teiid-odata-8.7.0.Final.war")
              08:36:18,592 INFO  [org.jboss.as.controller] (Controller Boot Thread)  JBAS014774: Service status report
              JBAS014777:   Services which failed to start:      service jboss.web.deployment.default-host./odata: org.jboss.msc.servi
              ce.StartException in service jboss.web.deployment.default-host./odata: org.jboss.msc.service.StartException in anonymous
              service: JBAS018040: Failed to start context

              08:36:18,654 INFO  [org.jboss.as] (Controller Boot Thread)  JBAS015961: Http management interface listening on http://12
              7.0.0.1:9990/management
              08:36:18,654 INFO  [org.jboss.as] (Controller Boot Thread)  JBAS015951: Admin console listening on http://127.0.0.1:9990

              08:36:18,654 ERROR [org.jboss.as] (Controller Boot Thread)  JBAS015875: JBoss Teiid + Teiid 8.4 (AS 7.2.0.Alpha1-redhat-
              4) started (with errors) in 11293ms - Started 420 of 507 services (2 services failed or missing dependencies, 82 service
              s are passive or on-demand)
              08:36:18,794 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  TEIID40003 VDB OverdriveVDB.1 is set to ACTIVE

              • 4. Re: File source xml importer - TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from
                Steven Hawkins Master

                I believe those are indicative of the rest easy patch not being applied.  You can follow the rest easy patch instructions from the download page - Downloads · Teiid

                1 of 1 people found this helpful
                • 5. Re: File source xml importer - TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from
                  lightsail pro Newbie

                  The rest easy patch actually fixed the both startup errors and remote file exceptions. Thanks a lot!

                  • 6. Re: File source xml importer - TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from
                    Steven Hawkins Master

                    That's great news.  It seems odd that it has that far reaching of an affect.  We may need to change the download page to indicate that it should be installed even when not using odata.