Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Java & ConText?

Java & ConText?

From: <danckaert_at_my-dejanews.com>
Date: Wed, 26 Aug 1998 21:37:20 GMT
Message-ID: <6s1v6g$8v0$1@nnrp1.dejanews.com>

Hi,

I'm trying to use java (oracle JDBC drivers) with an oracle 7.3.4 database to search context collections, and am getting a jdbc error. Specifically, I can take the exact query that runs within sqlplus, put it into a java application, and watch it fail unhappily.

An example query is:

select score(1),body from messages where contains(body,'baltimore',1)>0;

this works find in sqlplus, but I get the following error in java:

Ex: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

ORA-20000: ConText error:
DRG-10801: text query failed
DRG-11300: failed to translate query
DRG-11319: failed to parse WHERE clause
ORA-00911: invalid character


ORA-06512: at "CTXSYS.DRUE", line 180

ORA-06512: at "CTXSYS.DR_REWRITE", line 91 ORA-06512: at line 1

Any ideas?

thanks,
paul

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 16:37:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US