Reactions and jc_compare

Hi all,

 

we see the current problem that we insert a reaction and see a 1 as result for the appropriate jc_compare - but can't find the reaction if we use jc_compare in the where clause.

Have we overseen something?
We're working with 6.0.3 / Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
The statements are executed from an oracle user MYUSER with appropriate grants 

 

--insert a reaction

 

INSERT

 

INTO db_rcg_xxx.xx_reactions (rxn_id, reaction) values('TST_1234','C1=CC=CC=C1>>C1=CC=CC=C1');

--check if the data is in:

 

 select rxn_id,reaction, jc_compare(REACTION,'C1=CC=CC=C1>>C1=CC=CC=C1', 't:d') from DB_RCG_xxx.xxx_reactions where rxn_id = 'TST_1234';

 

--result was: a new record is inserted and the jc_compare shows a 1 as results

 

  jc_compare

 

select rxn_id,reaction, jc_compare(REACTION,'C1=CC=CC=C1>>C1=CC=CC=C1', 't:d') from DB_RCG_xxx.xxx_reactions  where (REACTION,'C1=CC=CC=C1>>C1=CC=CC=C1', 't:d') = 1;

--result was: no data found

 

 

Hi Edith,

Since the JChem Server / Structure Cache normally connects back via a different connection to the database, normally only committed inserts are visible for a subsequent search.

This only affects the fast search executed with domain index scan (after the where clause), so it is normal that otherwise the result is visible.

If you need to search within a transaction, please use this option (execution may be slower):

http://www.chemaxon.com/jchem/doc/dev/cartridge/cartapi.html#jc_compare_requireCommit

Kind regards,

Szilard

Thanks