File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes java.sql.SQLException: Io exception: End of TNS data channel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.SQLException: Io exception: End of TNS data channel" Watch "java.sql.SQLException: Io exception: End of TNS data channel" New topic

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

Ravi Shankar P

Joined: Jul 24, 2002
Posts: 1
java.sql.SQLException: Io exception: End of TNS data channel

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

Joined: Sep 28, 2000
Posts: 508
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)
D Rog
Ranch Hand

Joined: Feb 07, 2004
Posts: 472

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.

Retire your iPod and start with HD Android music player Kamerton | Minimal J2EE container is here | Light weight full J2EE stack | and build tool | Co-author of "Windows programming in Turbo Pascal"
Sunil Dumpala

Joined: Jul 28, 2005
Posts: 29
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

Joined: Dec 18, 2003
Posts: 2
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....
I agree. Here's the link:
subject: java.sql.SQLException: Io exception: End of TNS data channel
It's not a secret anymore!