Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes java.sql.SQLException: No more data to read from socket Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: No more data to read from socket" Watch "java.sql.SQLException: No more data to read from socket" New topic
Author

java.sql.SQLException: No more data to read from socket

Bennet Xavier
Ranch Hand

Joined: Jun 19, 2008
Posts: 162
Hi All,

i am using connection pooling,

code is :




and getting this error..

I DON'T HAVE ANY IDEA OF THIS EXCEPTION PLEASE HELP ME.

CAN WE CONTROL IN CONNECTION POOLING, IF YES TELL ME HOW ?

java.sql.SQLException: No more data to read from socket
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:208)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1118)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:478)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.
java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableSta
tement.java:954)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat
ement.java:3390)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStat
ement.java:4223)
at com.tt.rms.service.manager.RMSDatabaseManager.login(Unknown Source)
at com.tt.rms.service.manager.RechargeManager.onload(Unknown Source)
at com.tt.rms.service.manager.RechargeManager.<clinit>(Unknown Source)
at RMIServer.processRequest(RMIServer.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Sou
rce)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Sour
ce)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)


THANKS IN ADVANCE,

BENNET XAVIER x
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

This is one of the many reasons I encourage programmers to avoid...

1) Database specific objects such as "oracle.jdbc.OracleTypes.OPAQUE"
2) Stored procedures (whenever possible)
3) Non-general database formats such as XML as a data type

Off hand, I'd start with a stored procedure that takes no values and/or takes string value, and build up from there since any of the above thing could cause errors.


My Blog: Down Home Country Coding with Scott Selikoff
 
 
subject: java.sql.SQLException: No more data to read from socket