9 Replies Latest reply: Apr 5, 2010 1:40 AM by 458478 RSS

    JCA Adapter Example problem

    439977
      Im getting the following error when i use the jca adapter.
      the DBAdapter.jar is in the library path in adapter.ini.
      It seems strange as it throws bpel errors. do i need to install bpel?

      <MSG_TEXT>There was a problem in starting the bridge.</MSG_TEXT>
      <SUPPL_DETAIL><![CDATA[ORABPEL-12517
      AdapterFrameworkImpl::endpointActivation - Endpoint Activation Error.
      The Resource Adapter was unable to activate the endpoint :{} due to the following reason: ORABPEL-12529
      ManagedConnectionFactory problem.
      Could not instantiate ManagedConnectionFactory oracle.tip.adapter.db.DBManagedConnectionFactory due to: oracle.tip.adapter.db.DBManagedConnectionFactory
      Please make sure the corresponding JCA Resource Adapter has been deployed.

      Please correct the reported issue and redeploy the BPEL process.

           at oracle.tip.adapter.fw.jca.AdapterFrameworkImpl.endpointActivation(AdapterFrameworkImpl.java:522)
           at oracle.oai.agent.adapter.service.ServiceBridge.start(ServiceBridge.java:237)
           at oracle.oai.agent.proxy.AgentProxy.go(AgentProxy.java:672)
           at oracle.oai.agent.proxy.AgentProxy.start(AgentProxy.java:706)
           at oracle.oai.agent.proxy.AgentProxy.<init>(AgentProxy.java:415)
           at oracle.oai.agent.service.AgentService.run(AgentService.java:43)
           at java.lang.Thread.run(Thread.java:534)
      Caused by: ORABPEL-12529
      ManagedConnectionFactory problem.
      Could not instantiate ManagedConnectionFactory oracle.tip.adapter.db.DBManagedConnectionFactory due to: oracle.tip.adapter.db.DBManagedConnectionFactory
      Please make sure the corresponding JCA Resource Adapter has been deployed.

           at oracle.tip.adapter.fw.wsdl.WSDLUtils.setupManagedConnectionFactory(WSDLUtils.java:426)
           at oracle.tip.adapter.fw.jca.AdapterLocator.findResourceAdapter(AdapterLocator.java:182)
           at oracle.tip.adapter.fw.jca.AdapterFrameworkImpl.endpointActivation(AdapterFrameworkImpl.java:321)
           ... 6 more
      Caused by: java.lang.ClassNotFoundException: oracle.tip.adapter.db.DBManagedConnectionFactory
           at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
           at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
           at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
           at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
           at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
           at java.lang.Class.forName0(Native Method)
           at java.lang.Class.forName(Class.java:219)
           at oracle.tip.adapter.fw.wsdl.WSDLUtils.setupManagedConnectionFactory(WSDLUtils.java:419)
           ... 8 more
      ]]></SUPPL_DETAIL>
        • 1. Re: JCA Adapter Example problem
          159563
          Check if all the libraries are in you classpath.
          There is several more libraries concerning BPEL except the DBadapter itself.

          My classpath on Windows Xp is looks like:
          service_classpath=C:\oracle\ic10g\integration\interconnect\lib\iwoic.jar;C:\oracle\ic10g\integration\interconnect\lib\oai.jar;C:\oracle\ic10g\lib\xmlparserv2.jar;C:\oracle\ic10g\jdk\jre\lib\i18n.jar;C:\oracle\ic10g\integration\interconnect\lib\orabpel.jar;C:\oracle\ic10g\integration\interconnect\lib\orabpel-boot.jar;C:\oracle\ic10g\integration\interconnect\lib\orabpel-common.jar;C:\oracle\ic10g\integration\interconnect\lib\orabpel-thirdparty.jar;C:\oracle\ic10g\integration\interconnect\lib\orawsdl.jar;C:\oracle\ic10g\integration\interconnect\lib\bpm-infra.jar;C:\oracle\ic10g\integration\interconnect\lib\bpm-services.jar;C:\oracle\ic10g\integration\interconnect\lib\bcel-5.1.jar;C:\oracle\ic10g\integration\interconnect\lib\connector15.jar;C:\oracle\ic10g\integration\interconnect\lib\DBAdapter.jar;C:\oracle\ic10g\integration\interconnect\lib\toplink.jar;C:\oracle\ic10g\jdbc\lib\classes12.jar;C:\oracle\ic10g\jdbc\lib\nls_charset12.jar;C:\oracle\ic10g\rdbms\jlib\aqapi.jar;C:\oracle\ic10g\rdbms\jlib\jmscommon.jar;C:\oracle\ic10g\jlib\oraclepki.jar;C:\oracle\ic10g\jlib\ojpse.jar;C:\oracle\ic10g\jdk\jre\lib\ext\mail.jar;C:\oracle\ic10g\jdk\jre\lib\ext\activation.jar;C:\oracle\ic10g\integration\interconnect\lib\UserDefinedTransforms.jar;C:\oracle\ic10g\lib\dms.jar;C:\oracle\ic10g\opmn\lib\ons.jar;C:\oracle\ic10g\diagnostics\lib\ojdl.jar;C:\oracle\ic10g\lib\http_client.jar;C:\oracle\ic10g\jlib\javax-ssl-1_2.jar;C:\oracle\ic10g\jlib\jssl-1_2.jar


          P.S. BPEL - because this is JCA DBadapter (not proprietary DB interconnect adapter) was taken from BPEL initially.
          And this JCA adapter will be common for BPEL and InterConnect.
          • 2. Re: JCA Adapter Example problem
            439977
            i checked them in the service classpath. checked to see if the jar was there and sure enough..
            • 3. Re: JCA Adapter Example problem
              511304
              Try putting the BPEL likerelated jar files orabpel.jar, BPM_infra.jar etc in the begining of the classpath.
              • 4. Re: JCA Adapter Example problem
                439977
                do i need to install bpel? on the middle tier?...

                service_classpath=E:\Oracle\Fusion\101202\integration\interconnect\lib\orabpel.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\orabpel-boot.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\orabpel-common.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\orabpel-thirdparty.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\orawsdl.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\bpm-infra.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\bpm-services.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\DBAdapter.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\iwoic.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\oai.jar;E:\Oracle\Fusion\101202\lib\xmlparserv2.jar;E:\Oracle\Fusion\101202\jdk\jre\lib\i18n.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\bcel-5.1.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\connector15.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\toplink.jar;E:\Oracle\Fusion\101202\jdbc\lib\classes12.jar;E:\Oracle\Fusion\101202\jdbc\lib\nls_charset12.jar;E:\Oracle\Fusion\101202\rdbms\jlib\aqapi.jar;E:\Oracle\Fusion\101202\rdbms\jlib\jmscommon.jar;E:\Oracle\Fusion\101202\jlib\oraclepki.jar;E:\Oracle\Fusion\101202\jlib\ojpse.jar;E:\Oracle\Fusion\101202\jdk\jre\lib\ext\mail.jar;E:\Oracle\Fusion\101202\jdk\jre\lib\ext\activation.jar;E:\Oracle\Fusion\101202\integration\interconnect\lib\UserDefinedTransforms.jar;E:\Oracle\Fusion\101202\lib\dms.jar;E:\Oracle\Fusion\101202\opmn\lib\ons.jar;E:\Oracle\Fusion\101202\diagnostics\lib\ojdl.jar;E:\Oracle\Fusion\101202\lib\http_client.jar;E:\Oracle\Fusion\101202\jlib\javax-ssl-1_2.jar;E:\Oracle\Fusion\101202\jlib\jssl-1_2.jar

                still getting:

                <MSG_TEXT>There was a problem in starting the bridge.</MSG_TEXT>
                <SUPPL_DETAIL><![CDATA[ORABPEL-12517
                AdapterFrameworkImpl::endpointActivation - Endpoint Activation Error.
                The Resource Adapter was unable to activate the endpoint :{} due to the following reason: ORABPEL-12529
                ManagedConnectionFactory problem.
                Could not instantiate ManagedConnectionFactory oracle.tip.adapter.db.DBManagedConnectionFactory due to: oracle.tip.adapter.db.DBManagedConnectionFactory
                Please make sure the corresponding JCA Resource Adapter has been deployed.

                Please correct the reported issue and redeploy the BPEL process.

                     at oracle.tip.adapter.fw.jca.AdapterFrameworkImpl.endpointActivation(AdapterFrameworkImpl.java:522)
                     at oracle.oai.agent.adapter.service.ServiceBridge.start(ServiceBridge.java:237)
                     at oracle.oai.agent.proxy.AgentProxy.go(AgentProxy.java:672)
                     at oracle.oai.agent.proxy.AgentProxy.start(AgentProxy.java:706)
                     at oracle.oai.agent.proxy.AgentProxy.<init>(AgentProxy.java:415)
                     at oracle.oai.agent.service.AgentService.run(AgentService.java:43)
                     at java.lang.Thread.run(Thread.java:534)
                • 5. Re: JCA Adapter Example problem
                  511304
                  No. You don't need to install BPEL. Also, Make sure the DB Connection parameters are adapter.ini are correct.
                  • 6. Re: JCA Adapter Example problem
                    439977
                    yeap. theyre correct.
                    • 7. Re: JCA Adapter Example problem
                      470574
                      Possibly you need to configure interconnect classpath in opmn.xml
                      • 8. Re: JCA Adapter Example problem
                        42367
                        Edit opmn.xml and add toplink.jar and DBAdapter.jar in the environment section.

                        Example:
                        <ias-component id="InterConnect" status="enabled">
                        <environment>
                                  .......
                        <variable id="CLASSPATH" value="$ORACLE_HOME/integration/interconnect/lib/DBAdapter.jar" append="true"/>
                        <variable id="CLASSPATH" value="$ORACLE_HOME/integration/interconnect/lib/toplink.jar" append="true"/>
                        </environment>
                        • 9. Re: JCA Adapter Example problem
                          458478
                          Hi,

                          Looks like the eis connection that you are using in your JCA code is erroring out.
                          Please modify for a valid eis connection and then compile.
                          This will fix your issue.

                          Thanks,
                          Vijay.B