SQL error 17410 No more data to read from socket
Hi, I may have reached some stability limit of my JDBC thin driver, DB version and
the complexity of my use cases??
DB= 9.0.1.0
Jev/OC4J = 9.0.2
So this includes the JDBC thin driver included that looks like version; 9.0.2.7.99
----
It made no sense but changing a dynamic where clause being set onto a View over an Entity
like; vo.setWhereClause("myid = "+theID+" and someFk ="+theFkId);
To a dynamic where clause with bind params for efficiency:
vo.setWhereClause("myid = :1 and someFk = :2");
vo.setWhereClauseParam(0, theId);
vo.setWhereClauseParam(1, theFkId);
I checked that my bind variables are same data type as what's declared in the Entity.
This intermitantly causes:
JBO-26066, which is a wrapper over SQLException 17410 No more data from socket
Deep into the stack trace are unmarshalUB1(MARengine.java) ...
leading me to believe this isn't my code but a bug/stress issue with the driver.
Any thoughts?
curt