Re: Select hangs in C++

On 17 Dec 1997 19:59:29 GMT, "Gerry West" <gwest_at_skyconnect.com> wrote:

>Given an C++ multi-threaded application accessing embedded SQL ...
>
>We have an intermittent problem involving a simple SELECT.
>
>The function selects a count of specified rows then goes on to process an
>INSERT.
>
>Sometimes it hangs in the SELECT:
>
> /* Select count to determine if page exists */
> EXEC SQL SELECT count(*)
> INTO :iph_count
> FROM page_paging_history
> WHERE page_id = :page_id;
>
>Has anyone ever seen this and if so, have what can be done to handle
>it ?
>
>Thanks in advance,
>Gerry West
>

Since you are multithreaded is it possible one thread is locking the table while doing the insert? Received on Fri Dec 19 1997 - 00:00:00 CST