Re: Little OT: CLOB, Oracle Text, and ADO

Well, I thought it was required.

This may be another case of trying to determine which MetaLink documents are current and which are superceded.

What really makes it interesting is I've spent quite a bit of time with OWW trying to troubleshoot and iFS problem, they know I'm using ctxsrv, but have said nothing about it.

These aren't first tier support people either.

Guess I'll have to ask some more questions.

Thanks

Jared

On Friday 21 December 2001 20:00, MacGregor, Ian A. wrote:
> From the Intermedia New Features for 8.1.6
> ---------------------------------------------------------------------------
>---------- We now recommend processing pending DML through a dbms_job -- an
> individual job for each index, a ctxsys job for all indexes, or some
> combination of the two. This eliminates the need for ctxsrv, and thus
> eliminates the problem of starting ctxsrv each time the database starts.
> The ctxsrv program itself is now deprecated, and may be removed in some
> future release.
> ----------------------------------------------------------------------
>
> Is it required for IFS? I haven't tried to use that beast, but checking a
> Metalink forum, indicates that ctx_ddl.synch_index is preferred over
> ctxstv.
>
> Ian MacGregor
>
>
> -----Original Message-----
> Sent: Friday, December 21, 2001 12:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Really?
>
> Do you know which version?
>
> In 8i it seems to be alive and well, and iFS requires it.
>
> Maybe as of 9i?
>
> Jared
>
>
>
>
> "MacGregor,
> Ian A." To: Multiple recipients of
> list ORACLE-L <ORACLE-L_at_fatcity.com> <ian_at_SLAC.Stan cc:
> ford.EDU> Subject: RE: Little OT: CLOB,
> Oracle Text, and ADO Sent by:
> root_at_fatcity.c
> om
>
>
> 12/21/01 10:00
> AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> Ctxserv has been deprecated. Check the directory
> $ORACLE_HOME/ctx/sample/script for the approved ways of keeping the indexes
> in synch.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_slac.stanford.edu
>
> -----Original Message-----
> Sent: Friday, December 21, 2001 9:41 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> My experience with intermedia or context server, or whatever
> they call it this week, is in dealing with iFS, so I know just
> enough to be dangerous. :)
>
> It sounds like you need to have the context server running
> to periodically update the indexes.
>
> On unix it's 'ctxsrv'. I suggest you read the docs on this
> and do a search on metalink, there is some helpful
> information there.
>
> HTH
>
> Jared
>
>
>
>
>
> "Witold Iwaniec"
>
> <wiwaniec_at_novali To: Multiple recipients of
> list ORACLE-L <ORACLE-L_at_fatcity.com>
> stech.com> cc:
>
> Sent by: Subject: Little OT: CLOB,
> Oracle Text, and ADO
> root_at_fatcity.com
>
>
>
> 12/21/01 07:15
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
> Hello
>
> It may be little OT but I am sure there are developers here. Also I
> hope some DBAs may know the answer...
>
> I am experimenting with Oracle Text - need to use the field from a
> VB application.
>
> I have a table with a CLOB column and a ctxcat index built on that
> column. If I insert records using SQL Plus, TOAD, or similar tool,
> the index is automatically updated so my query:
>
> select note_oid from lrmi_note
> where catsearch(note_data, 'SomeValue', null) > 0;
>
> returns records matching the condition.
>
> In the application - if I use ADODB.Connection with parameters and
> execute my insert, the data is written, index automatically updated,
> and my query returns matching records.
>
> But if I use ADODB.Recordset to write the record, the data is written
> but the index doesn't get updated. If I open SQL Plus and run:
>
> select * from lrmi_note where note_oid = my_new_oid;
>
> it shows me the record with the CLOB column filled. But if I query
> the CLOB column using catsearch(), it doesn't return the record. If I
> rebuild the index, the query with catsearch() will return the records.
> But one of the reasons to use ctxcat indes is that it is updated with
> each transaction...
>
> While it may be specific to ADO I wonder if some Oracle gurus
> know, or can direct to some info, why Oracle doesn't update the
> ctxcat index even though the record is written and apears correctly.
>
> Witold==================================
> Witold Iwaniec
> Sr Software Developer
> NovaLIS Technologies
> wiwaniec_at_novalistech.com
> http://www.novalistech.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: MacGregor, Ian A.
> INET: ian_at_SLAC.Stanford.EDU
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).