Error updating structures table

Hi all,





I have created a user JCHEM, in my oracle database, which is the owner of all JChem object, structure table and property table.





I also created JCHEMUSER I granted to him all premisions and privileges following documentation.





I have a java application which maintains the structure table.





If I use the following values for the database connection everything works fine:





private String structureTableName = "ESTRUCTURES";


private String oracleDriver = "oracle.jdbc.driver.OracleDriver";


private String url = "jdbc:oracle:thin:@xxx.xxx.xxx.xxx:xxxx:xxxx";


private String loginName = "JCHEM";


private String password = "JCHEM";


private String propertyTable = "JCHEMPROPERTIES";





But if I use JCHEMUSER credentials I get two different errors depending on what value I set for structureTableName.





For the following settings





private String structureTableName = "JCHEM.ESTRUCTURES";


private String oracleDriver = "oracle.jdbc.driver.OracleDriver";


private String url = "jdbc:oracle:thin:@192.168.200.11:1521:doltp";


private String loginName = "JCHEMUSER";


private String password = "JCHEMUSER";


private String propertyTable = "JCHEM.JCHEMPROPERTIES";





I get the error: ORA-00942: table or view does not exist.





But the update is performed correctly.








For the following settings





private String structureTableName = "ESTRUCTURES";


private String oracleDriver = "oracle.jdbc.driver.OracleDriver";


private String url = "jdbc:oracle:thin:@192.168.200.11:1521:doltp";


private String loginName = "JCHEMUSER";


private String password = "JCHEMUSER";


private String propertyTable = "JCHEM.JCHEMPROPERTIES";





I get the error: No fingerprint information for JCHEM.ESTRUCTURES





and the update is not performed.





I imagine the correct configuration is the first one for JCHEMUSER, but I don't know why is producing such error.





JCHEMUSER has al privileges for JCHEM objects.





Any ideas?





Thanks a lot.

Hi,





Could you let me know your JChem and Oracle version ?





Best regards,





Szilard

Oracle 9.2.0.5


JChem 3.0.9

Hi,





I have tested the same JChem version with the same Oracle version.





I have granted the necessary privileges to JCHEMUSER.


I have tried inserting structures into the table, and it worked without error with your second set of settings.





I suspect JCHEMUSER does not have write permission on the property table.





You third set of settings are wrong, because by missing the schema you are actually referring to "JCHEMUSER.ESTRUCTURES" which does not exist.





Best regards,





Szilard

Hi,





JCHEMUSER has all permissions described in the documentation.





What it didn't have was the SELECT grant on Oracle Sequences created for structures table.





From JCHEM I issued the following command and everything worked right since then:





grant select on ESTRUCTURES_USQ to JCHEMUSER;





Please take this into consideration for future releases.





Thanks.

Hi,





Thank you for pointing this out, we will update the documentation.





Best regards,





Szilard