RE: How should I connect to BEA Weblogic from a pl/sql procedure and is this a stable connection.
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Aug 2004 08:03:21 -0500
Jaco
One approach might be to create a Java procedure in your database. Your
PL/SQL could call this, and in turn it could access your Java service. I
think the methods for PL/SQL to call a Java procedure are pretty well
documented. But you may find the performance may not meet your expectations.
There are probably several alternative configurations, so keep your mind
open.
There aren't too many Java developers on this forum in my experience (but
many of us are Java victims). Consider going to forums.oracle.com and asking
your question on a Java forum. My guess is that you are more likely to find
people that develop Java and PL/SQL for Oracle.
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you're on the wrong road, progress means
doing an about-turn and walking back to the right road; in that case,
the man who turns back soonest is the most progressive."
-- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of J.Polet@xxxxxxxxx
Sent: Wednesday, August 18, 2004 2:12 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: How should I connect to BEA Weblogic from a pl/sql
procedure and is this a stable connection.
Dennis,
Thanks for your reply.
> Jaco - I saw you received one reply. Did this answer your question? I
> briefly discussed your question with my WebLogic administrator and he
felt
> you needed to clarify what you are trying to do. Are you trying to start
> Weblogic, or connect to an application that is running under Weblogic?
> Normally Oracle acts as a resource for WebLogic, so the normal connection
> goes from WebLogic to Oracle.
I have missed the one reply you mentioned and I couldn't find it in the
archive.
To clarify my question:
We are trying to start an application that is running under Weblogic.
An example might make it clear:
In Weblogic we have a program (we call it a service) which validates an
address / zipcode combination.
In Oracle we have a pl/sql procedure which inserts a customer together with
his/hers address and zipcode in a table. Within this procedure we would
like to test whether the combination address and zipcode is valid by using
the service in weblogic.
I hope this carifies my question.
Jaco
(Embedded image moved to NL Telephone: +31 (0) 10 224 2045
file: pic12623.gif)Robeco E-mail: J.Polet@xxxxxxxxx
Jaco Polet
Corporate ICT/BS DBA
-- Binary/unsupported file stripped by Ecartis --
-- Type: image/gif
-- File: pic12623.gif
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
