Pavan,
> hi
> i sending procedure as attachments that is called by java program.
> please get it from attachments.
> i creates 15 worker threads and there is queue for job.
> worker threads get job from queue if it there and do some db
> operation.
> and wait if there is no job in queue. there is another thread that
> push
> job in queue.
> since whole processing takes time.....so worker threads always find
> job
> in queue.
Did you ever resolve this issue? I had a similar thread running on
this recently:
http://archives.postgresql.org/pgsql-jdbc/2006-01/msg00124.php
and I haven't any closer on your thread, either.
-David
David Hustace
The OpenNMS Group, Inc.
Main : +1 919 545 2553 Fax: +1 503-961-7746
Direct: +1 919 827 1201 Skype: dhustace
Key Fingerprint: 8EC1 F319 2C1D 3197 AAB9 580F FACD 1D19 175E D903