Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

Mapping Of Oracle procedures to Java

  Asked By: Daisy    Date: Nov 28    Category: Java    Views: 649

Problem is:

I am doing all Database related transactions in Oracle
Packages and Stored Procs.

Here I was utilizing in built Oracle features of doing

There are numerous update queries which are executed that
results in locking

of the tables for the substantial amount of time. These
locks are released at the time of

commit only.

Now I want to convert Orcale Procs to java and use
Multithreading also.

I want to know java in built features which can be directly
mapped to those of Oracles.

This will reduce my work of doing things manually.

Moreover efficiency of such self designed java programs will also be an

Has Any1 done the same before.

Help me with the relevant docs or link to the same.



2 Answers Found

Answer #1    Answered By: Saxon Anderson     Answered On: Nov 28

I recently took a class on this subject, where the
professor posted some chapters of his upcoming book
online in pdf format. Now the information that he
posted is good for Access, MySQL, as well as Oracle.
I think you'll find it handy.


Answer #2    Answered By: Geraldine Perkins     Answered On: Nov 28

also have a look at the oracle  documentation regarding the JVM
executed by the Oracle DBMS kernel itself. Are you a member of the
Oracle Tech Network (OTN)? If not, log in to http://otn.oracle.com
and sign up as a new user; then you have access to lots of
documentation, among which you should also find doc's about Java on
Oracle. They have integrated a JVM into the Oracle kernel since 8i.
Unfortunately I haven't had the time  to cope with this subject yet,
so I can't give any direct advice.

Didn't find what you were looking for? Find more on Mapping Of Oracle procedures to Java Or get search suggestion and latest updates.