cartridge sql function load_cache

Hi,

Following is the description in developer guid on the load_cache jchem function, can someone provide an example how to use this. I could not find this function in jchem package .. and other cartridge related packages ...

thanks

dong

 

Cache-related functions

After creating an index or inserting large number of structures into an indexed table, the structure cache must be refreshed. Unless you do it manually, this will be done automatically at the beginning of the next search, so it can take a very long time depending on the number and the characteristics of the new structures. To do it manually, use this function:

 

load_cache(idxSchema IN VARCHAR2, idxName IN VARCHAR2, partition IN VARCHAR2, options IN VARCHAR2)

Hi Dong,

This function is in the jchem_core_pkg package. (The documentation will be fixed for JChem version 6.1 to include the package name.) Example:

call jchem_core_pkg.load_cache('MY_INDEX_SCHEMA', 'MY_INDEX_NAME', NULL, NULL);

Peter

Hi Peter,

I did what you suggested, tried this, 

call

 

 

jchem_core_pkg.load_cache('IP','IDX_IBM_MOL',NULL,NULL);

however i am getting oracle error:

ORA-06576: not a valid function or procedure name

Is this function recently added to jchem cartridge/jchem_core_pkg, i am using jchem 5.9.3 according to following environment information

Oracle environment:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

JChem owner: JCHEM

JChem Server environment:

Java VM vendor: Sun Microsystems Inc.

Java version: 1.6.0_32

Java VM version: 20.7-b02

JChem version: 5.9.3

JChem Index version: 5080100

JDBC driver version: 11.1.0.7.0-Production

 

 

Hi Dong,

This function was introduced in JChem version 6.0. It is not available in the JChem version you are using. (We plan to do a big overhaul on the documentation and one of the improvements we are considering to make is to add a "since version" information to API elements -- at least to the newer functions where it really matters (now).) 

Peter

Thanks Peter, i thought so, we should plan to upgrade the jchem server to 6.0. Is the 6.0 stable?

Dong,

Apart from a significant increase in memory requirement for searching (currently under investigation), there are no known major stability issues with 6.0.2. (Of course, best is to test your most sensitive use cases before going into production with it.)

Peter