Home » Developer & Programmer » JDeveloper, Java & XML » Create Oracle Text Index from Java via JDBC (Oracle Text, Oracle 10g Enterprise Edition, Debian Linux)
icon5.gif  Create Oracle Text Index from Java via JDBC [message #317364] Wed, 30 April 2008 18:11
Messages: 2
Registered: August 2007
Junior Member
Hi, I have a question relevant to creation of the Text Index in Oracle Text via Java JDBC.
In Java I create client application and I connect to remote Oracle server. (there is Oracle
10g Enterprise Edition
on Debian Linux OS). In Java I create query:

CREATE INDEX index_name ON source_tab(text) indextype is ctxsys.context
parameters('datastore ctxsys.file_datastore filter ctxsys.null_filter');

and I start it by:

PreparedStatement stmt = db.prepareStatement(query);
ResultSet rs = stmt.executeQuery();

There is problem that Text Index is created empty and when I write out error log then:

DRG-11513: unable to open or write to file "path"

I have on my computer Oracle XE 10g (Windows XP OS) here this application in Java functions
without problems. Without problems it´s with that same query in SQLPlus when I connect at
this remote Oracle server via PuTTY.

Do you know anybody where could be error? Or at worst case where find I more detailed
manual about JDBC Oracle mainly possible errors and problems with compatibility?
Previous Topic: Java app waiting forever for Oracle
Next Topic: ORA-24338: statement handle not executed
Goto Forum:

Current Time: Tue May 21 17:59:45 CDT 2024