Timeout powershell command

Question

I'm using ODP.net with Powershell to execute query on my Oracle Database.

I want to time-out the execution of my query. This is my code :

[void][System.Reflection.Assembly]::LoadFile("C:\Oracle.ManagedDataAccess.dll")
$OracleConnexion = New-Object Oracle.ManagedDataAccess.Client.OracleConnection('User Id=test;Password="test";Data Source=10.0.0.0/TEST')

$FluxSiebel = "SELECT * FROM BLABLA"

Try { 

    $OracleConnexion.Open()

}Catch { 

    Write-Output "Connection KO"
    $OracleConnexion
    Exit 2
}


$Query=$OracleConnexion.CreateCommand()
$Query.CommandText=$FluxSiebel

$TimeTaken=  (Measure-Command  {

    $ExecuteQuery=$Query.ExecuteReader()

}).TotalMilliseconds | Out-String

I want to add a timeout of 1minutes on this section of my code : $ExecuteQuery=$Query.ExecuteReader()

How can I do this? I can't find any cmdlet doing this...

Thanks

docs.oracle.com/cd/E51173_01/win.122/e17732/… ?

K L
– K L

2016-02-26 17:15:52 +00:00
Commented Feb 26, 2016 at 17:15 — K L
– K L, Commented Feb 26, 2016 at 17:15

Harald F. · Accepted Answer · 2016-02-26 18:07:12Z

2

Use the CommandTimeout on the Command object returned from CreateCommand()

Example

$cmd=$OracleConnexion.CreateCommand()
$cmd.CommandText=$FluxSiebel
$cmd.CommandTimeout = 60; # 1 minute (60 seconds)

answered Feb 26, 2016 at 18:07

Harald F.

4,8431 gold badge29 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Timeout powershell command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related