CRecordset probelem

[learner123]

Hello ,
I create a CDatabase object in thread1 , I open a connection to data base in thread1 , I create a Recordset in thread one using this database object , all is success.
I use the same database object in thread 2 , the connection was alreadu made in thread1 , I create a RecorSet object using this CDatabase in thread2 , I say
RecordSet.Open() it hangs .

WHy ?
What should I do , WHat is wrong ?

[vmadhipatla]

if you are using oracle, oracle allows only one query per connection at any point of time.
so you are trying to use the same database connection in both the threads which translates to more queries per connection and oracle will
process the queries in that db connection serially.

[vmadhipatla]

provided your query in thread1 is still in progress and you are trying to open another recordset in thread2