This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes End of TNS datachannel Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "End of TNS datachannel Error" Watch "End of TNS datachannel Error" New topic
Author

End of TNS datachannel Error

Sujatha, Chigullapalli
Greenhorn

Joined: Nov 16, 2001
Posts: 6
Hi,
I was trying to connect to the Oracle database from Sybase App. Server by giving the database address in the Connection Cache properties. I am using the type 4 driver and the URL I am giving in the properties is :
jdbc racle:thin:@Apollo:1526 rcl
I am getting 'End of TNS datachannel' error. I did go through the message posted by someone on this website and the reply from Carl Trusiak. I checked with my DBA and the network administrator about the URL and network configuration of the box from which I am doing this test. They said everything is fine and it has nothing to do with network settings. And I think I did not give anything wrong in the URL I mentioned above, the dbServer is 'Apollo' ,SID 'orcl' listening on port 1526.
I am able to connect to oracle database from 'sql worksheet' from the same box...ping to the database from dos prompt is also successful...
Please help me if there is anything else I would have missed.
Thanks a lot!
Sujatha
[This message has been edited by Sujatha, Chigullapalli (edited November 19, 2001).]
Sujatha, Chigullapalli
Greenhorn

Joined: Nov 16, 2001
Posts: 6
Hi there ...I am still waiting for someone to reply for my message. Please help me figuring out the problem below. I really appreciate your response. Let me know if you need more details.
Thankyou!
Sujatha
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

what is the ORA-XXXXX error number?
Jamie
Sujatha, Chigullapalli
Greenhorn

Joined: Nov 16, 2001
Posts: 6
There is no ORA - xxxxx error associated with this.
It says :
Ping of ats_thin connection cache failed. JCMCache.getConnection() could not acquire a connection. java.sql.SQLException:End of TNS datachannel
ats_thin is the name of the connection cache where I give the URL for the database with user name and password.
Please let me know if you need more details.
Thankyou,
Sujatha
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

If you use System.out.println(e.getMessage()); it should return an error number such as "ORA-00945" or something. This helps in the investigative process. I have not dealt with this error before so I would need the ORA-XXXXX number.
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: End of TNS datachannel Error