Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using java to create a socket in oracle. Gulp :)

Re: Using java to create a socket in oracle. Gulp :)

From: I.A. Saez <i.a.saez.scheihingGEENSPAM_at_tue.nl>
Date: Fri, 08 Nov 2002 14:58:10 +0100
Message-ID: <3DCBC2F2.15CA52B6@tue.nl>


Simon,

What type of clients are we talking about? A bunch of dba's who should be alerted
about certain db events? if so then take a look at Oracle Entreprise Manager (Oem).
In oem you can specify events and fixit jobs.

kind regards,

Ivan

Simon Harvey wrote:

> Hi guys,
>
> I'm doing my final year university project and have a question that
> hopefully has a fairly straightforward answer.
>
> My project is about getting oracle to alert clients when certain events take
> place.
>
> I dont know if these are my only options but all I know of that might be
> able to achieve this is plsql and java. Seeing as I have studied java for 4
> years I am wanting to go down the java route. The client apps will likewise
> be written is java.
>
> My question probably begins with - is java ok to do this in, given that i
> have a limited timescale and knowledge of how java integrates with the
> database? I have used oracle for a while to play about with but I'm not
> completely clear what the limitations of the oracle jvm is.
>
> Now the real question. I think I'll want to open a socket using the oracle
> jvm so that the database can send information to the clients. Is this
> possible?
>
> I've been looking into how java and oracle get along and you seem to have to
> load the classes into the database and then perhaps fire them with a simple
> trigger. Is there anything more complicated than that? Is there anything i
> should watch out for?
>
> I know how to do socket to socket connection in java already so I'm really
> really hoping that the oracle version will be essentially identical.
>
> Ok, my final question is if the oracle jvm adds any functionality? In
> particular is there any easier way to get at table information, or do you
> still have to use jdbc?
>
> Thank you so much to anyone who could shed some light on this for me. It
> seems like a really exciting idea to have java in a database. I've been
> wondering for ages what the term oralce application can mean but this is
> beginning to give me a clearer example
>
> Kind regards
>
> Simon
Received on Fri Nov 08 2002 - 07:58:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US