rajni
New User
Oct 18, 2016, 12:14 AM
Post #1 of 1
(24750 views)
|
|
Perl threading with DBI insertion
|
Can't Post
|
|
Hi,
I am facing problem in multithreading with perl. I have created 5 threads and executing all at a time, during data insertion in database I am facing problem here I am inserted ‘function Name’ with ‘cdets id’ . During insertion in data base mapping problem is coming. ‘Function name’ and ‘cdets id ‘ is mismatching during insert query.
Example:
I have 10 CDETS with 70 function. After threading process for 10 cdets in database results are showing 8 CDETS with 70 functions.
Here 2 CDETS are missing and its function updated in database with other cdets functions.
Note: SELECT LAST_INSERT_ID() is also not working with multithreading here.
Below is sample code:
use threads;
foreach my $id (@ddts) {
my $thread_1 = threads->create(\&ExecuteCommand, "$id");
$count1++;
if ($count1>=5){
$thread_1->join();
$count1=0;
}
}
How can I run all threads at a time by creating multiple database handlers.
Could anyone please help/guide me in troubleshooting this issue.
Any pointers would be helpful.
Thanks,
Rajni
|
MAIN
SEARCH
WHO'S 
LOG 