How to set Execution Timeout for OracleScript?

How to set Execution Timeout for OracleScript?

Postby 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
ddeml77
 
Posts: 14
Joined: Thu 14 Jun 2007 08:56
Location: Germany

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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?
ddeml77
 
Posts: 14
Joined: Thu 14 Jun 2007 08:56
Location: Germany

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby ddeml77 » Mon 18 Jun 2007 08:09

I see. Thank you for your information! :)
ddeml77
 
Posts: 14
Joined: Thu 14 Jun 2007 08:56
Location: Germany

Postby Alexey » Mon 18 Jun 2007 08:26

You are welcome.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Thu 21 Jun 2007 09:22

Said property is implemented.
Look forward to the next build.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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
ddeml77
 
Posts: 14
Joined: Thu 14 Jun 2007 08:56
Location: Germany

Postby Alexey » Tue 07 Aug 2007 13:58

This was implemented on a base level (DbScript).
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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?
ddeml77
 
Posts: 14
Joined: Thu 14 Jun 2007 08:56
Location: Germany

Postby Alexey » Wed 08 Aug 2007 14:40

CommandTimeout property is supported in this latest version. You'll see it in the Properties window.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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
ddeml77
 
Posts: 14
Joined: Thu 14 Jun 2007 08:56
Location: Germany

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle