Home » Developer & Programmer » JDeveloper, Java & XML » Oracle Exception during Select (Oracle 9.2)
Oracle Exception during Select [message #347216] |
Thu, 11 September 2008 01:47 |
manjug
Messages: 4 Registered: September 2008
|
Junior Member |
|
|
This Exception occurs when we try to read one row in in one of the tables, immediately after DB restart.
Interesting thing is, Before this exception occured a lot of select, delete and insert have worked successfully. Checked the DB process and it was up & fine.
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] java.sql.SQLException: No more data to rea
d from socket
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.dbaccess.DBError.throwSqlEx
ception(DBError.java:134)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.dbaccess.DBError.throwSqlEx
ception(DBError.java:179)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.dbaccess.DBError.check_erro
r(DBError.java:1160)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.ttc7.MAREngine.unmarshalUB1
(MAREngine.java:961)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.ttc7.MAREngine.unmarshalSB1
(MAREngine.java:893)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.ttc7.Oopen.receive(Oopen.ja
va:109)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7
Protocol.java:584)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.driver.OracleStatement.open
(OracleStatement.java:586)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.driver.OracleStatement.doEx
ecuteWithTimeout(OracleStatement.java:2918)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45454] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.driver.OracleStatement.exec
uteQuery(OracleStatement.java:653)
Post this error it is followed by this error:
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45459] <Thread-13> :ERROR: [SQLException] java.sql.SQLException: Io exception: Broke
n pipe
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45459] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.dbaccess.DBError.throwSqlEx
ception(DBError.java:134)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45459] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.dbaccess.DBError.throwSqlEx
ception(DBError.java:179)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45459] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.dbaccess.DBError.throwSqlEx
ception(DBError.java:334)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45459] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.ttc7.TTC7Protocol.handleIOE
xception(TTC7Protocol.java:3664)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45459] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7
Protocol.java:591)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45459] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.driver.OracleStatement.open
(OracleStatement.java:586)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45459] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.driver.OracleStatement.doEx
ecuteWithTimeout(OracleStatement.java:2918)
Jan 3 18:37:59 rtp6em sem: MG9kEMFactory_91: [45459] <Thread-13> :ERROR: [SQLException] at oracle.jdbc.driver.OracleStatement.exec
uteQuery(OracleStatement.java:653)
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Dec 18 06:48:45 CST 2024
|