6 Replies Latest reply on Jan 28, 2007 12:23 PM by koen.aers

    [Beginner] How to call a stored procedure in a Task ?

      Hi all,
      can anybody tell me how to execute a custom Java Code from a Task ? I need to recall an Oracle stored procedure and evaluate its return value from the Task.....
      Thanks
      Francesco

        • 1. Re: [Beginner] How to call a stored procedure in a Task ?

          Francesco,

          First, I wonder if you really mean a Task?
          Is the primary work assigned to a person or other external agent?
          If not, you probably just want a Node.

          See http://docs.jboss.org/jbpm/v3/userguide/processmodelling.html#actions

          If you haven't already, please study the user guide before posting any more questions.

          -Ed Staub

          • 2. Re: [Beginner] How to call a stored procedure in a Task ?
            kukeltje

            Your the man Ed... thanks

            • 3. Re: [Beginner] How to call a stored procedure in a Task ?

              Listen,
              I have to decide if jBoss jBPM could replace a vendor solution for a Client of us.
              I have written twice to this forum asking for a guideline but I have been sent to the User forum.......(why are we talking about jBPM or not ????)

              I have written to jBoss Europe asking for assistence (rewarded assistence!) ...still nothing...and I mentioned it's for a critical project......

              I try to call by phone jBoss Europe but the phone is permanentely engaged.....

              So all they give you is a link to a document, read it and shut up!
              And you really think people is going to invest real $$$$ on this ??????
              On a link to a document ?????

              Better finding a SERIOUS company......
              Good luck !

              • 4. Re: [Beginner] How to call a stored procedure in a Task ?
                kukeltje

                Sorry, but the answer Ed gave is the correct one.... actions are java classes and in those you can do (almost ) everything you can do from normal java so this includes calling databases via jdbc with prepared statements stored procedures or whatever.

                My even shorter answer would have been:

                like you do from normal java

                Would you have been happier with that?

                The fact that you have problems getting into touch with jboss europe should *not* be directed at us, normal non-jboss affiliated people. So unless you come with questions like:

                I tried implementing an actionhandler that calls a stored procedure via jdbc and get this error. The code I use is this, the config is this and it does not do what I expect.


                The answer Ed gave is the best we can do in our spare time. Regardless of your priority or seriousness of a possible client. And we NEVER explicitly said to shut up, we never would. Things like RTFM/STFF or related comments will come by now and then and with good reason.

                Your reaction on the other hand is typical:
                http://wiki.jboss.org/wiki/Wiki.jsp?page=BadPosts
                http://www.catb.org/~esr/faqs/smart-questions.html




                • 5. Re: [Beginner] How to call a stored procedure in a Task ?
                  cpob

                   

                  "fmarchioni" wrote:

                  Better finding a SERIOUS company......
                  Good luck !


                  Like what Ronald mentioned... this is an open-source project, and this forum is maintained by developers/users of jBPM, not paid JBoss employees.

                  We see way too many posts where people want to know how to do the simplest things, without doing the proper research themselves.

                  jBPM is simple to understand if you just poke around the code, forums, wiki, etc. There's no crazy techniques or ideas at work here. Just plain ol' Java.

                  • 6. Re: [Beginner] How to call a stored procedure in a Task ?
                    koen.aers

                    That being said, if you are interested in professional help, please contact the sales organisation at sales@jboss.com or send us a private email. A good way to kickstart with jbpm is to go to one of our public trainings.

                    Regards,
                    Koen