jc_compare with requireCommit:n t:d not finding structure

I was trying to use the jc_compare with the options requireCommit:n t:d and it doesn't seem to be working.

Here's the test I ran.

-- create a regular oracle table

CREATE TABLE TEST
(
   SMILES varchar2(4000) NOT NULL
);
-- create jchem molecule index
CREATE INDEX IDX_TEST_SMILE ON TEST(smiles) INDEXTYPE IS jchem.jc_idxtype PARAMETERS('absoluteStereo=y,haltOnError=y,tableType=molecules');

-- with autoCommit off

insert into TEST(smiles)
values ('c1ccccc1');

-- verify record present
select * from Test;

-- returns row from same session

-- from different session no row is visible

-- trying to execute jc_compare with indicating the search should be run in the same session

select *
from Test
where jc_compare(smiles, 'c1ccccc1', 'requireCommit:n t:d') = 1;

-- results in no records being returned.

 

Questions:

Am I using this correctly? or is this a bug?

Meant to include the environment info.

select jchem_core_pkg.getenvironment() from dual;

Oracle environment:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bi
PL/SQL Release 10.1.0.5.0 - Production
CORE    10.1.0.5.0    Production
TNS for Linux: Version 10.1.0.5.0 - Production
NLSRTL Version 10.1.0.5.0 - Production

JChem Server environment:
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_12
Java VM version: 11.2-b01
JChem version: 5.2.5.1
JChem Index version: 5020400
JDBC driver version: 11.1.0.7.0-Production

Dan,

This is a bug in JChem Cartridge which will be fixed in version 5.3.1. The workaround until then is to use the deprecated 'p' search type option for duplicate search:

t:p requireCommit:n

Thank you for reporting this problem and apologies for the inconvenience.

Peter

Thanks Peter!

This looks like it does the trick.

I'll update to the newer Duplicate naming when we install 5.3.1.

I'll update to the newer Duplicate naming when we install 5.3.1.

 

JChem 5.3.2 has been released with the fix.

Peter