"End of TNS Data Channel" with Oracle Text problem

From: <l.maestri_at_mimesi.com>
Date: Tue, 04 Feb 2003 11:08:04 GMT
Message-ID: <3e3f9588.7906889@news.inet.it>

Hi everybody.

I have a problem with a query using multiple instances of the
"contains" operator.

It's something like this: "select field1,field2 from table1 where contains(fieldx,'something1',1)>0 and
contains(fieldx,'something2',2)>0"

This query is executed from inside an EJB (WebSphere 3.5.4) through a thin connection.
My Java code terminates with an exception on the executeQuery line:
"End of TNS Data Channel". This exception is dued to an Oracle crash
(core dump of Oracle 9i - 9.0.1.0.1 - ACCESS VIO).

The same query with only ONE "contains" operator or executed through an OCI connection runs without errors.

The Oracle Text indexed field is a BLOB field.

Any ideas?

Thanks for your help. Received on Tue Feb 04 2003 - 05:08:04 CST