Hello,
My tables:
create table DetailResume(
d_id number(14) primary key,
cv_id number(14) constraint DetailResume_fk references CvProperties(cv_id),
cat_id number(14) constraint DetailResume_fk2 references CvCategories(cat_id),
DetailResume clob);
create sequence DetailResume_seq
start with 1 increment by 1;
create or replace trigger DetailResume_trig
before insert on DetailResume
referencing new as new
for each row
begin
select DetailResume_seq.nextval into :new.d_id from dual;
end;
/
After giving respective grants to the user I have created this index
CREATE INDEX idx_detailResume ON detailResume(detailResume)
INDEXTYPE IS CTXSYS.CONTEXT;
Now I am making query as follow and its working fine:
SELECT SCORE(1), cv_id FROM detailResume WHERE CONTAINS(detailResume, 'cardiology', 1) > 0 and cat_id=5 order by SCORE(1) desc;
When I am using into my Java program:
String query = " SELECT SCORE(1), cv_id FROM detailResume WHERE CONTAINS(detailResume,'cardiology', 1) > 0 and cat_id=5";
String query1 = " insert into jobResponses(job_id,cv_id,responseStatus) values (?,?,0)";
PreparedStatement ps=cnn.prepareStatement(query);
rs=ps.executeQuery();
while(rs.next()){
String score = rs.getString(1);
String cvId = rs.getString(2);
}
ps.close();
rs.close();
cnn.commit();
cnn.close();
Then its throwing the following error:
java.sql.SQLException: ORA-20000: Oracle Text error:
DRG-10599: column is not indexed
Please advise
Thanks in anticipation