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 Go to next message
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)

Re: Oracle Exception during Select [message #347236 is a reply to message #347216] Thu, 11 September 2008 02:52 Go to previous messageGo to next message
manjug
Messages: 4
Registered: September 2008
Junior Member
Please help.
Re: Oracle Exception during Select [message #347253 is a reply to message #347236] Thu, 11 September 2008 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No evidence this is an Oracle problem.

Regadrs
Michel
Re: Oracle Exception during Select [message #347258 is a reply to message #347236] Thu, 11 September 2008 03:39 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
Did your application(server) reconnect after the bounce of the database?
Re: Oracle Exception during Select [message #347284 is a reply to message #347258] Thu, 11 September 2008 04:29 Go to previous messageGo to next message
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.
Re: Oracle Exception during Select [message #347374 is a reply to message #347284] Thu, 11 September 2008 07:17 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
Maybe a single connection in the pool?
"random" errors often point to that
Re: Oracle Exception during Select [message #347507 is a reply to message #347374] Thu, 11 September 2008 23:24 Go to previous message
manjug
Messages: 4
Registered: September 2008
Junior Member
The connection pool is of 30 and 25 were free at the pint of time this occured.
Previous Topic: Doubt In Using Extract Value
Next Topic: Bean / Java PJC
Goto Forum:
  


Current Time: Wed Apr 16 21:47:06 CDT 2014

Total time taken to generate the page: 0.10034 seconds