HI, We have a websphere application and the backend is oracle 8.1.7 on NT. We use JDBC for connectivity to Oracle. We are coming across the above mentioned error for some of the transactions. Also since no ORA- number is returned i'm unable to get to the cause of the error.
If anyone of u has come across a similar situation then pl let me know the cause of the error and the solution to it. [ July 26, 2005: Message edited by: Bear Bibeault ]
hi, I am experiencing the same problem, as it seems. Until yesterday, everything worked fine. All queries returned a result in an acceptable amount of time. Then I have added some new queries (which are only slitely modified versions of the others) and these run a long time until they might throw this error. Exactly the same queries return _at once_ using sqlplus. Has anyone hints where to start debugging? (Database/Driver/Query) Thanks Chantal
End of TNS Channel happens when the connection is dropped. Either the connection is timed out or the connection is forcefully dropped by the administrator. These could also occur if the database is designed to drop the connections in case it runs out of short space. I am not a database person but If I were to solve this I would isolate the problem and ask the DBA to monitor when exactly the connection gets dropped.
Even i faced this problem so many times......but then i used to solve it by stopping the process "TNS:Listener" which is running in the background thru Task Manager......and restart it......this will work sometimes...
Check ur DB Connections if u r connecting to the DB from a remote place.....bcos ur ip can be changing if u r on LAN. Ask ur Admin to Monitor that.
Hopefully this wud solve.....if any one of u have some other solution....plz......let me know....
subject: java.sql.SQLException: Io exception: End of TNS data channel