See also Marvin changes and JChem changes. These changes will also be automatically included in IJC since IJC uses Marvin and JChem.
{info} IJC verion 23.11.0 and higher require Java 17 and use Spring Security 6 framework. Spring Security 6 framework upgrade is automatic, but in special cases it can be modified manually. IJC can be now deployed using Open Web Start and IcedTeaWeb in the same manner as with Java Web Start. The overall functioning of both tools is also identical.
Marvin/Jchem 24.2.4 are used. JChem tables will not be regenerated from 24.1.2. IJC metadata will not be regenerated from the previous version.
Fixes to Java Web Start docker image related to Java, Tomcat, IJC license handling, project download links, etc.
Tautomer default settings in duplicate search in entity with tautomer duplicate checking is changed to "on".
Marvin/Jchem 24.2.3 are used. JChem tables will not be regenerated from 24.1.2. IJC metadata will not be regenerated from the previous version.
Default widget's border aligned when a widget is added into a container widget. This avoids hidden widget borders.
Disappearing scrip code of inner widgets (which are inside panel or tabpanel widget) fixed.
Marvin/Jchem 24.2.2 are used. JChem tables will not be regenerated from 24.1.2. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 24.2.1 are used. JChem tables will be regenerated to 24010200. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 23.6.5 are used. JChem tables will not be regenerated from 23.5.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 24.1.0 are used. JChem tables will not be regenerated from 24.1.0. IJC metadata will not be regenerated from the previous version.
Guava dependency changed. java.lang.NoClassDefFoundError: com/google/common
avoided in scripting.
Misleading export behavior fixed when fields from child entity only are selected
Header/footer configuration for printing can be also defined in IJC schema by administrator.
Structure's background color setting for table-type widgets fixed.
Schema refresh UX improved: When there is unavailable or poorly configured schema refresh in IJS file, pop-up "Schema refresh is not available for:..." alert message on schema-init event appears.
Calculated field can use an Extension field and vice versa.
New web service entity plugin calls ChEMBL to get descriptors for a molecule (aka chemical terms). Web service entity documentation updated.
Marvin/Jchem 23.15.2 are used. JChem tables will not be regenerated from 23.10.0. IJC metadata will not be regenerated from the previous version.
Multiple suspended table widgets bound to different child entities are now suspended / resumed properly.
Added support for Excel Date import (decimal number of days since 1900)
Marvin/Jchem 23.6.4 are used. JChem tables will not be regenerated from 23.5.0. IJC metadata will not be regenerated from the previous version.
Multiple suspended table widgets bound to different child entities still were not suspended / resumed properly.
Added support for Excel Date import (decimal number of days since 1900)
Structure's background color setting for table-type widgets fixed.
Marvin/Jchem 23.16.0 are used. JChem tables will not be regenerated from 23.16.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 23.16.0 are used. JChem tables will not be regenerated from 23.16.0. IJC metadata will not be regenerated from the previous version.
UI improvement - warning colors in Add-new-row dialog.
Multiple suspended table widgets bound to different child entities still are suspended/resumed properly.
Default font in widgets/renderers taken from JVM. It can be set also programmatically using com.chemaxon.ijc.form.api.AbstractWidget.setDefaultFont()
method call.
Added support for Excel Date import (decimal number of days since 1900).
Fixed - IJC sometimes froze during IJC close or project close.
Marvin/Jchem 23.15.1 are used. JChem tables will not be regenerated from 23.10.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 21.15.9 are used. JChem tables will not be regenerated from 21.15.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 23.6.3 are used. JChem tables will not be regenerated from 23.5.0. IJC metadata will not be regenerated from the previous version.
Added Attached Data search options - match type and prefixes.
Suspended table widget was not resumed properly during data reload.
Histogram chart widget "Start value" parameter business logic fixed.
Printing of child data fixed. (Broken since 23.5.0)
Marvin/Jchem 22.17.7 are used. JChem tables will not be regenerated from 21.16.0. IJC metadata will not be regenerated from the previous version.
Histogram chart widget "Start value" parameter business logic fixed.
Suspended table widget is now resumed properly during data reload.
Marvin/Jchem 23.12.0 are used. JChem tables will not be regenerated from 23.9.0. IJC metadata will not be regenerated from the previous version.
Choral and JPC entity can be deleted (again).
Java 17 is now bundled in installers.
Vulnerability CVE-2023-2976 fixed.
JPC - read molecule type and extract the standardizer. Display the standardizer as read-only in the entity customizer. Use the standardizer for display as standardized and similarity calculation.
Embeded MarvinSketch now persists its settings (to be common also for structure renderers).
Printing of child data fixed. (Broken since 23.5.0)
Fixed/re-enabled missing items in the services menu.
WebBrowserRenderer also handles String values and other non-image values.
Histogram chart widget "Start value" parameter business logic fixed.
Added Attached Data search options - match type and prefixes.
MSI installer is now signed.
Printing of table widgets improved - print output contains multi column headers
Suspended table widget is now resumed properly during data reload.
MS SQL JDBC driver was upgraded to 11.2.3.jre17 version. Note that since version 10.2 driver enables encryption by default and either certificates are used on client/server or encryption is disabled by adding ;encrypt=false to the jdbc connection url.
Vulnerability CVE-2016-1000027 fixed.
Marvin/Jchem 23.6.2 are used. JChem tables will not be regenerated from 23.5.0. IJC metadata will not be regenerated from the previous version.
Boolean field editing issues on PostgreSQL fixed.
Suspended table widget is now resumed properly.
Marvin/Jchem 23.9.0 are used. JChem tables will not be regenerated from 23.7.0. IJC metadata will not be regenerated from the previous version.
Suspended table widget is now resumed properly.
Boolean field editing issues on PostgreSQL fixed.
Marvin/Jchem 21.15.8 are used. JChem tables will not be regenerated from 21.15.0. IJC metadata will not be regenerated from the previous version.
Issue with version specific spring-security xml templates fixed.
Suspended table widget is now resumed properly.
Link to the new EULA is now used in IJC installer.
Mouse Mode option of a widget's structure renderer is persisted in the view. Default mode is "None".
Marvin/Jchem 22.17.6 are used. JChem tables will not be regenerated from 21.16.0. IJC metadata will not be regenerated from the previous version.
Problem with version specific spring-security xml templates fixed.
Suspended table widget is now resumed properly
Marvin/Jchem 23.8.0 are used. JChem tables will not be regenerated from 23.7.0. IJC metadata will not be regenerated from the previous version.
New IJC toolbar called Data Age
turned off by default
turn it on using menu View -> Toolbars -> Data Age
no further UI / configuration
displays HH:MM:SS elapsed time since data has been loaded into current Resultset
in tooltip displays name of Resultset (~Datatree)
Checkbox widget horizontal alignment issue fixed
All JPC molecule types are visible to a user and can be selected using a combobox (when creating an entity, etc.)
Marvin/Jchem 23.6.1 are used. JChem tables will not be regenerated from 23.5.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 23.8.0 are used. JChem tables will not be regenerated from 23.7.0. IJC metadata will not be regenerated from the previous version.
Problem with version specific spring-security xml templates fixed.
Calculate similarity also available for Choral cartridge.
CVE-2016-1000027 fixed.
Marvin/Jchem 23.5.0 are used. JChem tables will not be regenerated from 23.5.0. IJC metadata will not be regenerated from the previous version.
Similarity search results might differ. See: https://docs.chemaxon.com/display/docs/jchem-base_history-of-changes.md#april-5th-2023-jchem-base-2350
Broken distributions from 23.2.0 fixed.
Date and numeric fields copied to clipboard are now identical to its text-formatted representation.
Duplicit rows in grand-child data which were present in printed documents fixed.
New "Sgroup data formatted" option was added to the Structure renderer.
Marvin/Jchem 22.17.5 are used. JChem tables will not be regenerated from 21.16.0. IJC metadata will not be regenerated from the previous version.
Mouse Mode option of a widget's structure renderer is persisted in the view. Default mode is "None".
Fixed schema upgrade when security template contains special UTF-8 characters.
Marvin/Jchem 23.2.0 are used. JChem tables will not be regenerated from 23.2.0. IJC metadata will not be regenerated from the previous version.
Mouse Mode option of a widget's structure renderer is persisted in the view. Default mode is "None".
Improved DB trigger performance for JPC Chemical terms fields.
Fixed Boolean Chemical terms on PostgreSQL (use SMALLINT type instead of BOOL). Changed Boolean fields on MySQL (use TINYINT type explicitly).
Link to the new EULA used in IJC installer.
Marvin/Jchem 22.19.0 are used. JChem tables will not be regenerated from 22.19.0. IJC metadata will not be regenerated from the previous version.
Admin can setup password expiration and first password must-change for a user when using IJC tables for user management.
Fixed schema upgrade when security template contains special UTF-8 characters.
Marvin/Jchem 22.17.4 are used. JChem tables will not be regenerated from 21.16.0. IJC metadata will not be regenerated from the previous version.
Occasional error fixed: java.lang.IllegalStateException: Unexpected state - data request for suspended widget.
Improved performance of exported fields dialog.
Marvin/Jchem 21.15.7 are used. JChem tables will not be regenerated from 21.15.0. IJC metadata will not be regenerated from the previous version.
Improved performance of exported fields dialog.
CVE-2022-45868 - fixed.
CVE-2022-4065 fixed.
Fixed schema upgrade when security template contains special UTF-8 characters.
Occasional error fixed: java.lang.IllegalStateException: Unexpected state - data request for suspended widget.
Fixed NPE exception when opening Tools > Options > Miscellaneous and reading instantjchem.conf.
Fixed printing of List fields by joining their values with a newline.
Marvin/Jchem 22.19.0 are used. JChem tables will not be regenerated from 22.19.0. IJC metadata will not be regenerated from the previous version.
Improved performance of exported fields dialog.
Fixed printing of List fields by joining their values with a newline.
New 'All hits' option added to search options to iterate over all R-group decompositions.
Structure similarity can be calculated using new Extension field com.im.df.impl.db.field.extension.use.SimilarityCalculator. Similarity can be sorted, compared, queried and exported.
Marvin/Jchem 22.19.0 are used. JChem tables will not be regenerated from 22.19.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 22.17.3 are used. JChem tables will not be regenerated from 21.16.0. IJC metadata will not be regenerated from the previous version.
CVE-2022-37865 & CVE-2022-37866 fixed.
CVE-2022-4065 fixed.
Fixed printing of List fields by joining their values with a newline.
Marvin/Jchem 22.6.5 are used. JChem tables will not be regenerated from 21.20.0. IJC metadata will not be regenerated from the previous version.
Add groovy-dateutil library to enable Date().clearTime() again.
Oracle database Java classes for NLS or Internalization support included into IJC.
CVE-2022-42004 & CVE-2022-42003 fixed.
CVE-2022-42889 - OpenCSV security vulnerability fixed.
CVE-2022-31692 fixed.
CVE-2022-37865 & CVE-2022-37866 fixed.
Marvin/Jchem 21.15.6 are used. JChem tables will not be regenerated from 21.15.0. IJC metadata will not be regenerated from the previous version.
Add groovy-dateutil library to enable Date().clearTime() again.
Cannot connect to Oracle database using Japanese characters.
CVE-2022-42004 & CVE-2022-42003 fixed.
Marvin/Jchem 22.19.0 are used. JChem tables will not be regenerated from 22.19.0. IJC metadata will not be regenerated from the previous version.
CVE-2022-31692 fixed.
Added more customization options to the form editor.
Oracle database Java classes for NLS or Internalization support included into IJC.
Error popup window re-enabled. (Disabled in 22.7.0).
CVE-2022-42889 - OpenCSV security vulnerability fixed.
CVE-2022-42004 & CVE-2022-42003 fixed.
Export button status (enabled / disabled) aligned.
Copy-pasting of widgets and whole forms improved.
Marvin/Jchem 22.17.2 are used. JChem tables will not be regenerated from 21.16.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 22.17.1 are used. JChem tables will not be regenerated from 21.16.0. IJC metadata will not be regenerated from the previous version.
Add groovy-dateutil library to enable Date().clearTime() again.
Oracle database Java classes for NLS or Internalization support included into IJC.
CVE-2022-42004 & CVE-2022-42003 fixed.
CVE-2022-42889 - OpenCSV security vulnerability fixed.
Error popup window re-enabled. (Disabled in 22.7.0)
Marvin/Jchem 22.6.4 are used. JChem tables will not be regenerated from 21.20.0. IJC metadata will not be regenerated from the previous version.
Properly report invalid license during chemical terms validation.
Random java.lang.IllegalStateException: unprocessed multiEntityResponse from table and sheet widget fixed. (The only affected released version is 22.6.x. Fixed in 22.6.4.)
Fixed labels in a Groovy script withLock usage.
Updated Apache Commons Configuration library to 2.8.0 due to security issue.
Marvin/Jchem 22.16.0 are used. JChem tables will not be regenerated from 22.15.0. IJC metadata will not be regenerated from the previous version.
"Save working list" dialog improved. List of existing lists is alphabetically sorted, user can use "starts with" letters to change selection within the list.
Added Insert/Edit/Delete setting to JPC and Choral customizer.
Added Isotope matching (On/Exact/Ignore) to Duplicate search options. Exact is the default.
Added SQL filter option to JPC and Choral customizer.
Added default sort field option to JPC and Choral customizer.
CVE-2020-36518 fixed.
CVE-2022-22968 fixed.
Copy-pasting long in-list query string into a widget in query mode fixed. Clipboard content is not shrunk any more.
Fixed PDF import (broken since 21.5.0).
Fixed labels in a Groovy script withLock usage.
Improve JPC chemical terms calculation for molecules causing an error.
Improved JPC and JCC cartridge detection.
NPE when copy-pasting widget with conditional formatting between different datatrees fixed.
New structure format CXON adopted. See https://docs.chemaxon.com/display/docs/formats_marvin-documents-cxon.md
PickList uses values instead of labels for single and multiple item selection and saving/loading.
Properly report invalid license during chemical terms validation.
Random java.lang.IllegalStateException: unprocessed multiEntityResponse from table and sheet widget fixed. (The only affected released version is 22.6.x. Fixed in 22.6.4.).
Sheet widget automatically binds all fields from entity (problem solved).
The JWS installer is available from a docker container.
Updated Apache Commons Configuration library to 2.8.0 due to security issue.
When new field is created it is automatically added to sheet and table widgets in focused formview or gridview ONLY!
Marvin/Jchem 21.15.5 are used. JChem tables will not be regenerated from 21.15.0. IJC metadata will not be regenerated from the previous version.
Updated Apache Commons Configuration library to 2.8.0 due to security issue.
Fixed labels in a Groovy script withLock usage.
Properly report invalid license during chemical terms validation.
Marvin/Jchem 21.15.4 are used. JChem tables will not be regenerated from 21.15.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 22.6.3 are used. JChem tables will not be regenerated from 21.20.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 21.15.3 are used. JChem tables will not be regenerated from 21.15.0. IJC metadata will not be regenerated from the previous version.
Fixed PDF import (broken since 21.5.0).
Sheet widget automatically binds all fields from entity (problem solved).
PickList uses values instead of labels for single and multiple item selection and saving/loading.
Printing structures to ODT format fixed.
Copy-pasting long in-list query string into a widget in query mode fixed. Clipboard content is not shrinked any more.
Marvin/Jchem 22.6.2 are used. JChem tables will not be regenerated from 21.20.0. IJC metadata will not be regenerated from the previous version.
Printing structures to ODT format fixed.
CVE-2020-36518 fix
CVE-2022-22968 fix
Fixed PDF import (broken since 21.5.0)
Sheet widget automatically binds all fields from entity (problem solved)
Copy-pasting long in-list query string into a widget in query mode fixed. Clipboard content is not shrunk any more.
Marvin/Jchem 22.6.1 are used. JChem tables will not be regenerated from 21.20.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 21.15.2 are used. JChem tables will not be regenerated from 21.15.0. IJC metadata will not be regenerated from the previous version.
"Open in a new Tab" functionality fixed. This allows having multiple independent resultsets within the same datatree.
Printing structures to ODT format fixed.
In TabbedPane widget, users can specify tabs placement (Top, Left, Bottom, Right) and tabs layout (Wrap, Scroll) in tabbed pane customizer.
JNLPInstaller allows to define new --javadirs
argument in jnlp
file. Parameter contains multiple Java directories separated by semicolon. First directory that exists is used to run IJC.
Marvin/Jchem 22.6.0 are used. JChem tables will not be regenerated from 21.20.0. IJC metadata will not be regenerated from previous version.
ChemAxon company name changes to Chemaxon.
Printing of missing static labels fixed - for widget border titles, and panel titles. Also printing of booleans and sheet widget fixed.
UrlWebApp supports JNLPInstaller*.jar installer names. JNLPInstaller logs IJC version from info.properties.
Chemaxon logo updated.
MassSpectrum renderer is part of the IJC core now. Rendering was improved - more precise, better grid and colors, peaks displayed in a widget. Can parse Mass spectral peaks (MSP) format defined by chemdata.nist.gov (maximum peak is 100.0). Canvas handles data changes using new onEDPChange(). Groovy handler - renamed onChange to onVSChange.
Fixed - script output window isn't showing when script hook is executed.
hERG plugin available in Marvin Sketch. hERG calculations disabled (for chemical terms fields).
Default structure search type on schema level (Edit Schema -> Schema -> Misc.). Stored in database.
File import of Excel format improved.
Marvin/Jchem 21.4.6 are used. JChem tables will not be regenerated from 21.4.0.0. IJC metadata will not be regenerated from the previous version.
"Open in a new Tab" functionality fixed. (This allows having multiple independent resultsets within the same datatree.) (IJC-11752)
Printing structures to ODT format fixed. (IJC-11696)
Printing: Table header accepts font of table widget/gridview. (IJC-11730)
Fixed - script output window isn't showing when script hook is executed.(IJC-11757)
TabbedPane widget: User can specify tabs placement (Top, Left, Bottom, Right) and tabs layout (Wrap, Scroll) in tabbed pane customizer. (IJC-11729)
Marvin/Jchem 21.20.0 are used. Full regeneration is needed to use JChem 21.20.0. Please, regenerate all JChem tables after upgrade. The new table version is 21.20.0.0
IJC runs on Java 11 and above. Java 8 support deprecated.
New experimental Web service entity for data retrieval. Requires special startup option to create and needs a plugin installed for custom handler.
New experimental Extension field for data retrieval and custom query using Java plugins. Used for BLAST search - macromolecule subsequence query.
"Open in a new Tab" functionality fixed. (This allows having multiple independent resultsets within the same datatree.)
JNLPInstaller allows to define new --javadirs argument in jnlp file. Parameter contains multiple Java directories separated by semicolon. First directory that exists is used to run IJC.
TabbedPane widget: User can specify tabs placement (Top, Left, Bottom, Right) and tabs layout (Wrap, Scroll) in tabbed pane customizer.
java.lang.ClassNotFoundException related to License and/or Naming module fixed.
Printing structures to ODT format fixed.
Marvin/Jchem 21.15.1 are used. JChem tables will not be regenerated from 21.15.0 IJC metadata will not be regenerated from the previous version.
Upgraded Oshi library to version 5.2.1.
Importing data into cartridge environments fixed. When a single record cannot be imported (for example due to a constraint violation) other records from the same chunk are imported correctly.
OpenID authentication introduced to IJC. Amazon Cognito it the only supported and tested OpenID provider till now.
Lists default naming behavior changed:
default list name is composed from current date and time (was time only before)
datetime is always appended to default list name
user is always asked for list name when promoting temporary list to permanent (until Do not ask for name when making a list permanent option is activated)
Import error log file when importing invalid data improved. Error log file for structural file formats is always SDF format and is readable by molecule viewers (like MarvinView).
Standardizer free actions are available in IJC even without Standardizer license.
Improved performance of schema init (JChem cache registration, Groovy script parsing, XML parsing, JPC/JCC table init).
Marvin/Jchem 21.4.5 are used. JChem tables will not be regenerated from 21.4.0.0. IJC metadata will not be regenerated from the previous version.
Marvin/Jchem 21.15.0 are used. Full regeneration is needed to use JChem 21.15.0. Please, regenerate all JChem tables after upgrade. The new table version is 21.15.0.0
Improved performance of schema init (JChem cache registration, Groovy script parsing, XML parsing, JPC/JCC table init). (IJC-11695)
Importing data into cartridge environments fixed. When a single record cannot be imported (for example due to a constraint violation) other records from the same chunk are imported correctly. (IJC-11710)
Import error log file when importing invalid data improved. Error log file for structural file formats is always SDF format and is readable by molecule viewers (like MarvinView). (IJC-11712)
Standardizer free actions are available in IJC even without Standardizer license. (IJC-11680)
Lists default naming behavior changed: (IJC-11686)
default list name is composed from current date and time (was time only before)
datetime is always appended to default list name
user is always asked for list name when promoting temporary list to permanent (until Do not ask for name when making a list permanent option is activated)
OpenID authentication introduced to IJC. (Amazon Cognito it the only supported and tested OpenID provider till now.) (IJC-11665)
Random IllegalStateException when deleting fields fixed. (IJC-11579)
Schema init dialogs UX improved. (IJC-11520)
Upgraded Oshi library to version 5.2.1. (IJC-11506)
Marvin/Jchem 20.19.5 are used. JChem tables will not be regenerated from 20.12.0. IJC metadata will not be regenerated from previous version.
Marvin/Jchem 21.4.4 are used. JChem tables will not be regenerated from 21.4.0.0. IJC metadata will not be regenerated from the previous version.
Improved performance of schema init (JChem cache registration, Groovy script parsing, XML parsing, JPC/JCC table init). (IJC-11695)
Lists default naming behavior changed (IJC-11686)
Fixed display of an error message for default sort of Calculated fields. (IJC-11683)
Marvin/Jchem 20.14.0 are used. JChem tables will not be regenerated from 21.10.0. IJC metadata will not be regenerated from previous version.
Grouping table header od pivot table / gridview fixed. (Broken since IJC 21.8.0) (IJC-11688)
User is notified when schema refresh uses HTTP url instead of HTTPS. This warning can be turned off in .ijs file by setting ijc.schema.refresh.http.warning property to false. (IJC-11662)
Marvin/Jchem 20.13.0 are used. JChem tables will not be regenerated from 21.10.0. IJC metadata will not be regenerated from previous version.
Marvin/Jchem 20.19.4 are used. JChem tables will not be regenerated from 20.12.0. IJC metadata will not be regenerated from previous version.
Random NullPointerException from StructureRenderer fixed. (IJC-11640)
Admin privileges are no longer enforced during installation on Windows system. (IJC-11371)
Incorrect license evaluation is fixed. Any license has been incorrectly considered as expired one month earlier in Gallium.3 and Helium.1 and Helium.2. (IJC-11656)
Marvin/Jchem 20.10.0 are used. JChem tables will not be regenerated from 21.8.0. IJC metadata will not be regenerated from previous version.
Marvin/Jchem 20.19.3 are used. JChem tables will not be regenerated from 20.12.0. IJC metadata will not be regenerated from previous version.
Sheet widget is blank after data reload - problem fixed in Gallium.3 and Helium.1 LTS. (IJC-11626)
"Show tooltip" option appearance and persistence for chart widgets fixed. (IJC-11558)
Long application start when License key is in use, is solved by license checks updated in order to handle central Chemaxon licensing server. (IJC-11574)
IJC Gallium 3 is now compatible with MacOS Big Sur. (IJC-11588)
A couple of NullPointerEceptions thrown by the MolMatrix widget, after a view is reopened is fixed. (IJC-11625)
Fixed rendering of large texts in Sheet and Table widget cells. (IJC-11632)
Fixed charts-axis-not-updated bug. (IJC-11642)
Projects created by IJC version 2.2x and 2.3x were deprecated. (IJC-11633)
MacOS DMG installer is now notarized = trusted by Apple. (IJC-11619)
MacOS DMG installer is signed now. (IJC-11375)
Fixed persistence of Show R/S labels option of Structure Renderer. (IJC-11605)
Marvin/Jchem 21.4.2 are used. JChem tables will not be regenerated from 21.4.0.0. IJC metadata will not be regenerated from the previous version.
A couple of NullPointerEceptions thrown by the MolMatrix widget, after a view is reopened is fixed. (IJC-11625)
Fixed rendering of large texts in Sheet and Table widget cells. (IJC-11632)
Projects created by IJC version 2.2x and 2.3x were deprecated. (IJC-11633)
Marvin/Jchem 21.8.0 are used. Full regeneration is needed to use JChem 21.8.0. Please, regenerate all JChem tables after upgrade. The new table version is 21.8.0.0
Projects created by IJC version 2.2x and 2.3x were deprecated. (IJC-11633)
MacOS DMG installer is now notarized = trusted by Apple. (IJC-11619)
Plexus Connect simple tabe option -> https://docs.chemaxon.com/display/docs/discontinued_plexus-suite_simple-table.md is deprecated and it has been removed, because the performace problem of loading table widgets is solved. (IJC-11617)
Long application start when License key is in use, is solved by license checks updated in order to handle central Chemaxon licensing server. (IJC-11574)
NullPointerException after click in Browser widget fixed. (IJC-11481)
Sheet widget can include fields from child convergent entities. (The same way as Table widget can). (IJC-9720)
Marvin/Jchem 21.4.1 are used. JChem tables will not be regenerated from 21.4.0.0. IJC metadata will not be regenerated from the previous version.
Persistence of “Show R/S labels” option of the Structure Renderer has been fixed. (IJC-11605)
Formatting of JavaHelp has been improved: default font, bold style, pre/code background, block quote colors, headers and tables have been set. (IJC-11568)
The IJC application icon has been updated. (IJC-11555)
The F1 key, as well as various help buttons which appear in different sections of the application, are now connected to the proper sections of IJC offline JavaHelp. This function is context-sensitive - the part of the JavaHelp content relevant to the user’s current action is always displayed. (IJC-10109)
License checks were updated in order to handle the central ChemAxon licensing server. (IJC-11574)
Sheet widgets are not blank after data reload anymore. (IJC-11626)
IJC is now compatible with MacOS BigSur. (IJC-11588)
The MacOS DMG installer is signed now. (IJC-11375)
Marvin/Jchem 21.4.0 are used. Full regeneration is needed to use JChem 21.4.0. Please, regenerate all JChem tables after upgrade. The new table version is 21.4.0.0
Persistence of “Show R/S labels” option of the Structure Renderer has been fixed. (IJC-11605)
Formatting of JavaHelp has been improved: default font, bold style, pre/code background, block quote colors, headers and tables have been set. (IJC-11568)
The IJC application icon has been updated. (IJC-11555)
The F1 key, as well as various help buttons which appear in different sections of the application, are now connected to the proper sections of IJC offline JavaHelp. This function is context-sensitive - the part of the JavaHelp content relevant to the user’s current action is always displayed. (IJC-10109)
The Clean 2D and Clean 3D actions are now available in IJC Standardizer configuration. (IJC-11577)
Improved displaying of images in JavaHelp. (IJC-11572)
A Dynamic URL field can depend on a Calculated field. Also, a Calculated field which does not depend on any other field, gets properly evaluated. (IJC-11571)
Marvin/Jchem 20.19.2 are used. JChem tables will not be regenerated from 20.12.0. IJC metadata will not be regenerated from previous version.
Filtering child data bug (which was present since version 20.16.0) has been fixed. (IJC-11534)
Fixed ordering of child data when NULL ordering is changed in Schema settings. (IJC-11523)
Updating/inserting exceptions are properly displayed on the UI. In the previous versions, they were present in the log file only. (IJC-11547)
Data caching in table widgets has been changed. Now, the query clears the cache and getting data is optimized. (IJC-11548)
Improved error messages when editing chemical terms expressions. (IJC-11466)
A new offline documentation of IJC has been introduced. The source of JavaHelp has been changed. Now, IJC Help contains the product documentation in a different format and has a different layout. (IJC-11512)
Marvin/Jchem 21.2.0 are used. JChem tables will not be regenerated from 20.20.0.0. IJC metadata will not be regenerated from previous version.
"Show tooltip" option appearance and its persistence for chart widgets has been fixed. (IJC-11558)
Entity/datatree default sort persistence has been fixed. Now, the fields-sorting customizer handles the default sorting on an entity or datatree correctly. (IJC-11557)
Fixed sheet widget rowHeight and headerTitle settings persistence (broken in 20.20.0 only). (IJC-11556)
Occasionally a NullPointerException
was thrown after applying undo/redo
when widgets were created or deleted in design mode. This bug has been fixed. (IJC-11551)
Data caching in table widgets has been changed. Now, the query clears the cache and getting data is optimized. (IJC-11548)
Updating/inserting exceptions are properly displayed on the UI. In the previous versions, they were present in the log file only. (IJC-11547)
Filtering child data bug (which was present since version 20.16.0) has been fixed. (IJC-11534)
Improved performance of loading data after query on Oracle cartridge. (IJC-11532)
Fixed ordering of child data when NULL ordering is changed in Schema settings. (IJC-11523)
Several libraries upgraded (Guava, Gson, etc.) to run IJC on Java 11. Performance improved for table header display and pivoting. (IJC-11514)
A new offline documentation of IJC has been introduced. Source of JavaHelp has been changed. Now, IJC Help contains the product documentation in a different format and has a different layout. (IJC-11512)
The NetBeans platform has been upgraded to version 12.1. (IJC-11511)
IJC is fully compatible with MySQL 8, there is no need to adjust a default distribution. (IJC-11478)
Marvin/JChem 20.20.0 are used. Regeneration of Query Structures type tables is needed to use JChem 20.20.0. Please regenerate Query Structures JChem tables after upgrade. The new table version is 20.20.0.0. The version number of the other types of JChem tables has not changed.
"Hide column(s)" right-click action removed from table widget. (IJC-11531)
Improved performance of data loading on Derby database and export performance on all databases. (IJC-11528)
There is no error thrown when ROWID column type is used together with empty value generator. (IJC-11519)
Fixed runtime exception when creating a new field. (IJC-11518)
IJC stabilized when editing active datatrees. Runtime exceptions avoided. (IJC-11495)
Label widget customizers tweaked. (IJC-11494)
The CNS MPO (Central Nervous System Multiparameter Optimization) chemical terms expression has been implemented to favorite expressions. (IJC-11475)
Improved error messages when editing chemical terms expressions. (IJC-11466)
The sheet widget utilizes the Field Selector Panel for binding and ordering fields – in the same way as the table widget does. (IJC-6245)
Marvin/Jchem 20.19.1 are used. JChem tables will not be regenerated from 20.12.0. IJC metadata will not be regenerated from previous version.
Fixed runtime exception when creating a new field. (IJC-11518)
There is no error thrown when ROWID column type is used together with empty value generator. (IJC-11519)
Marvin/Jchem 20.19.0 are used. JChem tables will not be regenerated from 20.12.0. IJC metadata will not be regenerated from previous version.
When performing similarity search by JChem PostgreSQL Cartridge (JPC), similarity values of the found molecules are displayed correctly. (IJC-11499)
The IJC Plugins wizard shows the list of installed plugins accurately. (IJC-11493)
The IS VOID operator has been implemented for querying of child entities. By following IS NULL OR NOT EXISTS logic, it returns fields with NULL value and missing (not existing) rows in the child table. (IJC-11491)
The online dashboard is accessible again and there is no warning message displayed indicating that it is offline. The web browser widget supports HTTPS. (IJC-11490)
Sort in a form (data tree sort) could be invalid if a child entity had been removed from a data tree. Invalid sort results are now removed during the schema initialization if a child entity has been removed from a data tree. (IJC-11487)
Displaying updated data both in table widget and grid view has been fixed when 'connect.backend.mode'
startup option is on. (IJC-11485)
New options have been added into JChem PostgreSQL Cartridge (JPC) search: dbsmarkedonly - double bond stereo option and ignoretetrahedralstereo - ignore tetrahedral stereo option. (More information about these options are available in JPC API documentation here.) Also, JPC version is logged during the schema initialization. (IJC-11484)
A new standard widget – the Canvas widget has been added for custom drawing. It calls users' code for data retrieval and visualization. This code can be either a Groovy script or a Java handler from plugin. The Canvas widget can respond to mouse and keyboard input. Also added a new renderer – the Canvas cell renderer for custom drawing in tables with user code in Java. Both features support custom visualization: new charts and column renderers can be implemented, using external libraries is allowed. Visualization can be configured using settings in JSON map format. . (IJC-11458)
IJC uses Spring 5 now. The issue with adding a Binary field on Oracle DB with NullPointerException
has been fixed. (IJC-11420)
To better distinguish pivot entities against other entity types, a blue icon has been assigned to the pivot entity. Newly, a data tree containing only pivot entities has also blue icon. (IJC-10020)
The table widget does not become blank either after reloading data or after copying and pasting of a single value. (IJC-11500)
Scripts are properly saved. A custom default script is not lost after adding or editing anymore. (IJC-11258)
Changed query logic - any child field query (null or not null) implies INNER join. Also, if target field (used in SELECT column) is ID from a non-master entity or belongs to a child entity then use INNER join. (IJC-11449)
The issue with editing of date values has been fixed. (IJC-11398)
The issue with copying a structure to clipboard has been fixed. (IJC-11450)
Querying issue of Boolean values on PostgreSQL has been fixed. (IJC-11457)
Displaying updated data both in table widget and grid view has been fixed when "connect.backend.mode" startup option is on. (IJC-11485)
Sort in a form (data tree sort) could be invalid if a child entity had been removed from a data tree. Invalid sort results are now removed during the schema initialization if a child entity has been removed from a data tree. (IJC-11487)
The online dashboard is accessible again and there is no warning message displayed indicating that it is offline. The web browser widget supports HTTPS. (IJC-11490)
The IS VOID operator has been implemented for querying of child entities. By following IS NULL OR NOT EXISTS logic, it returns fields with NULL value and missing (not existing) rows in the child table. (IJC-11491)
The table widget does not become blank either after reloading data or after copying and pasting of a single value. (IJC-11500)
Scripts are properly saved. A custom default script is not lost after adding or editing anymore. (IJC-11258)
The issue with copying a structure to clipboard has been fixed. (IJC-11450)
Querying issue of Boolean values on PostgreSQL has been fixed. (IJC-11457)
Displaying updated data both in table widget and grid view has been fixed when connect.backend.mode startup option is on. (IJC-11485)
Sort in a form (data tree sort) could be invalid if a child entity had been removed from a data tree. Invalid sort results are now removed during the schema initialization if a child entity has been removed from a data tree. (IJC-11487)
The online dashboard is accessible again and there is no warning message displayed indicating that it is offline. The web browser widget supports HTTPS. (IJC-11490)
The IS VOID operator has been implemented for querying of child entities. By following IS NULL OR NOT EXISTS logic, it returns fields with NULL value and missing (not existing) rows in the child table. (IJC-11491)
Improved import option. The "Refresh data in opened views" import checkbox is enabled even if import has been made into an empty existing entity. (IJC-11461)
Marvin/Jchem 20.17.0 are used. JChem tables will not be regenerated from 20.12.0. IJC metadata will not be regenerated from previous version.
Usability of Boolean fields has been improved. Now, it’s easier to change the values of Boolean fields – they can be changed by clicking both in and out of the checkbox. (IJC-11474)
Displaying horizontal scrollbar in “Add New Row” dialog is avoided. (IJC-11465)
Behavior of checkboxes displayed at the end of import has been improved. “Refresh data in opened views” checkbox is enabled even if import has been made into an empty existing entity. (IJC-11461)
Querying issue of Boolean values on PostgreSQL has been fixed. (IJC-11457)
New conditional-formatting operators introduced: Does not start with / Does not end with / Does not contain / Does not contain (case insensitive). To improve consistency of the tool, the operators used in conditional formatting are now aligned with operators used in queries. (IJC-11454)
Issue with copying a structure to clipboard has been fixed. (IJC-11450)
Changed query logic – any child field query (null or not null) implies INNER join. Also, if target field (used in SELECT column) is ID from non-master entity or belongs to a child entity then use INNER join. (IJC-11449)
Admin Tool actions functionality is disabled when they are grayed out. (IJC-11446)
Upgrade to Spring Security 5 framework. (IJC-11427)
IJC uses Spring 5 now. Known issue: Adding a Binary field fails on Oracle DB with NullPointerException
. (IJC-11420)
Fixed editing of date values. (IJC-11398)
The custom default script is not lost when there is no other custom script in the view. (IJC-11258)
Selection behavior in widgets has been improved. Selection after queries (both specific queries/lists or show all) remains the same if possible. Also, multi selection and selection on child data remains the same if possible. (IJC-5051)
Changed query logic - any child field query (null or not null) implies INNER join. Also, if target field (used in SELECT column) is ID from non-master entity or belongs to a child entity then use INNER join. (IJC-11449)
Design of the "add new row" dialog has been improved. The horizontal scrollbar is not appearing anymore. (IJC-11465)
Marvin/Jchem 20.15.0 are used. JChem tables will not be regenerated from 20.12.0. IJC metadata will not be regenerated from previous version.
Scatter plot options persistence problem fixed. When settings of a Scatter plot widget are edited after its creation, the newly added settings persist. (IJC-11440)
Picklist bug fixed. Now, it is not possible to select multiple values from a picklist if picklist definition does not allow to insert new values. (IJC-11438)
Fixed unwanted appearance of additional conditional-formatting fields as visible columns in table widgets / grid views. (IJC-11435)
User access to Groovy scripts has been modified. Users without EDIT_SCRIPT role cannot see any Groovy scripts. (Can only run them.) (IJC-11426)
Hyperlinks in widgets reworked. No tooltip-like popups, underline does not appear above the cell bottom border anymore. On-mouse-over hyperlink text turns blue and becomes underlined. (IJC-11422)
Improved redo for form designer actions. Sequence of redo actions in design mode tweaked. (IJC-11444)
Order and default options in structure entity creation are adjusted to the search engine that is being used. Order of entity types has been changed. Cartridge entity types are preferred. (IJC-11434)
Fixed unwanted appearance of additional conditional formatting fields as visible columns in table widget / grid view. (IJC-11435).
Scatter plot options persistence problem fixed. (IJC-11440)
Fixed unwanted appearance of additional conditional-formatting fields as visible columns in table widget / grid view. (IJC-11435)
Buttons for R-group actions are available when the structure field is not present in master entity. (IJC-11394)
Marvin/Jchem 20.13.0 are used. Full regeneration is needed to use JChem 20.13.0. Please, regenerate all JChem tables after upgrade. The new table version is 20.12.0.0
MissingResourceException fixed. Creating view titles from resource bundles does not throw error. (IJC-11428)
Fixed query persistence on new JChem Cartridges PostgreSQL and Choral (JPC, JCC). (IJC-11424)
Buttons for R-group actions are available when the structure field is not present in master entity. (IJC-11394)
File import and merge functionality improved: new option Add-New-Rows-Only when merging introduced; IllegalStateException "Id field value cannot be modified" fixed when merging; validation in fields mapping dialog extended; import statistics improved. (IJC-11384)
NullPointerException in import when parsing error avoided. (IJC-11370)
Operators for 'Query structures' table type were limited to Superstructure and Duplicate search, since only these two are allowed by JChem. (IJC-11336)
Undo/redo for DESIGN mode implemented in the form designer. Following widget actions are undoable: Create new widget, Delete widget(s), Move widget(s), Resize widget. Undo is available only when the original action is connected to a view top-component. Each top-component has a separate queue for BROWSE and for DESIGN mode. (Grid views have only BROWSE queue.) All undo edits are discarded when the top-component is closed. BROWSE queue contains value edits. Undo/redo in groovy editor top-component has also been improved. (IJC-425)
Marvin/Jchem 20.11.0 are used. JChem tables will not be regenerated from 20.6.0. IJC metadata will not be regenerated from previous version.
Usability of the query widget pop-up has been improved. (IJC-11411)
Disabled creation of Standard fields and fixed calculation of Calculated fields for Pivot entity. (IJC-11408)
Support for Relevance ordering for JChem PostgreSQL cartridge entity has been added. (IJC-11404)
Support for Relevance ordering for JChem Choral cartridge entity has been added. (IJC-11389)
The “Reaction" products are displayed correctly (when Products type is chosen as “Reaction”). (IJC-11387)
The ROWID duplication for non-admin user is solved now. The promoting wizard opens now correctly, only once, when opened from a submenu item. (IJC-11381)
Permanent list creation is part of Plexus Connect’s Schema refresh feature. (IJC-11361)
SQL filter modification is also presented in Plexus Connect’s Schema refresh feature. (IJC-11342)
Fixed print error when printing widgets with conditional formatting. When the field used for conditional formatting is not presented in the form, printing does not fail. (IJC-11341)
IJC can run now using Java 11. (IJC-11281)
Exporting of sorted data has been fixed. The sorted resultset can be exported now. (IJC-11379)
The "<=" and ">=" operators have been introduced for decimal numbers. (IJC-11378)
Reading of default sort fields (also causing java.lang.IllegalArgumentException: Missing VertexRequest in export) fixed. (IJC-11367)
"Invisible widget" indication is avoided when inserting widgets into panels. Printing error does not occur when a widget exceeds the panel’s border in the form designer. (IJC-11338)
Displaying frozen columns in a table widget has been fixed. (IJC-11337)
Import error file format when importing invalid SDF structures changed. When invalid structures are found during import, the structure import error file is readable by molecule viewers. (IJC-10128)
Import regression caused by bad molecules has been fixed. Now, a bad molecule does not cause import breakdown. (IJC-11403)
Marvin/Jchem 20.8.0 are used. JChem tables will not be regenerated from 20.6.0. IJC metadata will not be regenerated from previous version.
Oracle Choral Cartridge is now supported by IJC. New Choral entity can import and query structures. Chemical terms are also supported.
Exporting of sorted data has been fixed. The sorted resultset can be exported now. (IJC-11379)
The "<=" and ">=" operators have been introduced for decimal numbers. (IJC-11378)
Reading of default sort fields (also causing java.lang.IllegalArgumentException: Missing VertexRequest in export) fixed. (IJC-11367)
"Invisible widget" indication is avoided when inserting widgets into panels. Printing error does not occur when a widget exceeds the panel’s border in the form designer. (IJC-11338)
Displaying frozen columns in a table widget has been fixed. (IJC-11337)
Import error file format when importing invalid SDF structures changed. When invalid structures are found during import, the structure import error file is readable by molecule viewers. (IJC-10128)
Import regression caused by bad molecules has been fixed. Now, a bad molecule does not cause import breakdown. (IJC-11403)
Marvin/Jchem 19.21.4 are used. JChem tables will not be regenerated from 19.21.0. IJC metadata will not be regenerated from previous version.
*Possible IndexOutOfBoundsException fixed when exporting pivot entity into Excel format. (IJC-11354)
*Fixed NPE after cancel of export background process. Excel export uses only (available connections - 1) threads for export - improved performance and fixed some export crashes. (IJC-11376)
*Exporting of sorted data has been fixed. The sorted resultset can be exported now. (IJC-11379)
*The "<=" and ">=" operators have been introduced for decimal numbers. (IJC-11378)
Marvin/Jchem 19.21.2 are used. JChem tables will not be regenerated from 19.21.0. IJC metadata will not be regenerated from previous version.
*Fix - proper closing of DB connection after import or query cancel on Oracle Cartridge. (IJC-11352)
*Picklist cache renewal fixed. (IJC-11327)
*NullPointerException in SingleDFItemNTO.updateStatus fixed. (IJC-11339)
*Query transformation for virtual entities added to fix export from pivot entity. (IJC-11353)
*Occasional NullPointerException when creating new Chemical Terms field fixed. (IJC-11357)
*NullPointerExceptions when customizing multiple widgets fixed. (IJC-11358)
*Fixed creating new cartridge entities - customizer in Schema editor (since version 19.15.0) wasn't showing cartridge entities under structure entities, but under standard entities. (IJC-11362)
*Reading of default sort fields (also causing java.lang.IllegalArgumentException: Missing VertexRequest in export) fixed. (IJC-11367)
Marvin/Jchem 20.4.0 are used. JChem tables will not be regenerated from 20.1.0. IJC metadata will not be regenerated from previous version.
Reading of default sort fields (also causing java.lang.IllegalArgumentException: Missing VertexRequest in export) fixed. (IJC-11367)
Added query transformation for virtual entities to fix export from pivot entity. (IJC-11353)
Marvin/Jchem 20.3.0 are used. JChem tables will not be regenerated from 20.1.0. IJC metadata will not be regenerated from previous version.
Fixed creating new cartridge entities - customizer in Schema editor (since version 19.15.0) wasn't showing cartridge entities under structure entities, but under standard entities. (IJC-11362)
NullPointerExceptions when customizing multiple widgets fixed. (IJC-11358)
Fix - properly close DB connection after import or query cancel on Oracle Cartridge. (IJC-11352)
Add support for MySQL 8 ORDER BY select. (IJC-11347)
Renamed Oracle cartridge entity and JChem Base entity when creating/promoting.
Marvin/Jchem 20.1.0 are used. Full regeneration is needed to use JChem 20.1.0. Please, regenerate all JChem tables after upgrade. The new table version is 20.1.0.0 .
Possibility to sort and filter queries and lists by display name(IJC-11284)
Fixed occasional NullPointerException when creating a new Chemical Terms field. (IJC-11357)
Picklist usability extended. Multiple picklist items can be selected in the Picklist selector dialog using CTRL or SHIFT key. A new row is inserted, and currently registered data is updated. The selected multiple picklist items are registered as comma-separated values into one field. This new feature enables users to simply create new values based on the current picklist items. It is applicable for string-like data types only. (IJC-11356)
Picklist cache renewal fixed. (IJC-11327)
The Query Builder can be opened by using Ctrl+F/Cmd+F keyboard shortcut. The former keyboard shortcut (Ctrl+B/Cmd+B) is also being used. (IJC-11312)
IJC supports connection to the new ChemAxon licensing system. (IJC-11260)
Marvin/Jchem 19.26.0 are used. JChem tables will not be regenerated from 19.22.0. IJC metadata will not be regenerated from previous version.
Better handling of import conversion error. When data mismatch occurs in the field type, the data conversion fails. The error is correctly reported, and the imported row skipped. (IJC-11334)
Fixed link to documentation page in the New Chemical Terms dialog. (IJC-11324)
Fixed IllegalStateException when deleting non-empty panel widgets in design mode. (IJC-11322)
TabbedPane widget corner cases improved. IllegalStateException and NullPointerException rare errors fixed. (IJC-11321)
When promoting a table, the primary key column is selected by default. (IJC-11313)
IJC’s Javadoc is now available for downloading in respective IJC version. (IJC-11309)
Prevent throwing runtime exceptions when a form contains a widget bound to missing field or missing vertex in datatree. (IJC-11306)
The option "ROWID" is no longer available to select in the "ID Field" when creating a table. (IJC-11252)
Added support for chemical terms fields in JChem PostgreSQL cartridge entity. Implemented using database trigger and function. (IJC-11189)
The MySQL JDBC driver has been changed. Now, IJC is compatible with MySQL version 8. Due to this upgrade, the new .ijs file can’t be opened with older IJC versions. This condition applies to all databases. (IJC-11154)
Marvin/Jchem 19.21.2 are used. JChem tables will not be regenerated from 19.21.0. IJC metadata will not be regenerated from previous version.
Prevent throwing runtime exceptions when a form contains a widget bound to missing field or missing vertex in datatree. (IJC-11306)
TabbedPane widget corner cases improved. IllegalStateException and NullPointerException rare errors fixed. (IJC-11321)
Fixed IllegalStateException when deleting non-empty panel widgets in design mode. (IJC-11322)
Better handling of import conversion error. When data mismatch occurs in the field type, the data conversion fails. The error is correctly reported, and the imported row skipped. (IJC-11334)
Marvin/Jchem 19.23.0 are used. JChem tables will not be regenerated from 19.22.0. IJC metadata will not be regenerated from previous version.
Regeneration of Markush structures type tables is needed to use JChem 19.22.0. Please, regenerate Markush structures JChem tables after upgrade. The new table version is 19.22.0.0. The version number of the other types of JChem tables has not changed.
Improved managing of child entities on datatree level in schema editor. The changes of child entities are now persisted. (IJC-11307)
Fixed import and display of molecules in INCHI format. (IJC-11294)
Improved generation of SQL queries for relationships. INNER join is used when left field is ID field and there is no sort for child data. (IJC-11296)
MSI distribution package for Instant JChem has been added. This should ease system administrators, the mass installations across the corporate network. (IJC-3061)
Multiple columns can be selected for promotion in both "Database Views" and "Database tables" panels. (IJC-10713)
Schema refresh "Connection error" dialog does not cancel all the future schema change events after pressing OK button. (IJC-11212)
PostgreSQL is available in Admin Tool and the database names in Admin Tool connection panel are now the same as in the "Connect to Schema" panel. (IJC-11262)
Schema refresh without restart functionality for Connect fixed for adding / removing child vertices. (IJC-11273)
Error message appears when IJC is launched with incompatible Java version. (IJC-11301 )
Export to file action can handle many-to-many relationships. (IJC-8417)
Improved performance of Schema initialization and performance of filtering in Schema editor. (IJC-11183)
Database Activity Log Viewer displays events when opened (Menu Window → Other). (IJC-11279)
When a structure is present in the row, the default row height of a grid view is resized to 100 pixels. (IJC-11288)
Marvin/Jchem 19.21.1 are used. Full regeneration is needed to use JChem 19.21.0. Please, regenerate all JChem tables after upgrade. The new table version is 19.21.0.0
Improved managing of child entities on datatree level in schema editor. The changes of child entities are now persisted. (IJC-11307)
Fixed import and display of molecules in INCHI format. (IJC-11294)
Improved generation of SQL queries for relationships. INNER join is used when left field is ID field and there is no sort for child data. (IJC-11296)
MSI distribution package for Instant JChem has been added. This should ease system administrators, the mass installations across the corporate network. (IJC-3061)
Multiple columns can be selected for promotion in both "Database Views" and "Database tables" panels. (IJC-10713)
Schema refresh "Connection error" dialog does not cancel all the future schema change events after pressing OK button. (IJC-11212)
PostgreSQL is available in Admin Tool and the database names in Admin Tool connection panel are now the same as in the "Connect to Schema" panel. (IJC-11262)
Schema refresh without restart functionality for Connect fixed for adding / removing child vertices. (IJC-11273)
Error message appears when IJC is launched with incompatible Java version. (IJC-11301 )
Export to file action can handle many-to-many relationships. (IJC-8417)
Improved performance of Schema initialization and performance of filtering in Schema editor. (IJC-11183)
Database Activity Log Viewer displays events when opened (Menu Window → Other). (IJC-11279)
When a structure is present in the row, the default row height of a grid view is resized to 100 pixels. (IJC-11288)
Marvin/Jchem 19.19.0 are used. JChem tables will not be regenerated from 19.17.0. IJC metadata will not be regenerated from previous version
Sorting buttons in toolbar have correct disabled/enabled state after being pressed. (IJC-10795)
Fixed copy & paste of grid view cells, improved performance of copy multiple rows, improved copy widgets in Design mode, disabled action Paste from History. (IJC-11250)
License related problem from version 19.18.0 has been fixed. The License Handler doesn't throw error when opening an IJC view. (IJC-11286)
Marvin/Jchem 19.18.0 are used. JChem tables will not be regenerated from 19.17.0. IJC metadata will not be regenerated from previous version
Marvin/Jchem 19.17.0 are used. Full regeneration is needed to use JChem 19.17.0. Please, regenerate all JChem tables after upgrade. The new table version is 19.17.0.0
After query no row count information in status bar (left bottom) is shown. This greatly improves performance on PostgreSQL DB. (IJC-11256)
Added escaping of '%' and '_' chars in a LIKE / NOT LIKE query (includes contains, starts with, ends with and their negation) for all supported DBs and also Calculated text fields. (IJC-11254)
Multiple View Value (F3) windows can be opened. This way multiple structures can be compared visually. (IJC-11242)
Improved query cancelling - query can be cancelled by cancelling the background process. The same applies for sorting the column. (IJC-11241)
Marvin/Jchem 19.15.0 are used. Full regeneration is needed to use JChem 19.15.0. Please, regenerate all JChem tables after upgrade. The new table version is 19.10.0.0
JChem PostgreSQL Cartridge is now supported by IJC
NullPointerException fixed when opening legacy forms (IJC 5.x) containing table widget or sheet widget. (Error has been introduced in 18.23.0 and Deuterium LTS.) (IJC-11234)
Fixed runtime exception when creating new Derby schema. (IJC-11230)
Marvin sketch window always visible (when extended display disconnected) (IJC-10650)
Admin role is not required any more for running reactor and changing data inside entities. This can be done also with Edit data role only.(IJC-9177)
Fixed add new row for EDIT_DATA rights. (IJC-11251)
Introduced possibility to set-up column width of table widget / gridview column also from column property sheet - specifying width in pixels. This works also for multiple columns in the same table widget or gridview.(IJC-11223)
Improved performance of form loading and record-to-record navigation in large data trees. (IJC-11200)
Filter child data functionality fixed, performance improved.(IJC-11246)
Encryption of complex passwords improved (IJC-11085)
Special characters in user names handled (IJC-11085)
IN list improvements and fixes - Oracle sorted IN list uses DECODE function instead of INSTR; fixed NOT IN list for lists bigger than 1000; optimized application of saved lists. (IJC-9714)
Fixed exporting of Pivoted data with Row or Extra value fields. (IJC-11240)
Marvin/Jchem 19.8.0 are used. JChem tables will not be regenerated from 19.7.0. IJC metadata will not be regenerated from previous version
Adding new rows implemented for JChem Oracle Cartridge entity with ROWID as PK based on a table with additional PK of type VARCHAR. (IJC-11172)
IllegalStateException preventing form save fixed. (IJC-11208)
Generated query for Child entity changed - querying for Child ID IS NULL generates LEFT OUTER JOIN, otherwise INNER JOIN. Also, default WHERE condition Child ID IS NOT NULL for joins was removed. (IJC-11177)
Creating/connecting to schema was throwing an exception. (IJC-11158)
Setting of Max hits in Overlap Analysis was not working. Also, performance of Overlap Analysis was improved (locally up to 8x). (IJC-9018)
Marvin/Jchem 19.7.0 are used.
Regeneration of Markush structures type tables is needed to use JChem 19.7.0. Markush structures JChem tables will be upgraded. The new table version is 19.7.0.
The version number of the other types of JChem tables has not changed. IJC metadata will not be regenerated from previous version.
Popup query box appearance/focus fixed (IJC-11174)
Next button in export wizard works properly (IJC-11150)
Similarity search was wrongly setting dissimilarityMetricParameters, which was causing an error on JChem Oracle Cartridge. (IJC-11111)
Marvin/Jchem 19.4.0 are used. JChem tables will not be regenerated from 18.18.0. IJC metadata will not be regenerated from previous version
Both 32 and 64 bit Windows installers has been fixed. Application can be launch through Desktop icon and Start menu again. (IJC-11151)
Mac OS installer works as well, there wrong application icon, though. (IJC-11146)
Excel export always creates temporary directory 'poifiles'. (IJC-11142)
Release was skipped.
Marvin/Jchem 19.1.0 are used. JChem tables will not be regenerated from 18.18.0. IJC metadata will not be regenerated from previous version
{info} Version 19.1.0 has been withdrawn from download page due to a problems with installers. Following versions works as expected.
Elemental analysis plugin do not work. As a workaround, standalone tools MarvinSketch or MarvinView can be used. (IJC-11123)
Installers are not bundle with IJC icon. As a result IJC can not be launched from the desktop or Start menu. But it can be still launched from the install destination directory (e.g. C:\Program Files\ChemAxon\InstantJChem\bin).
Marvin/Jchem 18.28.0 are used. JChem tables will not be regenerated from 18.18.0. IJC metadata will not be regenerated from previous version
Release was skipped.
Marvin/Jchem 18.26.0 are used. JChem tables will not be regenerated from 18.18.0. IJC metadata will not be regenerated from previous version
Equals ("=") operator for decimal numbers has been introduced (IJC-11023)
Action "Save Result as local DB" removed from IJC (IJC-10411)
"NoStructure" label appearance fixed for structure renderer (IJC-11063)
IJC dashboard has been updated. (IJC-11052)
Export to Excel functionality has been optimized (IJC-11082)
Release was skipped.
Release was skipped.
Release was skipped.
Marvin/Jchem 18.22.0 are used. JChem tables will not be regenerated from 18.18.0. IJC metadata will not be regenerated from previous version.
{info} Version 18.22.0 now supports AdoptOpenJDK 8
Release was skipped.
Marvin/Jchem 18.20.0 are used. JChem tables will have to be regenerate to 18.18.0.
Missing "Absolute label" structure information in printing fixed. (IJC-11010)
Browser rendere displays special characters correctly (IJC-11008)
Better images exported to Excel. Images exported as binary field reuse dimensions defined for structure field in export wizard.(IJC-10961)
Fixed saving charts as png image. (IJC-10624)
Copy pasting of structures in widgets fixed. (IJC-10290)
Release was skipped
Release was skipped
Marvin/Jchem 18.17.0 are used. JChem tables will not be regenerated from 18.8.0. IJC metadata will not be regenerated from previous version.
Copy to MS Office option (IJC-10257)
Structure is stored in clipboard in smiles format for simple copy (CTRL+C) command
Structure is stored in clipboard in mrv format for "Copy to MS Office" command
( You need to have JC4O installed)
Marvin/JChem 18.11.0 are used. JChem tables will not be regenerated from 18.8.0. IJC metadata will not be regenerated from previous version.
{info} DIF platform is no longer separately offered for download.
Marvin/Jchem 18.8.0 are used. JChem tables will have to be regenerate to 18.8.0.
Fixed IllegalStateException when child fields only are exported. (IJC-10891)
Fixed exception "IllegalArgumentException: horizontalAlignment" when loading legacy form or grid. (IJC-10883)
Fixed - occasionally new grid view wasn't shown in project tree. (IJC-10875)
Fixed ORA-00904: invalid identifier when querying NVARCHAR2 column type on Oracle database. (IJC-10870)
By default, grid view is not fit to screen. This prevents possible errors caused by combination of extremely shrink structure field and large molecules. (IJC-10859)
Fixed DFTermsFactory.createFieldOperatorValueExpr() automatically adding empty chemical terms operand for structural query expressions, if not specified explicitly.(IJC-10768)
Chemterms creation - fixed exceptions in log and progress bar is showing correctly. (IJC-9140)
Release was skipped
Marvin/Jchem 18.5.0 are used. JChem tables will not be regenerated from 17.29.0. IJC metadata will not be regenerated from previous version.
{info} JCHEMPROPERTIES upgrade problem with ORA-01502 is resolved.
No improvements or bugs fixed
Marvin/Jchem 18.4.0 are used. JChem tables will not be regenerated from 17.29.0. IJC metadata will not be regenerated from previous version.
{info} JCHEMPROPERTIES table upgrade is triggered on Oracle for both JChem Base and JChem Oracle Cartridge. If ORA-01502 appears, then perform rebuild of the system index of the JCHEMPROPERTIES table - alter index SYSxxxxxx rebuild; SYSxxxxxx will be name of the index found in the error message.
Problems with adding a new row with Date type data by "Add New Row" dialog has been fixed.
Markush viewer in IJC has been updated.
Marvin/Jchem 18.3.0 are used. JChem tables will not be regenerated from 17.29.0. IJC metadata will not be regenerated from previous version.
{info} JCHEMPROPERTIES table upgrade is triggered on Oracle for both JChem Base and JChem Oracle Cartridge. If ORA-01502 appears, then perform rebuild of the system index of the JCHEMPROPERTIES table - alter index SYSxxxxxx rebuild; SYSxxxxxx will be name of the index found in the error message.
{info} Chemaxon´s certificate has been renewed. This can lead to little inconvenience during auto update. Following warning may occur:
Please ignore it. If you decide to continue than update will finish as usual. This is unfortunately unavoidable at the moment. This warning does not mean that the new version is not signed with a valid certificate. It means that the previous version of IJC which was signed by old certificate, don´t recognize new certificate, which is use for signing at the moment. However if you decide to do reinstall instead of auto update, than you will not encounter any difficulties and everything should behave as usual.
{info} Release was skipped
Marvin/Jchem 18.1.0 are used. JChem tables will not be regenerated from 17.29.0. IJC metadata will not be regenerated from previous version.
{info} JCHEMPROPERTIES table upgrade is triggered on Oracle for both JChem Base and JChem Oracle Cartridge. If ORA-01502 appears, then perform rebuild of the system index of the JCHEMPROPERTIES table - alter index SYSxxxxxx rebuild; SYSxxxxxx will be name of the index found in the error message.
Molmatrix widget bug fixed. Sometimes, under specific circumstances, when bound to child entity, structures in molmatrix were not refreshed after change of master record. (IJC-10737)
The .tab file format was replaced by.txt file format in export actions. (PC-189)
Improvement in diagnosis of wrongly configured .ijs file. From now on, if the schema initialization fails because of missed information about database URL, than following error will appear:
Database URL must be provided.
{warning} Connection pooling library was upgraded. As a result, two properties in .ijs configuration file were replaced:
" custom.connection.pool.maxActive " is replaced with (renamed to) " custom.connection.pool.maxTotal " - meaning of the property and the value remains the same
" custom.connection.pool.whenExhaustedAction " is replaced with " custom.connection.pool.blockWhenExhausted " - meaning of the property is changed in accordance with the meaning in the upgraded library. If you are using this property please consult the library manual. (old version: [https://javadoc.io/static/commons-pool/commons-pool/1.6/org/apache/commons/pool/impl/GenericObjectPool.html#getWhenExhaustedAction()](https://javadoc.io/static/commons-pool/commons-pool/1.6/org/apache/commons/pool/impl/GenericObjectPool.html#getWhenExhaustedAction()), new version: https://commons.apache.org/proper/commons-pool/apidocs/org/apache/commons/pool2/impl/BaseGenericObjectPool.html#getBlockWhenExhausted--)
In a case where a configuration file will contain an old property, a user will be notified via an error message.
ERROR: Connecting to database failed: Your configuration file contains deprecated property specification
custom.connection.pool.maxActive/custom.connection.pool.whenExhaustedAction.
Please visit [Editing Schema Connection Settings](instant-jchem_editing-schema-connection-settings.md) for further information how to fix the problem
Marvin/Jchem 17.29.0 are used. JChem tables will have to be regenerate to 17.29.0. IJC metadata will not be regenerated from previous version.
{info} JCHEMPROPERTIES table upgrade is triggered on Oracle for both JChem Base and JChem Oracle Cartridge. If ORA-01502 appears, then perform rebuild of the system index of the JCHEMPROPERTIES table - alter index SYSxxxxxx rebuild; SYSxxxxxx will be name of the index found in the error message.
Marvin/JChem 17.28.0 are used. JChem tables will not be regenerated from 17.23.0. IJC metadata will not be regenerated from previous version.
{info} JCHEMPROPERTIES table upgrade is triggered on Oracle for both JChem Base and JChem Oracle Cartridge. The same as for version 17.27.0 applies.
Marvin/JChem 17.27.0 are used. JChem tables will not be regenerated from 17.23.0. IJC metadata will not be regenerated from previous version.
{info} JCHEMPROPERTIES table upgrade is triggered on Oracle for both JChem Base and JChem Oracle Cartridge. If ORA-01502 appears, then perform rebuild of the system index of the JCHEMPROPERTIES table - alter index SYSxxxxxx rebuild; SYSxxxxxx will be name of the index found in the error message.
{info} Release was skipped
Marvin/Jchem 17.25.0 are used. JChem tables will not be regenerated from 17.23.0. IJC metadata will not be regenerated from previous version.
Improved sorting speed on big lists (IJC-10660)
Improved performance for search domain queries (IJC-10661)
Improved UI and error reporting in relationships editor (IJC-10647)
Tooltips are disabled for button and label widgets. "Border option" is disabled for button widget (IJC-9735)
New option for printing. When print output is composed into multiple columns, user can decide the print order (direction). Vertical or horizontal (IJC-6509)
Marvin/JChem 17.24.0 are used. JChem tables will not be regenerated from 17.23.0. IJC metadata will not be regenerated from previous version
{warning} MS SQL driver upgraded to 6.2.1.
Fixed pasting SMILES into query structure window. (IJC-10628)
Tooltips are disabled for button and label widgets. "Border option" is disabled for button widget. (IJC-9735)
Marvin/JChem 17.23.0 are used. IJC metadata will not be regenerated from previous version
{warning} JChem tables will be regenerated to 17.23.0
Derby driver will be updated to a version 10.13.1.1
Critical bug introduced in IJC 17.16.0 fixed: User can import data into existing entity with only ROLE_EDIT_DATA role as before. (IJC-10603)
Updated Derby driver to a new version 10.13.1.1. All Derby based projects will ask for update during schema open. This update does NOT allow to revert back to the older version of IJC or Connect. (IJC-10584)
Marvin/JChem 17.22.0 are used. IJC metadata will not be regenerated from previous version
{warning} JChem tables will be regenerated from 17.13.0 to 17.22.0
Improved performance of permanent list loading (IJC-10579)
Fixed column manager not showing all available fields in certain circumstances (IJC-9464)
The molecule printing was not centralised on printouts, resulted that some part of the structure was cut (MRVGUI-2910)
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 17.20.0 are used. JChem tables will not be regenerated from 17.14.0. IJC metadata will not be regenerated from previous version
Improved performance on Oracle for in-list queries for lists based on integer, rowid or text (up to 4000 chars) fields and with more than 2000 items (IJC-10202)
Improved the performance of OR queries (IJC-10236)
Improved performance on MySQL for in-list queries for lists based on integer or text (up to 4000 chars) fields and with more than 5000 items (IJC-10495)
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 17.18.0 are used. JChem tables will not be regenerated from 17.14.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 17.17.0 are used. JChem tables will not be regenerated from 17.14.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 17.16.0 are used. JChem tables will not be regenerated from 17.14.0. IJC metadata will not be regenerated from previous version.
{warning} JChem tables regeneration needed between 17.13.0 and 17.14.0 versions. Since IJC 17.14.0 was skipped, regeneration will be done directly to 17.16.0
Value of print header/footer for dynamic field "Your user name" fixed. (IJC-10540)
Fixed IllegalStateException during import file process (IJC-10391)
{info} Memory leak affecting 17.6.0 - 17.13.0 versions was resolved
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 17.13.0 are used. IJC metadata will not be regenerated from previous version.
{warning} JChem tables will be regenerated from 17.5.0.1 to 17.13.0
{warning} Versions 17.6.0 - 17.13.0 seem to be affected by a memory leak in molecule panel widget, which causes slow eating up of memory resources. We are working on a fix.
Current workaround is to minimize usage of molecule panel to necessary minimum, as the memory leak happens only during rendering of the molecule. Switching the tab to a different form/grid without molecule panel, when not needed is enough to prevent memory problems.
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 17.10.0 are used. JChem tables will not be regenerated from 17.5.0.1. IJC metadata will not be regenerated from previous version.
No improvements or bugs fixed this release
Marvin/JChem 17.9.0 are used. JChem tables will not be regenerated from 17.5.0.1. IJC metadata will not be regenerated from previous version.
{warning} Due to internal problem with bundled Java 8 in installers, only unaffected platform independent ZIP, Mac OS X and server related IJC distributions are available.
Export to Excel using Repeat Rows option fixed for 1:1 child entities. (IJC-9911)
Fixed printing of structures in monochrome not working if color scheme wass set to monochrome. (IJC-6423)
Printing performance and memory consumption improved. (IJC-5265)
Marvin/JChem 17.8.0 are used. JChem tables will not be regenerated from 17.5.0.1. IJC metadata will not be regenerated from previous version.
{warning} Due to internal problem with bundled Java 8 in installers, only unaffected platform independent ZIP, Mac OS X and server related IJC distributions are available.
Frozen columns width fixed for tables and grids not working. (IJC-10365)
Rebinding sheet widget might lead to IndexOutOfBoundsException fixed. (IJC-10358)
Editing values in sheet widget can lead to IndexOutOfBoundsException fixed. (IJC-10336)
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 17.6.0 are used. IJC metadata will not be regenerated from previous version.
{warning} Full regeneration is needed to use JChem 17.5.0. Please, regenerate all JChem tables after upgrade. The new table version is 17.5.0.1
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 17.4.3.0 are used JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
No improvements or bugs fixed
{warning} Next release will be numbered by a new simplified versioning scheme. Details are described here.
Marvin/JChem 17.3.27.0 are used. JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
{warning} Java 7 support in Instant JChem will be dropped in 17.5.0 release.
Fixed missing [...] settings button in upper left corner of tables a grids (IJC-10303)
Progress bar for "Validating script of.." added for lager button's groovy scripts. (IJC-10294)
Filter query on JCC removed as it become deprecated in JCC API. (IJC-10262)
Improved the performance of OR queries. IJC-10236)
Structure field has new extra attribute "Default atom size", which sets the atom size of structure renderer in all widgets, where this field is used. (IJC-10223)
Added a possibility to have LDAP security case-insensitive. (IJC-9574)
IJC schema password (and DB username and password) is now encrypted with AES-256 (IJC-9453)
RejectedExecutionException (appearing in forms with large button scripts) fixed. (IJC-9323)
New ROLE_SPOTFIRE_INTEGRATION added co control Spotfire integration instead of ROLE_EXPORT_DATA (IJC-9297)
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 17.2.27.0 are used. JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
Command line argument "--exportMolFormatOnly" introduced. If this argument is present (with no value), than structure can be exported in "mol" format only. (IJC-10231)
Fixed editing of date / datetime in widgets (IJC-10004)
Marvin/Jchem 17.2.20.0 are used. JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
{warning} Java 7 support in Instant JChem is planned to be dropped. Please wait for further notification in upcoming releases
Permit creation of calculated field based on structure field when user has ROLE_EXPORT_DATA_AS_IMAGE_ONLY (IJC-10274)
Content of comboboxes with queries and lists names is enlarged to make whole query or list name visible. (IJC-7183)
Marvin/JChem 17.2.13.0 are used. JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
Fixed IllegalStateException after pasting structure into table, sheet or molmatrix widget. (IJC-10269)
Fix opening of non RFC compliant URLs in external web browser (IJC-10264)
Marvin/JChem 17.2.26.0 are used. JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
Fixed the display of aggregated values in pivot entity. (IJC-10220)
New hooks beforeInsertWindow, beforeInsert and afterInsert (IJC-10213)
Fixed Marvin issue when attaching groups using keyboard. (IJC-9897)
Marvin/JChem 17.1.30.0 are used. JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
Introduce import option "Insert new rows when merging" at import into existing entity (IJC-10225)
Fixed internal logging of pivot field changes. (IJC-10215)
Fixed issue when exporting pivot entity in a datatree. (IJC-10181)
Fixed a problem when export to Excel converted numbers to characters. (IJC-10134)
Marvin/JChem 17.1.23.0 are used. JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
Export to file: Use field labels from saved XML configuration preferably before table widget labels when user loads configuration explicitly in export wizard. (IJC-10226)
Append ellipsis to all values in widgets when value cannot be visible from begin to end. (IJC-10186)
Widget scripting hooks "beforeEdit" and "afterEdit" fixed. (IJC-9808)
Added a possibility to have LDAP security case-insensitive. (IJC-9574)
Marvin/JChem 17.1.16.0 are used. JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
ClassCastException (from IJC 17.1.9) fixed when printing table or gridview.(IJC-10234)
Fixed rare NullPointerException related to table widget and loading of data. (IJC-10230)
Marvin/JChem 17.1.9.0 are used. JChem tables will not be regenerated from 17.1.2.0. IJC metadata will not be regenerated from previous version.
{warning} JChem tables will be regenerated from 16.12.19.0 to 17.1.2.0
Marvin/JChem 17.1.2.0 are used. IJC metadata will not be regenerated from previous version.
{warning} JChem tables will be regenerated from 16.12.5.0 to 16.12.19.0
Marvin/JChem 16.12.5.0 are used. IJC metadata will not be regenerated from previous version.
IJC is now fully compatible with latest PostgreSQL 9.6. (IJC-10049)
Re-enabled double-click (edit value) on single-line and multi-line text widgets. (IJC-10156)
Copy action enabled for all widgets in design mode. (IJC-10174)
Fixed loading of pivot entity grid view that was causing an exception. (IJC-10184)
Fixed runtime error when performing search by selected value. (IJC-10191)
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 16.12.12.0 are used. JChem tables will not be regenerated from 16.12.5.0. IJC metadata will not be regenerated from previous version.
{info} No improvements or bugs fixed
{warning} JChem tables will be regenerated from 16.9.26.0 to 16.12.5.0
Marvin/JChem 16.12.5.0 are used. IJC metadata will not be regenerated from previous version.
New option in RDF import wizard. Radio buttons "Delete existing data" (this was default behavior in previous versions) and "Keep existing data" (new option - appends new data to existing records). "Delete existing data" (truncate) is the default option. (IJC-9811)
Import into entity feature enhanced: Structure field values can be updated when merging by any other (ID) field. (IJC-9848)
Spotfire/JChem for Excel Integration functionality requires IJC Viz license. (Before IJC Enterprise license has been required) (IJC-9889)
Fixed logic for executing OR queries in multi-entity environment. (IJC-10047)
Introducing SQL filter on relationship. It is always applied on data tree queries.(IJC-10061)
Save button in molecule pane is always enabled. (IJC-10121)
Fixed error in excel export when more than 1000 child records. (IJC-10124)
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 16.11.14.0 are used. JChem tables will not be regenerated from 16.9.26.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 16.11.7.0 are used. JChem tables will not be regenerated from 16.9.26.0. IJC metadata will not be regenerated from previous version.
Users with the ROLE_EXPORT_DATA can now export data from Instant JChem directly into Plexus Analysis. (PS-148)
Molecule auto-scale in Marvin sketch switched off (IJC-10122)
Fixed bug in Marvin Sketch - changing bond type using right click menu was causing an exception (IJC-10054)
Selection and query results updated on charts after resume (IJC-9803)
Marvin/JChem 16.10.31.0 are used. JChem tables will not be regenerated from 16.9.26.0. IJC metadata will not be regenerated from previous version.
Instant JChem supports text fields with text/html MIME type in Browser widget and Browser widget is able to renderer the html code. Simple editing is enabled. (IJC-9739)
The Preferences panel of MarvinSketch had not been accessible from Instant JChem. (MRVGUI-2510)
Marvin/JChem 16.10.24.0 are used. JChem tables will not be regenerated from 16.9.26.0. IJC metadata will not be regenerated from previous version.
Fixed displaying of widget tooltips (IJC-10067)
Reducing the maximal length of SQL statements while data loading approximately to 50kB (IJC-10062)
Marvin sketch pop-up dimensions and coordinates are persisted in user's preferences (user dir) (IJC-9991)
Fixed handling of backslash character in values in CSV export (IJC-9712)
Setting of custom background color of table header in table widget used for pivot entity fixed (IJC-9569)
Editing of structures using Marvin Sketch respects original structure format and "No Structure" flag (IJC-9553)
Marvin/Jchem 16.10.17.0 are used. JChem tables will not be regenerated from 16.9.26.0 IJC metadata will not be regenerated from previous version.
Oracle JDBC Driver upgraded to version 11.2.0.4. This version is certified with JDK 8, JDK 7 and JDK 6. (IJC-10037)
There is a new AdminTool operation 'Create *.ijs file for schema(s)'. (IJC-10008)
Composite support was removed from IJC/Connect (IJC-9925)
New action " Permanent list from current result set " under Lists window top menu accessible under F6 key. (IJC-9907)
Rotated box plot category axis labels 45° up(IJC-9942)
Marvin/JChem 16.10.10.0 are used. JChem tables will not be regenerated from 16.9.26. IJC metadata will not be regenerated from previous version.
{info} No improvements or bugs fixed in this release
{warning} JChem tables will be regenerated from 16.8.29.0 to 16.9.26.0
Marvin/JChem 16.10.3.0 are used. IJC metadata will not be regenerated from previous version.
The pivoting functionality was introduced to Instant JChem. More details about the new entity type and its use can be found in the documentation. (IJC-1066)
Only a valid recent URL is now offered in the database connection wizard. (IJC-6622)
Axis labels in radar chart widget display japanese characters properly. (IJC-9655)
Fixed editing of decimal number values in widgets. In some cases the decimal part was lost. (IJC-9943)
Data are sorted correctly when exporting with results filter. (IJC-9980)
Fixed AdminTool's operation for managing security configurations. It is now possible to copy a security config from one schema to another. The operation performs much faster by touching only the source and target IJC schemas.(IJC-9985)
Fixed the deadlock (freeze) on IJC close. This issue can appear in versions 16.9.5.0 and 16.9.12.0. (IJC-9993)
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 16.9.12.0 are used. JChem tables will not be regenerated from 16.8.29.0. IJC metadata will not be regenerated from previous version.
{warning} JChem tables will be regenerated from 16.7.4.0 to 16.8.29.0
Marvin/JChem 16.9.5.0 are used. IJC metadata will not be regenerated from previous version.
{warning} Java 6 support completely dropped. Please do NOT use Java 6 with the application as it will not start successfully. This release is the first release that is built without Java 6 compatibility in mind.
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 16.8.15.0 are used. JChem tables will not be regenerated from 16.7.4.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 16.8.8.0 are used. JChem tables will not be regenerated from 16.7.4.0. IJC metadata will not be regenerated from previous version.
Fixed missing styling in default index.html of the Java Web Start bundle. (IJC-9853)
Fixed 'afterEdit' hook which was accidentally called after running a query. (IJC-9801)
AdminTool supports PostgreSQL database. (IJC-9800)
Marvin/JChem 16.8.1.0 are used. JChem tables will not be regenerated from 16.7.4.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 16.7.25.0 are used. JChem tables will not be regenerated from 16.7.4.0. IJC metadata will not be regenerated from previous version.
{warning} Known limitation
When opening a view containing molMatrix widget, or when changing selection in such form, a Null Pointer Exception might appear without any effect on the functionality. (IJC-9873)
{warning} JChem tables will be regenerated from 16.5.23.0 to 16.7.4.0
Marvin/JChem 16.7.18.0 are used. IJC metadata will not be regenerated from previous version.
Improved confusing connection encryption usability. (IJC-9552)
Japanese characters are now printed correctly even when in header. (IJC-9829)
For datetime fields there is now available time component for setting hours - minutes - seconds. Changed behavior of date operators equals, before and between for date, without time. Equals loads correctly hits with all same date. Before and between now includes to the hits also last day. (IJC-9399)
Fixed OR queries for mol weight and formula for cartridge structure tables. (IJC-9578)
Added support for multiple extra fields in MolMatrix widget. (IJC-8578)
Large customizers in Schema Editor use scrollbars to make sure that 'Apply' and 'Discard' buttons are always visible. (IJC-9710)
Fixed a problem with Defaulf Sort Field wizard's Ascending/Descending sort buttons. (IJC_9719)
The 'beforeEdit' and 'afterEdit' scripts are correctly called from 'Delete' or 'Cut' action. (IJC-9437)
Hit highlighting option for molecules in Tools > Options > Miscellaneous > Molecule view/edit fixed. Setting of hit highlighting is applied in open views when molecule is "re-displayed". Selection is changed in single record widgets or after scroll in multi record widgets. (IJC-9416)
It is now possible to download the documents from OracleDB via WebBrowserWidget. (IJC-8662)
'Reload Data' (F5) action now re-runs the last query in addition to just dropping the caches. This makes sure that the displayed records reflect correctly the state of the underlying database tables. (IJC-5692)
{warning} Known limitation
When opening a view containing molMatrix widget, or when changing selection in such form, a Null Pointer Exception might appear without any effect on the functionality. (IJC-9873)
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 16.5.23.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
Fix the mapping between LDAP groups and IJC roles to support using an empty 'Group Search Base'. This makes it easier to set up security with LDAP searches in different parts of the LDAP tree. (IJC-9645)
Copy and Cut actions re-enabled on widgets in design mode - regression from IJC 16.3.7.0 (IJC-9450)
{warning} JChem tables will be regenerated from 16.5.9.0 to 16.5.23.0
Marvin/JChem 16.5.23.0 are used. IJC metadata will not be regenerated from previous version.
{warning} JChem tables will be regenerated from 16.2.22.0 to 16.5.9.0
Marvin/JChem 16.5.16.0 are used. IJC metadata will not be regenerated from previous version.
Marvin/JChem 16.5.2.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
Fixed issue in M:N data retrieval for certain circumstances. (IJC-9551)
Improvements in loading large amount of data from Oracle. (IJC-9492)
Use java.lang.Double for floating-point numbers by default. (IJC-9494)
Marvin/Jchem 16.4.25.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
Marvin/Jchem 16.4.18.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
Fixed a problem when running a search on Oracle on a field bound to BINARY_DOUBLE or BINARY_FLOAT column. (IJC-9009)
Default values are offered also in user mode, not only in admin mode (IJC-6562)
Marvin/Jchem 16.4.11.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
{info} No improvements or bugs fixed
Marvin/Jchem 16.4.4.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 16.3.28.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
Selection synchronization in Molecule Matrix widget fixed. (IJC-9389)
IllegalStateException when closing views during schema init fixed (IJC-8760)
Marvin/JChem 16.3.21.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 16.3.14.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
Fixed bug when form has been marked as modified when opened. This issue caused sometimes problems with widgets' size and position. (IJC-8761)
Fix a problem in the customizer for promoting entities. (IJC-9403)
Fix table/column information retrieval when logging as 'Normal user' that has access to certain fields forbidden by 'VISIBILITY' restriction. (IJC-9378)
Common table widget properties "Fit to screen", "Name" and "Border" visible and editable in table widget multiedit dialog. (IJC-9276)
The database connection activation and deactivation calls can be optimized based on users activity. There is a new JVM property which controls this behaviour. (IJC-8448)
Marvin/JChem 16.3.7.0 are used. JChem tables will not be regenerated from 16.2.22.0. IJC metadata will not be regenerated from previous version.
Added possibility to sort and filter fields in the Field Explorer (IJC-9351)
Marvin editor is cleared when "Clear Query" is applied (IJC-9088)
New role restricting users to export to Excel with images as structures only was introduced (IJC-9078)
Query highlighting (yellow background) reflects "Case insensitivity" query flag (IJC-8946)
{warning} JChem tables will be regenerated from 15.11.23.0 to 16.2.22.0
Marvin/JChem 16.2.29.0 are used. IJC metadata will not be regenerated from previous version.
Spotfire integration dynamically detects free port for communication starting at user's default port. (IJC-9298)
When Spotfire integration is running, IP addres and port is displayed as a tooltip on toolbar icon. Also as menu text in File menu and in schema's context menu. (IJC-9355)
Fixed a problem when MolMatrix showed gray pane in query mode after "Clear query". (IJC-9346)
Fixed a problem with removing picklist from a field. (IJC-9345)
Added a possibility to sort fields in column manager (IJC-8363)
IJC Plugin Manager correctly follows redirection from http: to https: protocol. (IJC-9036)
{primary} Note for Autoupdate Center users
Update to this version will be performed as two-step operation. In the first step, IJC will update Auto Update Services and after the software restart the regular auto update can continue in the second step.
{info} Release was skipped. Improvements and bug fixes will be available in next release
Marvin/JChem 16.2.15.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous verison.
{info} No improvements or bugs fixed
Marvin/JChem 16.2.8.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous version.
Rare java.lang.IllegalStateException during IJC startup fixed (IJC-7251)
Fixed a problem when creating a decimal number field with BINARY_DOUBLE or BINARY_FLOAT column on Oracle. (IJC-5649)
Marvin/JChem 16.2.1.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous version.
The impossibility of editing large structures from grid view or table widget was fixed. (IJC-9183)
The printing of Japanese characters when using Java 1.8 is now supported. (IJC-9096)
Fixed a problem when running a search on Oracle on a field bound to BINARY_DOUBLE or BINARY_FLOAT column. (IJC-9009)
Marvin/JChem 16.1.25.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 16.1.18.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous version.
Fixed NPE from IJC schema initialization ('Formula' field) when logging into IJC as 'Normal user' (IJC-9184)
The problem with threads remaining in JVM after exporting structures to Excel was fixed (IJC-9172)
Marvin/JChem 16.1.11.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous version.
OS-default printer is now preselected in print dialog (IJC-9176)
Slightly lower memory requirements for JChemBase structure searches (IJC-8928)
Marvin/JChem 16.1.4.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous version.
Added support for PostgreSQL database. You will need the enterprise license in order to connect to a PostgreSQL database server.
Improved beforeEdit/afterEdit scripting hooks support for more widgets
Fixed 'Cut' action on a permanent list node.
Fixed possibility of IllegalArgumentException error when sharing a form with charts.
Marvin/Jchem 15.12.14.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous version.
Support of queries using multiple structures combined with an OR operator was fixed in the 15.12.14.0 version of JChem Cartridge for Oracle. The upgrade of JChem Cartridge is necessary .
Fixed a bug that let the database password leak into a log file when the SQL logging was set to 'SQL Statements and times'.
Marvin/JChem 15.12.7.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous version.
Sorting of data applied properly in export to file.
IllegalArgumentException when aligning multiple columns with various renderers in grid view or table widget fixed.
Support for Japanese, Korean and Chinese fonts in PDF (created via Print to file action or Print preview action)
Marvin/Jchem 15.11.30.0 are used. JChem tables will not be regenerated from 15.11.23.0. IJC metadata will not be regenerated from previous version.
Sorting of data applied properly in export to file.
Support for Japanese, Korean and Chinese fonts in PDF (created via Print to file action or Print preview action)
Import list from file based on other than ID field fixed
Marvin/Jchem 15.11.23.0 are used. IJC metadata will not be regenerated from previous version.
{info} JChem tables will be regenerated from 15.10.5.0 to 15.11.23.0
Marvin/JChem 15.11.16.0 are used. JChem tables will not be regenerated from 15.10.5.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 15.11.9.0 are used. JChem tables will not be regenerated from 15.10.5.0. IJC metadata will not be regenerated from previous version.
New events are available on a form -- onInsertRows and onDeleteRows. They can be used to customize 'New row' and 'Delete rows' actions.
Container widgets (Panel, Tabbed Panel) selection and insertion troubles in design mode fixed.
Marvin/JChem 15.11.2.0 are used. JChem tables will not be regenerated from 15.10.5.0. IJC metadata will not be regenerated from previous version.
Fixed behavior in MySQL if filed with default value is set to required.
'Start Spotfire/JChem4XCL integration' action is controlled by ROLE_EXPORT_DATA.
Marvin/JChem 15.10.26.0 are used. JChem tables will not be regenerated from 15.10.5.0. IJC metadata will not be regenerated from previous verison.
Fixed NPE when running a search and having forms open that are not fully initialized.
The ROLE_EXPORT_DATA now also controls Cut action and several list actions such as 'Edit list', 'Export list to a file' and 'Copy/Cut' list.
Spotfire bridge plugin available for versions 6.0 and 7.0.
Clicking on images in Grid View is fixed. Storing null value from Grid View is fixed.
Marvin/Jchem 15.10.19.0 are used. JChem tables will not be regenerated from 15.10.5.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 15.10.12.0 are used. JChem tables will not be regenerated from 15.10.5.0. IJC metadata will not be regenerated from previous version.
Introduced support for SHA1 encryption checksums algorithm on Oracle.
The 'Connection already unwrapped' problem was fixed.
Marvin/JChem 15.10.5.0 are used. IJC metadata will not be regenerated from previous version.
{info} JChem tables will be regenerated from 15.3.9.0 - see release notes of JChem
Fixed an issue which prevented creation of Chemical Terms field on a structure table with JChem Cartridge index.
Print, Export, Copy and Copy to MS Office actions are disabled based on new ROLE_EXPORT_DATA. Create Script and Edit Script actions are disabled based on new ROLE_EDIT_SCRIPT. No IJC schema upgrade is needed, but these two new roles will be automatically made available after connecting IJC to the database.The description of the user roles can be found here.
{primary} You need to update your security configuration and map these two new roles to your LDAP/AD groups, otherwise your user will not have these roles and consequently will not be able to export/print/copy or create/edit scripts.
{warning} This release version was skipped
{warning} This release version was skipped
Marvin/JChem 15.9.14.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
{warning} Copy/Paste of Markush structures does not work properly on Mac OS X platform
Marvin/JChem 15.9.7.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 15.8.31.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 15.8.24.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Fixed a bug that prevented editing a boolean field with F2 key
Fixed a bug that threw an error when an image in a grid view was clicked
Multiple rows can be edited form Grid View and from Table widget. New child data will be generated if needed
Added support for multi-editing by pressing F2 key
Fixed IJC_INVOCATION_LOG and IJC_CHANGE_LOG tables creation and 'User logged in' event logging
User can specify one custom image file that can be (re)used later in printing header / footer definition tab. Chosen file is stored in user's preferences
Marvin/JChem 15.8.17.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
IJC Personal Server has been renamed to Spotfire/JChem4XCL integration . You can start or stop Spotfire/JChem4XCL integration using two different manners:
Right click on schema in Project explorer and choose Start/Stop Spotfire/JChem4XCL integration . This is similar as before. Integration starts directly without any additional dialog.
Select schema in Project explorer and choose new toolbar button Start/Stop Spotfire/JChem4XCL integration .
Configuration of server IP address and port number can be found under Tools>Options>Misc>Other. Default is http://localhost:8080.
User can specify one custom image file that can be (re)used later in printing header / footer definition tab. Chosen file is stored in user's preferences.
Marvin/JChem 15.8.10.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Fixed a bug in changing the value of boolean fields.
Warning message before schema upgrade is now highlighted in red and more visible to avoid a user to do schema upgrade unintentionally.
Improved error reporting of invalid structures during import.
Marvin/JChem 15.8.3.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 15.7.27.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Fixed bug from IJC 15.6.29 when exporting records based on current query was ignored and exported all data instead
Fixed AdminTool's 'Change owner' operation to work correctly with calculated fields. A calculated field remains a user-level item when its owner is changed using AdminTool
Multiple rows can be edited form Grid View and from Table widget. New child data will be generated if needed.
Date fields were enhanced to support time. Date with the time part can be displayed, edited, queried, imported and exported. Custom date format is used not only for displaying, but also for editing the values
Fixed a Structure Renderer's NullPointerException appearing when trying to view a Markush structure
Introduced netbeans.auth_url_excludes IJC startup option to ignore HTTP authentication requests for URLs that match the regex value of this option
A possibility to specify default value of URL field was added to "Create new field" and "Schema editor"
Updated the default IJC logo graphics in printed forms
Fixed few bugs with date selection when using calendar panel in query mode - choosing today's date and changing date after one was selected didn't work
Improved querying of dates and timestamps for Oracle DB. DATE field correctly uses to_date and TIMESTAMP uses to_timestamp SQL function
Exception during "Copy to MS Office" action when JChem for Office not installed is handled. User friendly info message appears instead of java exception
Fields browser doesn't appear again when it is closed by user in design mode until it opened by Windows -> Fields Browser
{warning} This release version was skipped
{warning} This release version was skipped
{warning} This release version was skipped
Marvin/JChem 15.6.29.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Improvement of performance of relational data export
Added an ability for RDF import into existing entities. Truncate all data from existing entities and pass data from RDF file into existing (and empty) entities. This approach keeps widgets in existing forms bound to existing fields
Marvin/Jchem 15.6.22.0 are used. JChem tables will not be regenerated fro 15.3.9.0. IJC metadata will not be regenerated from previous version.
Speed of all searches, including structure searches was significantly improved
Removing unnecessary dependencies from overlap analysis. Has no effect for the end user
Fixed NullPointerException when right clicking on any form entry from dashboard and click on "properties" item
Marvin/JChem 15.6.15.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Fixed a problem in displaying child entity IDs in table widget for one-to-one relations
Fix a problem with missing rows during CSV file export of 1:N relational data
Added print support for extra fields in MolMatrix widget
Marvin/JChem 15.6.8.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Export to Excel utilizes JChem for Excel Java API
Fixed a bug when empty value in single field widget (SFW) after editting value or reloading data upon another SFW in other form in the same datatree
Marvin/JChem 15.6.1.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
{info} Instant JChem is planned to switch to Java 7 platform and Java 6 support will be dropped. The switch is planned for release 15.6.22.0
Marvin/JChem 15.5.25.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Fixed bug with Object.toString() like "java.lang.Object@5bffe7d2" appearing in widgets instead of null (empty) value
Fixed bug when java.lang.ClassCastException occasioanly occured during export
Export to file fixed for fields from entities with relation 1:1 or N:1 when under parent relation 1:N
Fixed a performance issue of "Show All" structures performed after running a structure search
{warning} This release version was skipped
Marvin/JChem 15.5.11.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Marvin/Jchem 15.5.4.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Marvin/Jchem 15.4.27.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 15.4.20.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Added a possibility to specify character encoding of imported CSV file when the encoding is different then platform default encoding.
Fixed IJC offline help typography problems.
Fixed Automatic update for Instant JChem 6.x versions to rolling release versions.
Added F5 as default keyboard shortcut for Reload data.
Fixed problems with using Oracle ROWID column as an entity ID field. It is now possible to insert records to such entities and retrieve the auto-generated ROWID values for the ID field.
Marvin/JChem 15.4.13.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Added option to select the encryption algorithm for JDBC connections to Oracle databases. The supported algorithms are RC4, 3DES ans AES.NullPointerException when exporting to file in some versions of Linux JRE fixed
CSV file import (and other text formats) is able to handle line breaks inside values
Fixed a problem with incorrect import with space separeted CSV files containing a + sign
Fixed a graphical layout bug of promoting table to structure entity
Marvin/JChem 15.4.6.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Marvin/Jchem 15.3.30 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
Added support for ordered IN_LIST query on MySQL.
Conditional formatting bug when using fields from multiple child entities fixed.
Fixed the problem with exporting structures into *.xlsx file using the EMF image format.
Fixed importing from documents such as PDF or Word documents into Instant JChem.
Fixed a security issue allowing users to login into Plexus even when they had no IJC roles assigned.
Marvin/JChem 15.3.16.0 are used. JChem tables will not be regenerated from 15.3.9.0. IJC metadata will not be regenerated from previous version.
{warning} Marvin is always freezing, when trying to open a Markush Structure on JChem Cartridge
Marvin/JChem 15.3.9.0 are used. IJC metadata will not be regenerated from previous version.
{info} JChem tables will be regenerated from 15.3.2.0 - see release notes of JChem
{warning} Marvin is always freezing, when trying to open a Markush Structure on JChem Cartridge
Fixed the problem that a shared project would not automatically open again after IJC restart.
Fixed a problem when IJC was not exiting cleanly when closed.
Marvin/JChem 15.3.2.0 are used. IJC metadata will not be regenerated from previous version.
{info} JChem tables will be regenerated from 14.9.1.0.
{warning} Marvin is always freezing, when trying to open a Markush Structure on JChem Cartridge
Improving performance of retrieving data for 1:N relationships in Plexus.
Fixed a problem when after running a date query and navigating back to Query mode, the date query was not retained.
Excel exporter formats integer and float fields as numbers according to their renderers' settings in IJC.
Marvin/JChem 15.2.23.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
{warning} Marvin is always freezing, when trying to open a Markush Structure on JChem Cartridge
New text operators introduced - does not start with, does not end with, does not contain
New tool in IJC that can synchronize scripts between IJC schema and local disc folder
Added findItemById
method in DIF API
Marvin/JChem 15.2.16.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
{warning} Known Limitation
When running a query on Markush tables on JChem Cartridge, sometimes the query validator pops up an error about R-group and R-atom definitions.
Marvin/JChem 15.29.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
{warning} Known Limitation
Marvin is always freezing, when trying to open a Markush Structure on JChem Cartridge
Importing of SDF with MOL file V3000 is now supported.
Added support for Java Web Start memory settings to be set separately for 32-bit and 64-bit Java versions. Usage in the .jnlp file configuration:
<application-desc main-class="com.im.ijc.jnlpinstaller.Main">
<argument>--on64bit</argument>
<argument>-J-Xmx1024m -J-Xms256m</argument>
</application-desc>
Marvin/JChem 15.2.2.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
{success} Java 8 is now officially supported platform.
Improved behaviour of "test-run" functionality in Admin Tool. Now it is possible to click the Back button in the wizard, redefine the settings and try "test-run" as many times as needed
Added an information panel in Admin Tool that shows brief description of a given functionality of Admin Tool (Clone Operation, Delete Operation, etc.)
UI improvements in Admin Tool. Progress bars in Lists and some other small changes.
Multi-selection of widgets remembers the order of selection. This can be useful e.g. in export.
When a connection with roles ADMIN_TOOL and/or ADMIN_TOOL_ADVANCED is opened in IJC, it is automatically added into Admin Tool
Small improvements and fixes in Dashboard navigation of the forms while using keyboard.
Fixed a bug that caused SQL syntax exception when trying to change a length of a VARCHAR field via Schema Editor
Instant JChem now limits the size of text displayed in form or table. This works around the problem of IJC freezing when accidentally showing markush structures as text.
Fixed a problem that caused an Illegal State Exception appearing after creation of a widget from a Field Browser.
Excel exporter now formats integer and float fields as numbers according to their renderers' settings in IJC.
Parsing groovy button scripts on background so it doesn't block opening form.
Fixed a problem in printing of R-group decomposition search results. The R-group definitios were missing from the header of the table.
Fixed a problem, when sorting according to a field with COLB column definition, all data disappeared
Fixed db view based structure entities to support joining in the JChem cartridge index table (*_JCX).
Marvin/JChem 15.1.26.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Performance improvement of data retrieval for data trees with many-to-one relationship where source field is referring for non ID field.
Marvin/JChem 15.1.19.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Better logging of eventual export issues.
UI improvements in Admin Tool.
Multi-selection of widgets now remembers the order or selection and puts the fields in that order in the export dialog.
Loading of data more efficiently when having a Many-to-One relationship
Marvin/JChem 15.1.12.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Introduced support for SHA1 encryption checksums algorithm on Oracle.
Fixed a problem with character set encoding during import of sdf files, which caused special characters to be broken. Now, when importing with different encoding than the default system one, the proper character set needs to be selected in import options combo box.
Marvin/JChem 15.1.5.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Improved performance of forms containing sheet widgets.
EMF image format introduced for molecules in Excel export. EMF is default molecule format if JChem for Excel is not installed on workstation.
Conditional formatting in Excel export fixed. When data field (field providing values) of conditional formatting is not the formatted field itself, then conditional formatting is applied in excel file, even if the value field is not included in exported fields.
Fixed an issue causing Java Lang Exception during creating of a new form.
NullPointerException in export fixed when sheet widget or molmatrix widget is placed on inactive tab of tabbed pane widget.
Conditional formatting in Excel export fixed. When data field (field providing values) of conditional formatting is not the formatted field itself, then conditional formatting is applied in excel file, even if the value field is not included in exported fields.
Marvin/JChem 14.12.15.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Fixed bug with stale conditional formatting. The formatting wouldn't update in records with missing value. The problem occurred only if the conditional formatting was based on a different field than the displayed value
List is always stored with context of root vertex state and thus visible among permanent lists for active data tree. Before this improvement, "Save list" functionality did not work when field in a detail table was highlighted
Fixed a bug in calculated fields loading data across a relationship. An error could be thrown in case there were no related data
Marvin/Jchem 14.12.8.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
{info} Automatic updates will now point to latest 14.x versions instead of 6.3.x version
Fixed a bug that caused Java Heap Space errors when trying to create a conditional formatting on a text field based on another text field
Fixed a problem, when Admin Tool was not able to translate the database schema names in IJC MetaData during Migrate Operation, when the source and target schema names were different
Fixed a bug in Change Owner operation in Admin Tool causing it to run out of memory
Marvin/JChem 14.12.1.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Further enhancements in multi entity data export performance. See documentation for details
Fixed a problem when it was impossible to connect with IJC to the database after upgrade of IJC metadata, which was caused by bad handling of inconsistencies in broken permanent lists and queries
Fixed a bug that caused IJC not to exit cleanly after opening a form with certain configuration containing panel widget, causing a locked project message
Fixed a regression that disabled a possibility to create a private calculated field on a form shared with ROLE_USER security permission
Marvin/Jchem 14.11.24.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Improvements in export of multi entity data and enhancements in export performance
Improved the way how export handles formatting of data during export to Excel
Progress bar in bottom right corner of the screen stays active until all data are loaded into the form
Fixed a bug when hiding a column(s) in Grid View caused rearrangement of remaining columns in the view
Fixed a regression in Instant JChem's installation, which caused an error when trying to create Pick List on an existing column
Marvin/JChem 14.11.17.0 are used. JChem tables will not be regenerated from 14.9.1.0.
{warning} IJC metadata will be regenerated from previous version.
{info} IJC Metadata regeneration in this version brings changes in format of Permanent Queries and Lists.
Renamed "Clone Form" functionality to "Open in a New Tab"
Improved performance during scrolling the records in the form
Usability improvements in Admin Tool's Security wizard. Now it is possible to remove the security template, validate the security template xml and to use security template of different schema if needed.
Fixed Admin Tool's Auto connection feature being unusable when IJC Meta data was in different schema.
Marvin/JChem 14.11.10.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Improved "Add new row" dialog. It is possible to load values from existing rows.
Added possibility to add widgets in Design mode by drag and drop from Field Browser
Improved performance of browsing through records over slow network. A periodical heartbeat database request is ensured to be performed at most once per minute.
Made Structure Pane as default (first) option when drag and dropping structure field to form from Field Browser in Design Mode
Slight UI improvement in Admin Tool. Added a progress bar for loading data
Removed superfluous menu items in form's right click menu
New Calculated Filed Dialog now displays where the calculated field will be created
Fixed jumping to first record after removal of the current record from results. Now, when a record is removed from current results, the previous one is shown.
Fixed wrong behaviour of "today" operator on date fields with TIMESTAMP format
Fixed a regression when opening a shared form by different user offering always "Save Copy of Form"
Fixed Field Browser not displaying the fields from the active Data Tree automatically in Design Mode
Fixed Field Browser not refreshing during switching among forms from different Data Trees
Tool tip, if not defined, is showing by default the field's value not only for Text Renderer, but for all renderers.
Preventing Connection Pool error messages caused by timeout when working in Grid View loading big amount of data
Marvin/JChem 14.11.3.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Fixed sharing grid view action.
Applying list performance.
Improved efficiency of loading data for conditional formatting. Also fixed UI freezing during wait for conditional formatting data.
Fixed error when copying mol matrix to a different schema.
Fixed Widget Palette disappearing when switching between Browse and Design mode.
Once export is performed upon grid view, table or sheet widget containing custom column titles, these titles are memorized and used in any future export where possibly just field names are available. In this case, field names are replaced by memorized custom titles. It applies to XLSX, CSV and TAB formats.
Fixed long list usage on Oracle.
Fixed NOT IN LIST operator.
Users with ROLE_USER can create their own private calculated fields. As other user's objects this should be possible to share later (e.g. when field is used in a shared form).
Improved the performance of form settings loading. The application no longer freezes when the form settings are loaded over the network.
Marvin/JChem 14.10.27.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Fixing error when certain data were not imported to JChem base structure tables.
Fixed problem with lost conditional formatting. The bug should be present only in 14.10.20. If you open a form in version 14.10.20 and your conditional formatting is lost, don't modify the form to avoid saving it. We recommend to upgrade to recent version as soon as possible.
Fixed a bug that prevented usage of textual extra field in molmatrix widget.
Fixed a regression causing problems with tabbed pane resizing and dragging.
Fixed a bug when changing multiple single line widget settings and only last selected widget changed.
Background and foreground colors from Panel, TabbedPane, Label and renderers applied to print reports.
Fixed behaviour of horizontal alignment settings in Forms Model API. The methods which previously worked with undocumented integer constants now work with enumeration of values.
Admin Tool indicates progress of background operations.
Better performance when retrieving relational data - unnecessary select statements removed.
Fixed a problem with occasional unintentional disabling of "Search by selected value" and "Create R-group table" actions.
Users with ROLE_USER can create their own private calculated fields. As other user's objects this should be possible to share later (e.g. when field is used in shared form).
Marvin/JChem 14.10.20.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Allowing multiple result sets for one data tree.
Colouring tabs according to which result set it shows.
Fixed a problem with database default values on JChem Base tables - particularly with auto-generated timestamp.
Fixed printing of text alignment in sheet widget.
Fixed printing of label widget including text.
Fixed ignoring row titles in sheet widget when printing.
Fixed numeric format settings bug.
Correctly releasing memory after disconnect from Instant JChem schema.
Ability to call one script from another.
Ability to rename IJC schema in admin tool.
Usability of Admin Tool improved.
Improving Conditional formatting dialog - it's more clear what field is being colored.
Marvin/JChem 14.10.13.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Marvin/JChem 14.10.6.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Order Pick list values alphabetically or numerically depending on the field used.
Opening forms performance: Load configuration xml of form once schema is connected.
Small schema init performance - faster loading of JChemProperties table.
Fixed various errors when editing schema. The schema was not properly invalidated after disconnecting.
Marvin/JChem 14.9.29.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Optimalizing start up performace - lists are loaded only when needed.
Fixed when Pick list's retrieving existing values ignored SQL filter.
Excel Export Improvements
Various Admin Tool improvements
Marvin/JChem 14.9.22.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Fixed color highlighting when you run structure query on the form view.
Manage Child Entities dialog's showing relationships properly and performance fixes when there are many entities involved.
Automatic adjusting the height if the central window in Manage Child Entities dialog
Fixed error when sorting a calculated field containing null values.
Fixed a random freezing when adding widgets.
Fixed some error when printing particular structure data.
Cherry picking always work with data in a root table.
Fixed missing reaction library when creating a new reaction.
Fixed not working Truncate limit for lists.
Various Admin Tool improvements.
Plugin deployment with Java Web Start distribution ( documentation ).
Marvin/JChem 14.9.15.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Color highlighting is lost when you run Structure query on the Form view.
Work around: go to the customize widget settings by right click on "Molecule pane" and change the color scheme to "CPK"
There are no new bug-fixes.
Marvin/JChem 14.9.8.0 are used. JChem tables will not be regenerated from 14.9.1.0. IJC metadata will not be regenerated from previous version.
Color highlighting is lost when you run Structure query on the Form view.
Work around: go to the customize widget settings by right click on "Molecule pane" and change the color scheme to "CPK"
Querying by calculated fields is now possible.
Problem with building relational queries which are two tables or more away from the root one.
Better handling of scaling in printing for large forms.
Ability to reduce the font size of Label Widget if the text doesn't fit in.
Closing schema (IJC) is faster, particularly on VPN networks.
Fixing load export configuration on Mac.
Various admin tool improvements.
Expand data tree nodes automatically when there are 3 and less data trees filtered in Projects window.
Marvin/JChem 14.9.1.0 are used. JChem tables will be regenerated. IJC metadata will not be regenerated from previous version.
Improved handling of long names relationships
Improvements in Admin Tool user interface
Please note that Instant JChem 14.8.25 was skipped.
Marvin/JChem 14.8.18.0 are used. JChem tables and IJC metadata will not be regenerated from previous version.
Possible crashing on GNU/Linux with Java 7
Starting IJC on 64-bit GNU/Linux with JDK 8 causes an error
Starting ChemDraw as structure editor on a 64-bit operating system causes an error
Added support for NVarChar and NChar SQL Server data types. See the documentation.
Improved Admin Tools' sorting of Schema list - it is now case insensitive and handles Schema Names better when starting with numeric or special symbol
Optimised IJC Metadata fetching, giving better performance on schemas with a number of IJC items (Data Trees, Views, Entities...)
Fixed a problem with Chemical Terms field expression validator considering mass(reactant(0)) as invalid Chemical term
Marvin/JChem 14.8.11.0 are used. JChem tables and IJC metadata will not be regenerated from previous version.
Possible crashing on GNU/Linux with Java 7
Starting IJC on 64-bit GNU/Linux with JDK 8 causes an error
Starting ChemDraw as structure editor on a 64-bit operating system causes an error
Date queries using a relative time period (see documentation).
Enabling Database Row Level Security by using Script hook for new connection (see documentation).
Usability improvement of chart creation in Widget palette - each Chart has it's own icon.
Fixed error displayed when creating calculated field where division by zero occur.
IJC schema upgrade shows warning when license is expired.
Update center does not offer updated when support license is expired.
Admin tool improvements and bug-fixes.
Marvin/JChem 14.8.4.0 are used. JChem tables and IJC metadata will not be regenerated from previous version.
Possible crashing on GNU/Linux with Java 7
Starting IJC on 64-bit GNU/Linux with JDK 8 causes an error
Starting ChemDraw as structure editor on a 64-bit operating system causes an error
Allowing drag and drop between lists with temporary queries (or lists) and permanent queries (or lists).
Fixed ‘Temporary queries history limit’ in Tools-Options -> Misc -> Lists & Queries -> Queries.
Marvin/JChem 14.7.28.0 are used. JChem tables and IJC metadata will not be regenerated from previous version.
Possible crashing on GNU/Linux with Java 7
Starting IJC on 64-bit GNU/Linux with JDK 8 causes an error
Starting ChemDraw as structure editor on a 64-bit operating system causes an error
Admin tool improved. Possibility to migrate only items of a specific user.
Bug with writing reverse text to single line text widget fixed.
Bug with no possibility to enter editing mode in table widget fixed.
Marvin/JChem 14.7.21.0 are used. JChem tables and IJC metadata will not be regenerated from previous version.
Possible crashing on GNU/Linux with Java 7
Starting IJC on 64-bit GNU/Linux with JDK 8 causes an error
Starting ChemDraw as structure editor on a 64-bit operating system causes an error
Text alignment in sheet widget is not retained
Editing text in text field reverses the text written, the cursor is on the left and move to the left as you type. Resulting text/number has reversed order of letters. The only option how to edit it correctly is in the grid view.
General improvements in script output appearance being less offensive and general improvements in Output Window handling
Each script now shows its output in separate Output Window
Fixed text horizontal alignment in exported Excel files
Fixed "freezing problem" after query returning many hits when Scatter Plot was present in a form view
Fixed problem when some data were not shown in a form view, particularly when retrieving a huge amount of hits
Fixed missing relationships in new Edge Manager dialog
Fixed various problems related to Admin Tool
Fixed a problem with In List Query not supporting tokens with commas. It is now possible to use double quotes (see documentation)
Fixed a problem with Temporary Query/List not being automatically updated after application of Permanent Query
Marvin/JChem 14.7.14.0 are used. JChem tables and IJC metadata will not be regenerated from 14.7.7.0 version.
Possible crashing on GNU/Linux with Java 7
Starting IJC on 64-bit GNU/Linux with JDK 8 causes an error
Starting ChemDraw as structure editor on a 64-bit operating system causes an error
It is possible to create and save, or load export templates
Added option in Export Wizard to open the exported file, or show it in its enclosing folder
All IJC lists (e.g. Form Views lists) are sorted by default and can be searched
Marvin/JChem 14.7.7.0 are used. JChem tables and IJC metadata will be regenerated from 6.3 version.
Possible crashing on GNU/Linux with Java 7
Starting IJC on 64-bit GNU/Linux with JDK 8 causes an error
Starting ChemDraw as structure editor on a 64-bit operating system causes an error
Impossible to connect to database with certain proxy settings
Text alignment in sheet widget is not retained
Alignment of date fields when having 2 different date renderers (Date Pane and Text field) together in 1 form throws an exception
Removed VMN support and Convert VMN to MRV functionality in IJC
Improved structure query representation as text. Structure is represented as SMILES and if structure2name license is present, IUPAC name is shown instead.
Results of a query with In-list operator are sorted according to the order that the query was defined. This feature is currently limited only to Oracle Database.
Possibility to run export in background
Sorting according to calculated fields is now possible
In any wizard with field selection, it is possible to add/remove fields by double clicking
Added support in IJC for big numbers in the database (Forum Link)
Added a new tool for managing and migrating IJC schemas (see the documentation)
Tooltip for Table Widget, Mol Matrix and Charts can use a field from other entity
Fixed a problem with Admin Tool and manually added connections not getting all priviledges
Fixed a problem when using Admin Tool to connect to an unreachable database froze IJC for a long time
Fixed a bug in Admin Tool when connecting to invalid connection gave wrong information to the user
Fixed a bug in Float renderer causing it not to accept customisation options
Fixed a problem with Date Picker in Query Builder using wrong date format
Fixed a bug with Standardizer not being able to process files bigger than 2GB (Forum Link)
Fixed Admin Tool's Clone and Migrate operations not updating the progress bar correctly
Tooltips with additional description are shown in Extra Attributes tab in the Schema Editor
Fixed a bug, when Query Pop Up window did not close when using "Between" operator and having the second text field in focus
Version numbers were increased to 6.x to be in sync with Marvin and JChem.
Patch release.
Marvin/JChem 6.3.4 are used. JChem tables and IJC metadata will not be regenerated from the 6.3 version.
Label widget does not shrink after content modification. It can still expand when text does not fit, but no shrinking at all.
Fixed various errors when editing schema. The schema was not properly invalidated after disconnecting.
Patch release.
Marvin/JChem 6.3.4 are used. JChem tables and IJC metadata will not be regenerated from the 6.3 version.
Improved schema init performance for users in user mode.
Improved schema close performance.
Automatic adjusting the height if the central window in Manage Child Entities dialog.
Manage Child Entities dialog's showing relationships properly and performance fixes.
Fixed a random freezing when adding widgets.
Fixed pick list's retrieving existing values ignored SQL filter.
Fixed a small error in API for DFEntityDataProvider.
Patch release.
Marvin/JChem 6.3.3 are used. JChem tables and IJC metadata will not be regenerated from the 6.3 version.
Fixed editing of a text in single line text field widget.
Fixed error when copying forms from the "Copy view from another user" dialog.
Various Admin Tool improvements.
IJC schema upgrade shows warning when license is expired.
Update center does not offer updated when support license is expired.
Patch release.
Marvin/JChem 6.3.2 are used. JChem tables and IJC metadata will not be regenerated from the 6.3 version.
Java 8 is not supported yet.
Editing text in text field reverses the text written, the cursor is on the left and move to the left as you type. Resulting text/number has reversed order of letters. The only option how to edit it correctly is in the grid view.
We are working on fixing this and provide the fixed version as soon as possible.
General improvements in script output appearance being less offensive and general improvements in Output Window handling
Each script now shows its output in separate Output Window
Added a new tool - "Admin Tool" for managing and migrating IJC schemas (see the documentation)
Fixed not persisted master-detail retrieval limit setting when selecting multiple rows for showing Data Union in detail table
Fixed the Pick List problem where new pop-up window caused clearing all of previously created query settings
Fixed error in print preview
Fixed not applied horizontal alignment of date fields with specific widget settings
Fixed error in file import when merging fields
Fixed "freezing problem" after query returning many hits when Scatter Plot was present in a form view
Fixed text alignment in exported Excel files
Fixed problem when some data were not shown in a form view, particularly when retrieving a huge amount of hits
Fixed missing relationships in new Edge Manager dialog
Patch release.
Marvin/JChem 6.3.1 are used. JChem tables and IJC metadata will not be regenerated from the 6.3 version.
List of the data trees in Projects window is now sortable according name
Optimised export to Excel, less memory consumption preventing out of memory errors
Support of large Integer numbers - 64bit types, works for primary ID column too
Manual Drag'n'Drop reordering of fields in Schema editor -> Entities shows warning when Alphabetical Ordering is enabled
Label Widget can show images and the limit for the image size was increased to 1MB
Improved Label Widget editing - new Customiser dialog, shows preview, URL, text and image can be edited in one single dialog
Improved Label Widget to automatically resize according to updated content
Fixed bug with editing problem of multi line labels
Printing is not allowed when query is running
Fixed an error appearing after trying to open Print Preview on a table with no columns
Fixed an issue with Browser rendered and Browse pane widget not showing images stored in binary fields
Fixed error when printing table with no columns
Fixed Charts Customiser showing wrong bound fields
Fixed an exception appearing after stopping a query
Fixed a problem with printing a wide form or while query is still running, throwing an exception
Fixed a problem with horizontal alignment of the text fields - was always aligned to the left
Fixed an issue with decimal places customisation when showing decimal numbers
Fixed a problem with creating a new Project with empty local DB caused IJC to request a Schema Upgrade
Fixed a problem when rebinding a Multi Line Widget needed reopening the form to take effect
Fixed an error appearing after trying to import empty SDF file to existing entity
Fixed an error with adding a widget to shared (read-only) form and saving it to own form
Fixed a problem with borders and inter-widget space (compact fields) appearance in certain form configurations
Fixed a problem with CheckBoxes not being responsive during Field Promotion dialog
Feature release.
Marvin/JChem 6.3 are used. IJC and JChem tables will be regenerated from the 6.2.x versions.
Pick list functionality
Possibility to define order of fields in insert row dialog.
Browser Widget displays formatted text.
Browser Widget works for text and calculated fields.
Improved Relationship Wizard.
MolMatrix widget displays all records in child entity with 1:1 or N:1 relationship.
MolMatrix supports fields from child entities.
Parallel connecting to multiple schemas.
Persistent Sorting and support for multi entity sorting.
It is possible to sort parent data according to child data with N:1 relation.
Enhanced dialog for In list query editing.
Support for RTF text format displaying in widgets.
Distinct values in form based query.
Improvements in tab panel handling.
Modifiable IJC user directory path for Java Web Start deployed IJC.
Multi-entity charts - charts can use data from different, related entities.
Fixed ISE exception when trying to delete relationship.
Optimized 'sql-metadata-all-views' SQL template for Oracle.
Fixed "Otherwise" color option for Conditional Formatting.
Fixed View Value for Markush structure throwing IAE exception.
Fixed Case-insensitive checkbox not in being in sync between grid view and query builder.
Fixed Standrt/Cartridge entity over database view allowing creation of new calculated fields.
Fixed reordering tabs in tabpane corrupting form for Wombat Text Field.
Fixed a problem with "between" query operator being used after "in list" operator.
Fixed problems with Table column header background color.
Fixed Scatter plot widget highlighting wrong points.
Fixed right-clicking on MolPane with two columns not showing pop-up menu.
Fixed N-up printing problems for Grid view after printing from Form view.
Fixed an error after promotion of view to entity.
Fixed Conditional Formatting not working for null values in DatePane.
Fixed a problem with stopping a query throwing an error.
Fixed an issue with persisting lock when user with EDIT_SCHEMA did not log out properly.
Fixed between operator not working in form-based query popup.
Fixed a problem with printing of Web Browser widget creating a ghost image.
Fixed an issue with creation of new Derby Database schema.
Fixed a problem with Scatter plot tooltip set to display formula, displaying structure instead.
Fixed Export Wizard showing invalid values in selected fields list.
Fixed an issue with exporting an entity.
Fixed a problem with connection to Composite database.
Fixed an issue with horizontal scroll bar suddenly appeaingr in Export to file wizard.
Fixed a problem with password not being encrypted after connection to schema.
Fixed a problem when Oracle schema name must have been entered in uppercase only in connect to schema dialog.
Fixed some performance issues with persistent sorting.
Fixed a problem with selected entity being ignored by new relationships wizard.
Fixed proper alignment of different number formats in the fields.
Fixed a problem with not being able to maximize a sliding view when launching IJC.
Fixed structure table in other database schema using structure column in lower case for users.
Fixed widgets being shifted when recreating the form with API, by a script.
Fixed an issue with compact fields form not being compact anymore.
Fixed a problem when Standardizer omitted the structure.
Fixed an error with synthesizing JCB TableSetInfo based on a db view.
Patch release.
Marvin/JChem 6.2.4 are used. JChem tables and IJC metadata will not be regenerated from 6.2.3 versions.
Various admin tool bug-fixes and improvements
Fixed a problem with printing a wide form or while query is still running
Fixed error in print preview
Fixed error after stopping query
Fixed not persisted master-detail retrieval limit setting when selecting multiple rows for showing Data Union in detail table
Fixed an error with adding a widget to shared (read-only) form and saving it to own form
Fixed an error appearing after trying to import empty molecules in SDF file to an existing entity
Patch release.
Marvin/JChem 6.2.3 are used. JChem tables and IJC metadata will be regenerated from 6.2 versions.
Patch release.
Marvin/JChem 6.2.1 are used. JChem tables and IJC metadata will be regenerated from the 6.2 version.
Fixed a problem fields in tabbed pane did not always update when advancing records
Fixed a problem with Instant JChem 6.2 not working properly with Oracle 9i database
Feature release.
Marvin/JChem 6.2 are used. IJC and JChem tables will be regenerated from the 6.1.x versions.
Added support for Microsoft SQL Server database
Improved changing of values of fields, that participate in relationships, via Groovy
Spring Framework/Security was updated to 3.1.4
Switched to Java 7 as main platform, while retaining support for Java 6
Improved data retireval for charts
Added persistence to Form API for Tree Table Widget and for Charts
Improved querying for info about cartridge tables
Improved dashboard font anti-aliasing
Improved adding defalut roles in the security settings
Improved selection update performance of more complicated forms
Bind widget to fields dialog now remembers last used "bounds"
Fixed a problem with copying of a form shared by other user
Fixed a bug with editting of the button script
Fixed some minor issues with Restore Schema from ZIP Backup functionality.
Fixed a problem when Give ownership dialog showed unsorted list of users
Fixed a problem with a confirmation dialog for deleting a child row not showing the row id
Fixed a problem with IJC not starting on Mac OS X Maverics
Fixed pop-up menus not showing all fields if the pop-up menu did not fit the screen
Fixed tooltip not showing value without field name
Fixed a problem when Standard/Cartridge entity allowed creating new chemical term fields via database view
Fixed a problem with querying on two child entities at the same time
Fixed single field widgets added to Form View starting with empty selection
Fixed "Give ownership" dialog not showing sorted list of users
Query builder used to run query from calculated field caused a crash. Query builder now behaves in the same way as Form View regarding querying calculated fields
Fixed font selection for widget customization with Java 7
Fixed not working editing of an empty structure on Oracle DB with Cartridge
Fixed an issue with Save copy and Closing unsaved views dialogs appearing even if no changes were made
Fixed Tools -> Open URL functionality working with Standard License
Fixed problems with changing values of fields participating in relationships
Fixed case-insensitive search option affecting table joins
Fixed some minor issues with Restore Schema from ZIP backup
Fixed problems with sorting parent table data by child values when the relation was N:1
Patch release.
Marvin/JChem 6.1.9 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
Patch release.
Marvin/JChem 6.1.8 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
Patch release.
Marvin/JChem 6.1.7 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
Patch release.
Marvin/JChem 6.1.6 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
Patch release.
Marvin/JChem 6.1.5 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
Optimalized performance of SQL metadata handling
Fixed randomly appearing error after startup
Patch release.
Marvin/JChem 6.1.4 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
Improved the query for sorting 1:1 related entities in grid view to fix a problem when the original query caused ORA-00942.
Fixed a problem with fonts customization of the widget when Java 7 is used.
Fixed a problem when editing an empty structure in MolPane widget did not work, while Oracle DB with JCC was used.
Fied an issue when setting a query operator on text field (in Grid view) and changing it to in list, set '=' operator instead.
Fixed a problem when opening a shared project from ijp file, the project did not appear in Project Pane until reopening the project.
Fixed an issue when database column names readed as lower case for Admin and upper case for User.
Fixed header background missing for the column's header in the table.
Fixed a problem when a "Missing Fields" report was absent when Admin connected, but User could see it - now it is visible only for Admin.
Fixed a problem when changing a query from "search by selected value" to "between" query operator.
Patch release.
Marvin/JChem 6.1.3 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
Fixed issues with "Save copy" and "Closing unsaved view" dialogs.
Mainly changes in JChem.
Patch release.
Marvin/JChem 5.12.6 are used. JChem tables will not be regenerated from the 5.12.5 version.
Allow federated search to be used with standard cartridge entities.
Fixed a problem in queryForData method from DFEntityDataProvider trying to retrieve all columns, instead of specified
Patch release.
Marvin/JChem 6.1.2 are used. JChem tables will be regenerated from the 6.1 version.
Minor changes in the Forms API.
Fixed an issue with IJC breaking japanese characters in the XML security configuration.
Fixed a problem with not changing text field widget renderer when rebinding to a different field.
Added a possibility to highlight, which user is currently in single admin mode.
Feature release.
Marvin/JChem 6.1 are used. IJC and JChem tables will be regenerated from the 6.0.x versions.
Form API - allows forms to be created by scripts (documentation).
Palette for widgets in form design mode, widgets can be added more easily.
Printable Button widget.
Derby JDBC driver updated to 10.10.1.1 version.
New Prediction action removed from IJC menu.
Default size of Import dialog increased.
Fixed a problem when Table lost selection after Reload Data action is performed.
Fixed a bug when Copy-pasted widget had the same ID as original one.
Fixed a bug with N-up printing from Grid view after printing setting were remembered from Form view.
Fixed a bug when Cd_structure column is wrongly identified as binary field when promoting MySQL view.
Fixed a problem with date field and clearing query in query builder.
Fixed T2P database schema name translation support, different DB schema names can be used.
Fixed a bug in sheet widget when after editing data, the widget did not update.
Fixed a problem when trying to copy a form from other user while opening it caused an error.
Fixed a bug when hitting enter in the date field did not start a query.
Fixed an inaccurate licensing message when trying to create an Oracle schema with IJC Standard license.
Fixed a bug when table lost selection after Reload Data action was performed.
Improving error message if retrieving structures fail.
Do not show asking dialog about copying shared form of other user if it's disabled in "Tools-> Options -> Confirmations -> Ignore all changes in design of shared views owned by other users".
Fixed a bug in copy/paste of widgets.
Fixed an issue with editing date value in small table widget in query mode.
Patch release.
Marvin/JChem 6.0.5 are used. JChem tables will not be regenerated from the 6.0.x version.
Fixed LDAP configuration doesn't allow to change value of objectClass=inetorgperson.
Fixed disappearing list after it was edited.
Patch release.
Marvin/JChem 6.0.4 are used. JChem tables will not be regenerated from the 6.0.x version.
Allow federated search to be used with standard cartridge entities.
Fixed restoring schema zip backups on Mac OS X.
Fixed a problem in queryForData method from DFEntityDataProvider trying to retrieve all columns, instead of specified
Patch release.
Marvin/JChem 6.0.3 are used. JChem tables will not be regenerated from the 6.0.x version.
Fixed compatibility with ChemDraw 13
Frequently Asked Questions page created - IJC FAQ
Patch release.
Marvin/JChem 6.0.2 are used. JChem tables will not be regenerated from the 6.0.x version.
Patch release.
Marvin/JChem 6.0.1 are used. JChem tables will not be regenerated from the 6.0.x version.
Fixed error with exporting to Excel
Fixed issues with incorrectly working licences
Fixed maximum memory settings for 64-bit IJC, corrupting path to JRE in instantjchem.conf
Updated toolbar for user interface consistency with Marvin
Fixed unbound widgets in tabbed panel
Feature release.
Marvin/JChem 6.0 are used. IJC and JChem tables will be regenerated from the 5.12.x versions.
New Welcome Screen, now called Dashboard.
Dashboard is maximized by default.
Persistent sorting configuration and possibility to configure default sort.
New start option to set own HTML page as startup page in Dashboard.
Multi selection in master can show union of rows in detail.
Groovy updated to 2.1.2.
Export wizard features Configuration step, and last used configuration is remembered.
"Markush reduction" option added into Show/Hide R-groups toolbar button.
GUI facelift with new icons and splash screen.
Domain search in form-based query.
Added Spotfire integration support for relational data.
New scripting hooks for Text field widget - beforeEdit and afterEdit.
Implemented a default scripting hook for all widgets in a form.
New option for tautomer search to ignore tautomer stereochemistry.
Added support for transfer entities based on database views.
"Contains" operator made to be default instead of "=" operator for text field queries.
Chemical terms columns are now promotable for Cartridge standard entity.
Ability to lock toolbar navigation arrows to root entity only.
Ability to search Current Results in Domain Search.
Improved performance for sheet widget, column-based data retrieval.
Fixed improper locking of DFLock in Groovy examples.
Fixed permanently being asked for Metadata upgrade.
Fixed displaying incorrect similarity scores in similarity search of reactions.
Extra attributes can be edited by double-click.
Fixed exception when creating List widget.
Fixed widget binding to newly joined table via existing edge.
Fixed errors in R-group table during copying the structure or additional fields.
Fixed verification of Standard and Enterprise licenses.
Fixed database password visibility in logs with enabled SQL logging.
IJC does not know about JChemPropertyTable in user mode on MySQL.
Improved performance of table sorting.
Disabled function Save Results as Local Database... for SQL Entity type.
Fixed bug with using TNS keyword-value syntax in connection URL for Oracle DB in T2P tool.
Fixed a Tree Table widget bug during field deletion.
Fixed table row header updating.
Fixed a bug with unrecognised JDBC type for date.
Fixed UnknownFormatConversionException when views with certain characters (e.g. '%') could not be opened.
Fixed SSS-duplicate tautomer search problem in the Search Dialog.
Fixed a Mac OS X specific bug with copy/paste in grid view.
Fixed issues during printing of Sheet Widget
Fixed standard copy action - copies molecules as smiles now.
Fixed Copy to MS Office not working when molecules are copied.
Fixed Copy to MS Office for fields from multiple entities.
Fixed detection of JChem for Excel export format.
Version numbers were increased to 5.x to be in sync with Marvin and JChem
Patch release.
Marvin/JChem 5.12.5 are used. JChem tables will not be regenerated from the 5.12.x version. IJC tables will not be regenerated from the version 5.12.3.1 and onwards. Projects from a newer major version can not be used with this version.
Fixed DFEntityDataProvider.queryForData(query, fields, ...) tries to retrieve all columns from db instead of required
Fixed usage of federated search on Standard tables with JChem Cartridge index.
Patch release.
Marvin/JChem 5.12.4 are used. JChem tables will not be regenerated from the 5.12.x version. IJC tables will not be regenerated from the v5.12.3.1
Fixed sorting of fields on Oracle e.g. in Promote table dialog.
Fixed setting of default field value.
Patch release.
Marvin/JChem 5.12.3 are used. JChem tables will not be regenerated from the 5.12.x version. IJC tables will need regeneration in order to update column JDBC types. The change is backward compatible with 5.12.x.
Fixed copying values from child entity fields in a multi-entity table widget.
Fixed exceptions after deleting a db column used in a calculated field.
Fixed structure search with older JChem cartridge.
Fixed deadlock in button scripts.
Fixed Oracle Float detection in the SQL Entity creation wizard.
Fixed OracleText search on a child table.
Fixed problems with OracleText search and OracleText index detection.
Fixed Oracle TIMESTAMP data type handling.
Patch release.
Marvin/JChem 5.12.3 are used. JChem tables will not be regenerated from the 5.12.x version. IJC tables will not be regenerated from the v5.12.2.
Fixed error while running similarity search.
Fixed NPE while deleting schema with opened form containing text field widget.
Patch release.
Marvin/JChem 5.12.2 are used. JChem tables will not be regenerated from the 5.12.x version. IJC tables will need regeneration because of some new features. The change is backward compatible with 5.12.x.
Performance improved during rapid scrolling - CLOB reading optimization on Oracle.
JChem Cartridge queries are canceled immediately.
Basic implementation of the OracleText feature.
Fixed bug with dropped cartridge index when dropping structure entity based on DB view.
Fixed bug with child's entity data if logged in as Schema administrator.
Fixed problem with non refreshing data from child entity in Table widget.
Fixed problem with fields from another entity in calculated fields ( Forum topic).
PNG images are pre-selected as default structure format in Export to Excel dialog if JChem for Excel is not installed on the computer (Forum topic).
Patch release.
Marvin/JChem 5.12.1 are used. IJC and JChem tables will not be regenerated from the 5.12.0 version.
Editable SQL Entity definition.
Better accessible Stop query button (right icon in the main toolbar).
Shorter delay while stopping queries.
Fixed deadlock when navigating back in new SQL Entity wizard.
Fixed reading of old count(*) query definitions.
Fixed when selected cell was not highlighted in MolMatrix when clicking into partly visible row.
Feature release.
Marvin/JChem 5.12.0 are used. IJC and JChem tables will be regenerated from the 5.11.x versions.
All installers bundled with Java using JRE 1.6.0_41.
Performance
Column-based data retrieval.
Fixes to errors when scrolling through the results quickly.
Automatic setting of Java Heap Memory if possible (-Xmx param), likely to be set to more than 512MB.
Security
Sharing and security settings based on a role.
Optional disabling of "remember password checkbox" in the dialog to connect to IJC schema.
Scripting
Better stacktrace in groovy scripts.
Fixes to problems with JChemCartridgeJChemBaseCapability and JChemCartridgeStandardCapability.
Handle errors during scriptable event handling
Usability
Equal operator is set as default in query mode => you can enter a value without operator.
Ability to disable snap-to-edge in form designer.
Possibility of sorting according to child entity fields in the table.
Showing the entity name in the tooltip of table column headers. Useful when there are fields from different entities shown in the table.
Pre-filled field default values in insert row dialog for detail entities.
Mandatory fields shown in red if required but missing in Add new row dialog.
ETL functionality for database administration
Saving of results to a local database schema, allowing for data in destination schema to be edited but not for new rows to be added - no migration of the db sequences.
Test2Production - metadata migration tool. Migrates IJC objects from an IJC source schema to a destination schema, schema IDs of both must be identical. Migrates only changes in IJC_* tables; no other (i.e. chemical) data are migrated.
SQL Entity - new flexible entity type defined by a SQL statement.
MolMatrix widget supporting text fields also in standard entities.
MolMatrix printing.
Fixes for NULLs in LIST type variable being replaced in calculated fields. Some new variable types implemented.
Chemical terms fields and calculated fields supporting MIME type.
Better handling large data in Spotfire integration.
Fixed few errors in IJC/Spotfire synchronization.
Fixed displaying Gridviews with more than one 1:1 related tables.
Fixed wrong decimal mark in Gridview when using e.g. German locale in Windows ( Forum topic.)
Fixed not persisted settings if the number format has decimal places set to 0.
Fixed adding reactions to a reaction table without standardizer license.
Updated reaction library.
Fixed welcome screen not showing bottom panel (forum) when proxy is set.
Fixed missing rows after sort if there are missing rows in _JCX index table.
Fixed SQLException: Protocol violation when reading large CLOBs (Forum topic).
Improved New Script and New View dialogs contains Script type and View type pre-filled by default.
Fixed ignored Structure Format in Extra attributed when importing SD file (Forum topic).
Fixed error when printing unformatted decimal number.
Improved visage of printed boolean fields.
Fixed ugly sheet widget when more rows are visble.
Fixed Markush substructure highlight issue after search with homology group narrow translation.
Button Widget visage improved in Mac OS.
Fixed help in IJC Marvin Sketch sketcher.
Improved performance of TreeTable with larger datasets. (Forum topic).
Fixed non-working search cancelling without JChem Cartridge.
Fixed not shown values in group field when the same field is visible as value field in TreeTable.
Fixed Query Builder not working correctly with more than two substructure queries.
Fixed decryption of credentials in Prepared Configuration (Forum topic).
Improved error reporting of cartridge queries.
Fixed Sheet widget / field manager, order modification does not persist.
Fixed Grid view does not show value in 'View Value' when field is from child table.
Made Count(*) query working for nested detail tables.
Patch release.
Marvin/JChem 5.11.5 are used. IJC and JChem tables will not be regenerated from the 5.11.x versions.
Patch release.
Marvin/JChem 5.11.4 are used. IJC and JChem tables will not be regenerated from the 5.11.x versions.
Fixed usage of ROWID as ID field in Oracle views.
Fixed init and destroy methods in button scripts ( Forum topic).
Fixed disabled paste action of widgets in form designer.
Patch release.
Marvin/JChem 5.11.3 are used. IJC and JChem tables will not be regenerated from the 5.11.x versions.
Fixed schema init failure in 'Normal mode' when using std/cart entity which involves a db view as the main table.
Fixed disabled paste action of widgets on switching to design mode.
Fixed SQL Filter extra attribute persistence on standard entity.
Implicit heap memory (-Xmx) settings set back to 512MB.
Patch release.
Marvin/JChem 5.11.3 are used. IJC and JChem tables will not be regenerated from the 5.11.x versions.
Fixed not working import without standardizer license.
Fixed domain search using list of non-ID field.
Patch release.
Marvin/JChem 5.11.2 are used. IJC and JChem tables will not be regenerated from the 5.11.x versions.
Fixed mixed-up aggregated values in Tree Table.
Fixed slow New Chemical Terms Field dialog.
Fixed multiply(a,b,..) function in Calculated fields ( Forum topic).
Fixed ConcurrentModificationException when scrolling through a list of compounds.
Patch release.
Marvin/JChem 5.11.1 are used. IJC and JChem tables will not be regenerated from the 5.11 version.
Decimal number zero gets formatted correctly when significant figures are used.
In list operator can be used with values in parenthesis.
Fixed few bugs in TableTree widget.
Feature release.
Marvin/JChem 5.11.0 are used. IJC and JChem tables will be regenerated from the 5.10.x versions.
Performance
Faster schema initilization if connecting in user mode.
Optimized access to JCHEMPROPERTIES and to IJC_* tables leads to faster schema init.
Fixed schema initialization performance when std/cart based db views are used.
Chemistry
R-Group table improvements
Preserving R-group orientation and coloring.
Ability to choose molecule format for R-group structure fields.
R-group columns are located right after structure column by default.
Added Markush structure enumeration to JChem tables.
Scripting hooks
Results are coming continuously while the search runs - no more modal Running the query dialog.
Improved error reporting from JChem Cartridge searches.
Improving copy/paste functionality into MS Office applications.
Export to Excel 2007 file format (.xslx support).
Export to Excel in JChem for Excel format.
New Tree Table widget used for grouping rows according a field value - Experimental.
Fixed handling proxy PAC file URL redirection.
Fixed error when dataset in boxplot contained one data point.
Customizable rows limit for box plot.
Fixed Grid view synchronization when field are added by own java plugin code.
Fixed NPE in Text field if defined discrete values on the field.
Fixed not working startup switches on ijc.exe - using intantjchem.exe instead and removing ijc.exe from installation directory.
Fixed content of zip file when using Backup schema to ZIP file...
Fixed SQL parser error when parsing dblink identifiers that contain dot character (eg. '.').
Save current query definition under Tools -> Experimental -> Save Current Query.
Fixed failing cartridge filter query for dates.
Fixed saving structures in MolMatrix in defined molecule format.
Added multi-selection for MolMatrix on MacOS - Meta+Click add/remove the cell to/from selection.
Removed row count for detail tables in gridview.
Pick-up schema dialog sorts schemas alphabetically.
Patch release.
JChem/Marvin 5.10.4 are used. IJC and JChem database tables will not be updated from 5.10.x.
Fixed bug when the value in another row could be accidentally deleted during manual editing in multi-entity table.
Fixed unsuccessful deletion of Chemical Terms field columns in Standard structure tables on Oracle cartridge.
Patch release.
JChem/Marvin 5.10.3 are used. IJC and JChem database tables will not be updated from 5.10.x versions.
Patch release.
JChem/Marvin 5.10.1 are used. IJC and JChem database tables will not be updated from 5.10.0.
Fixed Non-hits search option on cartridge.
Fixed crash in charts when category field contains null values.
Fixed gridview refresh/synchronization when adding fields via users java code.
Removing redundant ctFilter search option on cartridge (generated twice).
Feature release.
Marvin/JChem 5.10.0 are used. IJC and JChem tables will be regenerated from the 5.9.x versions.
Performance
Performance improved for loading detail data in relational data trees. Reduced number of database calls for many-to-one and one-to-one relationships.
Optimisation of SQL statements for table component.
Removing unnecessary ALTER SESSION statements and jchem_core_pkg.init() calls.
Avoiding reading information about sequences during the schema initialisation process if it is not needed thus improving schema init performance.
Removing reading the table foreign keys during schema init. They are read only when needed, which is rarely.
Removing DISTINCT statement from ID retrieval in some cases. This improves query performance.
Much faster reading ALL_TAB_COLUMNS.DATA_DEFAULT column on Oracle, hence improving schema init performance.
Database and Connection
Improving connection pool settings thus preventing several connection errors to occur.
Added support for relational data access to OData adapter.
Ability to import structures from pdf and other document formats (doc, docx, xls, xlsx, ppt, pptx, odf, txt, html, xml) according the names.
Structure format and image size can be specified during export to Excel file.
Possibility to enumerate a Markush structure to JChem table.
Marvin services can be installed to JWS using commandline options.
Query
A new implicit 'COUNT()' field is made available which allows the user to return parent records with a specified number of child records (When COUNT()=0 then this is equivalent to 'NOT EXISTS').
Added structure search options for R-group atom matching, exact query atom matching and halt on error.
Added two R-atom matching search options: Bridging R ligand allowed and R ligand equality check.
Scripts
Scripts can be easily cancelled by using cross-end button appearing in the right-bottom corner during script execution.
A new built in script, configurable in the schema editor which can run groovy code against the schema after and prior to login and logout events.
Button scripts are validated at runtime in the editor and a detailed feedback is returned when there is an error in the script.
Adding some default IJC API imports to scripts.
Added ability to share scripts between users.
Widgets
Fixed incomplete search results in Markush Viewer.
Markush Viewer is used as a viwer for Markush structures in MolMatrix (shortcut F3).
Fixed problem when column with empty name was printed with field's name.
Export of compressed MOL files allowed too large coordinate values which caused distortion in the molecule after import it.
Fixed exporting comlumn names without spaces upon RDF export.
Fixed AssertionError when fields could not be found in the entity. Particularly when working with text columns with discrete set of values ( Forum topic).
Drop-down list of discrete values is kept up-to-date and contains all values even after editing.
Database and Queries
Fixed problem with DB security filter - SQL Filter (Forum topic).
R-group decomposition and undefined R-atom search now handles the case when the query contains both undefined R-atoms and R-groups with definitions.
Fixed problem when CT Filter in Form-based query reset search options.
Implemented Halt on error search option - if set to no search continues on error (eg. in CT filter) and returns as many hits as possible.
UI
Fixed error in Browser widget pop-up menu.
Minor UI improvements in Personal server manager and better exception handling.
Fixed missing project icons in Open Project dialog.
Fixed broken Ctrl+P shortcut for printing.
Scripts
Script errors are shown in the Output window and do not disturb in an anoying error dialog.
Fixed bug when layout of button script editor did not resize correctly.
Script editor usability improvement (eg. run script by using Ctrl+R shortcut, name of executed script written in output window).
Widgets
Fixed problem with charts when all IDs would be retreived unnecessarily in some cases. Caused performance problem with large data sets.
Fixed problem with printing charts.
Fixed NPE when deleting field from sheet widget.
Fixed problem that standardizer file was modified when user did not want to save changes.
Multi column data in the clipboard can not be pasted as a new list.
Fixed problem with training functionality.
Closing communication with Spotfire if IJC is closed.
Spotfire extension is properly signed by Chemaxon as the publisher.
Patch release.
Marvin/JChem 5.9.4 are used. IJC and JChem tables will not be updated from 5.8.x.
Patch release.
Marvin/JChem 5.9.3 are used. IJC and JChem tables will not be updated from 5.8.x.
Patch release.
Marvin/JChem 5.9.2 are used. IJC and JChem tables will not be updated from 5.8.x.
Fixed problem with line endings when exporting SDF files.
Better diagnostics in JWS launcher.
Patch release.
Marvin/JChem 5.9.1 are used. IJC and JChem tables will not be updated from 5.8.x.
Fixed problem with structures shown in ballstick.
Fixed various connection problems and connection losts.
Fixed problem with popped up exceptions from JDBC calls when SQL logging is on.
Fixed problem with blank rows when records was missing in index Cartridge table.
Prediction of chemical properties can be run.
Feature release.
Marvin/JChem 5.9.0 are used. IJC and JChem tables will not be updated from 5.8.x.
Database and Connection
Added support for encrypted JDBC connection on Oracle.
Tooltip on schema in project explorer is showing additional user info (schema admin mode, roles, etc.) (Forum topic).
A new security policy added to support the OAM and WIRE integrated authentication/authorization providers.
Queries
Alow to cancel Cartridge queries.
Improvements to SQL logging.
Widgets
Allow to customize properties of multiple widgets at once.
Customizable tooltip field for widgets and tables.
Allow to minimise space between border and widget content to make better use of space on form.
Ability to parse text within PDF files and import structures.
Improvements to RDF export of secondary structures with regards to compatibility with ISIS.
Added support for structure search through the Schema to OData adapter.
External libraries are supported in Groovy scripts.
Persistent print settings (page size, orientation, margins, header & footer content).
Database and Queries
Optimisation of SQL for table components.
Performance improvement in retrieval relational data when there is only one element.
Fixed error when cancelling data retrieval.
Fixed error in executing complex Markush relational query.
Connections
Fixed error with lost entities when loading mode Load as needed was set.
Fixed error in handling usernames in ijc_user table.
Added timeout for shared projects connections.
Widgets and UI
Fixed error when scrolling MolMatrix with conditional formatting.
Fixed error when moving structures in the IJC 5.8 sketcher (Forum topic).
Persist absolute label setting in Structure renderer.
Fixed error when cutting Panel or Tabbed Panel widget.
Fixed error when column manager erases settings of column headers.
Fixed error in printing forms with calculated fields.
Fixed error during closing IJC when reading row numbers still happening.
Fixed problems in Marvin calculator plug-in services.
Patch release with newer JChem libraries.
Marvin/JChem 5.8.2 are used. IJC and JChem tables will be updated from 5.7.x and will no longer be usable with 5.7.x versions.
Local databases will be updated to a new version of Derby and will no longer be usable in 5.7.x versions.
Fixed problem with LDAP security not being backward compatible with 5.7
Show RGroup decomposition menu in main menu.
Fixed problem with evaluation of calc field being skipped when there is no child row.
Optimised building table/column info for relationships to avoid performance problem.
Feature release.
Marvin/JChem 5.8.0 are used. IJC and JChem tables will be updated from 5.7.x and will no longer be usable with 5.7.x versions.
Local databases will be updated to a new version of Derby and will no longer be usable in 5.7.x versions.
Database
Derby database used for local databases upgraded to version 10.8.1.2
Oracle JDBC driver is actually version 11.1.0.7.0 for Java SE 6 despite the fact that the module number is 11.2.0.2.1
LOGIN_COUNT column added to IJC_USER table to record the number of times each user logs in to IJC
Connection pool parameters changed to reduce number of permanent database connections. These settings can be configured.
Connect to schema
Box plot widget, allowing distributions of values to be displayed graphically
Personal server
Added server providing access to IJC data as OData, using RESTful web service
Spotfire plugin allowing import of IJC data into Spotfire (experimental feature)
Form builder
Conditional formatting does not mask selection in table widget or grid view
Row height of sheet widget is configurable
Form definitions are loaded when needed, rather than at start
Scripting
Groovy version updated to 1.8.4
Various improvements to script editor
Improved documentation and examples
Scripts can be run without need to open in editor.
Query
Markush
Login default changed to Multi-user mode
Single user mode problems solved
Databases
Improved decimal number fields handling on Oracle
Fixed removal of extra attributes from entity - ie. permissions can be again easily added/removed
Printing
Fixed error when using add/remove list from current results when using text based fields
Fixed printing calculated fields producing double values
Fixed printing of very wide tables
Fixed printing of background colours in table headers
Printing of molecules improved
UI
Increased width of max hits text field in overlap analysis dialog
Increased width of current row text field in main toolbar
Better descriptions in sharing dialog
Widgets
Implemented view value action in MolMatrix
Fixed lost of focus on editing text field widget with multiple values
Better handling of too small or too large values in charts
Improvements in scaling of axes in scatter plot when data changes
Fixed reseting coordinates in charts
Removed minimal row height in tables
Top and bottom alignment actions added to form designer
Fixed redirecting in browser widget
Fixed various bugs in RDF import/export
Fixed problem with deletion of calculated field
Fixed wrong structure renderer settings
Script failures are written to log file
Fixed bug in Marvin services client
Fixed sorting of detail tables on Derby
Cut function removed from browse mode in form/grid view
Calculated fields are supported in lists
Forms/Gridviews configuration is loaded to memory only when needed. This speeds up connecting to schema especially on remote databases when schema contains lots of complex forms.
Patch release with one particular improvement.
Marvin/JChem 5.7.2 are used. IJC and JChem tables will not be updated from 5.7.x versions. This version cannot be used with 5.8.x projects
Patch release with newer JChem libraries.
Marvin/JChem 5.7.2 are used. IJC and JChem tables will not be updated from 5.7.x versions. This version cannot be used with 5.8.x projects
Patch release with one ported feature.
Marvin/JChem 5.7.1 are used. IJC and JChem tables will not be updated from 5.7.x versions. This version cannot be used with 5.8.x projects
This is primarily a stabilisation release with relatively few new features.
Marvin/JChem 5.7.1 are used. JChem tables will be updated from 5.6.x and will no longer be usable with 5.6.x versions.
Possibility to change fonts in a form globally in one run
Fixed problem with 'Default header font' property in table customiser, it was in fact the font from widget border
Added print guidelines to form designer
Improved space handling of header and footer when printing
Fixed printing of calculated fields
This is primarily a stabilisation release with relatively few new features.
Marvin/JChem 5.7.0 are used. JChem tables will be updated from 5.6.x and will no longer be usable with 5.6.x versions.
Case insensitive search support for text fields
Added option to export structures in SMILES when exporting to Excel
Basic support for calculated fields in lists
Improved relational data retrieval performance
Chemical-Terms filter added to a context menu in form based queries
By default showing relevant R-groups when searching structures
Correct colour schema used when showing R-groups hits
Fixed badly formated SDF export
Fixed Ctrl+C in widgets
Fixed problems when using RAW db type
Fixed importing decimal numbers on locales that use comma as the decimal separator
Various printing fixes: structures from child table, boolean text-fields, no font defined
Fixed refreshing files in Projects window
Fixed query performance degradation found in IJC 5.6.x
Fixed problem with deleting additional query terms
Fixed domain searches with large lists of IDs
Fixed some Chemical-Terms templates
Minor bug fix release.
Marvin/JChem 5.6.0.3 are used. IJC and JChem tables will not be updated from 5.6.0.2
Fixed RDF import of secondary structures
Fixed navigation through entries by arrow keys in relational form views
Fixed problem with Oracle/Cartridge relational queries
Minor bug fix release.
Marvin/JChem 5.6.0.2 are used. IJC and JChem tables will not be updated from 5.6.0.2
Removed extensive logging of SQL parser exceptions when there are DB view problems
Fixed schema init performance regression related to loading DB views
Fixed problems with Oracle/Cartridge queries
Minor bug fix release.
Marvin/JChem 5.6.0.2 are used. IJC and JChem tables will not be updated from 5.6.0
Feature release.
Marvin/JChem 5.6.0 are used. IJC and JChem tables will be updated from 5.5.x and will no longer be usable with 5.5.x versions.
JChem cartridge
Support for views of cartridge tables as structure entities
Improved query performance for some types of JChem cartridge query
Cherry picking for list management
R-group deconvolution
Markush
Added homology group search options
Improved handling of chemical terms filter
Expand homology groups is off by default
Options for 2D cleaning
Markush structure can be generated from searched result
Forms and widgets
Selection data layer - allow table and mol matrix to display just selected rows
Button widget allows scripts to be performed in forms
Double click opens viewer not editor if you only have read-only access
Size of form XML reduced, improving load time.
Sheet row labels can be edited
Markush viewer used for viewing structures
Mouse drag action can be configured in molecule pane
Ability to remove grouping from decimal numbers
Visualisation widgets
Rainbow colouring for scatter plot - colour point by separate field
Point size in scatter plot can be specified by separate field
Logarithmic axes for scatter plot
Ability to reverse axis direction in radar chart
Selected rows in radar chart are highlighted
Demo project includes presentation of the new visualisation features
List management - new 'working list' list to support cherry picking
Scripting
Improved error handling
Demo scripts improved
Java web start installation directory can be shared on a multi-user system
Warning when passwords are included in shared projects
Switch to query mode instead of Browse when initial data retrieval is switched off (IJC-3759)
A bug in the Oracle JDBC driver was causing columns that were created with default values for scale and precision (e.g. NUMBER or INTEGER) to be reported as type NUMBER(0,0), which resulted in these columns being handed by default as integers, when in many cases they should be treated as decimal numbers. This was fixed by reverting the Oracle driver to the 11.1.0.7.0 driver. But the module version must be increased for the module to be upgraded, so this module now has a version of 11.2.0.2.0.1 which is misleading.
Fixed problem with structure table being renamed (e.g. to 'Any Structures' when the table type was changed
Import
Fixed problem with RDF import handling decimal numbers as integers.
Fixed problem with standard import with secondary molecule not being recognised due to whitespace being trimmed
Much of the printing subsystem has been improved, removing many bugs and quirks
Exporting structure fields from child entities is now possible
Improved layout and fixes in fields customizer
Scatterplot and histogram widgets - correct order of categories in legend for numeric values
Scatter plot widget - improved/fixed performance of tooltip
Chemistry menu moved to top-level menu from Tools submenu
Installers - installation of JChem .NET API doesn't fail without .NET 4.0
Clearer error message for admin when users are not logged out correctly
Improvements in ChemDraw integration
Fixed problems with green borders showing for some form widgets when using Windows Classic theme
Minor bug fix release.
Marvin/JChem 5.5.1 are used. IJC and JChem tables will be updated from 5.5.0.
Query
Fixed problem in query where moving mouse over stereochemistry radio button can alter other query settings
Fixed problem entering values for between operator using form based query
Fixed problem with commas disappearing when using 'In List' operator (Forum topic)
Fixed problem printing when multiple levels of data are present
Schema connect
Username+password only stored after successful login
Username+password not shown when the NEVER option is specified, even when connection fails
Fixed problem with unexpected column types preventing schema being initialised
Forms and widgets
Allow forms to cope with situation where field binding for MolPane has been lost
Fixed problem with form not being saved when using some combination of user settings
MolMatrix widget supports the 'Show R-groups' setting
MolMatrix widget row height is now correctly persisted
Better retention of formatting properties when copying and pasting widgets
Fixed NullPointerException from BorderSupport.updateBorder() method
Fixed NullPointerException when creating MolPane widget
Retention of multiple selection of widgets when right click mouse button is used onto a selected widget
Fixed problem when the same fields were not showing 100% mapping on form copy
Fixed problem with RDF import not using the specified table names
Better handling of exporting data to Excel when input data exceeds 65k rows
RXN format used as default for ChemDraw data exchange format, so that reactions can be supported
Added mechanism for cancelling scripts
Fixed problem with removing fields from the 'Copy fields' dialog in reactor support
Search enabled in user guide (Forum topic)
Improved sequence creation on Oracle
Added support for binary_float and binary_double column types
Fixed error when backing up schema to zip file
Convert type function can not be applied to an entity field that is sourced from a database view
Feature release.
Marvin/JChem 5.5.0 are used. IJC and JChem tables will be updated from 5.4.x and will no longer be usable with 5.4.x versions.
Improvements to reactor
Copy field from reactants to products
Wider range of runtime options
Improvements to charts
Radar chart added
Colour by category
Improvements to forms
More formatting and display options for widgets
Stats bar can be hidden
Faster opening
Lower memory footprint
Zip/unzip local databases
Backup and restore a local database
Send a local database to another user
API examples tutorials re-organised
Easier to set up and run the tutorials
Less duplication of content
Tutorial binaries no longer included in IJC
New ways of handling groups in LDAP or Active Directory
Markush - display of only those R-group definitions that are involved with matching the query
Schema Editor
Accordion display rather than tabs
Add ability to drop unused table
Nodes auto-expanded when opened
Ability to correct for errors when missing items from database are found on startup
XML for schema items is written to database in more compact from
Simplified 'Add Edge' wizard
Scripting
Groovy version updated to 1.7.10
Scripts can be saved
Scripts now have access to entire Java API (including all libraries)
Deployment
64 bit installers now available
Provide mechanism to delete obsolete JWS installations
More control over which shared projects are displayed when IJC restarts
Uninstaller does better job of removing files
Other miscellaneous improvements
Syntax of chemical terms favourites simplified
Option for encrypting more properties in the .ijs file
Added option for format numbers using number of significant figures
Improved behaviour of navigation toolbar when multiple rows are selected
*_JSU table no longer required to be present for cartridge indexes
Overlap analysis now works when target is a cartridge based entity
More friendly display of errors
"Saving snapshot" slowness detector disabled
Fixed problem with files not being released in VMN file convertor
Removed "Show implicit hydrogens" option as no longer present in Marvin
Fixed NullPointerException that was sometimes seen when closing projects
Fixed some bugs related to reaction enumeration
Fixed problem with widgets bing lost from panel widgets when copying form
Fixed problem with some widgets settings being lost when copying form
Improved encoding of characters in URL fields ( Forum topic)
Some printing bugs fixed
Calculated fields excluded from permanent lists
Improved behaviour of fields with distinct values set when using insert row dialog
Removed cause of pauses in UI when using schema editor
Fixed problem with changes of precision for numbers during Excel export (Forum topic)
Fixed problem with form needing saving as soon as it is opened
Improved keyboard navigation in MolMatrix widget
Fixed problems and inconsistencies with inserting duplicate structures in cartridge based entities
Allow multiple widgets to be more easily moved as a single unit
Fixed regression resulting in rows not being retrieved from database in bulk
Minor bug fix release. Marvin/JChem 5.4.1.1 are used (unchanged from previous release).
Fixed performance problem with loading IJC schema
Fixed performance problem when running structure queries in child tables
Fixed problem with showing 'No-Structure' when an empty molecule was displayed by ChemDraw
Minor bug fix release.
Marvin/JChem 5.4.1.1 are used. Tables should not need updating from 5.4.0.
Performance and UI improvements with charts
Performance improvements with selection
Performance improvements with opening forms
Reduced memory consumption of forms
Provide way to configure handling of RAW column type on Oracle
Improvement to 'Add edge' dialog for data trees
XML editor for security configurations
Scripting can use Marvin/JChem classes
Bemis Murcko framework added to chemical terms favourites
Increased -J-XX:MaxPermSize parameter to 196m to allow trouble free operation on 64bit Java
Fixed problems with query results when structure table was child table
Fixed problem with import/export of dates
Promote table handles columns with decimal numbers better
Fixed potential freeze when adding new widgets for form
Prevent creation of calculated field that uses a different calculated field
Fixed problem with remembering horizontal alignment setting for columns in table widget and grid view
Fixed problem running with old versions of Java 1.6 related to JAXB
Fixed problem printing form with date widget
Fixed problem with editor not working for newly added structure widget
Fixed problem with sorting items in the data trees tab of the schema editor
Fixed problem with sorting database views in Derby database
Fixed problem with dates earlier than Jan/1 1900 in database
Feature release.
Marvin/JChem 5.4.0.1 are used. IJC and JChem tables will be updated from 5.3.x and will no longer be usable with 5.3.x versions. Security configuration will be migrated to new configurations. These changes are quite significant . Please read before updating and only upgrade if you are sure you no longer want to use 5.3.x. A backup of earlier data is strongly recommended.
Java 6 must be used. Java 5 is no longer supported. A correct version of Java is included in the installer.
New and improved widgets
Histogram (*)
Scatter plot (*)
Structure matrix
Multi-field sheet
Tabbed pane
Conditional formatting (*) - colour code values based on user defined criteria
Improvement layout for the schema editor
Faster startup performance - faster reading of info from DB and options for optimising this
Support for Composite database - Composite is a virtual database allowing data from multiple sources to be accessed as a single datasource
Support for ChemDraw as a sketcher
Calculated fields - ability to generate a field based on a calculation of values from other fields
Improved Markush features - more enumeration and display options, plus the ability to specify the query and target structures
LogP training - train the logP calculator with your own data
Event logging - significant events can be logged to database tables
Role based filtering of items - show/hide data trees and other items for particular users
Database authentication with Oracle and MySQL - user database accounts for your IJC login
Option to show only a specific data tree using a startup or IJC URL parameter - start IJC with only specific data trees showing
Proxy settings handles .pac configuration files
Scripting support - scripts can be run against schemas or data trees
(*) Please note that a new "IJC Viz" license is required to use the charting and conditional formatting features. Without a license these features are restricted to "demo mode" where they are active with data containing no more than 350 rows. Examples are available in the Wombat demo data.
Please also note that since IJC 5.4 a license is required to access the full functionality of IJC. Without a license data can still be viewed and queried in IJC, but you cannot create new tables in the database. This allows you to distribute data to collaborators and for them to be able to work with the data without needing a license, but to be able to create and manage the data in the first place you need a "IJC standard" license. An "IJC Enterprise" license is still needed for connecting to remote (Oracle or MySQL) databases.
Minor bug fix release.
Fixed problem with autoupdate that could result in IJC continually asking to be updated.
Fixed rare problem in building queries in relational data with OR operator
Minor bug fix release.
Marvin/JChem 5.3.8 are used. JChem tables will not be regenerated from 5.3.7 version.
Added ability to turn off auto-saving of form design in case of very large forms and/or slow databases. When done form must be manually saved.
BLOB column now promotable as text field on Derby and Oracle.
Improved import of structure name files that do not have .name extension.
Minor bug fix release.
Marvin/JChem 5.3.7 are used. JChem tables will not be regenerated from 5.3.6 version.
"No data" message removed from widgets when no row is present, as this was confusing some users. The consequence is that there is now no way to distinguish between a null value for a row and there being no rows.
Improvements in performance when retrieving data for child tables.
Improvements to shared project and Java Web Start installation.
API tutorials updated to current version of IJC.
API javadocs improved - new modules were added.
Improvements in formatting options for decimal numbers.
Better validation of table name length for JChem entities.
Warning on startup about different JChem cartridge version only shown to users with ROLE_EDIT_SCHEMA or ROLE_ADMIN roles.
Fixed problem with horizontal alignment setting for TextField widgets.
Fixed problem with blank structure column in grid view and form when using "Display as standardized" together with "View in 2D" option.
Fixed problem with data not being updated in views when standardizer is changed.
Minor bug fix release.
Marvin/JChem 5.3.6 are used. JChem tables will not be regenerated from 5.3.4 version, though some chemical terms columns may be recalculated.
Oracle: Faster hit list generation and possible improvements in startup time
Fixed problem with widget properties not being enabled when no rows were present
Fixed problem in schema editor where displayed column name was not updated when it was edited
Fixed problem where column width was sometimes reset for tables in forms
Disabled index creation for binary fields
Fixed problem when setting widget title to empty - setting was not saved
Form widgets have a minimum size to prevent them being resized to zero and becoming invisible
Fixed error during query execution when whole column in grid view was selected
Fixed problem caused by Oracle's flashback tables
Fixed problem when creating user defined reaction library (Forum topic).
Feature release.
Marvin/JChem 5.3.4 are used. Cache registration table needs adding for each JChem property table, but structure tables will not need regeneration from IJC 5.3.1.
There was no IJC release between 5.3.1 and 5.3.4.
Updates are available through autoupdate and Java Web Start. Installer is also available.
Support for multiple database schemas for Oracle.
List management can use fields other than the ID field.
Improved paste of lists of values into query for 'In list' and 'Not it list' operators.
Delete database artifacts checkbox is now unchecked by default and remembers your last setting to reduce risk of deleting tables in database by mistake.
Regenerating JChem tables requires ROLE_ADMIN and ROLE_EDIT_SCHEMA whereas previously it needed either of these roles. This makes it easier to restrict who can upgrade JChem tables.
Startup performance should be improved, especially for databases with lots of tables.
Better estimate of library size for large Markush libraries. Estimate is displayed as exponent of 10 rather than 2. e.g. 10^17.
Added command-line option to turn off initial data retrieval for scenario where very large tables or slow databases are used.
Improved installer that separates out installation of the .Net components as a separate sub-installer (on Windows only)
Import
Fixed problem importing structures to standard tables (Forum topic).
Fixed problem with setting default values during import.
Fix problem importing into entity containing dynamic URL fields.
Fixed problem with some errors terminating overlap analysis (Forum topic).
Sort of mol formula field was not using the cd_sortable_formula column.
URL fields
Fix problem with URL field created always with default mime type.
URL Fields with ftp and https protocols now support authentication.
Updating CT expression didn't reload data in views.
Results were not updated correctly when queries were run in multi-user mode.
Printing now works correctly when disconnected from network.
Tables with JChem cartridge indexes can only be created in the default schema.
JChem table upgrading can only be performed for the default Oracle schema. If you are using additional schemas then these must be updated to JChem 5.3.4 external to IJC (e.g. using jcman).
Copy from grid view and paste into sketcher does not work. As a workaround view the structure in the popup view and copy it (Ctrl-C) from there and then paste.
Important: Upgrade process will not complete correctly if you have JChem table names that are longer than 24 characters. See this forum topic for details.
Feature release.
Marvin/JChem 5.3.1 are used. JChem tables will need regeneration from IJC 3.x.
You can upgrade from 3.x using the update center, but if you are on Windows and wanting to use OLE copy and paste or the improved EMF export features then you should uninstall and install the new version using the installer as these features will not be provided though autoupdate.
Support for tables using text based columns for their primary keys.
Support for project: URLs in URL fields allowing files to be located within the project and distributed to other users within a project zip file.
Introduced binary field type for storing things like images within the database.
Improved column manager providing easier ways to show/hide and re-order columns.
Added import of Thomson Reuters Markush DARC (*.vmn) files (single file only).
Convertor utility for Thomson Reuters Markush DARC (*.vmn) files allowing multiple files to be easily imported into an IJC Markush table.
Added ability to define tautomer duplicate filtering when creating JChem or cartridge tables
Default property table changed from JCHEMPROPERTIES to JChemProperties to be consistent with jchemmanager.
Column names in grid view column header can now span multiple lines to allow easier reading of long field names.
Various improvements/fixes to printing:
Fixed problem with field labels sometimes being missing.
Fixed problems printing multiple structures from text fields.
Number of decimal places settings is now used when printing.
Cartridge improvements:
Improvements/fixes for setting duplicate filtering and absolute stereo and standardizer settings.
Fixed problem with query structures over 4000 characters long when querying a varchar2 column.
User defined structure format now used for editing and inserting structures.
Fixed problem with scrolling in grid view when horizontal scrolling was sometimes reset to the left.
URL fields encode the URL correctly to avoid problems with "funny" characters.
Validation of column names improved: correct max column name lengths now used and columns that already exist in DB are not validated as they must be valid.
Fixed problem with very long popup menus overflowing screen size.
Hit alignment for Markush structures can be slow, resulting in slow scrolling in grid view after running a query. Workaround is to turn off hit alignment.
Data is not refreshed when a chemical terms expression is updated for a chemical terms field. Workaround is to use 'Data->Reload data' to force a refresh.
Minor bug fix release.
Marvin/JChem 5.2.6 are used. JChem tables will not be regenerated from earlier IJC 3.0.x versions.
Wrong schema icon in import into remote database
A few dialogs layout and user interface problems fixed mainly on Mac (connect to schema, table widget, progress dialog, add edge in datatree dialog, entity properties dialog in import)
Error when autoscale is turned off in Browser widget
Browser widget sometimes failed to display data
Some distinct values, empty structures and absolute stereo settings were not always applied when new jchem entity was created
Fixed problem applying standardizer to cartridge tables
Error when adding new row to a child table in a many-to-one relationship
Some issues with menu actions to open windows fixed.
Fixed problems with database explorer functionality
Some documentation improvements: a few screenshots updated in user documentation, cartridge admin page improved, and other minor fixes
Less logging into IJC log file, some formatting improved
Partial fix for Oracle databases when column default value is set to special values like SYSDATE
Fields in promote table dialog are sortable now
Error when disconnecting from schema after IJC startup
The 3.0.3 update center has been re-released as something was missing from the original. If you had already updated the update will happen again. This does not affect the Java Web Start version.
Bug fix release with important bug fix. All users should update.
Marvin/JChem 5.2.5 are used. JChem tables will not be regenerated from earlier IJC 3.0.x versions.
Fixed problem with IJC crash after enabling standardization and displaying Molecule widget (Forum topic)
Improved support for some column types fixing problems executing queries and creating fields.
Bug fix release with important bug fixes. All users should update.
Marvin/JChem 5.2.5 are used. JChem tables will not be regenerated from earlier IJC 3.0 versions.
Fixed problem handling large integer values (Forum topic)
Fixed problem promoting tables (Forum topic)
Minor bug fix release.
Marvin/JChem 5.2.5 are used. JChem tables will not be regenerated from earlier IJC 3.0.0 version.
Browser pane widget errors on click to hyperlinks
Browser pane widget errors when autoscale is turned off
Errors when running permanent queries
Potential freezing IJC on startup when shared projects was opened in previous session
Feature release
Marvin/JChem 5.2.5 are used. JChem tables should not need regenerating from version 2.5.3.
Derby database is updated to version 10.5.1.1. Local databases opened in IJC 3.0 can no longer be opened in older versions. If you want to test your local databases then make a copy of your project before you open it with IJC 3.0.
New field type for data external to IJC defined using a URL. The URL defines the location of documents that can be text, html, images, PDF, MS Office documents etc. URL can be statically or dynamically defined.
New widget for displaying images and html content. Primarily for use in conjunction with URL fields.
Much enhanced schema editor:
Data tree editor moved into schema editor.
Contents of explorer split into separate tabs to make navigation easier.
Made layout and names more consistent and more logical.
Provided more right-click options and toolbar actions.
Promote entity wizard now provides ability to promote fields, making promotion process much faster and easier.
Improved icons and graphics used throughout.
Added support for database views for non-structural data.
Controlling editability:
Added ability to restrict editing of values in an entity.
Added ability to restrict inserting new rows in an entity.
Added ability to restrict deleting rows in an entity.
Added ability to restrict editing of values in a field.
Add ability to define a SQL filter that acts as a row level filter on database tables (e.g. control access to compounds that are assigned to the project the user belongs to).
Improved printing:
Automatic scaling of forms to the paper size when form is too big.
Added support for n-up printing (printing multiple form records to a single page).
Improved structure renderer:
Added ability to use structure renderer for text columns containing structures (e.g. as smiles).
Added ability to display multiple structures as a matrix view (e.g. multiple smiles strings, each on a separate line).
Added support for reaction based enumeration using ChemAxon Reactor. Provides a simple way to perform reaction based enumeration in an IJC database.
Added additional similarity search metrics such as Tversky, Dice, Euclidian.
Provided warning when multiple users try to use local database at the same time.
Fixed error during printing
Fixed problem with printing relational data form
Fixed problem with display of Markush structures containing homology groups
Fixed problem with hit alignment and enumeration of aromatic Markush structures
Fixed problem merging data into JChem tables using Oracle cartridge index
Improved validation of values integer and decimal fields
Improved validation of values in "Between" queries
Fixed problem with being unable to import into an existing table with only read-only access rights.
Added support for wider range of data and time column types
Added support for wider range of numeric column types
Allowed merge of files that contain null values for the merge key (Forum topic)
Prevented merge of files using fields that do not support the equals operator as this was not correct and caused errors (Forum topic)
Fixed problem with using lower case table names in MySQL on Linux (table names are case sensitive).
Fixed various bugs that caused printing to fail. e.g. (Forum topic)
Minor bug fix release.
Marvin/JChem 5.2.4 are used. JChem tables will not be regenerated from earlier IJC 2.5.x versions.
Improved warning when project is located on shared disk and opened by more than one user at the same time
Fixed error during promote FK to relationship
Proxy server settings warning improved
New row dialog has combo box chooser for discrete values fields
Fixed potential error when promoting JChem table based on Oracle Cartridge
Minor bug fix release.
Marvin/JChem 5.2.3 are used. JChem tables will not be regenerated from earlier IJC 2.5.x versions.
Local DB (Derby) now supports creation of DECIMAL columns
Fixed problem with web proxy detection - sometimes appeared even when network was connected correctly
Fixed problem with wrong sorting of rows in detail tables after new search
Fixed problem with installation of Academic license
Added missing column types for MySQL: BIGINT was not recognised as valid column type for ID field. Some BLOB and BINARY columns not recognised
Fixed problems with Structure column/widget's colour scheme property (Forum topic)
Hot fix update for IJC 2.5.1
Fixed problem with module versions which prevented table regeneration working correctly.
Minor bug fix release.
Marvin/JChem 5.2.2 are used. JChem tables will not be regenerated from earlier IJC 2.5.x versions.
Some actions were not enabled in the project explorer context menu.
Fixed problem with list renderer when values were null.
Fixed problem when clicking outside widget in form did not cause widget to leave edit mode.
Major version release. This is a rollup of all the previous fixes and improvements since IJC 2.4 and includes a new installer to fix installer related problems on Windows Vista. This version is only available as a new installer or as the Java Web Start version. It is not available using autoupdate.
Marvin/JChem 5.2.1.1 are used. Some JChem tables will be regenerated.
Added ability to copy a view (form or grid view) from one data tree to another (Forum topic).
Query builder and Query as text windows are not shown by default. If you want to use these you can show them using the appropriate items in the Window menu.
Fixed problems with installer under Windows Vista which resulted in updates not being applied correctly.
Fixed problem with querying dates on some databases (Forum topic).
Fixed problem with database connection being randomly closed (Forum topic).
Fixed problems relating to accessing files on Windows using UNCs (Forum topic).
Fixed problem when column renderer in table could become null when value for multiple columns was set.
Fixed problem with chemical terms columns not being deleted from the database.
Fixed memory leak that could cause IJC to die when schema editor was used extensively.
MaxPermGen memory size increased to 120m to avoid potential out of memory errors. If running on 64 bit Java then this setting may need to be be increased further. Edit the etc/instantjchem.conf file to do this.
Minor bug fix release
Marvin/JChem 5.2 are used. JChem tables will not be regenerated from IJC 2.4.3.
Fixed problem deleting last column in grid view on Linux when using Java 1.6 (Forum topic).
Fixed bug preventing promotion of foreign key to relationship in some cases.
Location of promote foreign key button changed to be consistent with other promote buttons
Fixed problem the setting dates with new row dialog with certain locales (Forum topic).
Fixed problem with chemical terms expressions that use structure search not being enabled (Forum topic).
This is primarily a bug fix release
Marvin/JChem 5.2 are used. JChem tables will be regenerated.
Fixed error preventing printing (Forum topic).
Fixed problems with hit alignment sometimes failing with Markush table types.
Improvements to showing license errors during query execution.
Fix for problem when chem terms values were recalculated even if chem terms expression was not altered.
Added display option for showing/hiding R/S labels on atoms for structures (Forum topic).
Structure search names changed to be consistent with the new names used in JChem.
Added security configuration template for Microsoft Active Directory.
This is primarily a bug fix release
Marvin/JChem 5.1.5 are used. JChem tables will not be regenerated from IJC 2.4.
Fixed problems with converting field type not copying values correctly.
Improvements in handling NUMBER columns in Oracle:
Fixed problem creating number column with a non-zero scale component.
Number columns can be promoted to decimal number fields.
Fixed problems with validation of query values (e.g. for Between operator).
Fixed problem with hit alignment of Markush structures caused by 2.4.1 upgrade (Forum topic).
Fixed problem with temporary lists and queries not being created unless query builder was showing.
Fixed problem with structures not being correctly coloured when a chemical terms only search had been run.
Provide warning when proxy server settings may need attention.
Structure editor opens wider when editing reactions.
Fixed random exception that sometimes prevented a project being opened.
Improvements in display of some dialogs on Mac.
Fixed some problems with using date editor in query mode.
Improved promote foreign key function to allow creation of many-to-one relationship.
Fixed problems running using latest Java versions (e.g. 1.6.0_12).
This is primarily a bug fix release
Marvin/JChem 5.1.4 are used. JChem tables will not be regenerated from IJC 2.4.
Fixed problem restoring lists of more than 1000 IDs on Oracle.
Fixed problem writing errors file during import when location was specified using a UNC (Forum topic).
Fixed error that occurred when column size was edited when creating a field.
Fixed problems exporting data from entities in the schema editor (Forum topic).
Fixed problem with converting structures to 2D in import not working (Forum topic).
Introduced a maximum number of deleted rows before undo operation is disabled (too high a value caused excessive memory consumption due to the need to support undo). Limit is 1000.
Added missing project related actions to File menu and projects window context menu.
Fixed problem with search by selected value opening structure editor.
Fixed problem with Command key on Mac switching table cell to edit mode
Added missing support for CHAR columns on Oracle
JWS clears out old IJC installation files before updating to new ones.
Fixed problem with Markush tables when Markush license has been removed or become invalid.
Feature release. This release is almost entirely focused on usability issues based on user feedback.
Marvin/JChem 5.1.3 are used. JChem tables will be regenerated.
Support for JChem cartridge on Oracle.
Create JChemBase table with cartridge index on cd_structure column.
Create standard table with cartridge index on column with structures.
Promote existing cartridge tables in the database into IJC.
Support for different table types, standardizer and chemical terms columns.
File import.
Support for import of chemical names using Name2Structure calculator plugin
Better determination of whether text files contain structures
Better determination of JChem table type based on the types of structures found (Forum topic).
Better determination of data field type where empty values were encountered.
Changed name normalisation so that fields are always recognised if the file (or similar file) is re-imported into the same entity.
File import action made less sensitive to context to avoid the risk of importing data into an existing entity by mistake. If wanting to import into an existing entity this must be explicitly specified using the r-click action on the node in the project explorer. Otherwise file is always imported into a new entity.
Parsing for field detection can be cancelled.
Import into existing entity now possible without ROLE_EDIT_SCHEMA rights (new fields cannot be created).
File export.
Added support for export in smarts format.
Added support for exporting relational data to flat file formats (SDF, Excel...).
Printing.
Improved print quality using Jasper Reports print engine.
Print preview
Allow footers and headers to be specified.
Print to PDF.
Grid view
Discontinuous selection intervals now possible.
Added ability to auto-estimate the best column widths to use.
Added popup menu to row header to allow adding and deleting rows.
Design mode display is now more consistent with browse mode settings.
Multi-line text display improved.
Form view
Added warnings when innapropriate widgets were used and would result in not all data being displayed.
Widget right-click menu options improved.
Added horizontal alignment to widget display options.
Added ability to horizontally align multiple widgets.
Widgets can be selected using Tab key.
Query
Better support for 'between' queries for dates.
Date picker tool added to query builder.
Added progress dialog during data retrieval so that you don't have to wait for all IDs to load for very large tables.
Query as text window shows structures as (cx)smiles or (cx)smarts as is most appropriate for the search type (Forum topic).
List and Query management
Added ability to add/remove a list to/from the current result set
Added data tree selector to Lists & queries window to make it easier to see lists and queries from other data trees.
Added ability to create new list and define the contents for this list.
Project explorer.
Created 'single project mode' where a simplified representation of the projects tree is displayed when only a single project is open.
Added default option to close current project when opening a new one so that you stay in single project mode.
Added option to 'autoconnect' to a schema when IJC is opened.
Added ability to clean up all unused related artifacts when a data tree is deleted.
Simple Federated Search (SFS).
Moved SFS window to main window and improved layout.
SFS window can be specified as start page.
Added ability to collate all SFS results into a new data set.
UI/Usability.
Added option to define a default start page. Specified page can be Welcome screen, Simple Federated search or any view (form or grid view). Option to open this start page maximised.
Added 'Remember this decision' option in many places.
Added keyboard shortcuts for switching mode in form and grid view (Ctrl-1, Ctrl-2, Ctrl-3).
Warnings added on startup when licenses have expired or are about to expire.
Convert type can now be used to create a copy a field of the same type.
Improved performance when using Copy & Paste for large numbers of cells (Forum topic).
Added more data flavours when copying single structures from grid and form view so that they paste better.
Other.
Many bugs have been fixed, including:
Removed problems related to project contents using absolute file paths.
Fixed problems with temporary list and queries not being created if data from the data tree had not yet been opened.
Improved hit alignment performance for Markush structures.
Fixed problems during file import with empty values causing the automatic detection of the best field type to fail.
Fixed problem with slow scrolling in grid view when 2D structures needed to be generated.
Fixed some problems inserting and deleting rows in detail tables for relational data.
Fixed problem with adding detail table when master table contained data.
Fixed problem using a file url for shared projects (Forum topic).
Fixed problem deploying license file when chemaxon dir did not exist (Forum topic).
This is primarily a bug fix release
Marvin/JChem 5.0.3 are used. This is unchanged from 2.3
Overlap analysis: The outputted field can be specified.
Overlap analysis: Option added to turn off writing hits to console during (Forum topic).
Added action to main toolbar to reset windows (this was present in Windows menu too).
Chemical Terms: Hint about code assist feature added to chemical terms editor
IJC URLs: Generate URL dialog now only allows creation of URLs for shared databases in shared projects.
Fixed problem exporting to Excel where sheet name contained illegal characters or was too long
Fixed problem with empty strings not being accepted as values for float fields (they are converted to null).
Fixed problem with copying multi-line text in grid view (Forum topic).
When switching to query mode first used field gets focus.
Corrected wrong license file location property in JNLP file. It should be chemaxon.license.url not ijc.license.url.
License manager window now has Close button, not OK/Cancel.
Fixed problem with hit highlighting when structure was in detail entity and displayed using structure widget.
Query actions sometimes became disabled.
Apply list and query actions sometimes became disabled.
Chemical terms expression is validated during federated search.
Fixed problems with data in grid view sometimes not displaying when scrolling.
Fixed rare exception when hiding columns in grid view.
Fixed problem with boolean columns in grid view sometimes becoming not editable.
Changed misleading warning message when no standardizer license is present.
Fixed problem with progress going immediately to 100% during import of text files.
Fixed problem cancelling chemical terms queries.
Fixed problems renaming lists and queries.
Fixed exception that occurred when with searches with Ignore operator (Forum topic).
Fixed rare exception when editing values and typing too fast!
Fixed problem when editing values where change was made in DB but old value was sometimes still displayed.
Direct editing of values in fields that are used in relationships is disabled.
Correct JChem table type selected after parsing completes during import.
Fixed problem with branding index page for Java Web Start version.
Deleting project now deletes the files properly.
Excluded null as an option when editing boolean fields which require a value
Fixed potential problem with query when wrong results could be returned
Fixed exception that occurred when in query builder when deleting elements
Fixed exception that occurred when typing in URL when opening shared project
Feature release
Marvin/JChem 5.0.3 are used. JChem tables will be regenerated.
Marvin/JChem 5 related features
Marvin User interfaces are updated.
New license system is used. Request updated license file if you do not already have one.
Code assist for chemical terms expressions.
Query and Markush JChem table types are supported
Markush enumeration added.
Structure file import now uses Marvin record parsing interface.
Hit highlighting now uses JChem chemaxon.util.HitDisplayTool class.
Hit alignment enabled for superstructure searches.
JChem search options now uses chemaxon.sss.search.JChemSearchOptions class.
Mol Formula field is sorted using the new cd_sortable_formula column.
New features
Shared project deployment.
License file can be centrally deployed.
IJC URLs allow you to send a link that opens IJC and shows the view + list/query.
Schema Editor: Promote foreign key to relationship.
Form builder: WBLabel widget allowing static text to be put an a form.
Other improvements
Additional standardizer templates provided.
Query as text window indicates whether current query has been executed.
Overlap analysis writes matching IDs to the report.
Changed the order for chemical terms favourites. The new order is: FLOAT, TEXT, INT, BOOLEAN
Oracle driver updated to 11g driver (version 11.1.0.6.0)
Derby database version updated to 10.3.2.1
Removed dependency on java.awt.Robot class when resizing rows in grid view (Forum topic).
Option to not show Welcome screen on startup
Column names also checked for name matches during file import (Forum topic).
User asked whether to save view when shared view is first modified.
Table names restricted to proper tables (synonyms, views etc. not listed).
Show/hide R-group definitions property for Marvin renderer.
JChem tables are created as InnoDB types on MySQL. InnoDB no longer has to be the default table type.
Improved consistency between query builder and form based query
Remember username/password checkboxes stay sticky when schema is manually disconnected.
Better handling of undo queue for MSketchPane
Workaround for Oracle returning illegal JDBC column types (Forum topic).
Fix for problem for Oracle JDBC metadata where TIMESTAMP columns were being reported as TIMESTAMP(6) (the brackets and size should not be present).
Uninitialized views are closed when connection is closed.
Fixed problems with setting default fingerprint settings for each JChem table type.
Fixed problem with some queries when there were more than 2 levels of hierarchy.
Fixed problems with some Marvin popup windows.
Bug fix release
JChem 3.2.12 and Marvin 4.1.14 are used. This is unchanged from 2.2.0.
Boolean field is queryable in form based query
Boolean field null state handled better in browse mode
Queries for boolean field = false no longer return rows where values are null
Date field is queryable in form based query
Date formats handled in more consistent format throughout IJC (Forum topic)
Improvements to editing date fields
Text array fields exported correctly in Excel export
Fixed bug preventing new rows being added in multi-user mode (Forum topic)
Less confusing error message when setting a duplicate structure
Improved formatting of float fields during display and editing
List is applied with entries in correct order
Printed forms are prettier
Improvement to layout of some dialogs on Mac
Fixed various memory leaks
Fixed problems reordering columns under Java 1.6 (Forum topic)
Name in border can be changed for tables in forms (Forum topic)
RDF import is more tolerant of bad entries
Fixed performance regression in overlap analysis (Forum topic)
Fixed potential issue with database connections that were idle for long periods
Fixed problem with tab separated format text file import with empty values
Fixed problem with query by example not being enabled for fields from detail tables
Fixed problem with editing queries following federated search
Fixed problems with project groups (Forum topic)
Fixed problem with export where all records were sometimes exported, not current result set
View toolbar rearranged by relocating some global actions to main toolbar
Fixed problem with pasting multiple values causing multiple screen refreshes
Fixed problem with windows opened by Marvin Sketch remaining open after sketch closes. These windows are now closed when the sketch closes
Fixed problem with queries not being cancellable
Fixed potential problem when creating new entity or field fails
Fixed problems with export to excel (Forum topic)
Autoupdate upgrade to allow upgrade to 2.2.1
Feature release
JChem 3.2.12 and Marvin 4.1.14 are used. JChem tables will be regenerated.
Query
Form based query
Added Starts with, Ends with and Contains operators for text fields
Query panel re-worked to simplify query builder and make it work in conjunction with form based query
Structure can be directly pasted into empty structure query widget
Added federated search feature allowing structure searches to be run across multiple data trees
Security
Support for authentication using LDAP
Added ability to ROLE_ADMIN to log out a user (Forum topic)
Users can be added/deleted/modified from multi-user mode
File export
Option to generate missing coordinates during SDF, MRV... export
Export to Excel format (structures included as images)
Standard import
Records with errors are written to a file
Duplicate records are written to a file
RDF import
Improved auto-determination of field types and sizes
Mechanism added to prevent naming conflicts
Records with errors are written to a file
Java Web Start
Startup performance improved during reading of information from DatabaseMetaData
Form printing
Views (form and grid view), queries and lists are directly sharable, allowing all users to see a standard set of forms
Description attribute added for things like entity, data tree etc.
General improvements to relational data management
Added ability to refresh data (e.g. if a different user has edited values)
Fixed problem with Integer values specified using scientific notation being handled as decimal numbers
Unrestricted searched permitted in remote databases
Clean2D done before passing structure to Marvin for display in form or grid view (forum topic)
Fixed some problems in relationship creation
Fixed problems with copy & paste and export of Text Array fields
Fixed problem dropping IJC tables from database
Fixed problem recognising some boolean chemical terms functions
Fixed error preventing clearing data in grid view
Many-to-many relationships now prevent duplicate values in join table
Fixed problem clearing molecules (forum topic)
Fixed problems with reported statistics during import (forum topic)
Form printing limited to single record at a time
Printed forms are not very beautiful
Progress finishes at 99% (bug in NetBeans library)
Boolean and Date fields are not queryable in form based query
Error message when setting a duplicate structure is misleading
Bug fix release
JChem 3.2.11 and Marvin 4.1.13 are used. This is unchanged from 2.1
Feature release
JChem 3.2.11 and Marvin 4.1.13 are used. JChem tables will be regenerated.
Query management feature added
List management feature added
Query by example feature added
Queries can be restricted to a particular list (search domain)
Goto row feature added in grid and form views
Option to encrypt database connection details
Import and export of InChI format structures
Added additional Marvin display options for structures
Added option to strip quotes from data during import of text files
IJC can now run using Java 1.6.
Notification icon when updates are available
Improvements to wrapping of multi-line text display
Removed limit of deleting more than 1000 rows
Perfect search options work correctly
Fixed problem on Oracle with queries not working when data was sorted
Query widget borders now visible on Mac
Entity deletion in Oracle now more fault tolerant
Fixed problem with Oracle reporting wrong max size for CLOB columns
Cursor changes when re-sizing form widgets in design mode
Missing show user list action restored
Fixed problems with windows opened by Marvin Sketch e.g. calculator plugin windows
Bug fix release
JChem 3.2.10 and Marvin 4.1.12 are used. This is unchanged from 2.0.1.
Bug fix release
JChem 3.2.10 and Marvin 4.1.12 are used. JChem tables will be regenerated.
Fix bugs preventing multi user access with read-only access.
Fixed wrong expression for TPSA chemical terms favourite.
Fix for query panel occasionally throwing exception when query being reinstated.
Fixed problem with parser properties not being displayed during import.
IJC will run on Java 1.6.
Fixed problem with wrong number of records being reported during import.
Public release
Patched version of JChem 3.2.9 and Marvin 4.1.11 are used
Fixed problems with nbm files on update center not being recognised as signed by ChemAxon certificate.
Changes to Welcome screen
Fixed problem with failures with Chemical terms calculations in Derby database
Private beta release
JChem 3.2.9 and patched version of Marvin 4.1.11 are used. JChem tables will need regenerating.
Improvements to relational data handling:
Row insert and delete for many-to-many relationships
Add a simplified process for creating a detail entity
Improved enabling the add and delete row actions depending on context
Fixes to relationship creation and display
Fixes to data retrieval for many-to-many relationships when fields are not the ID fields
Fixed problems with unique index creation
Improved ability to execute some complex advanced queries
Structure queries can be part of an OR expression
Multiple structure queries can be specified
Improved descriptions and messages when clearing data in grid view
Fixed problems with focus handling making editing form contents difficult
Fixed problems with large structures in Oracle JChem tables
Minor import and merge improvements
Fixed problem in query when Marvin Sketch was close with More window open
Fixed problem pasting multi-line text
Fixed problem on Windows with options not being able to find the instantjchem.conf file
Updated user guides
Public beta release
JChem 3.2.7 and patched version of Marvin 4.1.9 are used. JChem tables will need regenerating.
Various form builder usability improvements.
Chemical terms favourites can be edited
More complete version info now present in About box
NetBeans platform updated to 6.0. Major changes include:
Autoupdate UI changed (now Tools -> Plugins)
User settings editor improved
Query:
Query UI and implementation re-written
Hit alignment bugs fixed
Return non-hits for structure query
Standard and Advanced query modes
Relational query now possible
AND and OR queries now possible
Schema Editor enhancements:
Index management
Improved handling of Relationships
Promote standard table now works
Sequence definition for standard Oracle tables
Minor improvements to RDF import
Various UI and usability improvements
Better support for dates
Better support for list fields
Improvements to multi-threaded database connections
Improvements to Undo/Redo support
Extensibility improvements:
Not all advanced queries that can be built will execute:
Marvin Sketch panel does not appear correctly in standardizer editor when used for defining standardizer for a JChem table
Marvin Sketch and Standardizer editors are slow to load
Problems are seen with modal Marvin calculator plugin windows on some platforms
Some aspects of many-to-many relationships are not yet working
Hot fix update for IJC 2.0M3
JChem 3.2.5 and Marvin 4.1.7 are used (this is unchanged from M3a).
Fixed problem with data retrieval with Relationships where the field was not the primary key column.
Hot fix update for IJC 2.0M3
JChem 3.2.5 and Marvin 4.1.7 are used (this is unchanged from M3a).
Better error tolerance and error reporting when initializing IJC schema.
Added ignore directive to RDF import template.
Hot fix update for IJC 2.0M3
JChem 3.2.5 and Marvin 4.1.7 are used (this is unchanged from M3a).
Problem with scrolling "out of range" in a table causing inconsistency between row header and main table fixed.
Export to file now works in multi-user mode.
Sketcher remembers last drawn structure if it has nothing better to display.
Option to reload results when data is imported into existing table.
Fixed discrepancy in number of rows reported at end of import.
Hot fix update for IJC 2.0M3
JChem 3.2.5 and Marvin 4.1.7 are used (this is unchanged from M3a).
Fixed problem with hit highlighting and alignment.
Fixed problem with display not always updating after chemical terms calculation.
Optimum separator is selected when parsing text file.
Improved error reporting during RDF import.
Fixed problem when structures without coordinates are opened in sketcher.
Hot fix update for IJC 2.0M3
JChem 3.2.5 and Marvin 4.1.7 are used (this is unchanged from M3a)
Fixed problem with graph library version when updating from 2.0M2
Hot fix update for IJC 2.0M3
JChem 3.2.5 and Marvin 4.1.7 are used (this is unchanged from M3a)
RDF import improvements:
Empty structures are allowed.
Fixed memory leak preventing import of large files.
Better handling of Cancel and Finish buttons in wizard.
Improved progress notification.
Hot fix update for IJC 2.0M3
JChem 3.2.5 and Marvin 4.1.7 are used. JChem table regeneration is required.
New features:
Copy form from other user.
Clone form.
Template based import now supports SDF files as well as RDF.
IUPAC name added as chemical terms expression favourite.
Improved documentation.
Bugs fixed:
Marvin update fixes infinite loop problem when parsing some files.
"Unsupported file format" problem for non-structure files solved.
Hit alignment now works in grid view.
Improved layout of demo project for Windows.
Fixed potential problem with lower case table names.
Improved editing of checkbox widget.
Known issues and limitations:
Many-to-many relationships are not supported.
Schema Editor lacks management of indexes.
Limited support for editing relational data.
Performance needs optimising in some areas.
Problems exist with views not updating when data is changed (e.g. during import/merge).
Some threading issues when updating and reading data need resolving.
Second public preview (alpha) release of IJC 2.0
JChem 3.2.4 and Marvin 4.1.6 are used. JChem table regeneration is required.
New features:
Form builder.
Relational data.
RDF import prototype.
Improved schema editor.
Data Tree editor.
Improved user documentation.
Initial developer documentation.
Known issues and limitations:
First public preview (alpha) release of IJC 2.0
New features:
JChem version updated to 3.2.3. This upgrade requires jchem tables to be regenerated which will happen when you first connect to the database. You will be asked to confirm you want the regeneration to proceed. Please backup your data first if it contains important information that you cannot easy re-create.
Bugs fixed
Fixed problem with display of overlap analysis results.
Improved editing of multi-line text fields.
Know issues
Improved support for non-english languages (including non-western languages)
Added ability to specify file encoding for file import and export (e.g. for reading files containing Japanese text).
Improved validation of file names
Minor documentation updates
Bugs fixed
Better performance for chem terms calculations and table regeneration on multi-cpu/core machines.
Right-click popup menu in grid view providing view, edit and copy & paste functions.
Minor documentation updates
Improvements to copy & paste
Bugs fixed
Bugs fixed
Bugs fixed
Fixed occasional problem with viewing data in grid view (NullPointerException).
Fixed alignment problem in Welcome screen when viewed at narrow size.
Possible safe fix for un-reproducible bug report in grid view where data was being requested for row that didn't exist.
Fixed problem importing of some types of reaction files.
Fixed problem with structure file viewer not displaying the correct number of structures
Fixed problems with files not being released during import and export
Changed user dir to ijc_1_0 to prevent possible conflict with pevious updates from Update Center
Removed r-click popup from structure editor panel in grid view
Bugs fixed
Fixed occasional problem with queries not being executed and Show All button not functioning.
Fixed problem restoring Chem Terms filter in query panel when no structure is specified
Fixed problem with grid view not updating
Fixed problem with row count being one too many after import
Fixed problem with not being able to close standardizer editor when changes were present
Hit alignment now supports link groups
Delete row in grid view now prompts for whether to delete row from db.
Text values truncated during import when too long for column size.
Message presented to user when opening HSQL database.
IJC license will be found if located in Marvin licenses.dat file.
Improved import performance.
Documentation updates.
Query structures displayed without implicit hydrogens.
All modules use the same EULA, which refers to 3rd party libraries and licenses.
IN LIST queries added for integer and text fields.
Bugs fixed
UpdateHandler closed immediately following import
Cell selection for 2D structures in grid view now works properly
Adding row in grid view now scrolls to correct row
Disabled sorting of structure fields
StandardizeForDisplay now uses default standardization when none is specified.
Changing StandardizeForDisplay setting now updates structure display immediately.
Workaround for problem with My Documents directory appearing read-only on Windows XP
Fixed bug resulting in creation of local database files when using remote database.
Fixed bug with missing values in standard import.
Fixed bug with default values for non-text fields in standard import.
Fixed bug with merging with delineated text files.
Fixed bug with updating date fields in some database types.
Fixed bug with date editor in grid view
Fixed rare startup deadlock when table editor was open and HSQL database had been shutdown incorrectly.
Fixed problem setting default values and required status of fields with Derby databases
Derby in now local database for new projects resulting in improved performance for large data sets
Adding fields is much faster
Shutdown is much faster
Restart after improper shutdown is much faster
Added JChem tables types which are present in JChem 3.2
Improvements to display of 3D structures in grid view
Hit highlighting and alignment for 3D structures
Improved usability of editing structures in grid view
Explicit hydrogens not displayed in query panel
Improved documentation for grid view display settings
Improved documentation for query
Improved documentation for memory management
Added documentation about Derby and HSQL based projects
Faster loading of entity editor by lazy loading of standardizer editor
Quick import is cancellable
CLogP renamed to LogP in Chemical Terms favourites
Chemical Terms editor now available in query panel
Java memory settings can now be specified using Tools -> Options
Bugs fixed
Fixed problem importing files greater than 2GB in size.
Fixed problem with grid lines not being displayed in grid view on Mac
Chem Terms fields excluded from fields displayed in Add Row dialog in grid view
Chemical terms filters can now be run without a structure query
Queries are cancellable
Improved management of favourites in Chemical Terms editor
Field type/editability indicators removed from grid view column headers
3D structures can be displayed as 2D without converting permanently to 2D
Editing structures in grid view now more consistent with editing other data types
Improved documentation on license keys
Various bugs fixed
The JChem version used is the jchemTEST_2006_08_17 build
Added chemical terms filter to query
Various bugs fixed
The JChem version used is the jchemTEST_2006_08_17 build
Welcome screen
Quick import wizard
Merge data during import
Standardizer editor
Overlap analysis to compare 2 databases for identical or similar structures
Improved structure search options
Copy & Paste and Undo in grid view
Find function in grid view
Improved performance for large data sets
The JChem version used is the jchemTEST_2006_08_17 build
Added row height zooming in grid view.
Added possibility for horizontal scrolling in grid view.
Added ability to delete field directly form grid view.
Added chemical terms fields based on JChem chemical terms columns.
Added ability to standardize structure files using standardizer files.
Native molecule format used in import where possible.
Grid view can be printed.
Added Exact Fragment structure search mode.
Creating entity from existing table now adds fields for all column types that IJC understands.
Grid view only asks for data when view is shown.
Improved notification on progress during field adding/editing.
Better validation during file import.
Better error recovery when database cannot be connected etc.
Bugs fixed
Structure support module providing basic support for viewing structure files
Various UI changes to improve usability
Standardizer license detection now works
IJC license required for connecting to remote databases
Major documentation update
Added new project template with sample data
Passwords for remote databases not stored
Bugs fixed
This is a beta release ready for the ChemAxon UGM
Create entity from existing JChem table
Project template with local db
Bugs fixed
Grid view and results now synchronised with changes in the table editor
JChem tables updated when new version of JChem is found
jchem.jar updated to latest development build
Table editor enhancements
Icons for adding fields
Standardizer tab now displays warning about needing a standardizer license
Grid view enhancements
Column header now displays sort info on second line
Selected rows now highlight
Oracle separated as a separate module to enable licensing
Restricted to local database only unless IJC license key is entered (any text will do currently)
HSQL local database searches run unrestricted
Sort directives now retained when a new query is executed
ChemAxon update center URL set to http://www.chemaxon.com/jchem/ijc/updatecenter/updates.xml (update center does not yet exist)
Added link to IJC forum in Help menu
Improved validation when editing and creating various artifacts
Added ability to display structures in standardized form
Bugs fixed
File import enhancements
Added create new table from file capability
Added RDF format
Progress bar shows actual progress
Field type can be chosen during import
Grid view can be opened after import to display data
File export enhancements
Added RDF format
Fixed problem with exporting MRV format
Import and export are global actions in main toolbar and file menu.
Reworked project explorer nodes and editors according to discussions in Budapest
DataTree now displays the table it represents
Grid view opens as default action (double click) on a table node
Transparent support for embedded HSQL database
Ability to define license keys as options. These are used as defaults when creating new JChemProperties table.
Hit highlighting colours configurable as options.
Similarity threshold disabled unless similarity search selected.
More context sensitive help in wizards
Tooltips in table toolbar
JChem table editor uses tabbed view - expert features not displayed unless needed
Added settings for ChemAxon update center. Removed NetBeans update centers
Table settings are persistent.
Enhancements to schema editor
Most field and column properties are editable, where appropriate
Convert field function (e.g text -> integer)
Export to file
Boolean and date field types
Hit alignment and substructure highlighting
Improved documentation
Major enhancements to the table viewer.
Configurable renderer types for all fields
Marvin display options
Multi-line text fields
Alignment, colours, fonts etc.
Configurable row height and column widths.
Show/hide columns
Cell editing, row addition/deletion
Cached result set, allowing all data in large table to be viewed
Querying and sorting reworked to use cached result set
Sort manager dialog allows multi column sorting
Performance excellent for thousands of rows
Performance reasonable for 10's of thousands of rows (depending on database speed/location)
Application almost completely localized. English only current language.
Minor enhancements/bugfixes to schema editor
Reworked Getting Started Guide (available from the Help menu)
Enhanced schema editor.
Element properties are displayed when selected from the explorer.
Initial editing of some element properties. More work is needed to make all the properties editable.
New project wizard now operational
Standard entities are now supported, in addition to JChemBase entities
JChemProperties table can now be created when a new schema is created. license keys can be specified.
Enhancements to file import
CSV and TAB separated files now supported
Additional import options available
Ability to specify default values
Improved user interface
Improvements to import performance
Improvements to datasource configuration and management
Some unnecessary menu and toolbar items have been removed.
There are sensible items in the Help menu and the basics of a help system are in place.
Clarification/definition of key concepts/terms, and major refactoring to accommodate this.
Schema
Entity
Property Category
Field
Support for the key IJC use case
Creating a new IJC Entity
Importing an SD file into it
Adding/creating Fields
Viewing the data in a table
Executing queries on the data.
SD file import capabilities
Major refactoring of the DataLoader and DataObjects used in the Project Explorer
Major refactoring and clean up of the DIF tier
Options/settings/L&F made to match those of jcman as far as it possible.
The version of JChem used is 3.1. New option in RDF import wizard. Radio buttons "Delete existing data" (this was default behavior in previous versions) and "Keep existing data" (new option - appends new data to existing records). "Delete existing data" (truncate) is the default option.