Home » Developer & Programmer » JDeveloper, Java & XML » springframework.jdbc.UncategorizedSQLException
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

Previous Topic: PLS-00311 Error when creating java stored function
Next Topic: BC4J Connection Pooling Issue
Goto Forum:
  


Current Time: Thu Mar 28 14:21:10 CDT 2024