There are several options and the one that best suits you is largely dependent upon scale and functionality and since scripting is possible at the IJC level the former becomes less important. Often, a project might be developed to a start point using single session Derby RDBMS (free,bundled). At some point the scale or data or number of concurrent users may dictate a switch to MySQL or Oracle. The Oracle option is mandatory if your organisation will also take advantage of the scalability of the Oracle cartridge. In case of tight budget, free RDBMS like Postgres could be use and it could be extended by JChem Postgres cartridge.
There is a limit on the size of the cache in 32 bit Java of ~1600MB. There are several options to increase the cache size. If you switch to 64 bit Java this limit is theoretically infinite and should cache tens of millions of structures. You can also switch to using the Chemaxon cartridge which puts the overhead on to the Oracle server and away from the client machine.
This is a complex subject that is best discussed with the Sale/Consultancy services team. In essence IJC supports a security model and choice of policies that are somehow independent of the RDBMS security. At the simplest level one could distribute a derby zip file to the organisations you work with. With more sophisticated RDBMS (Oracle) and with correct network configuration (often VPN), one could allow direct access to external CRO's. At the IJC level the admin user can deploy objects within a schema and other roles exist to control edit/read capability. Each user within the policy owns and independently shares access to their forms. In the case of Oracle, licensing is based upon CPU's. In the case of IJC, the licence varies depending upon number of users and additional items like calculator plugins, reactor etc.
Uninstallation of IJC JWS needs to be performed manually. It is a two step process.
1. Run the command "jawas -viewer" from the Run dialog or command line and remove the application from the Java Cache Viewer window.
1. Other temporary files must be removed by hand. They are stored in $HOME/.chemaxon folder. There should be a folder named like ws_installation_Ver#. This folder contains the whole IJC and can be removed. There should be also a folder named ws_Ver# which contains shared project configurations and customizable settings for IJC. For complete uninstallation, please remove this folder too.
Apache Derby database offers a possibility to clean the database from unused space, which can occur after, for example, deletion of rows in some tables. In case of questions FreshDesk
When updating IJC by the Auto Update Center, the libraries used for the upgrade will be stored in the USERDIR. The uninstaller however does not clean them up and therefore the uninstallation has to be completed manually, by removing those left temporary files. The files are usually located in C:\Users\username\AppData\Roaming\.instantjchem\IJCVERSION (typically for windows). This folder should be deleted after performing uninstallation. You can find the exact location of the USERDIR in Help -> About InstantJChem.
This special case might be needed when for example downgrading IJC after an update by Auto Update Center, which breaks functionality because of expired license for that particular new version.
{warning} Please note that by deleting all the content of instantjchem directory (not only the IJCVERSION subdirectory), you might also delete settings for other possible versions of IJC running in parallel.
Please remove/rename the old/existing userdir. This can be found using Help → Instant JChem. Re-start IJC and the problem should be resolved.
Please try data → reload data to refresh calculated field values.
Data can be visualised by binding entity data to widgets which is a task completed during form building. There are a number of these "Viz" widgets such as scatter plot, histogram, radarchart and box plot.
IJC structures are usually stored in BLOB or CLOB columns. IJC has some limitation how much data from a BLOB/CLOB column can get for one item. By default it is set to 10241024 bytes and hence Markush structures might be pretty big, IJC just shows blank cell. You can workaround it by setting your own limit by startup option: ijc.lobs.maxSize=* <number of bytes>. Please see more about how to set this option in admin's guide.
This problem is caused by Ubuntu and certain bugs in how Java is treated in the latest versions. The workaround for that is to run the following command from terminal, or put the following command to a startup script so that it runs any time the user logs in.
unset GNOME_DESKTOP_SESSION_IDIf you are using Java 8 can you please try to install Java 11 and see if the problem with resolution persists. If there is a reason, that you cannot upgrade to higher version of java, you can use following parameter as workaround for that. Set following in instantjchem.conf file.
-J-Dsun.java2d.dpiaware=falseEverything will be scaled, including the user content. Downside effect is that text and graphics will be a little blurry.
There are several entry points in the IJC application that facilitate Groovy coding. You can add scripted calculated fields at the entity level or compile full scripts at the data tree or schema levels depending upon the nature of the task. You can use these scripts to complete among other things, data import/export and derivations.
An alternative to calculated fields are columns populated using triggers. Cartridge functions can be adopted in such a mechanism to utilise Chemaxon functionality. Additionally these are normal fields and can be queried and ordered.