Multithreading in Oracle (Java, SQLJ, Pro*C,??) on 10g


Posted on 16th Feb 2014 07:03 pm by admin

I am investigating how to run a Java stored procedure in multithread mode.
I know that if I change the program to be multithreaded, the Database runs it fine, but it will not show any concurrency because the JVM uses a preemptive model and all threads become a single thread.
I also read parts of the SQLJ manual where multithreading.
I'm guessing this SQLJ program must reside on the Server outside of the DB to be able to run concurrently.
But if I call it from the DB (say a PL/SQL package) wouldn't be running on the DB?

Any help on this will be appreciated.
Thanks

No comments posted yet

Your Answer:

Login to answer
206 Like 37 Dislike
Previous forums Next forums
Other forums

How to ... (FAQs)
... get e-mail notifications As several people asked how to get e-mail notifications when new posti

Multiple submit forms inside a mysql array page
Hi all,

Im having trouble to get the beneath script to work the thing i can't seem to get wor

Parse error: syntax error, unexpected $end in
hello,
i receive the error :Parse error: syntax error, unexpected $end in C:xamppxampphtdocsh

PHP4 to PHP5 Conversion
Hi Everyone,

I am working on a site that is built up on PHP4 and each page is being started f

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide

array & querys help/advice.
Ok so here goes , I have a mysql database and basically here's what I need to do.

// foreach

Can anyone give me some link on .htaccess tutorial
i wish to have friendly url using .htaccess, but no idea yet about this

Hope that anyone cou

PHP Surveys
I really would like some advice.

If you have a client come to you asking for a survey to be d

check if string contain only a-z/A-Z
Is where any way to check if string contains only a-z/A-Z, without writing an array with all possibl

problems with contact forms that are only protected against SQL injections
What could be a potential problem with contact forms that are only protected against SQL injections

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash