Instant JChem Changelog

What's new in Instant JChem 17.24.0

Oct 23, 2017
  • 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)

New in Instant JChem 17.23.0 (Oct 2, 2017)

  • 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)

New in Instant JChem 17.22.0 (Sep 25, 2017)

  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 17.20.0 (Sep 5, 2017)

  • Improvements and bugs fixed
  • 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)

New in Instant JChem 17.17.0 (Aug 9, 2017)

  • 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.

New in Instant JChem 17.16.0 (Jul 27, 2017)

  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 17.13.0 (Jul 22, 2017)

  • Improvements and bugs fixed:
  • Bundled Java in installers is back to normal.
  • Installers that bundle Java are available for download again

New in Instant JChem 17.1.16.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 17.1.9.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • Fixed disabled value editing in sheet widgets. (IJC-10200)

New in Instant JChem 17.1.2.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • A new option "Frozen Column Count" was added to table widget (and grid view) properties. It allows to specify number of "frozen" columns locked out from horizontal scrolling. These columns are the most left columns in the table or grid view and they are always visible. (IJC-402)

New in Instant JChem 16.12.26.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 16.12.5.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 16.11.14.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • Fixed setting and retrieving of horizontal alignment property for widget renderers. (IJC-10131)

New in Instant JChem 16.11.7.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • Users with the ROLE_EXPORT_DATA can now export data from Instant JChem directly into Plexus Analysis. The documentation on this feature can be found here. (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)

New in Instant JChem 16.10.31.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 16.10.24.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 16.10.17.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 16.10.3.0 (Feb 17, 2017)

  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 16.9.12.0 (Feb 17, 2017)

  • 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.
  • Improvements and bugs fixed:
  • Rare IllegalStateException Window System API is required to be called from AWT thread only exception fixed. (IJC-9945)

New in Instant JChem 16.9.5.0 (Feb 17, 2017)

  • Marvin/JChem 16.9.5.0 are used. IJC metadata will not be regenerated from previous version.
  • Improvements and bugs fixed:
  • Fixed a problem with loading db view based entities during the schema initialization. This affected MiniReg application as well. (IJC-9839)

New in Instant JChem 16.8.15.0 (Feb 17, 2017)

  • 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.
  • Improvements and bugs fixed:
  • Fixed conditional formatting on MolMatrix multiple extra fields (IJC-9836)

New in Instant JChem 16.8.8.0 (Feb 17, 2017)

  • 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.
  • Improvements and bugs fixed:
  • 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)

New in Instant JChem 16.8.1.0 (Feb 17, 2017)

  • 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
  • Improvements and bugs fixed:
  • Fixed a Null Pointer Exception error appearing at first start up or scrolling of a Mol Matrix widget (IJC-9873)

New in Instant JChem 16.7.25.0 (Feb 17, 2017)

  • 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
  • Improvements and bugs fixed:
  • Added a possibility to toggle displaying of of all data or only relevant data in entities in convergent relationships to parent entity. More details in documentation here. (IJC-9726)

New in Instant JChem 16.7.18.0 (Jul 26, 2016)

  • Improvements and bugs fixed:
  • Japanese characters are now printed correctly even when in header.
  • 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.
  • Fixed OR queries for mol weight and formula for cartridge structure tables.
  • Added support for multiple extra fields in MolMatrix widget.
  • Large customizers in Schema Editor use scrollbars to make sure that 'Apply' and 'Discard' buttons are always visible.
  • Fixed a problem with Defaulf Sort Field wizard's Ascending/Descending sort buttons.
  • The 'beforeEdit' and 'afterEdit' scripts are correctly called from 'Delete' or 'Cut' action.
  • 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.
  • It is now possible to download the documents from OracleDB via WebBrowserWidget.
  • '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.

New in Instant JChem 16.5.30.0 (Jul 26, 2016)

  • Improvements and bugs fixed:
  • 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.
  • Copy and Cut actions re-enabled on widgets in design mode - regression from IJC 16.3.7.0.

New in Instant JChem 16.5.23.0 (Jul 26, 2016)

  • Improvements and bugs fixed:
  • IJC/Plexus can optionally use a shared pool of connections to a database for all IJC schemas that it opens from the same database schema.

