There is also an oracle built in UTL_TCP that will allow the database to
connect to a socket.
"I.A. Saez" <i.a.saez.scheihingGEENSPAM_at_tue.nl> wrote in message
news:3DCBC2F2.15CA52B6_at_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 - 08:01:17 CST
