3 Replies Latest reply on Apr 18, 2011 10:03 AM by Steven Hawkins

How to set query Timeout in Teiid 7.3

Rakesh Balguri Apr 16, 2011 10:50 AM

Hi,

Can anyone tell me how to set the query timeout in Teiid 7.3

I want to set the query timeout to 60 seconds and if the query takes more time to execute than 60 seconds it should throw some exception.

Can anyone tell me how and where we configure this to set the timeout and throw an exception when it exceeds the timeout.

Thanks

Rakesh

1. How to set query Timeout in Teiid 7.3

Ramesh Reddy Apr 16, 2011 9:40 PM (in response to Rakesh Balguri)

Rakesh,

Check out Statement API, use setQueryTimeout method on it.

Ramesh..
Like (0)

Actions
2. How to set query Timeout in Teiid 7.3

Rakesh Balguri Apr 18, 2011 5:46 AM (in response to Ramesh Reddy)

Hi Ramesh,

Thanks for the reply.

Is there any way to the set the query timeout on the Server side instead of on the Statement. Like can we specify this in the teiid-jobss-beans.xml file or a similar file?

Thanks,
Rakesh.
Like (0)

Actions
3. How to set query Timeout in Teiid 7.3

Steven Hawkins Apr 18, 2011 10:03 AM (in response to Rakesh Balguri)

Hi Rakesh,

Could you log a feature request? Some things to think about:
Would you want it to only be a server side setting, and/or set as a connection property? Would the Statement.setQueryTimeout override the server value?

Steve
Like (0)

Actions

JBossDeveloper