New in Instant JChem 16.5.16.0 (Jul 26, 2016)

  • Improvements and bugs fixed:
  • Introduced support for multiple default sort fields for an entity.

New in Instant JChem 16.5.2.0 (Jul 26, 2016)

  • Improvements and bugs fixed:
  • Fixed issue in M:N data retrieval for certain circumstances.
  • Improvements in loading large amount of data from Oracle.
  • Use java.lang.Double for floating-point numbers by default.

New in Instant JChem 16.4.25.0 (Jul 26, 2016)

  • Improvements and bugs fixed:
  • Fixed a bug that prevented creation of binary fields.

New in Instant JChem 16.4.18.0 (Jul 26, 2016)

  • Improvements and bugs fixed:
  • Fixed a problem when running a search on Oracle on a field bound to BINARY_DOUBLE or BINARY_FLOAT column.
  • Default values are offered also in user mode, not only in admin mode.

New in Instant JChem 16.4.4.0 (Jul 26, 2016)

  • Improvements and bugs fixed:
  • A small improvement in Admin Tool notification messages.

New in Instant JChem 16.3.28.0 (Jul 26, 2016)

  • Improvements and bugs fixed:
  • Selection synchronization in Molecule Matrix widget fixed.
  • IllegalStateException when closing views during schema init fixed.

New in Instant JChem 6.3.1 (Jul 1, 2014)

  • New Features or Improvements:
  • 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
  • Bugs fixed:
  • Fixed bug with editing problem of multi line labels
  • Printing is not allowed when query is running
  • 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 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 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

New in Instant JChem 6.3.0 (Jun 2, 2014)

  • New features:
  • 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.
  • Bugs fixed:
  • 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.

New in Instant JChem 6.2.3 (May 13, 2014)

  • Marvin/JChem 6.2.3 are used. JChem tables and IJC metadata will be regenerated from 6.2 versions.
  • New features:
  • Connections from Schema editor are automatically added to the Admin Tool
  • Bugs fixed:
  • Fixed a problem during synthetising JCB TableSetInfo based on database view

New in Instant JChem 6.2.0 (Feb 3, 2014)

  • Marvin/JChem 6.2 are used. IJC and JChem tables will be regenerated from the 6.1.x versions.
  • New Features or Improvements:
  • 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"
  • Added support for Spotfire 5.5
  • Bugs fixed:
  • 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

New in Instant JChem 6.1.7 (Feb 3, 2014)

  • Patch release:
  • Marvin/JChem 6.1.7 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
  • Fixed a problem with Java Web Start version of IJC not running on latest Java 1.7.0_51 update

New in Instant JChem 6.1.6 (Feb 3, 2014)

  • Patch release:
  • Marvin/JChem 6.1.6 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
  • Bugs fixed:
  • Fixed a problem when stopping a non structure query caused an error.

New in Instant JChem 6.1.5 (Feb 3, 2014)

  • Patch release:
  • Marvin/JChem 6.1.5 are used. JChem tables and IJC metadata will be regenerated from the 6.1 version.
  • Bugs fixed:
  • Optimalized performance of SQL metadata handling
  • Fixed randomly appearing error after startup

New in Instant JChem 6.1.4 (Dec 30, 2013)

  • Bugs fixed:
  • 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.

New in Instant JChem 6.1.3 (Nov 8, 2013)

  • Fixed issues with "Save copy" and "Closing unsaved view" dialogs
  • Mainly changes in JChem.

New in Instant JChem 6.1.2 (Oct 29, 2013)

  • 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.

New in Instant JChem 6.1 (Oct 22, 2013)

  • New features or improvements:
  • Form API - allows forms to be created by scripts (documentation).
  • Palette for widgets in form design mode, widgets can be added more easily (feature description).
  • Printable Button widget.
  • Derby JDBC driver updated to 10.10.1.1 version.
  • Upgraded demo projects available online.
  • Bugs fixed:
  • 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.

New in Instant JChem 6.0.5 (Sep 19, 2013)

  • Bugs fixed:
  • Fixed LDAP configuration doesn't allow to change value of objectClass=inetorgperson.
  • Fixed disappearing list after it was edited.

New in Instant JChem 6.0.4 (Sep 19, 2013)

  • Bugs fixed:
  • 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

