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

Hi guys,

Thanks all for replying. I actually *have* to use java so plsql isnt an option. I dont have time to learn it in that sort of detail anyway.

The clients are written in java and they will be told when certain events of interest to dba types occur. The specifi event it responds to doesnt really matter i dont think because I might only implement very basic proof of concept event/trigger pairs. Remember I'm not an oracle guru im just a student!

So, do you all think it will be easy to use java in the the database just as it is used outside the database.

Sincerest thanks to those who have offered their thoughts

Take care

Simon

"Matthias Rogel" <rogel_at_web.de> wrote in message news:aqgm3h$9vtil$1_at_ID-86071.news.dfncis.de...
> hi simon,
>
> yeah, plsql and java is the right way to go.
>
> i had a similar problem: alerting clients asynchronously from the
> database. (even clients not connected to the database)
>
> i chose RMI, which works great: clients implement a callback-interface
> just load the compiled stubs and the rest of your code (already
> compiled) into oracle and build a PL/SQL-wrapper.
>
> best of luck,
> mr
>
>
>
> 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 - 09:56:56 CST