This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Monitering Oracle Database using Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Monitering Oracle Database using Java" Watch "Monitering Oracle Database using Java" New topic
Author

Monitering Oracle Database using Java

R.A.Partha sarathy
Greenhorn

Joined: Sep 30, 2003
Posts: 9
HI
pls help me out in the following problems.

Problem 1:
I have a database which dynamicaly updates or grows.i have to write a Java program which fetches records when there is change or update or new entry in the database.so my program should always moniter the status of the database.we can write this program using plain java or servlets or jms or databse triggers or java stored procedures or threads.give me solution with a sample program.database is Oracle 8.1.7.
Problem 2:
How to convert my ResultSet object to Hashtable.with sample programs
Problem 3:
How to make a XML Document from the data got by a SQL Query using JDBC.with sample program.
regards
Sarathy(Sun_Sarathy@yahoo.com)
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
I have a database which dynamicaly updates or grows.i have to write a Java program which fetches records when there is change or update or new entry in the database.so my program should always moniter the status of the database.we can write this program using plain java or servlets or jms or databse triggers or java stored procedures or threads.give me solution with a sample program.database is Oracle 8.1.7.
Visit Oracle Technology Network. They have all kinds of sample code demonstrating Oracle features.
How to convert my ResultSet object to Hashtable.with sample programs
How about describing what do you want the Hashtable to look like?
How to make a XML Document from the data got by a SQL Query using JDBC.with sample program.
Again, this depends quite a lot on what do you want your XML document to look like. If you're using Oracle, I'd suggest taking a look at their documentation (Oracle has some fancy built-in XML features).


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1131

Lasse,
For your information, Sarathy has already received some replies to this very same question that (s)he posted to the Oracle Technology Network Forums, so I'm assuming (s)he already knows about "OTN" ;-)
Good Luck,
Avi.
[ October 13, 2003: Message edited by: Gregg Bolinger ]
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

Originally posted by Avi Abrami:
Lasse,
For your information, Sarathy has already received some replies to this very same question that (s)he posted to the Oracle Technology Network Forums, so I'm assuming (s)he already knows about "OTN" ;-)
Good Luck,
Avi.

Why does your Very Same Question link take us to a JCalendarCombo Project Page? Please do not do this.


GenRocket - Experts at Building Test Data
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1131

That was a genuine mistake. I feel like a real idiot. Please accept my apologies. I meant this URL:
http://forums.oracle.com/forums/thread.jsp?forum=99&thread=205907&tstart=0&trange=15
Sorry,
Avi.
 
Consider Paul's rocket mass heater.
 
subject: Monitering Oracle Database using Java