Menu
▾
▴
springframework-developer
|
From: G.Shriram <shr...@gm...> - 2008-06-24 13:47:02
|
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.
|
|
From: Robert W. <rw...@gm...> - 2008-06-24 15:39:37
|
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 > |
|
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. |
|
From: G.Shriram <shr...@gm...> - 2008-07-07 11:15:41
|
I see no reply to this thread. Can someone assist please. -- View this message in context: http://www.nabble.com/End-of-file-on-communication-channel-tp18091397p18314453.html Sent from the springframework-developer mailing list archive at Nabble.com. |
|
From: Darren D. <da...@da...> - 2008-07-07 17:08:45
|
On Mon, Jul 07, 2008 at 04:15:39AM -0700, G.Shriram wrote: > I see no reply to this thread. Can someone assist please. this list is fairly dead these days, you'll likely have much more success posting to the relevant forum at http://forum.springframework.org Regards, -- Darren Davison Public Key: 0xE855B3EA |
