Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 29 Nov 2005 @ 23:17:49 GMT

  <Prev Next>  
Next> Last>>  

Subj:   JDBC and Idle Response
From:   Mohommod.Khan

I am using a JDBC driver (version to connect to Teradata. It appears that sessions created via my JDBC connection have something wrong with them. Consider this:

1) I login to Teradata with a JDBC connection.

2) I execute a select statement from a view.

3) I get the results back, Teradata is DONE processing my query.

4) PMON shows me this: AMP State = Idle and PE State = Response.

Idle/Response? What does that mean? After a query is done, the session should be Idle/Idle, not Idle/Response. It's like the JDBC driver is not managing the session characteristics properly.

Moreover, sessions that get caught in this "Idle/Response state" begin blocking new sessions. For example, session 1 does a select from a view and is now caught in the Idle/Response state. Then another session, session 2, comes in and tries to update the table that session 1 used. Session 2 then shows up as blocked (by session 1) in PMON. Yet session 1 has no active SQL.

Has anyone encountered something like this? I really need help here. I need to be able to connect using JDBC and not have sessions (that should be idle) block other sessions.

Thanks in advance.

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