|
From: G.Shriram <shr...@gm...> - 2008-06-25 04:08:46
|
Thanks for reply. I also have several other applications running in the same OC4J server in different container but using the same database with out any exception of such type. The other applications are not using spring framework which makes me think that should be some issue related to the way Spring framework handles database connectivity. So any other suggestions or solutions would be of great help. rob.winch wrote: > > You may already realize this, but I think this is more of a problem with > your database than a Spring problem. This link [1] may be of use to you. > If > not, I would look into the error code that was returned from Oracle > "ORA-03113". > > [1] > http://www.mydatabasesupport.com/ora-03113-end-of-file-on-communication-channel.html > > On Tue, Jun 24, 2008 at 8:47 AM, G.Shriram > <shr...@gm...> > wrote: > >> >> Hi >> I am using spring framework with OC4J container having emulated JNDI >> location. Occasionally I get this error: >> >> INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, >> MySQL, >> Oracle, PostgreSQL, Sybase] >> >> >> >> 08/06/24 11:10:13 org.springframework.jdbc.UncategorizedSQLException : >> CallableStatementCallback; uncategorized SQLException for SQL [{call >> hcaus_reviews_info_pkg.get_reviews_info_prc(?, ?, ?, ?, ?, ?, ?)}]; SQL >> state [63000]; error code [3113]; ORA-03113: end-of-file on communication >> channel >> >> >> >> ; nested exception is java.sql.SQLException: ORA-03113: end-of-file on >> communication channel >> >> >> >> 08/06/24 11:10:13 Caused by: java.sql.SQLException: ORA-03113: >> end-of-file >> on communication channel >> >> >> >> 08/06/24 11:10:13 at oracle.jdbc.driver.DatabaseError.throwSqlException >> (DatabaseError.java:137) >> >> >> >> 08/06/24 11:10:13 at oracle.jdbc.driver.T2CConnection.checkError(T2CCon >> nection.java:698) >> >> >> >> 08/06/24 11:10:13 at oracle.jdbc.driver.T2CConnection.checkError(T2CCon >> nection.java:630) >> >> >> >> 08/06/24 11:10:13 at oracle.jdbc.driver.T2CCallableStatement.execute_fo >> r_describe(T2CCallableStatement.java:845) >> >> >> >> 08/06/24 11:10:13 at oracle.jdbc.driver.T2CCallableStatement.execute_fo >> r_rows(T2CCallableStatement.java:1007) >> >> >> >> 08/06/24 11:10:13 at oracle.jdbc.driver.OracleStatement.doExecuteWithTi >> meout(OracleStatement.java:1153) >> >> >> >> 08/06/24 11:10:13 at oracle.jdbc.driver.OraclePreparedStatement.execute >> Internal(OraclePreparedStatement.java:2932) >> >> >> >> 08/06/24 11:10:13 at oracle.jdbc.driver.OraclePreparedStatement.execute >> (OraclePreparedStatement.java:3023) >> >> >> >> 08/06/24 11:10:13 at oracle.jdbc.driver.OracleCallableStatement.execute >> (OracleCallableStatement.java:4132) >> >> >> >> 08/06/24 11:10:13 at com.evermind.sql.FilterPreparedStatement.execute(F >> ilterPreparedStatement.java:255) >> >> >> >> 08/06/24 11:10:13 at com.evermind.sql.FilterPreparedStatement.execute(F >> ilterPreparedStatement.java:255) >> >> >> Can anybody help me to resolve this exception. >> -- >> View this message in context: >> http://www.nabble.com/End-of-file-on-communication-channel-tp18091397p18091397.html >> Sent from the springframework-developer mailing list archive at >> Nabble.com. >> >> >> ------------------------------------------------------------------------- >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> Springframework-developer mailing list >> Spr...@li... >> https://lists.sourceforge.net/lists/listinfo/springframework-developer >> > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Springframework-developer mailing list > Spr...@li... > https://lists.sourceforge.net/lists/listinfo/springframework-developer > > -- View this message in context: http://www.nabble.com/End-of-file-on-communication-channel-tp18091397p18104615.html Sent from the springframework-developer mailing list archive at Nabble.com. |