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

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



Tue, 26 Apr 2005 21:48:29 GMT
 Using java to create a socket in oracle. Gulp :)

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

Quote:

> 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



Tue, 26 Apr 2005 21:58:10 GMT
 Using java to create a socket in oracle. Gulp :)
There is also an oracle built in UTL_TCP that will allow the database to
connect to a socket.

Quote:
> 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


> > 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



Tue, 26 Apr 2005 22:01:17 GMT
 Using java to create a socket in oracle. Gulp :)

What kind of events do you wish to notify to the client ?

Have you looked at DBMS_ALERT package or the Management Server.

Quote:
> 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



Tue, 26 Apr 2005 23:07:18 GMT
 Using java to create a socket in oracle. Gulp :)
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


Quote:

> What kind of events do you wish to notify to the client ?

> Have you looked at DBMS_ALERT package or the Management Server.


> > 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



Tue, 26 Apr 2005 23:23:38 GMT
 Using java to create a socket in oracle. Gulp :)
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

Quote:

> 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



Tue, 26 Apr 2005 23:43:44 GMT
 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


Quote:
> 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


> > 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



Tue, 26 Apr 2005 23:56:56 GMT
 
 [ 7 post ] 

 Relevant Pages 

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

2. Access Oracle DB Using Java App (created using Jbuilder 3)

3. Oracle 8i Java Stored Procs and Sockets

4. ORacle 8.1.5 Sockets and Java

5. JDBC error calling an Oracle procedure using thin driver (No more data to read from socket)

6. ---JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA---

7. Get a free training in creating a persistent Java application without using JDBC

8. creating an auction site using java servlets

9. using Java and data created in C/C++

10. create java class using bfile

11. Creating Stored Procedures using Java

12. Creating a datasource inside a Java application using avaible drivers


 
Powered by phpBB® Forum Software