Select hangs in C++

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 Received on Wed Dec 17 1997 - 00:00:00 CST