OraFAQ Forum: JDeveloper, Java & XML » Oracle Exception during Select

Home » Developer & Programmer » JDeveloper, Java & XML » Oracle Exception during Select (Oracle 9.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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)

Report message to a moderator

Re: Oracle Exception during Select [message #347236 is a reply to message #347216]

Thu, 11 September 2008 02:52

manjug
Messages: 4
Registered: September 2008

Junior Member

Please help.

Report message to a moderator

Re: Oracle Exception during Select [message #347253 is a reply to message #347236]

Thu, 11 September 2008 03:33

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No evidence this is an Oracle problem.

Regadrs
Michel

Report message to a moderator

Re: Oracle Exception during Select [message #347258 is a reply to message #347236]

Thu, 11 September 2008 03:39

Frank
Messages: 7901
Registered: March 2000

Senior Member

Did your application(server) reconnect after the bounce of the database?

Report message to a moderator

Re: Oracle Exception during Select [message #347284 is a reply to message #347258]

Thu, 11 September 2008 04:29

manjug
Messages: 4
Registered: September 2008

Junior Member

Thanks for looking into this. Yes it did... The next select query was successful. The issue was seen again much later. After a few minutes time, all became well. I am looking for the root cause and as well as a solution.

Report message to a moderator