7 Replies Latest reply: Jun 20, 2008 8:16 AM by 453920 RSS

    Collaboration BPEL an Content DB

    542055
      Hello,

      i have the task to design a document based bpel process for my bachelor thesis, which receives a document from an application and writes it into the content database. But i don't have a clue how to solve this problem...

      The main problem, at the moment, is: How does BPEL communicates with the content DB?
      And which why is the best? AQ Adapter, DB Adapter, Java API???

      I've read a lot about the content db and also about bpel, but i haven't fount anything about the collaboration of these two. I would be glad if somebody have a hint for me, or even better a tutorial/documentation ;)

      thx Matthias
        • 1. Re: Collaboration BPEL an Content DB
          527121
          Hi,

          Here, http://www.oracle.com/technology/products/contentdb/index.html you have the Oracle Content DB Developer Kit, that is the Java API necessary to communicate with Content DB.

          In here, http://download-west.oracle.com/docs/cd/B32119_01/welcome.html you have the documentation about Oracle Content DB.

          You can find BPEL in JDeveloper 10.1.3.1

          I hope that helps, some how...

          Rgds
          • 2. Re: Collaboration BPEL an Content DB
            542055
            Hi, thanks for the quick answer... unfortunately it doesn't help a lot ;)

            In the Content DB Administrator's Guide are only a few pages over the collaboration between bpel and content db....

            The Content DB Developers Kid i've already downloaded and tryed out. But when i run the SetupExamples i get a NPE @ line 306

            java.lang.NullPointerException:java.lang.NullPointerException
            java.lang.NullPointerException
                 at oracle.ifs.examples.api.SetupExamples.main(SetupExamples.java:306)

            It seams that the requestedAttributes and the NamedValues are NULL, dont know why...

            Any ideas for that?

            thx, Matthias
            • 3. Re: Collaboration BPEL an Content DB
              527121
              Hi,

              You have to configure the file runtime.defaults with your data:

              SAMPLE_FILES_PATH=.../cdb_devkit/cdb/sample_files
              You have to put the path of the sample files, from the devkit

              CONTENT_DB_URL=http://<hostname>/content/ws
              the url for your content

              ADMIN_USER_NAME=
              ADMIN_USER_PASSWORD=
              The admin user and password of your content

              SANDBOX_ROOT_PATH=
              the path of content (exº SANDBOX_ROOT_PATH=/oracle/test)
              Oracle is the domain (the SITE) and Test is the name I want to the container

              And you have to put a user that exists:
              SAMPLE_USER1_NAME=
              SAMPLE_USER1_PASSWORD=
              SAMPLE_USER2_NAME=
              SAMPLE_USER2_PASSWORD=

              After this you have to configure the project properties, with the path of the runtime.defaults

              I hope it helps,
              Rgds
              CD
              • 4. Re: Collaboration BPEL an Content DB
                542055
                And you have to put a user that exists:
                SAMPLE_USER1_NAME=
                SAMPLE_USER1_PASSWORD=
                SAMPLE_USER2_NAME=
                SAMPLE_USER2_PASSWORD=
                I forgot to change these ones... I'll try it out Thursday, because tomorrow is official holiday :D
                • 5. Re: Collaboration BPEL an Content DB
                  542055
                  Thanks for the hint, after changing the runtime.defaults the samples are workling...
                  • 6. Re: Collaboration BPEL an Content DB
                    jigark
                    Hi ,

                    Please see Note:353660.1 in metalink. Compiling and Running Oracle Content Services 10.1.x and ContentDB 10.2 Custom BPEL Workflows

                    Hope this will helps.

                    Jigar
                    • 7. Re: Collaboration BPEL an Content DB
                      453920
                      I am learning to develop a web application to connect to content DB to upload and download files. I have a few problems, please help me out. I am using JDeveloper.
                      1. please give more detailed example how to set the SANDBOX_ROOT_PATH.
                      2. I keep getting the "Error locating workspace.

                      Thanks a lot.