Forum Stats

  • 3,757,770 Users
  • 2,251,264 Discussions
  • 7,869,910 Comments

Discussions

ConnectionFactory in Java stored procedure

bluefrog
bluefrog Member Posts: 1,512
edited Oct 3, 2011 3:59PM in Java Message Service (JMS)
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.

Answers

  • bluefrog
    bluefrog Member 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
    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?
  • This looks like a question specific to Oracle® Streams Advanced Queuing, so I suggest you ask in the forum for that product:
    3068

    Nigel
    Nigel Deakin-Oracle
This discussion has been closed.