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

How can I get my program to read a larger array ??
Hi:

I have this program that reads from an array to do calculations. The array are just t

extract content from a website
i have written a code that will grab the content from the index page..
i would like to know how c

Default TimeZone
The server I'm working with is hosted in America so all times inserted into the database are coming

send() and recv() parameters confusion
On server Side:
int recv (Socket,Buffer, Length, Flags)
On Client Side:
int send (Soc

Needing Youtube thumb nail fix.
I have a script on a site that pulls in you-tube videos,
The problem is, that the thumb nails for

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

Matchcode in ALV change header column
Hello everyone,

I am working in an SAP system that is currently in upgrade and conversion

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s

Error in SQL Syntax HELP!!!
I have this page:

Code: <?php

session_start();

//connect to server and s