New in Instant JChem 6.0.3 (Jul 24, 2013)

  • Marvin/JChem 6.0.3 are used. JChem tables will not be regenerated from the 6.0.x version.
  • Bugs fixed:
  • Fixed compatibility with ChemDraw 13
  • Frequently Asked Questions page created - IJC FAQ

New in Instant JChem 6.0.2 (Jul 23, 2013)

  • Marvin/JChem 6.0.2 are used. JChem tables will not be regenerated from the 6.0.x version.

New in Instant JChem 6.0.1 (Jul 23, 2013)

  • Marvin/JChem 6.0.1 are used. JChem tables will not be regenerated from the 6.0.x version.
  • Bugs fixed:
  • 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

New in Instant JChem 6.0 (Jun 28, 2013)

  • Marvin/JChem 6.0 are used.
  • New features:
  • 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.
  • Owner of items can transfer ownership to another user.
  • Minor improvements:
  • Added Spotfire integration support for relational data.
  • Text query is case-insensitive by default.
  • 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.
  • Bugs fixed:
  • 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.

New in Instant JChem 5.12.4 (May 13, 2013)

  • Fixed sorting of fields on Oracle e.g. in Promote table dialog.
  • Fixed setting of default field value.

New in Instant JChem 5.12.3.1 (May 3, 2013)

  • 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.

New in Instant JChem 5.12.3 (May 3, 2013)

  • Fixed error while running similarity search.
  • Fixed NPE while deleting schema with opened form containing text field widget.

New in Instant JChem 5.12.2 (Apr 4, 2013)

  • Bugs fixed or minor improvements:
  • 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.
  • PNG images are pre-selected as default structure format in Export to Excel dialog if JChem for Excel is not installed on the computer.

New in Instant JChem 5.12.1 (Mar 21, 2013)

  • Bugs fixed or minor improvements:
  • 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.

New in Instant JChem 5.12.0 (Mar 21, 2013)

  • New features and improvements:
  • 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 (Full feature description).
  • Optional disabling of "remember password checkbox" in the dialog to connect to IJC schema. (Documentation).
  • 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 (Full feature description).
  • Ability to disable snap-to-edge in form designer Documentation).
  • 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 (Documentation).
  • 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 Documentation).
  • SQL Entity - new flexible entity type defined by a SQL statement (Full feature description).
  • MolMatrix widget supporting text fields also in standard entities.
  • MolMatrix printing.
  • Support for composite LDAP user search.
  • Bugs fixed or minor improvements:
  • Fixes for NULLs in LIST type variable being replaced in calculated fields. Some new variable types implemented, please see the (full feature description).
  • 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.

New in Instant JChem 5.11.5 (Feb 25, 2013)

  • Fixed copy-paste of widgets, allowing all widgets to be copied to clipboard

New in Instant JChem 5.11.4 (Dec 20, 2012)

  • Bugs fixed or minor improvements:
  • Fixed usage of ROWID as ID field in Oracle views.
  • Fixed init and destroy methods in button scripts.

New in Instant JChem 5.11.3.1 (Dec 20, 2012)

  • Bugs fixed or minor improvements:
  • 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 persistance on standard entity.
  • Implicit heap memory (-Xmx) settings set back to 512MB.

New in Instant JChem 5.11.3 (Dec 20, 2012)

  • Bugs fixed or minor improvements:
  • Fixed not working import without standardizer license.
  • Fixed domain search using list of non-ID field.

New in Instant JChem 5.11.2 (Dec 20, 2012)

  • Bugs fixed or minor improvements:
  • Fixed mixed-up aggregated values in Tree Table.
  • Fixed slow New Chemical Terms Field dialog.
  • Fixed multiply(a,b,..) function in Calculated fields.
  • Fixed ConcurrentModificationException when scrolling through a list of compounds.

New in Instant JChem 5.11.1 (Dec 20, 2012)

  • Bugs fixed or minor improvements
  • 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.

New in Instant JChem 5.11.0 (Dec 20, 2012)

  • New features and improvements:
  • 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
  • Custom double-click action for MolPane, MolMatrix, Text field, Text area, Table and Grid view.
  • 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.
  • Bugs fixed or minor improvements:
  • 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.

New in Instant JChem 5.10.4 (Dec 20, 2012)

  • Bugs fixed
  • 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.

New in Instant JChem 5.10.1 (Dec 20, 2012)

  • 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).