Skip to Content
0
Apr 04, 2014 at 11:25 AM

Issue with teradata connection

47 Views

Hi,

I am trying to connect to teradata using the application where we are using Java code to connect(Using JDBC datasource).

In the application we use excel sheet to upload the values. If i have 2 lineitems to upload, and when i try for the first time, error of not getting conneted to teradata will come for the first lineitem and the second lineitem values will be uploaded without any problem. there after if i try to upload, all the lineitmes will be uploaded to teradata without any fail. but the same issue will be seen if the application is kept idle and used after some time.

when i tried to check the error, it says, "SOCKET COMMUNICATION FAILURE".

when we checked teraddata logs, we found out that there are more nunber of ET than BT. so tried setting TMODE = ANSI in database URL. but still issue is triggering.

can anybody help on this issue.? its little urgent.

Thank you in advance.