wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android 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: 1121

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

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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Monitering Oracle Database using Java
 
Similar Threads
how to use jts in weblogic 6.0
JDBC
how to use jts in weblogic 6.0
JDBC - Where does one begin?
Getting Every Five Record