Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: Io exception: End of TNS data channel

 
Ravi Shankar P
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
java.sql.SQLException: Io exception: End of TNS data channel

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 ]
 
Chantal Ackermann
Ranch Hand
Posts: 508
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
D Rog
Ranch Hand
Posts: 472
Linux Objective C Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you solved your problem? It seems I have a similar problems, queries processing randomly rises such kind of errors. I checked a listener log, however there was no any signs of problems.
 
Sunil Dumpala
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Swaroop Chowdary
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic