JChem 15.4.20.0: problem with jc_equals and jc_compare

Hi all,

After upgrading Jchem to version  15.4.20.0 steel hang queries using functions jc_equals and jc_compare.

select * from chem_STRUCTS


where jc_equals(structure,to_clob('OC1[C@H](O)[C@@H](O)[C@H](O)[C@H](O1)CO'))=1

 

Query hanging for hours.

Please, help us to understand what is happened. 

Environment:

JChem server environment 
---------------------------------------------------------------------------------------------------- 
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_GG_PORTAL 
  
JChem Server environment: 
Java VM vendor: Oracle Corporation 
Java version: 1.7.0_75 
Java VM version: 24.75-b04 
JChem version: 15.4.20.0 
JChem index version: 15030900 
                                  
JDBC driver version: 11.2.0.3.0

 

Regards,

Maria

Hi Maria,

Unfortunately, there was a bug occasionally causing duplicate search to freeze in case of big tables. This bug was fixed in the latest released version of JChem (15.6.1).

Nevertheless, we recommend to use jc_compare instead of the deprecated jc_equals.

Best regards,

Krisztina

Hi Krisztina,

 

Thank you very much for the quick response.

We have updated Jchem to version 15.6.1 and began testing.

 

Regards,

Maria