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

Your Answer:

Login to answer

Other forums

Connection Timeout
I'm using xmii 12.0

I'm calling a transaction as a web service from a windows application

Mass activity scheduling
Hi experts,

Im facing some problems to deal with mass activity jobs.
When I run some

parse error
On my local machine I keep getting parse error for my footer. When I put it online, it doesn't show

Time script, set to my time zone?
I am using this line to get the date and time

Code: $time = date(F." ".d.", &q

My XSRF Prevention code isn't working
First of all, thanks for the generous help you guys have given me in the past on this forum.
Seco

Multi dimensional arrays
If I put in this code:

1
2
3
4
5
6
7
8
9
10
11
12
13<

how can i make a .gif images for my site
Dear Friends ,

Pls solve my problem , I am starting making new site but i dont know how can i

selectbox+database connection retrive problem
Code: [Select]
<tr>
<th align="left" scope="c

Drop Down and text box issue
Is it possible to set a drop down list and text boxes to a certain width?

here is my code

PHP Form to Variable.
Hi! I have written a HTML-form code in DreamWeaver CS3 (in a PHP doc) and I really need it to work s