ODAC NonBlocking problems

ptesone · Post by **ptesone** » Thu 04 Mar 2010 13:25

hi odac team,

My question is very simple, is possible with the ODAC prevent the continuous blocks in the APP when his open a SQL query using NonBlocking = true?

Please try you with this simple SQL and send me the result:

select *
from all_users,all_constraints,all_cons_columns,all_apply_error,
all_apply_table_columns,all_tab_columns,all_tab_comments

I have a open support ticket for this issue for some time and not have any answer of the last four emails. besides your email server in some moment send a error message (Failed Recipient: [email protected]).

===================
Ticket ID: 10852
Department: Dac Team
Priority: Medium
Status: On Hold

Regards,
Peter

ptesone · Post by **ptesone** » Fri 05 Mar 2010 13:09

hi,

Any comment or suggestion?

Regards,
Peter

Challenger · Post by **Challenger** » Fri 05 Mar 2010 13:48

We have answered you by mail. Here is the answer:
It is a known behavior of Oracle 8 Client. There are two global variables, OCIThreaded and OCIMutexed, declared in modue OraCall. By default they are set to True. You can set them to False in initialization section of your main unit. This will solve the problem but can cause other errors.

ptesone · Post by **ptesone** » Fri 05 Mar 2010 14:12

Hi Challenger,

Thanks for answer...

The last week I try your recommendation but the problem remain. I use OCIThreaded := false; OCIMutexed := false; but I got the same problem, when execute a SQL the app is freeze.

I test with a SQL that freeze the application for 7 minutes and other SQL's works well.

This is the only way to solve this problem? The are other way to solve this freeze problem with some SQL's ?

Regards,
Peter

ptesone · Post by **ptesone** » Mon 08 Mar 2010 14:09

Hi Challenger,

I have a question, this problem affect too the NET connection type?

I try the same SQL using the net option and the result is the same that I use the OCI connection.

The are other way to solve this freeze problem with some SQL's ?

Regards,
Peter

ptesone · Post by **ptesone** » Wed 10 Mar 2010 01:01

Hi,

Any suggestion to avoid this problem?

Regards,
Peter

Challenger · Post by **Challenger** » Thu 11 Mar 2010 14:55

Can you send us the script to create server objects that are used in a problem SQL statement?

bengunn · Post by **bengunn** » Fri 08 Oct 2010 07:17

Same problem.
Seems like NonBlocking works only for statement executing, whereas main thread sleep(visually) while fetchin data.
dataset isnt connected to any controls as a datasource, btw
ODAC 6.90.0.52