wood burning stoves 2.0*
The moose likes Java in General and the fly likes Stored procedure Vs Java prg Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Stored procedure Vs Java prg" Watch "Stored procedure Vs Java prg" New topic
Author

Stored procedure Vs Java prg

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
Hi,
An application which queries a lot the DB to process around 10k records individually and at the same time it also needs some IO operations. I guess it may take around 1 hr. in Java.
Which kind of approach better best suits to do this job.
If its a stored procedure, how flexible is it enough to handle IO,string and amount calculation for a non-PL/SQL programmer.
Does Oracle 9i supports executing Java classes from stored procedure. Is it good prg. practise.
Advise on it.
Thanks,
Anil


SCJP 1.5, SCEA, ICED (287,484,486)
Sean MacLean
author
Ranch Hand

Joined: Nov 07, 2000
Posts: 621
Oracle actually allows you to load, compile and run Java classes directly in the database, so I image that you can call such classes from stored procedures. This area of their site might provide some insight.
http://otn.oracle.com/tech/java/java_db/content.html
Sean
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Stored procedure Vs Java prg
 
Similar Threads
Performance of fomatting string : Java vs Database.
stored procedure
Java Stored procedure vs DB stored procedure
retrieving three resultsets
Stored procedures..