-
1. Re: Calling EJB from inside Oracle Database
guy_rouillier Mar 5, 2004 11:02 PM (in response to osoe)Search the archives from last year. Some of us have gotten this to work. We talked about coordinating efforts but that didn't happen. I've never seen any formal instructions, we all just kind of hacked at it. And your approach is the one we used - just load all the JBoss client jars and your client jars into Oracle. I'm sure we could pare that down dramatically if we could muster a group to work on it, but that approach will get you started.
-
2. Re: Calling EJB from inside Oracle Database
osoe Mar 7, 2004 11:45 AM (in response to osoe)Thanks for your reply. I tried searching the archive with out much luck. I would appreciate if you could post the URL. (May be I am asking too much)
Thanks -
3. Re: Calling EJB from inside Oracle Database
nickman Mar 8, 2004 7:21 AM (in response to osoe)I added the doc to the jboss wiki:
http://jboss.org/wiki/Wiki.jsp?page=oracleejb.html
The formating is giving me agro, but if you hit the link above directly, it should work.
//Nicholas -
4. Re: Calling EJB from inside Oracle Database (the right way t
nickman Mar 8, 2004 7:39 AM (in response to osoe)Following up on this issue, I am also [very late on] working on an Oracle Cache Invalidation bridge. While studying up on this, I have concluded that the direct invocation of EJBs , and other services in JBoss via RMI or HTTP is probably not optimal. It is just too unstable, and I question Oracle commitment to maintaining a current VM inside the database.
On the other hand, their messaging solution is very stable (and the grapevine says soon to be much improved over all). I see this as a better solution ttowards implementing an invocation layer over JMS to JBoss from Oracle. Something like this:
Oracle (PL/SQL Block Somewhere) ---> Invoke Internal Java Class (Bridge Client) ---> Package Invocation ---> Send Invocation Over OracleAQ (wait for response) ---> JBoss Resident Oracle Invocation Bridge Server ----> Receive Message --> Unpack Invocation ---> Pass to standard Invoker ---> Send Response Back to Caller.
(The chapter on the detached invokers in the Admin docs made it all clear)
In progress...... -
5. Re: Calling EJB from inside Oracle Database
osoe Mar 9, 2004 10:04 AM (in response to osoe)Excellent WIKI doc and I like the messaging approach.
A question regarding step 2 on the "How to call JBoss EJBs From the Oracle Internal VM". Why do I have to recompile all the invalid classes if I use JBOSS 3.2.3 with Oracle 9i (JDK1.3.1)
Thanks