Help : End of TNS data channel
can anyone suggest a solution for the error i am getting with a very simple
insert statement ? I am not using anyting advanced like CLOB / BLOB. I am
using Oracle 8.1.5.
java.sql.SQLException: Io exception: End of TNS data channel
thanks in advance.
Re: Help : End of TNS data channel
Check the width of each column ( you are using in Insert statement w.r.t
values (i.e variables) width). Are u using diff. database environment (Database
check and try once again
"news.devx.com" <firstname.lastname@example.org> wrote:
>can anyone suggest a solution for the error i am getting with a very simple
>insert statement ? I am not using anyting advanced like CLOB / BLOB. I am
>using Oracle 8.1.5.
>java.sql.SQLException: Io exception: End of TNS data channel
>thanks in advance.
I got the Oracle error message 'End of TNS data channel' when trying to query over a database link. The problem turned out to be that the link was created using the 'connect to current_user' clause, which implies that the user must be a global user defined in LDAP, which wasn't the case.
Recreating the link without the current_user clause (instead using the default of connected user) solved the problem.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL