How to setup a timeout parameter when using "Database.Templates.templateQuery()" .

How to setup a timeout parameter when using "Database.Templates.templateQuery()" .

book

Article ID: KB0089947

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
===========
How to setup a timeout parameter when using "Database.Templates.templateQuery()" .

Environment:
===========
BusinessEvents 3.0.2HF3 onwards
All Operating Systems

Symptoms:
=========
Agent hangs when process Database.Templates.templateQuery() - timeout parameter required.

Cause:
======
n.a.

Resolution:
========
Add the following TRA property to set a timeout value.

be.dbconcepts.templates.query.sqltimeout=&lttimeoutInSeconds>

NOTE:
"ORA-01013: user requested cancel of current operation" error is thrown when timeout is reached.

Issue/Introduction

How to setup a timeout parameter when using "Database.Templates.templateQuery()" .