| springframework.jdbc.UncategorizedSQLException [message #254360] |
Thu, 26 July 2007 10:04 |
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
|
Senior Member |
|
|
Our Apps and DBA team have redeployed the codes from one server to another. After doing the same, we are getting a strange error while calling the SP from Java.
below is the log:-
org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for
SQL [{call market_dtl_pg.spm_mina_mkt_search(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}];
SQL state [null]; error code [17410]; No more data to read from socket; nested exception is java.sql.SQLException:
No more data to read from socket
java.sql.SQLException: No more data to read from socket
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Inlined Compiled Code))
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java(Inlined Compiled Code))
at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java(Compiled Code))
at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:375)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1141)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2149)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2032)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2894)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:684)
at org.springframework.jdbc.core.JdbcTemplate$5.doInCallableStatement(JdbcTemplate.java:858)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:823)
at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:856)
at org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:102)
As im a DB guy, i tried calling the SP from TOAD and it works fine..dont know where exactly the problem is....
Anyone have any idea on this?
Naveen
[Updated on: Thu, 26 July 2007 10:09] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
