aspose file tools*
The moose likes JDBC and the fly likes SQLException: Io exception: There is no process to read data written to a pipe. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLException: Io exception: There is no process to read data written to a pipe." Watch "SQLException: Io exception: There is no process to read data written to a pipe." New topic
Author

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

Ashutosh Goyal
Greenhorn

Joined: Mar 16, 2010
Posts: 9
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

Joined: Sep 01, 2005
Posts: 182
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

Joined: Mar 16, 2010
Posts: 9
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

Joined: Dec 20, 2006
Posts: 2503
    
    8

Welcome to JavaRanch, Ashutosh.


OCUP UML fundamental and ITIL foundation
youtube channel
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2503
    
    8

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

Joined: Mar 16, 2010
Posts: 9
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

Joined: Mar 16, 2010
Posts: 9
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

Joined: Mar 16, 2010
Posts: 9
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

Joined: Dec 20, 2006
Posts: 2503
    
    8

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

Joined: Mar 16, 2010
Posts: 9
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

Joined: Mar 16, 2010
Posts: 9
Will somebody help me ?

Please.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQLException: Io exception: There is no process to read data written to a pipe.