How to set Execution Timeout for OracleScript?

ddeml77 · Post by **ddeml77** » Thu 14 Jun 2007 09:21

Hello,

apparently we have the problem reported here if we try to execute an OracleScript with an OracleConnection in direct mode.

We are using OraDirect Version 4.0.14.

However, i was not able to find out how to increase the execution timeout - neither in OracleConnection not in OracleScript. Does somebody know how to solve this?

Thanks for any help!

Greetings - Richie

Alexey · Post by **Alexey** » Thu 14 Jun 2007 13:16

Unfortunately, there is no execution timeout currently.
We are going to provide appropriate property in the nearest future. It will be called OracleScript.CommandTimeout.

ddeml77 · Post by **ddeml77** » Fri 15 Jun 2007 15:46

Alexey wrote:It will be called OracleScript.CommandTimeout.

Is this going to be the timeout for execution of the complete script? Or is this timeout value going to count for each command within the script?

Alexey · Post by **Alexey** » Mon 18 Jun 2007 06:56

It is going to be the timeout for maximum pause from a server during the execution of the script.

ddeml77 · Post by **ddeml77** » Mon 18 Jun 2007 08:09

I see. Thank you for your information!

Alexey · Post by **Alexey** » Mon 18 Jun 2007 08:26

You are welcome.

Alexey · Post by **Alexey** » Thu 21 Jun 2007 09:22

Said property is implemented.
Look forward to the next build.

ddeml77 · Post by **ddeml77** » Tue 07 Aug 2007 13:23

Hey Alexey,

I just downloaded the most current licensed version of OraDirect .NET Professional for .NET Framework 2.0 dated 25.06.07. The Version of CoreLab.Data.dll is 4.0.11.0 and the Version of CoreLab.Oracle.dll is 4.0.15.0.

However I still did not find the craved property OracleScript.CommandTimeout. Since the date of your post about acknowledgement that the property is implemented laid a few days before the release date of the most current library versions, I hoped that the property is already available.

When can I expect the first release that supports a command timeout in the class OracleScript?

Greetings - Richie

Alexey · Post by **Alexey** » Tue 07 Aug 2007 13:58

This was implemented on a base level (DbScript).

ddeml77 · Post by **ddeml77** » Tue 07 Aug 2007 14:08

I see: Class DbScript is implemented in assembly CoreLab.Data.dll. The Timestamp of version 4.11.0 of this dll is 18.05.2007.

When can I expect the first release that supports a command timeout for class OracleScript?

Alexey · Post by **Alexey** » Wed 08 Aug 2007 14:40

CommandTimeout property is supported in this latest version. You'll see it in the Properties window.

ddeml77 · Post by **ddeml77** » Tue 21 Aug 2007 11:26

Hello Alexey,

I downloaded the most current version of OraDirect .NET Professional version 4.00.16 (13.08.07). I still cannot find the "CommandTimeout" property - neither in class DbScript not in class OracleScript.

I try to find the property by investigating the OracleScript class in the Object browser. The IntelliSense has no knowledge about the Property as well. Also i added an OracleScript as component to a Windows.Forms class. The Properties window (right click on the "oracleScript1" component and selecting "Properties"), I find the Properties "Connection", "ScriptText", "GenerateMember" and "Modifiers", but no Porperty "CommandTimeout".

Actually, I still dont know how to access or modify the Command Timeout with the most current Version of OraDirect .NET Professional version 4.00.16 (13.08.07).

Would you be so kind and send me a sample project that set the CommandTimeout property or give me a step-by-step-explanation how to make the CommandTimeout property visible in the Properties window?

I noted that the version of assembly CoreLab.Data.dll is still 4.0.11.0. And since DbScript is implemented in there, could be possible that you use a more current version of the assemblies which are not accessible to me?

Greetings - Richie

Alexey · Post by **Alexey** » Wed 22 Aug 2007 07:52

It is strange that you don't see this property.
Anyway, we are going to release OraDirect .NET 4.20 tomorrow. Please wait a bit.