Search found 2 matches

by naidug
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 ...
by naidug
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 ...

Go to advanced search