Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 24 Feb 2004 @ 20:19:06 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Query Timeout question
 
From:   Yepuri, Vijay

Hi William,

string myConnString =
"DRIVER={Teradata};DBCName=dbcname;UID=user;PWD=password;DATABASE=databa
se;";
    OdbcConnection myConnection = new OdbcConnection(myConnString);
    myConnection.ConnectionTimeout = 60;
    myConnection.Open();

This is only for ConnectionTimeout.

.NET Definition for ConnectionTimeout:

"Gets or sets the time to wait while trying to establish a connection before terminating the attempt and generating an error."


One available for JDBC:

QueryTimeOut The query timeout limit is the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a SQLException is thrown. The current query timeout limit is measured in seconds and zero means unlimited. To override this behavior for a specific application, use statement.setQueryTimeout().


Error from WinCLI

802 Timeout

Explanation: The request has timed out.

Remedy: Increase the timeout value using Statement.setQueryTimeout() or set the QueryTimeOut value in the terajdbc.conf file on the gateway.

Resubmit the job.


Not sure if both ConnectionTimeout (.NET) and QueryTimeout (JDBC) are same.


Thanks

Regards

Vijay



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019