This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,562 Users
  • 2,269,776 Discussions


ConnectionFactory in Java stored procedure

bluefrog LondonMember Posts: 1,512
edited Oct 3, 2011 3:59PM in Java Message Service (JMS)

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;

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.


  • bluefrog
    bluefrog LondonMember Posts: 1,512
    edited Oct 3, 2011 5:25AM
    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
    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?
  • This looks like a question specific to Oracle® Streams Advanced Queuing, so I suggest you ask in the forum for that product:

    Nigel Deakin-Oracle
This discussion has been closed.