• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLException: Io exception: There is no process to read data written to a pipe.

 
Ashutosh Goyal
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
java.sql.SQLException: Io exception: There is no process to read data written to a pipe.
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:572)
at java.sql.DriverManager.getConnection(DriverManager.java:196)
at DataConnection.main(DataConnection.java:40)

I am facing this probelm and not able to make connection with Oracle10g. I have my java program on AIX 5.3. Same programe is running at my local machine. Some one can help me out please. Thanks in advance.
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ashutosh,

Can you issue a tnsping from the AIX server to database server with success?


or simply you can try establishing a telnet connection


Give us feedback about your progress.

Regards,

Fatih.
 
Ashutosh Goyal
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Fatih for response.
My database is also on the same AIX server. So there is no question that it won't ping. And not only in the same server I am not able to establish the connection with database which exists on the other servers.

Thanks
 
Jan Cumps
Bartender
Posts: 2602
13
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to JavaRanch, Ashutosh.
 
Jan Cumps
Bartender
Posts: 2602
13
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are some watchouts when you port Java Web applications from Windows to AIX:
http://www.ibm.com/developerworks/aix/library/au-aix-javatraps/index.html
 
Ashutosh Goyal
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This link is not helpful for me. I have already tried this.
And I typed my Java progrma on AIX box directly.

Please help me. It's has become very big issue.
Thanks in advance.
 
Ashutosh Goyal
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If I use 32 bit version of java and "oci" driver to connect with Oracle then it is working fine.
If I use 32 bit version of java and "thin" driver to connect with Oracle then it shows me ablove error.
If I use 64 bit version of java and "thin" driver then also it shows me ablove error.

But if I use 64 bit version of java and "oci" driver then also system shows :

Exception in thread "main" java.lang.UnsatisfiedLinkError: ocijdbc10 (A file or directory in the path name does not exist.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:994)
at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:958)
at java.lang.System.loadLibrary(System.java:453)
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:4077)
at java.security.AccessController.doPrivileged(AccessController.java:192)
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:4073)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:447)
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:92)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:839)
at java.sql.DriverManager.getConnection(DriverManager.java:572)
at java.sql.DriverManager.getConnection(DriverManager.java:196)
at DataConnection.main(DataConnection.java:66)

This may help you to help me.
Thanks
 
Ashutosh Goyal
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Problem may be beacause of Timeout as explained in link
http://www.ibm.com/developerworks/aix/library/au-aix-javatraps/index.html

But there is no solution how to resolved it out.
 
Jan Cumps
Bartender
Posts: 2602
13
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ashutosh Goyal wrote:This link is not helpful for me. I have already tried this.
...
Ok. I could not find that info in your original post.
 
Ashutosh Goyal
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I forgot to mention it. Sorry for that.
Now please understand my problem and reply.

I am always here if you want some more info.
 
Ashutosh Goyal
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Will somebody help me ?

Please.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic