Home » Developer & Programmer » JDeveloper, Java & XML » Create Oracle Text Index from Java via JDBC (Oracle Text, Oracle 10g Enterprise Edition 10.2.0.3.0, Debian Linux)
icon5.gif  Create Oracle Text Index from Java via JDBC [message #317364] Wed, 30 April 2008 18:11
fatenn
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 10.2.0.3.0
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: Wed Apr 23 03:58:47 CDT 2014

Total time taken to generate the page: 0.09763 seconds