File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Monitering Oracle Database using Java

 
R.A.Partha sarathy
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 11962
5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic