Search found 2 matches
- Fri Sep 07, 2012 9:07 pm
- Forum: JDBC
- Topic: SetTimout to terminate the sql execution if takes too long
- Replies: 3
- Views: 21763
Re: SetTimout to terminate the sql execution if takes too lo
Hi naidug, Welcome to the forums! First thing I want to ask is do you really have SQL that is running for "minutes/hours"?!?! I have yet to experience a query that runs more than a minute in Vertica. However, we're running Cognos queries and those appear to take a long time to run because it takes ...
- Sat Sep 01, 2012 3:42 am
- Forum: JDBC
- Topic: SetTimout to terminate the sql execution if takes too long
- Replies: 3
- Views: 21763
SetTimout to terminate the sql execution if takes too long
We are trying to find how to set timeout to the connection/Statement to prevent sql taking minutes/hours. It looks like Vertica driver doesn't support setTimeout (sec), what is the alternate? Anyone solved the problem? Vertica takes minutes/hours occassionally to execute a SQL causing to accumulate ...