interMedia: No more data to read from socket

Hi. Running Oracle 8.1.7. When I perform interMedia searches with large results, I get the following JDBC exception:

SELECT id, score(1) "score"
FROM ccs_search
WHERE contains(content, '((test%)*(1/10))', 1) > 1 ORDER BY score(1) DESC

Connecting to database (jdbc:oracle:thin:@localhost:1521:CAPU) Connected
Exception in thread "main" java.sql.SQLException: No more data to read from sock
et

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
	at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:933)
	at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:739)
	at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:698)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:373)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
	at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
	at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:1826)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2015)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
571)
	at DriverTest.execute(DriverTest.java:24)
	at DriverTest.main(DriverTest.java:52)

The query does not fail when the result is "small", ie. I can increase the score - but in the long run, that's not a satisfactory workaround. I expect that the connection between the interMedia server (?) and Oracle breaks somehow (does this make sense at all - ie. is it possible?). Large standard queries that do not use interMedia do not break in the above manner.

I've tried JDBC drivers for both 8.1.7 and 8.1.7.1, I'm certain the problem is not with these.

Thanks in advance,

Morten Received on Tue May 07 2002 - 08:06:54 CDT