LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rgvenkatesh

Was wondering if the DB nodes in Lavastorm have any timeout set up in built in them or is it possible to customize a timeout logic around a DB node (both DB execute and JDBC).

The scenario we are trying to handle is:
We are querying the Oracle and Sybase DBs at many places and we need to put up a logic which triggers an error if a Db execute or JDBC execute takes more than a configured time to respond.
I did some research but couldn�t find an explicit timeout option on these nodes like we have in HttpNodes.

Obviously this has a definite relation with the way the query or the view used in the DB node is written, but if we have a timeout option/logic we can find these rogue queries and fix them to respond fast.

Regards,
Venkatesh

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

http://infocenter.sybase.com/help/in...c/prjdbc14.htm

You may be able to configure the node thru a parameter such as this:

jdbc:protocol://servername:port?DEFAULT_QUERY_ TIMEOUT=nnn

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rgvenkatesh

Thanks for the reply,
Can we do something similar on the DB execute node as well?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

You would have to research the Oracle Documentation.
I _believe_ that I once saw someone put the entire TNS entry into the DBService parameter, but I don't know if Timeout is part of what you can use there.