Forcing a Timeout During Long-Running SQL Operations in Services and Notifications
In Adapter for JDBC services or notifications, some of the SQL operations may take a long time to execute. You can force these services or notifications to time out after a specific amount of time. You specify the number of seconds with the watt.adapter.JDBC.QueryTimeout property.
To set this property, use Integration Server Administrator and select Settings > Extended > Edit Extended Settings. Enter this property in the Extended Settings box:
watt.adapter.JDBC.QueryTimeout=value
where value is the number of seconds the adapter waits for the service or the notification to execute before stopping the SQL operation and throwing an exception. For more information about setting the watt properties, see the webMethods Integration Server Administrator’s Guide for your release.