Disabling check of existing tables in SQLDirectory

Antonio_Pescion — Thu, 01 Jun 2017 15:38:52 GMT

Is there any way to skip the check of the existing tables in SQLHelper class?

This is because for security reasons (lower-privileged database user). I need to use synonyms (oracle) in place of actual tables and it seems, looking at SQLHelper class, that nuxeo performs a preliminary check by table metadata that doesn't work when the synonyms are used.

Thank you in advance

More information:

I performed a test changed this row in org.nuxeo.ecm.directory.sql.SQLHelper in tableExists method:

ResultSet rs = metaData.getTables(null, schemaName, table.getPhysicalName(), new String[] { "TABLE" }); ResultSet rs = metaData.getTables(null, schemaName, table.getPhysicalName(), new String[] { "TABLE", "VIEW", "SYNONYM"});

and I haven't anymore errors

Re: Disabling check of existing tables in SQLDirectory

Florent_Guillau — Thu, 27 Jul 2017 11:13:48 GMT

You could change all your directory/vocabulary configurations to have <createTablePolicy>never</createTablePolicy> but that's a lot of directories to track down. Otherwise NXP-19635 would solve this but it's not yet scheduled to be implemented.

topic Disabling check of existing tables in SQLDirectory in Nuxeo Forum

Disabling check of existing tables in SQLDirectory

Re: Disabling check of existing tables in SQLDirectory