SQL logging

Viewing data in Instant JChem widgets, always involves executing a set of SQL statements that are constructed by IJC based on the data model or set of entities in the datatree. Sometimes and for various reasons, the data set returned might be unexpected, NULL or the SQL very slow to execute, indicating some inherent issue with the generated SQL statement. It is often useful to obtain the SQL statements and check them - the SQL logging options are available to facilitate this. There are now three levels of SQL logging available which are configured by

Tools->Options

and 'Other Settings' tab - please see the screen shot below. No logging and SQL with and without execution times define the three possible states.

{primary} For SQL logging to take effect in the log file, you need to re-connect (disconnect and connect again) to your IJC schema.