Search the newsgroup for dbms_alert. While it is probably possible to open
a socket inside Java in the database. I would use a package that Oracle
already supplies. dbms_alert will handle it nicely; sure it doesn't solve
it with the solution you have chosen, but it probably meets your business
needs.
Jim
"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
news:HqQy9.27487$zX3.68522_at_news.indigo.ie...
>
> What kind of events do you wish to notify to the client ?
>
>
> Have you looked at DBMS_ALERT package or the Management Server.
> "Simon Harvey" <ReplyToGroup_at_thanks.com> wrote in message
> news:GgPy9.4562$dz2.416492_at_stones...
> > 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 - 09:23:38 CST
