Trouble with not owner users of JChem on a new installation

User 34df8f131d

25-03-2015 12:06:05

AgiLab, as
a partner of Chemaxon,  has a VALUE ADDED RESELLER LICENSE. We’ve
installed the cartridge in a new updated environment and we have some trouble
accessing (with PL/SQL) Jchem object with not owner users.


Here is our
environment /


JCHEM_CORE_PKG.GETENVIRONMENT()


Oracle environment:                                                                                                                                                                                                           
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Oracle
Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production


PL/SQL Release
12.1.0.2.0 - Production


CORE    
12.1.0.2.0           
Production


TNS for
64-bit Windows: Version 12.1.0.2.0 - Production


NLSRTL
Version 12.1.0.2.0 - Production


JChem
owner: AGILAB_CHEM


JChem
Server environment:


Java VM
vendor: Oracle Corporation


Java
version: 1.8.0_25


Java VM
version: 25.25-b02


JChem
version: 15.3.9.0


JChem index
version: 15030900


JDBC driver
version: 11.2.0.3.0


JChem
Server start directory: C:\chemaxon\jchem\cartridge


JChem
Server host:port : localhost:1099 


 


For
instance, a very simple PL/SQL function which works fine with previous
installation. This function updates a markush structure in the adequate table
created with JCAM exe


FUNCTION
modify_markush(


     
p_structure IN VARCHAR2, -- in cxsmiles


     
p_id IN NUMBER --  Id


) RETURN
BOOLEAN


IS


begin


-- Update
target


   
agilab_chem.jchem_table_pkg.jc_update(p_structure,'AGILAB_CHEM.AG_MARKUSH_LIBRARY',
p_id);


   
return true;


END
modify_markush;


 


Calling
this function from a not owner user : demo


set
serveroutput on


declare


b boolean;


begin


if
ag_jchem.modify_markush('CC(

ChemAxon abe887c64e

25-03-2015 12:22:09

Hi Renaud,


Have you tried to disconnect and reconnect your database sessions after starting the server of the updated JChem Cartridge system?


Krisztina