2 Replies Latest reply on Oct 3, 2011 7:59 PM by Nigel Deakin-Oracle

    ConnectionFactory in Java stored procedure

    bluefrog
    bluefrog Sep 29, 2011 4:28 PM
      Hi

      I'm new to JMS, in fact I'm new to Java generally speaking.

      Question I have is, can one create a connectionFactory in a Java Stored Procedure on the Oracle Database ?
      If so, how do I go about doing so?


      the example in the documentation;
      http://download.oracle.com/docs/cd/E11882_01/server.112/e11013/jm_opers.htm#i1005974

      shows one how to setup a connectionFactory using a JDBC thin driver, but presumably the driver is not necessary. Not sure either way, and a brief description would be most appreciated.
      • 79 Views
      • Tags:
        • 1. Re: ConnectionFactory in Java stored procedure
          bluefrog
          bluefrog Oct 3, 2011 9:25 AM (in response to bluefrog)
          Perhaps my question should be rephrased.
          Can anyone help with regard to how I can get started with initiating a JMS client session within the Oracle database ?


          The documentation
          http://download.oracle.com/docs/cd/E11882_01/server.112/e11013/jm_create.htm#CIAHHADD
          states that;
          >
          In Oracle Database 10g, you can create as many JMS Sessions as resources allow using a single JMS Connection, when using either JDBC thin or JDBC thick (OCI) drivers.
          >

          So it probably is possible but it sounds as though I have to create a "JMS Connection" first before I can initiate a JMS session, so how do I create a JMS connection to the local database?
          • 2. Re: ConnectionFactory in Java stored procedure
            Nigel Deakin-Oracle
            Nigel Deakin-Oracle Oct 3, 2011 7:59 PM (in response to bluefrog)
            This looks like a question specific to Oracle® Streams Advanced Queuing, so I suggest you ask in the forum for that product:
            Advanced Queueing

            Nigel
            1 person found this helpful