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

[Need Help] php timing issues
I don't know what is going wrong. I need some help with being able to set an image at 9:00am Colorad

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Echo-ing MySQL content and Keep Formatting?
I have data in my MySQL such as:

QuoteBlah blah

Blah blah

etc
but when i ech

help need on ob_start()
Hi

I am a newbie in php, I have a code
Line number On/Off | Expand/Contract <?phpo

Kill a process
I have a question - how can I kill a process from a command line or by using Oracle SQL Developer? I

Accessing Infotype data in dialog program
Hi All
In Dialog programs attributes I didn't see any logical database field. How can I access

Allegro crashes when running load_bitmap. Why?
I can not get Allegro to load any BMP images. Here is a section of test code. The picture is in the

Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_

asking for direction
I have 2 tables in my data, which are "post" and "event"
I won't make a summa

PHP hyperlinks generator
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500