IJC : Oracle Cartridge :no structure search results:

User 773d472e7f

12-07-2012 10:01:36

Dear ChemAxon,


I have connected IJC (5.9.4) to an oracle (11) database with the JC Cartridge (JChem 5.9.2 : index version 5080100)  installed and a domain index generated (onto a standerd table containing +15 million structures).


In IJC I have:


Created an IJC-schema to the oracle JC domain index user.


Set the Schema : Miscellaneous : 


: Turn off initial data retreval (checked)


: Enable Event Logging (checked)


: Load as needed (checked)


Prompted the standerd molecule table to entety.


Opened a grid view onto the table.


Created a search on a related data field (ID) and returned many thousands of rows with no problems.


When I search by structure no rows are ever returned (though the structures exist).


Please would you help.


Many Thanks


Bernard


 


 


 


 


 


 


 

ChemAxon 2bdd02d1e5

12-07-2012 11:38:04

Dear Bernard,


It seems that you have updated Cartridge from some previous version and forgot to update indexes?


Please regenerate the indexes as described in help: http://www.chemaxon.com/instantjchem/ijc_latest/docs/admin/cartridge.html#regenerating


You need to drop the index which belongs to standard table and then recreate in on that table. It is quite straight forward according simple instructions(two SQL commands).


This is common problems during upgrades so hopefully it solves the issue. 


Please let us know if it helps otherwise we must find another solution.


Filip

ChemAxon fa971619eb

13-07-2012 11:13:45

Sometimes errors during search result in this symptom. Things like invalid or missing licenses.


There are two things to check:


1. check that a structure search (e.g. using a jc_compare() operator) can be done directly in Oracle (e,.g. using SQLPlus).


2. Look in the IJC log file to look for search releated errors (View -> Instant JChem Log file).


Tim

User 773d472e7f

13-07-2012 16:02:58

IThanks for the 2 replies.


1. I did drop and then rebuild the the domain index. It reported a successfull completion.


2. I tested using a cartridge function directly in sqlplus. The error was.


SQL> SELECT count(*) FROM akos_moltable WHERE jc_compare(smiles, 'c1ccccc1', 't:d maxTime:15000') = 1;
SELECT count(*) FROM akos_moltable WHERE jc_compare(smiles, 'c1ccccc1', 't:d maxTime:15000') = 1
*
FEHLER in Zeile 1:
ORA-20101: Please, create domain index on the column referenced in the operator
JC_COMPARE of the table with DATA_OBJECT_ID=175313. You can find out the name
of the table by executing:
SELECT owner, object_name INTO schema_name, table_name
FROM sys.dba_objects WHERE DATA_OBJECT_ID = 175313
ORA-06512: in "JCHEM.JCHEM_CORE_PKG", Zeile 121
ORA-06512: in "JCHEM.EXEC_FUNC", Zeile 11
ORA-06512: in "JCHEM.COMPARE_FUNC", Zeile 7


3. A copy of IJC LOG FILE is reproduced below. This does state that there is a license not found errer. I have installed the licence and the license does list correcty when  I call the relevent jchem cartridge function.


the log fole listing follows ...........


-------------------------------------------------------------------------------
>Log Session: Friday, July 13, 2012 3:17:52 PM CEST
>System Info:
  Product Version         = Instant JChem 5.9.4
  Operating System        = Windows 2003 version 5.2 running on x86
  Java; VM; Vendor        = 1.6.0_26; Java HotSpot(TM) Client VM 20.1-b02; Sun Microsystems Inc.
  Runtime                 = Java(TM) SE Runtime Environment 1.6.0_26-b03
  Java Home               = c:\Program Files\ChemAxon\InstantJChem\jre
  System Locale; Encoding = en_GB (instantjchem); Cp1252
  Home Directory          = C:\Documents and Settings\bernard.AKOSGMBH
  Current Directory       = C:\Program Files\ChemAxon\InstantJChem
  User Directory          = C:\Documents and Settings\bernard.AKOSGMBH\Application Data\.instantjchem\ijc_5_9
  Installation            = C:\Program Files\ChemAxon\InstantJChem\instantjchem
                            C:\Program Files\ChemAxon\InstantJChem\harness
                            C:\Program Files\ChemAxon\InstantJChem\ide
                            C:\Program Files\ChemAxon\InstantJChem\platform
  Boot & Ext. Classpath   = c:\Program Files\ChemAxon\InstantJChem\jre\lib\resources.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\rt.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\sunrsasign.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\jsse.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\jce.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\charsets.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\modules\jdk.boot.jar;c:\Program Files\ChemAxon\InstantJChem\jre\classes;c:\Program Files\ChemAxon\InstantJChem\jre\lib\ext\dnsns.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\ext\localedata.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\ext\sunjce_provider.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\ext\sunmscapi.jar;c:\Program Files\ChemAxon\InstantJChem\jre\lib\ext\sunpkcs11.jar
  Application Classpath   = C:\Program Files\ChemAxon\InstantJChem\platform\lib\boot.jar;C:\Program Files\ChemAxon\InstantJChem\platform\lib\org-openide-modules.jar;C:\Program Files\ChemAxon\InstantJChem\platform\lib\org-openide-util-lookup.jar;C:\Program Files\ChemAxon\InstantJChem\platform\lib\org-openide-util.jar
  Startup Classpath       = C:\Program Files\ChemAxon\InstantJChem\platform\core\core.jar;C:\Program Files\ChemAxon\InstantJChem\platform\core\org-openide-filesystems.jar;C:\Program Files\ChemAxon\InstantJChem\instantjchem\core\locale\core_instantjchem.jar
-------------------------------------------------------------------------------
WARNING [org.netbeans.core.startup.NbEvents]: The extension C:\Program Files\ChemAxon\InstantJChem\instantjchem\modules\ext\commons-codec-1.4.jar may be multiply loaded by modules: [C:\Program Files\ChemAxon\InstantJChem\instantjchem\modules\chemaxon-jchem.jar, C:\Program Files\ChemAxon\InstantJChem\instantjchem\modules\org-springframework.jar]; see: http://www.netbeans.org/download/dev/javadoc/org-openide-modules/org/openide/modules/doc-files/classpath.html#class-path />WARNING [org.netbeans.core.modules]: the modules [com.im.ijc.autoupdate, com.im.ijc.chem.overlap, com.im.ijc.core, com.im.ijc.formview, com.im.ijc.groovy, com.im.ijc.io, com.im.ijc.logviewer, com.im.ijc.project, com.im.ijc.querytextpanel, com.im.ijc.renderers, com.im.ijc.security, com.im.ijc.serverconnect, com.im.ijc.sfs, com.im.ijc.sketchreg, com.im.ijc.standardizer, com.im.ijc.structurefiles, com.im.ijc.training, com.im.ijcs.impl.odata, com.im.uiutil, org.netbeans.modules.db.sql.editor, org.netbeans.modules.derby, org.netbeans.modules.diff, org.netbeans.modules.editor.bracesmatching, org.netbeans.modules.editor.codetemplates, org.netbeans.modules.editor.indent.project, org.netbeans.modules.editor.macros, org.netbeans.modules.jumpto, org.netbeans.modules.options.editor, org.netbeans.modules.refactoring.api, org.netbeans.spi.editor.hints] use org.jdesktop.layout which is deprecated: Use javax.swing.GroupLayout instead. (In form editor: select Form ... in Inspector; change Layout Generation Style to Standard Java 6 code.)
INFO [org.netbeans.core.startup.NbEvents]: Turning on modules:
        org.openide.util.lookup [8.3.1 110214-aec102d89c78]
        org.openide.util [8.6.1 110214-aec102d89c78]
        org.openide.modules [7.17.2 110214-aec102d89c78]
        org.apache.derby/1 [10.8.1.2 201205120129-197701]
        oracle.jdbc/1 [11.2.0.2.0.1 201205120129-197701]
        com.mysql.jdbc/1 [5.1.13 201205120129-197701]
        org.apache.commons.lang/1 [2.5 201205120129-197701]
        com.compositesw.jdbc/1 [5.1.0 201205120129-197701]
        com.lowagie.iia [2.1.7 201205120129-197701]
        org.dom4j/1 [1.6.1 201205120129-197701]
        org.freehep/1 [5.2.6 201205120129-197701]
        org.netbeans.libs.commons_logging/1 [1.13.1.11 11 110214-aec102d89c78]
        org.openide.awt [7.23.1 110214-aec102d89c78]
        org.openide.filesystems [7.38.2 110214-aec102d89c78]
        org.netbeans.api.progress/1 [1.20.2 110214-aec102d89c78]
        org.openide.dialogs [7.15.1 110214-aec102d89c78]
        org.openide.nodes [7.16.1 110214-aec102d89c78]
        org.openide.windows [6.33.1 110214-aec102d89c78]
        org.netbeans.spi.quicksearch [1.6.1 110214-aec102d89c78]
        org.netbeans.modules.editor.mimelookup/1 [1.16.1 110214-aec102d89c78]
        org.openide.text [6.30.1 110214-aec102d89c78]
        org.netbeans.swing.tabcontrol [1.21.1 110214-aec102d89c78]
        org.netbeans.swing.outline [1.9.1 110214-aec102d89c78]
        org.openide.explorer [6.28.2 110214-aec102d89c78]
        org.openide.actions [6.16.1 110214-aec102d89c78]
        org.netbeans.modules.queries/1 [1.19.1 110214-aec102d89c78]
        org.openide.loaders [7.16.1 110214-aec102d89c78]
        org.netbeans.bootstrap/1 [2.33.2 110214-aec102d89c78]
        org.netbeans.core.startup/1 [1.25.3 110214-aec102d89c78]
        org.netbeans.modules.javahelp/1 [2.17.1 110214-aec102d89c78]
        chemaxon.jchem/1 [5.9.4 201205120129-197701]
        com.google.common.guava [8.0 201205120129-197701]
        com.im.commons [5.9 201205120129-197701]
        org.apache.poi [3.7 201205120129-197701]
        org.netbeans.modules.editor.mimelookup.impl/1 [1.9.1 110214-aec102d89c78]
        org.netbeans.swing.plaf [1.16.1 110214-aec102d89c78]
        com.l2fprod.common.swing.outlookbar [1.0 201205120129-197701]
        org.openidex.util/3 [3.25.1 110214-aec102d89c78]
        org.openide.io [1.23.1 110214-aec102d89c78]
        org.netbeans.modules.sendopts/2 [2.9.1 110214-aec102d89c78]
        org.netbeans.modules.utilities/1 [1.35.1 110214-aec102d89c78]
        org.apache.tools.ant/1 [1.8.2 201205120129-197701]
        com.codehaus.groovy [1.8.4.1 201205120129-197701]
        org.apache.commons.pool/1 [1.5.5 201205120129-197701]
        org.samba.jcifs [1.3.17 201205120129-197701]
        swingx/1 [1.6 201205120129-197701]
        org.netbeans.modules.projectapi/1 [1.31.1 110214-aec102d89c78]
        org.netbeans.modules.projectuiapi/1 [1.47.2.8 8 110214-aec102d89c78]
        org.netbeans.modules.target.iterator/1 [1.2.1 110214-aec102d89c78]
        org.slf4j [1.0 201205120129-197701]
        net.sf.log4jdbc [1.2 201205120129-197701]
        org.netbeans.libs.osgi [1.1.1 110214-aec102d89c78]
        o.mozilla.rhino/1 [1.7.2 110214-aec102d89c78]
        org.netbeans.api.xml/1 [1.22.1 110214-aec102d89c78]
        org.netbeans.modules.xml.core/2 [1.21.1.4 4 110214-aec102d89c78]
        org.netbeans.modules.editor.errorstripe.api/1 [2.11.1.1 1 110214-aec102d89c78]
        org.netbeans.modules.editor.util/1 [1.36.1 110214-aec102d89c78]
        org.netbeans.modules.lexer/2 [1.35.1.1 1 110214-aec102d89c78]
        org.netbeans.modules.editor.settings/1 [1.31.1 110214-aec102d89c78]
        org.netbeans.modules.editor.lib2/1 [1.28.1.2 2 110214-aec102d89c78]
        org.netbeans.modules.editor.fold/1 [1.18.1.2 110214-aec102d89c78]
        org.netbeans.modules.editor.lib/2 [2.10.2.10.2 10 110214-aec102d89c78]
        org.netbeans.modules.editor.errorstripe/2 [2.12.1.1.1 1 110214-aec102d89c78]
        org.netbeans.modules.keyring [1.1.2 110214-aec102d89c78]
        org.netbeans.core/2 [3.20.2.1 110214-aec102d89c78]
        org.netbeans.modules.options.api/1 [1.18.1 110214-aec102d89c78]
        org.netbeans.modules.editor.indent/2 [1.19.1.10 110214-aec102d89c78]
        org.netbeans.modules.editor/3 [1.50.1.3.10.2 3 110214-aec102d89c78]
        org.netbeans.modules.options.keymap [1.10.1 110214-aec102d89c78]
        org.netbeans.modules.editor.settings.storage/1 [1.25.1 110214-aec102d89c78]
        org.jdesktop.layout/1 [1.13.1 110214-aec102d89c78]
        org.netbeans.modules.options.editor/1 [1.21.1 110214-aec102d89c78]
        org.netbeans.modules.diff/1 [1.28.2.42.1 42 110214-aec102d89c78]
        org.netbeans.modules.editor.completion/1 [1.20.1.1 1 110214-aec102d89c78]
        org.netbeans.spi.editor.hints/0 [1.14.1.7.2 7 110214-aec102d89c78]
        org.netbeans.modules.editor.codetemplates/1 [1.17.1.1 1 110214-aec102d89c78]
        org.netbeans.libs.lucene/1 [2.10.1.232 232 110214-aec102d89c78]
        org.netbeans.core.ui/1 [1.22.1 110214-aec102d89c78]
        org.openide.execution [1.18.1 110214-aec102d89c78]
        org.netbeans.api.java.classpath/1 [1.25.1 110214-aec102d89c78]
        org.netbeans.api.annotations.common/1 [1.5.1 110214-aec102d89c78]
        org.netbeans.spi.tasklist/1 [1.11.1.1 1 110214-aec102d89c78]
        org.netbeans.modules.masterfs/2 [2.25.2 110214-aec102d89c78]
        org.netbeans.modules.parsing.api/1 [1.33.2.4 4 110214-aec102d89c78]
        org.netbeans.modules.jumpto/1 [1.17.1 110214-aec102d89c78]
        org.netbeans.modules.editor.guards/1 [1.8.1 110214-aec102d89c78]
        org.netbeans.modules.refactoring.api [1.11.1 110214-aec102d89c78]
        org.netbeans.spi.navigator/1 [1.13.1 110214-aec102d89c78]
        org.netbeans.modules.csl.api/2 [2.5.1.2.1.1.4 2 110214-aec102d89c78]
        org.netbeans.modules.xml.lexer [1.9.1 110214-aec102d89c78]
        org.netbeans.modules.editor.structure/1 [1.24.1.1 1 110214-aec102d89c78]
        org.netbeans.modules.editor.bracesmatching/0 [1.13.1 110214-aec102d89c78]
        org.netbeans.modules.xml.text/2 [1.24.1.5 5 110214-aec102d89c78]
        net.sf.cglib/1 [2.1.3 201205120129-197701]
        org.apache.commons.collections/1 [3.2.1 201205120129-197701]
        org.quartz/1 [1.8.4.1 201205120129-197701]
        org.springframework/1 [3.0.5.2 201205120129-197701]
        org.apache.http.clinet [1.0 4.1.2 201205120129-197701]
        com.im.ijc.sketchreg [5.9 201205120129-197701]
        com.im.ijc.sketchreg.chemdraw [5.9 201205120129-197701]
        org.netbeans.modules.xml.xam/1 [1.10.2.1 1 110214-aec102d89c78]
        org.netbeans.modules.xml.schema.model/1 [1.10.1.1 1 110214-aec102d89c78]
        org.netbeans.modules.xml.axi [1.10.1 110214-aec102d89c78]
        org.apache.commons.dbcp/1 [1.4 201205120129-197701]
        com.im.commons.nbcommons [5.9 201205120129-197701]
        com.im.commons.db [5.9.2 201205120129-197701]
        org.netbeans.libs.xerces/1 [1.18.1.280 280 110214-aec102d89c78]
        org.acegisecurity/1 [3.0.5.1 201205120129-197701]
        com.im.ijc.server.api [5.9 201205120129-197701]
        com.im.df.api [5.9 201205120129-197701]
        com.im.df.api.friend [5.9 201205120129-197701]
        org.codehaus.gpars [0.12 201205120129-197701]
        net.sf.jsqlparser/0 [0.7.0.1 201205120129-197701]
        com.im.ijc.server.impl [5.9 201205120129-197701]
        com.michaelbaranov.microba/1 [0.4.4.3 201205120129-197701]
        com.im.commons.ui [5.9 201205120129-197701]
        com.im.df/1 [5.9.1 201205120129-197701]
        com.im.ijc.security/1 [5.9 201205120129-197701]
        com.im.ijc.cf [5.9 201205120129-197701]
        org.netbeans.modules.db.metadata.model/0 [0.9.1 110214-aec102d89c78]
        org.netbeans.core.ide/1 [1.20.1 110214-aec102d89c78]
        org.netbeans.modules.db/1 [1.38.2.30 30 110214-aec102d89c78]
        org.netbeans.modules.defaults/1 [1.11.1 110214-aec102d89c78]
        com.im.df.localdb/1 [5.9 201205120129-197701]
        com.im.df.server.local [5.9 201205120129-197701]
        com.im.ijc.core/1 [5.9.4 201205120129-197701]
        com.jacob.com [1.0 201205120129-197701]
        com.im.ijc.io [5.9 201205120129-197701]
        org.apache.commons.beanutils/1 [1.8.3 201205120129-197701]
        org.apache.commons.digester/1 [2.1 201205120129-197701]
        org.eclipse.jdt.core.compiler [5.3.1 201205120129-197701]
        net.sf.jasperreports/1 [4.1.3 201205120129-197701]
        org.netbeans.modules.autoupdate.services [1.20.1 110214-aec102d89c78]
        com.im.ijc.autoupdate/1 [5.9 201205120129-197701]
        chemaxon.ijc.updatecenter [5.9 201205120129-197701]
        org.netbeans.modules.usersguide/1 [1.28.1 110214-aec102d89c78]
        org.netbeans.modules.favorites/1 [1.20.1 110214-aec102d89c78]
        org.jfree.chart [1.0.13.2 201205120129-197701]
        com.im.uiutil [5.9 201205120129-197701]
        org.netbeans.modules.settings/1 [1.26.1 110214-aec102d89c78]
        com.jamesmurty.util [0.5 201205120129-197701]
        org.netbeans.api.visual [2.23.1.1 110214-aec102d89c78]
        com.im.ijc.jrprinting [5.9 201205120129-197701]
        com.im.ijc.widgets/1 [5.9.1 201205120129-197701]
        com.im.ijc.training [5.9.1 201205120129-197701]
        com.im.ijc.branding/1 [5.9.4 201205120129-197701]
        com.im.ijc.welcome/1 [5.9 201205120129-197701]
        com.im.commons.db.test [5.9 201205120129-197701]
        com.im.ijc.versionprovider [5.9.4 201205120129-197701]
        org.netbeans.libs.jna/1 [1.7.2 110214-aec102d89c78]
        org.netbeans.core.netigso [1.4.3 110214-aec102d89c78]
        org.ccil.cowan.tagsoup [1.2 201205120129-197701]
        org.netbeans.modules.web.flyingsaucer/1 [1.8.1.1 1 110214-aec102d89c78]
        it.tidalwave.image [0.9.6.1.1 201205120129-197701]
        com.im.ijc.renderers/1 [5.9.1 201205120129-197701]
        org.netbeans.modules.extbrowser/1 [1.19.1 110214-aec102d89c78]
        org.apache.tomcat [7.0.14 201205120129-197701]
        com.im.ijc.serverconnect [5.9 201205120129-197701]
        com.im.ijcs.test [5.9 201205120129-197701]
        org.netbeans.modules.db.sql.visualeditor/1 [2.9.1.30 110214-aec102d89c78]
        org.netbeans.modules.keyring.impl [1.0.1 110214-aec102d89c78]
        org.netbeans.modules.xml.xdm/1 [1.11.2.1 1 110214-aec102d89c78]
        com.im.df.core.derby/1 [5.9 201205120129-197701]
        org.netbeans.modules.editor.plain.lib/1 [1.13.1 110214-aec102d89c78]
        com.im.df.db.mysql/1 [5.9 201205120129-197701]
        com.im.ijc.standardizer/1 [5.9 201205120129-197701]
        org.netbeans.modules.dbapi [1.13.1.30 110214-aec102d89c78]
        org.netbeans.core.output2/1 [1.18.2 110214-aec102d89c78]
        org.netbeans.libs.swingx/1 [1.6.1 110214-aec102d89c78]
        org.netbeans.modules.db.dataview [1.7.1 110214-aec102d89c78]
        org.netbeans.core.windows/2 [2.21.1.1 110214-aec102d89c78]
        org.netbeans.core.execution/1 [1.20.1 110214-aec102d89c78]
        org.netbeans.modules.projectui [1.21.3.8 110214-aec102d89c78]
        com.im.ijc.groovy [5.9 201205120129-197701]
        com.im.ijc.project/1 [5.9 201205120129-197701]
        org.netbeans.modules.autoupdate.ui [1.16.1 110214-aec102d89c78]
        com.im.ijc.logviewer [5.9 201205120129-197701]
        org.netbeans.modules.editor.actions/1 [1.5.1.2 110214-aec102d89c78]
        org.netbeans.modules.editor.plain/2 [1.14.1 110214-aec102d89c78]
        org.netbeans.modules.lexer.nbbridge/1 [1.10.1.1 110214-aec102d89c78]
        com.im.db.composite/1 [5.9 201205120129-197701]
        org.odata4j [0.5 201205120129-197701]
        com.im.ijcs.impl.odata [5.9 201205120129-197701]
        com.im.ijcs.server.personal [5.9 201205120129-197701]
        com.im.ijc.extensions.spotfire [5.9 201205120129-197701]
        com.im.ijc.chem.overlap/1 [5.9 201205120129-197701]
        com.im.ijc.querytextpanel [5.9 201205120129-197701]
        embedded.ldap [1.0 2.4.2 201205120129-197701]
        org.fest [1.2 201205120129-197701]
        com.im.ijc.reactor/1 [5.9 201205120129-197701]
        org.xhtmlrenderer [8.0 201205120129-197701]
        com.im.df.exportimport [5.9 201205120129-197701]
        com.im.ijc.formview/1 [5.9 201205120129-197701]
        com.im.ijc.gridview/1 [5.9 201205120129-197701]
        com.im.ijcs.test.tomcat [5.9 201205120129-197701]
        com.im.ijc.structurefiles/1 [5.9 201205120129-197701]
        com.im.ijc.extraloaders [5.9 201205120129-197701]
        com.im.df.core.oracle/1 [5.9 201205120129-197701]
        com.im.ijc.webc [5.9 201205120129-197701]
        com.im.ijc.sfs [5.9 201205120129-197701]
        com.im.ijc.update.pack [5.9.4 201205120129-197701]
        org.apache.xml.resolver [1.11.1.12 12 110214-aec102d89c78]
        org.netbeans.modules.editor.indent.project/0 [1.1.1 110214-aec102d89c78]
        org.netbeans.modules.db.core [1.15.2 110214-aec102d89c78]
        org.netbeans.modules.db.sql.editor [1.15.1.30 110214-aec102d89c78]
        org.netbeans.modules.print.editor [7.6.1 110214-aec102d89c78]
        org.netbeans.modules.derby [1.18.1 110214-aec102d89c78]
        org.netbeans.modules.xml.retriever/1 [1.10.2 110214-aec102d89c78]
        org.netbeans.modules.xml.schema.completion [1.9.2 110214-aec102d89c78]
        org.netbeans.core.nativeaccess/1 [1.7.1 110214-aec102d89c78]
        org.netbeans.swing.dirchooser [1.8.1 110214-aec102d89c78]
        org.netbeans.libs.felix [1.1.1 110214-aec102d89c78]
        org.netbeans.modules.editor.macros/0 [1.9.1.1.10 1 110214-aec102d89c78]
        org.netbeans.core.io.ui/1 [1.8.1 110214-aec102d89c78]
        org.netbeans.modules.progress.ui [1.12.1 110214-aec102d89c78]
        org.netbeans.core.browser/1 [1.6.1.1 1 110214-aec102d89c78]
        org.netbeans.modules.editor.bookmarks/1 [1.13.1 110214-aec102d89c78]
INFO [com.im.df.util.GenericInstancesProvider]: MViewPane instances provider created (AWT_THREAD). Initial instance count:12, initial delay 0sec.
INFO [com.im.df.util.GenericInstancesProvider]: MSketchPane instances provider created (AWT_THREAD). Initial instance count:3, initial delay 0sec.
INFO [com.im.df.util.GenericInstancesProvider]: ConfigBuilderPanel instances provider created (REQUEST_PROCESSOR). Initial instance count:2, initial delay 20sec.
INFO [com.im.df.util.GenericInstancesProvider]: ChemicalTermsTextPane instances provider created (REQUEST_PROCESSOR). Initial instance count:1, initial delay 10sec.
INFO [com.im.workbench.project.StartupWindowInstaller]: do not initialize schema
INFO [com.im.df.localdb.api.ProjectDatabaseSupport]: Creating project db for C:/Documents and Settings/bernard.AKOSGMBH/My Documents/IJCProjects/ijc-project  of type derby
WARNING [org.netbeans.core.TimableEventQueue]: Still previous controller [email protected]9
WARNING [org.netbeans.modules.autoupdate.updateproviders.AutoupdateCatalogFactory]: Services/AutoupdateType/standard-update-provider.settings: url_key attribute deprecated in favor of url
Diagnostic information
Input arguments:
        -Xms48m
        -Xmx512m
        -XX:MaxPermSize=196m
        -Dderby.system.home=derby
        -Dnetbeans.logger.console=true
        -ea
        -Dorg.netbeans.ProxyClassLoader.level=1000
        -DuseGtk=false
        -Dorg.netbeans.core.TimeableEventQueue.report=86400000
        -Djdk.home=c:\Program
        Files\ChemAxon\InstantJChem\jre
        -splash:C:\Documents
        and
        Settings\bernard.AKOSGMBH\Application
        Data\.instantjchem\ijc_5_9\var\cache\splash.png
        -Dnetbeans.home=C:\Program
        Files\ChemAxon\InstantJChem\platform
        -Dnetbeans.user=C:\Documents
        and
        Settings\bernard.AKOSGMBH\Application
        Data\.instantjchem\ijc_5_9
        -XX:+HeapDumpOnOutOfMemoryError
        -XX:HeapDumpPath=C:\Documents
        and
        Settings\bernard.AKOSGMBH\Application
        Data\.instantjchem\ijc_5_9\var\log\heapdump.hprof
        -Dnetbeans.system_http_proxy=DIRECT
        -Dsun.awt.keepWorkingSetOnMinimize=true
        -Dnetbeans.dirs=C:\Program
        Files\ChemAxon\InstantJChem\instantjchem;C:\Program
        Files\ChemAxon\InstantJChem\harness;C:\Program
        Files\ChemAxon\InstantJChem\ide
Compiler: HotSpot Client Compiler
Heap memory usage: initial 48.0MB maximum 494.9MB
Non heap memory usage: initial 12.2MB maximum 228.0MB
Garbage collector: Copy (Collections=18 Total time spent=0s)
Garbage collector: MarkSweepCompact (Collections=6 Total time spent=2s)
Classes: loaded=7038 total loaded=7044 unloaded 6
INFO [org.netbeans.core.ui.warmup.DiagnosticTask]: Total memory 2,147,483,647
INFO [null]: Total physical memory 2,147,483,647
WARNING [org.netbeans.JarClassLoader]: Opening C:\Program Files\ChemAxon\InstantJChem\instantjchem\modules\ext\xmlbeans-2.5.0.jar took 563 ms
INFO [org.netbeans.ui.metrics.projects]: USG_PROJECT_OPEN
WARNING [org.netbeans.JarClassLoader]: Opening C:\Program Files\ChemAxon\InstantJChem\instantjchem\modules\ext\jcampdx-lib-0.9.1.jar took 579 ms
WARNING [org.netbeans.JarClassLoader]: Opening C:\Program Files\ChemAxon\InstantJChem\instantjchem\modules\ext\ooxml-schemas-1.1.jar took 2,984 ms
WARNING [org.netbeans.modules.progress.spi.InternalHandle]: Setting ProgressHandle.setInitialDelay() after the task is started has no effect
WARNING [org.netbeans.modules.progress.spi.InternalHandle]: Setting ProgressHandle.setInitialDelay() after the task is started has no effect
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-df-core-derby.jar!/META-INF/spring/database-context.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-df-db-mysql.jar!/META-INF/spring/database-context.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-db-composite.jar!/META-INF/spring/database-context.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-df-core-oracle.jar!/META-INF/spring/database-context.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-ijc-server-impl.jar!/META-INF/spring/applicationContext-operation-beans-definitions.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-df-server-local.jar!/META-INF/spring/applicationContext-shared-server-and-local-beans.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from class path resource [META-INF/spring/applicationContext-security-configurations.xml]
INFO [org.springframework.security.core.SpringSecurityCoreVersion]: You are running with Spring Security Core 3.0.5.RELEASE
INFO [org.springframework.security.config.SecurityNamespaceHandler]: Spring Security 'config' module version is 3.0.5.RELEASE
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from class path resource [META-INF/spring/db-oracle-mixinContext.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-df.jar!/META-INF/spring/db-common-coreContext.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-commons-db.jar!/META-INF/spring/applicationContext-data-type-column-handlers.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-ijcs-impl-odata.jar!/META-INF/spring/ApplicationContext-odata-producer-providers-beans.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-df-server-local.jar!/META-INF/spring/applicationContext-local-core-beans.xml]
INFO [org.springframework.context.support.GenericApplicationContext]: Refreshing org.springframework.context[email protected]: startup date [Fri Jul 13 15:19:24 CEST 2012]; root of context hierarchy
INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory]: Pre-instantiating singletons in org.s[email protected]1ca13d4: defining beans [derbyDataSourceFactory,derbyDatabasePlatformFactory,mysqlDataSourceFactory,mysqlDatabasePlatformFactory,compositeDataSourceFactory,compositeDatabasePlatformFactory,compositeStringColumnHandler,oracleDataSourceFactory,oracleDatabasePlatformFactory,oracleByteArrayColumnHandler,oracleStringColumnHandler,add-table-std-operation,add-table-generic-operation,add-table-jchemproperty-operation,add-table-jcb-operation,update-table-name-operation,update-standardizer-operation,update-absolute-stereo-operation,add-jcc-index-to-jcb-table-operation,add-jcc-index-to-std-table-operation,drop-tables-operation,drop-table-jchemproperty-operation,drop-column-operation,add-column-operation,update-column-notnull-operation,update-column-default-operation,update-column-name-operation,update-column-definition-operation,update-chemical-terms-expression-operation,add-field-operation,delete-field-operation,update-field-operation,update-schema-operation,add-entity-operation,delete-entity-operation,update-entity-operation,add-data-tree-operation,delete-data-tree-operation,update-data-tree-operation,add-query-operation,delete-query-operation,update-query-operation,add-script-operation,delete-script-operation,update-script-operation,add-list-operation,delete-list-operation,update-list-operation,add-view-operation,delete-view-operation,update-view-operation,add-chemicalterms-column-operation,add-sequence-operation,drop-sequence-operation,drop-trigger-operation,drop-chemical-terms-column-operation,add-relationship-operation,delete-relationship-operation,update-relationship-operation,add-foreign-key-operation,drop-foreign-key-operation,add-index-operation,drop-index-operation,add-unique-constraint-operation,drop-unique-constraint-operation,rebuild-index-operation,rebuild-index-cartridge-operation,metadata-drop-tables-operation,metadata-delete-schema-item-operation,metadata-update-schema-item-operation,metadata-add-schema-item-operation,metadata-delete-view-operation,metadata-update-view-operation,metadata-add-view-operation,metadata-add-list-query-operation,metadata-update-list-query-operation,metadata-delete-list-query-operation,connectionPoolFactory,initalDataSourceFactoryBean,initialDataSource,databasePlatform,ijcMetadataDao,ijcLoggingDao,tableManager,queryDefinitionFactory,selectPrototype,queryDefinitionBuilder,sqlSelectBuilder,dbSchemaManager,dbSchemaPersistence,txManager,txAttributes,txInterceptor,schemaId,userDetailsDao,userLoginDao,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,authenticationInterceptor,userLoginService,userLoginServiceAdmin,accessDecisionManager,org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource#0,org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor#0,org.springframework.security.methodSecurityMetadataSourceAdvisor,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator#0,oracleSelectExtensions,jccSQLTranslator,localJchemManager,basicAppenderFactory,appenderRegistry,sqlTranslator,jchemSearchTranslator,termEncoder,defaultBooleanColumnHandeler,defaultByteArrayColumnHandler,defaultDateColumnHandeler,defaultFloatColumnHandeler,defaultIntegerColumnHandler,defaultStringColumnHandler,schemaProducerProvider,structureProducerProvider,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,queryService,localQueryExecutor,localJChemExecutor,username,ddlService,defaultLobHandler,paramProcessor,paramProcessor2,contextProvider]; root of factory hierarchy
INFO [org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor]: Validated configuration attributes
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-df-core-derby.jar!/META-INF/spring/database-context.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-df-db-mysql.jar!/META-INF/spring/database-context.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-db-composite.jar!/META-INF/spring/database-context.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-df-core-oracle.jar!/META-INF/spring/database-context.xml]
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from URL [jar:file:/C:/Program%20Files/ChemAxon/InstantJChem/instantjchem/modules/com-im-commons-db.jar!/META-INF/spring/applicationContext-data-type-column-handlers.xml]
INFO [org.springframework.context.support.GenericApplicationContext]: Refreshing [email protected]760b: startup date [Fri Jul 13 15:19:33 CEST 2012]; root of context hierarchy
INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory]: Pre-instantiating singletons in org.s[email protected]722c99: defining beans [derbyDataSourceFactory,derbyDatabasePlatformFactory,mysqlDataSourceFactory,mysqlDatabasePlatformFactory,compositeDataSourceFactory,compositeDatabasePlatformFactory,compositeStringColumnHandler,oracleDataSourceFactory,oracleDatabasePlatformFactory,oracleByteArrayColumnHandler,oracleStringColumnHandler,defaultBooleanColumnHandeler,defaultByteArrayColumnHandler,defaultDateColumnHandeler,defaultFloatColumnHandeler,defaultIntegerColumnHandler,defaultStringColumnHandler]; root of factory hierarchy
INFO [com.im.commons.db.datasource.DataSourceFactory]: Testing com.im.df.core.derby.EmbeddedSourceFactory
INFO [com.im.commons.db.datasource.DataSourceFactory]: Testing com.im.df.db.mysql.MysqlDataSourceFactory
INFO [com.im.commons.db.datasource.DataSourceFactory]: Testing com.im.db.composite.CompositeDataSourceFactory
INFO [com.im.commons.db.datasource.DataSourceFactory]: Testing com.im.df.core.oracle.OracleDataSourceFactory
INFO [com.im.df.core.oracle.OracleDataSource]: Loaded JDBC driver: oracle.jdbc.driver.OracleDriver
INFO [com.im.commons.db.datasource.BaseDataSource]: Creating DB pool: jdbc:oracle:thin:@localhost:1521:orak
INFO [com.im.commons.db.datasource.BaseDataSource]: JDBC connection for jdbc:oracle:thin:@localhost:1521:orak: [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Testing com.im.df.core.derby.DerbyDatabasePlatformFactory
INFO [com.im.commons.db.AbstractDatabasePlatform]: Testing com.im.df.db.mysql.MysqlDatabasePlatformFactory
INFO [com.im.commons.db.AbstractDatabasePlatform]: Testing com.im.db.composite.CompositeDatabasePlatformFactory
INFO [com.im.commons.db.AbstractDatabasePlatform]: Testing com.im.df.core.oracle.OracleDatabasePlatformFactory
Creating AbstractDatabasePlatform with:
driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:orak
username=akos_samples_b
schema=AKOS_SAMPLES_B
INFO [com.im.commons.db.AbstractDatabasePlatform]: Found JChem cartridge owned by JCHEM
Cartridge environment:
Oracle environment:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE        11.1.0.7.0        Production
TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
JChem owner: JCHEM
JChem Server environment:
Java VM vendor: Oracle Corporation
Java version: 1.7.0_03
Java VM version: 22.1-b02
JChem version: 5.9.2
JChem Index version: 5080100
JDBC driver version: 11.1.0.7.0-Production
Database Info:
Product name: Oracle
Product version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Major version: 11
Minor version: 1
INFO [com.im.ijcs.impl.dao.IJCMetadataDao]: Initializing IJCMetadataDao
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from class path resource [META-INF/spring/anonymous-security-template.xml]
WARNING [org.netbeans.modules.progress.spi.InternalHandle]: Setting ProgressHandle.setInitialDelay() after the task is started has no effect
INFO [com.im.df.impl.db.sprovider.ConnectedToDBState]: Using anonymous authentication
INFO [com.im.df.impl.db.persist.AuthenticationInterceptor]: Logged in user admin with roles [ROLE_USER, ROLE_EDIT_DATA, ROLE_EDIT_SCHEMA, ROLE_ADMIN]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Found JChem cartridge owned by JCHEM
INFO [com.im.ijcs.impl.ddl.DefaultDDLService]: Current user set to: admin
INFO [com.im.ijcs.impl.query.DefaultQueryService]: Current user set to: admin
INFO [com.im.ijcs.impl.query.DefaultQueryService]: Schema ID set to: 8F53C67063B6FBB310D18DB5083B8E6D
INFO [com.im.commons.db.AbstractDatabasePlatform]: checking for the schema existence: 8F53C67063B6FBB310D18DB5083B8E6D
WARNING [org.netbeans.modules.progress.spi.InternalHandle]: Setting ProgressHandle.setInitialDelay() after the task is started has no effect
INFO [com.im.df.impl.db.sprovider.DDLModeSelectionState]: showoptions.user mode = DEFAULT
WARNING [org.netbeans.modules.progress.spi.InternalHandle]: Setting ProgressHandle.setInitialDelay() after the task is started has no effect
INFO [com.im.ijcs.impl.ddl.DefaultDDLService]: Getting model for user admin with roles ROLE_USER ROLE_EDIT_DATA ROLE_EDIT_SCHEMA ROLE_ADMIN
INFO [com.im.ijcs.impl.ddl.DefaultDDLService]: Loading database info in mode: LAZY_LOADING
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table infos for all tables and views for schema AKOS_SAMPLES_B, tablesToInit = null, loadType = LAZY, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_ASTRAL_CS,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_AVAILABILITIES_TABLE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_COMMAND_TABLE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_IMPORTLOG_TABLE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_IMPORT_ERRORS_TABLE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_CCLK,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_CONV,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_CTAB,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_FLEX,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_FMLA,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_FSDL,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_FSIX,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_FSUP,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_IKY2,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_LOG,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_NEC,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_PROP,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_RSGP,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLIX_SKY2,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLTABLE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_NOTES_TABLE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_REGLOG_BOOK,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_SAMPLETYPE_TABLE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_SUPPLIERPRICES_TABLE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_SUPPLIERS,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_AUTHORITIES,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_CHANGE_LOG,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_CUSTOM_ITEMS,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_INVOCATION_LOG,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_ITEM_INFO,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_ITEM_USER,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_SCHEMA,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_SCHEMA_AUTHORITIES,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_SECURITY_INFO,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_USER,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.IJC_VIEWS,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.JCHEMPROPERTIES,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.JCHEMPROPERTIES_CR,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.JC_IDX_PROPERTY,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo: DBTableInfoProxy{AKOS_SAMPLES_B.JC_IDX_UDOP,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.ACD_CAS,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.ACD_MOLVIEW,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.AKISC,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLVIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.ALL_SUPPLIERS,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.BATCHES_FOR_UPDATE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.BATCH_MYSQL_PUBLISH,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.BATCH_PUBLISH_PRICES,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.BATCH_PUBLISH_UPDATE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.BB_VIEW,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.BDA_NON_VIRTUALS_VIEW,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.BDA_VIRTUALS_VIEW,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.CATALOGUE,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.MOLECULE,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.MOLTABLE_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.MOL_URL,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.NS_VIEW,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.PACKAGE,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.PACKAGE_PRODUCTS,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.PUBCHEM_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.PUBLISHED_BATCHES,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.SCD_CAS,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.SCD_MOLVIEW,LAZY}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built lazy DBTableInfo for view: DBTableInfoProxy{AKOS_SAMPLES_B.SC_VIEW,LAZY}
StopWatch 'Building table infos for all tables and views for schema AKOS_SAMPLES_B, tablesToInit = null, loadType = LAZY, lazyLoader = [email protected]': running time (millis) = 687
-----------------------------------------
ms     %     Task name
-----------------------------------------
00297  043%  Building table names and types
00390  057%  Reading view definitions
00000  000%  Assembling table infos for 42 tables
00000  000%  Assembling table infos for 28 views
StopWatch 'Finding JChem property table': running time (millis) = 1438
-----------------------------------------
ms     %     Task name
-----------------------------------------
01438  100% 
INFO [com.im.commons.db.AbstractDatabasePlatform]: Found 1 JChem property tables
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.ACD_CAS
Examining AKOS_SAMPLES_B.ACD_CAS view's SQL: SELECT                               cat.cas , mt.akos_number, xmt.mdlnumber
FROM  aCD.aCD2D_cas cat, akos_moltable mt,  aCD.aCD2D_MOLTABLE xmt
WHERE cat.cdbregno = xmt.cdbregno
and          xmt.mdlnumber = mt.mdlnumber
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.ACD_CAS involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'cat' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'xmt' -> null
 'mt' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.ACD_CAS,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.ACD_CAS, tablesToInit = [AKOS_SAMPLES_B.ACD_CAS], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.ACD_CAS,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.ACD_CAS, tablesToInit = [AKOS_SAMPLES_B.ACD_CAS], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 1047
-----------------------------------------
ms     %     Task name
-----------------------------------------
00141  013%  Building table names and types
00000  000%  Reading view definitions
00078  007%  Building column infos
00672  064%  Building constraint infos
00156  015%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.ACD_MOLVIEW
Examining AKOS_SAMPLES_B.ACD_MOLVIEW view's SQL: SELECT                                               CDBREGNO,  MDLNUMBER
FROM acd.acd2d_moltable
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.ACD_MOLVIEW involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'acd.acd2d_moltable' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.ACD_MOLVIEW,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.AKISC
Examining AKOS_SAMPLES_B.AKISC view's SQL: select                             count(akos_number), akos_number
from akos_batchtable
where supplier_id = 'AKI' and sample_type = 'SCREENING_SAMPLE'
group by akos_number 
order by akos_number
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.AKISC involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'akos_batchtable' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.AKISC,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW
Examining AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW view's SQL: SELECT                                            AKOS_NUMBER,  'http://akosservice.de/akossamplesservice/php/akossamplesretrieval.php?IDNUMBERS=' || AKOS_NUMBER
FROM akos_moltable
ORDER BY AKOS_NUMBER
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW involves the following tables: {
 'akos_moltable' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW, tablesToInit = [AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW, tablesToInit = [AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 250
-----------------------------------------
ms     %     Task name
-----------------------------------------
00125  050%  Building table names and types
00000  000%  Reading view definitions
00000  000%  Building column infos
00094  038%  Building constraint infos
00031  012%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.AKOS_MOLVIEW
Examining AKOS_SAMPLES_B.AKOS_MOLVIEW view's SQL: SELECT                                     AKOS_NUMBER,  MDLNUMBER
FROM akos_moltable
ORDER BY AKOS_NUMBER
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.AKOS_MOLVIEW involves the following tables: {
 'akos_moltable' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_MOLVIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.AKOS_MOLVIEW, tablesToInit = [AKOS_SAMPLES_B.AKOS_MOLVIEW], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.AKOS_MOLVIEW,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.AKOS_MOLVIEW, tablesToInit = [AKOS_SAMPLES_B.AKOS_MOLVIEW], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 250
-----------------------------------------
ms     %     Task name
-----------------------------------------
00125  050%  Building table names and types
00000  000%  Reading view definitions
00016  006%  Building column infos
00078  031%  Building constraint infos
00031  012%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.AKOS_VIEW
Examining AKOS_SAMPLES_B.AKOS_VIEW view's SQL: SELECT                                     AKOS_NUMBER, 'http://akosservice.de/akossamplesservice/php/akossamplesretrieval.php?IDNUMBERS=' || AKOS_NUMBER
FROM AKOS_MOLTABLE
ORDER BY AKOS_NUMBER
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.AKOS_VIEW involves the following tables: {
 'AKOS_MOLTABLE' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.AKOS_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.AKOS_VIEW, tablesToInit = [AKOS_SAMPLES_B.AKOS_VIEW], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.AKOS_VIEW,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.AKOS_VIEW, tablesToInit = [AKOS_SAMPLES_B.AKOS_VIEW], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 234
-----------------------------------------
ms     %     Task name
-----------------------------------------
00125  053%  Building table names and types
00000  000%  Reading view definitions
00016  007%  Building column infos
00078  033%  Building constraint infos
00015  006%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.ALL_SUPPLIERS
Examining AKOS_SAMPLES_B.ALL_SUPPLIERS view's SQL: SELECT distinct                           BT.AKOS_NUMBER, BT.NOTE_ID_CPY,  NT.NOTE
FROM AKOS_BATCHTABLE BT, AKOS_NOTES_TABLE NT
WHERE  (BT.NOTE_ID_CPY = NT.NOTE_ID)
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.ALL_SUPPLIERS involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'BT' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'NT' -> StandardTableSetInfo: Name=AKOS_NOTES_TABLE
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.ALL_SUPPLIERS,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.BATCHES_FOR_UPDATE
Examining AKOS_SAMPLES_B.BATCHES_FOR_UPDATE view's SQL: select                                           bt.akos_number,  bt.availability,  bt.sample_type
from akos_batchtable bt left join published_batches pt
on bt.akos_number = pt.akos_number
and bt.sample_type = pt.sample_type
and bt.availability = pt.availability
where bt.published_flag = 'N'
and   pt.akos_number is null
order by akos_number, sample_type, availability
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.BATCHES_FOR_UPDATE involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'pt' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'bt' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.BATCHES_FOR_UPDATE,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.BATCH_MYSQL_PUBLISH
Examining AKOS_SAMPLES_B.BATCH_MYSQL_PUBLISH view's SQL: select distinct                                  BT.AKOS_NUMBER, BT.PUBLISH_AV as "AVAILABILITY", BT.PUBLISH_ST as "SAMPLETYPE", SP.QUANTITY || ' ' || SP.UNIT as "PACKAGESIZE" ,  min(SP.AKOS_PRICE) || ' ' || SP.CURRENCY as "PRICE", SP.QUANTITY, MT.MOLWEIGHT AS "MOLWEIGHT", MT.MOLFORMULA AS "FORMULA", MT.INCHIKEY, MT.INCHI AS "INCHINAME"
from AKOS_SUPPLIERPRICES_TABLE SP, AKOS_BATCHTABLE BT, AKOS_MOLTABLE MT
where MT.AKOS_NUMBER = BT.AKOS_NUMBER 
and (SP.SUID (+) = BT.SUPPLIER_ID)
and (SP.PRICEGROUP (+) = BT.PRICEGROUP)
group by BT.AKOS_NUMBER, BT.PUBLISH_AV, BT.PUBLISH_ST, SP.QUANTITY, SP.UNIT, SP.CURRENCY, MT.MOLWEIGHT, MT.MOLFORMULA, MT.INCHIKEY, MT.INCHI
order by BT.AKOS_NUMBER, SP.QUANTITY
 
Can't parse 'AKOS_SAMPLES_B.BATCH_MYSQL_PUBLISH' view's SQL: 'select distinct                                  BT.AKOS_NUMBER, BT.PUBLISH_AV as "AVAILABILITY", BT.PUBLISH_ST as "SAMPLETYPE", SP.QUANTITY || ' ' || SP.UNIT as "PACKAGESIZE" ,  min(SP.AKOS_PRICE) || ' ' || SP.CURRENCY as "PRICE", SP.QUANTITY, MT.MOLWEIGHT AS "MOLWEIGHT", MT.MOLFORMULA AS "FORMULA", MT.INCHIKEY, MT.INCHI AS "INCHINAME"
from AKOS_SUPPLIERPRICES_TABLE SP, AKOS_BATCHTABLE BT, AKOS_MOLTABLE MT
where MT.AKOS_NUMBER = BT.AKOS_NUMBER 
and (SP.SUID (+) = BT.SUPPLIER_ID)
and (SP.PRICEGROUP (+) = BT.PRICEGROUP)
group by BT.AKOS_NUMBER, BT.PUBLISH_AV, BT.PUBLISH_ST, SP.QUANTITY, SP.UNIT, SP.CURRENCY, MT.MOLWEIGHT, MT.MOLFORMULA, MT.INCHIKEY, MT.INCHI
order by BT.AKOS_NUMBER, SP.QUANTITY
 '
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.BATCH_MYSQL_PUBLISH,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT
Examining AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT view's SQL: SELECT                                    distinct bpp.AKOS_NUMBER,   bpp.AVAILABILITY,  mt.PUBLISHED,  bpp.PUBLISHED_FLAG,   bpp.QUANTITY,   bpp.UNIT,   bpp.SAMPLE_TYPE, 'http://akosservice.de/akossamplesservice/php/akossamplesretrieval.php?IDNUMBERS=' || bpp.AKOS_NUMBER, bpp.CTNUM || ' ' || akos_price || ' ' || currency
FROM BATCH_PUBLISH_PRICES BPP, AKOS_MOLTABLE mt
WHERE bpp.AKOS_NUMBER = mt.AKOS_NUMBER
ORDER BY AKOS_NUMBER, UNIT desc, QUANTITY
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT involves the following tables: {
 'mt' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'BPP' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT, tablesToInit = [AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT, tablesToInit = [AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 250
-----------------------------------------
ms     %     Task name
-----------------------------------------
00125  050%  Building table names and types
00000  000%  Reading view definitions
00016  006%  Building column infos
00078  031%  Building constraint infos
00031  012%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.BATCH_PUBLISH_PRICES
Examining AKOS_SAMPLES_B.BATCH_PUBLISH_PRICES view's SQL: SELECT                                              BT.AKOS_NUMBER,  bt.availability,  bt.published_flag, bt.sample_type,  min(SP.AKOS_PRICE), SP.SUPPLIER_PRICE, SP.QUANTITY, SP.UNIT, SP.CURRENCY, BT.AKOS_NUMBER || ' ' || sp.QUANTITY || sp.UNIT || ' (' || bt.publish_av || ' ' || bt.publish_st || ')'
FROM AKOS_SUPPLIERPRICES_TABLE SP, AKOS_BATCHTABLE BT
WHERE  (SP.SUID (+) = BT.SUPPLIER_ID)
AND (SP.PRICEGROUP (+) = BT.PRICEGROUP)
group by BT.AKOS_NUMBER, bt.availability, bt.published_flag, bt.sample_type, sp.supplier_price, SP.QUANTITY, SP.UNIT,  SP.CURRENCY, BT.AKOS_NUMBER || ' ' || sp.QUANTITY || sp.UNIT || ' (' || bt.publish_av || ' ' || bt.publish_st || ')'
ORDER BY BT.AKOS_NUMBER, SP.QUANTITY, SP.UNIT
 
Can't parse 'AKOS_SAMPLES_B.BATCH_PUBLISH_PRICES' view's SQL: 'SELECT                                              BT.AKOS_NUMBER,  bt.availability,  bt.published_flag, bt.sample_type,  min(SP.AKOS_PRICE), SP.SUPPLIER_PRICE, SP.QUANTITY, SP.UNIT, SP.CURRENCY, BT.AKOS_NUMBER || ' ' || sp.QUANTITY || sp.UNIT || ' (' || bt.publish_av || ' ' || bt.publish_st || ')'
FROM AKOS_SUPPLIERPRICES_TABLE SP, AKOS_BATCHTABLE BT
WHERE  (SP.SUID (+) = BT.SUPPLIER_ID)
AND (SP.PRICEGROUP (+) = BT.PRICEGROUP)
group by BT.AKOS_NUMBER, bt.availability, bt.published_flag, bt.sample_type, sp.supplier_price, SP.QUANTITY, SP.UNIT,  SP.CURRENCY, BT.AKOS_NUMBER || ' ' || sp.QUANTITY || sp.UNIT || ' (' || bt.publish_av || ' ' || bt.publish_st || ')'
ORDER BY BT.AKOS_NUMBER, SP.QUANTITY, SP.UNIT
 '
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.BATCH_PUBLISH_PRICES,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.BATCH_PUBLISH_UPDATE
Examining AKOS_SAMPLES_B.BATCH_PUBLISH_UPDATE view's SQL: SELECT                                    distinct bpp.AKOS_NUMBER,   bpp.AVAILABILITY,   bpp.PUBLISHED_FLAG,   bpp.QUANTITY,   bpp.UNIT,   bpp.SAMPLE_TYPE, 'http://akosservice.de/akossamplesservice/php/akossamplesretrieval.php?IDNUMBERS=' || bpp.AKOS_NUMBER, bpp.CTNUM || ' ' || akos_price || ' ' || currency
FROM         BATCH_PUBLISH_PRICES bpp, BATCHES_FOR_UPDATE bfu
WHERE         bpp.AKOS_NUMBER  = bfu.AKOS_NUMBER
and                bpp.SAMPLE_TYPE  = bfu.SAMPLE_TYPE
and                bpp.AVAILABILITY = bfu.AVAILABILITY
ORDER BY bpp.AKOS_NUMBER, bpp.UNIT desc, bpp.QUANTITY
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.BATCH_PUBLISH_UPDATE involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'bpp' -> StandardTableSetInfo: Name=BATCH_PUBLISH_PRICES
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'bfu' -> StandardTableSetInfo: Name=BATCHES_FOR_UPDATE
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.BATCH_PUBLISH_UPDATE,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.BB_VIEW
Examining AKOS_SAMPLES_B.BB_VIEW view's SQL: select                                         r,  akos_number
  from (
    select distinct m.akos_number, b.sample_type, row_number() over (order by m.akos_number) r
    from akos_moltable m, akos_batchtable b
    where b.sample_type = 'BUILDING_BLOCK'
    and m.akos_number = b.akos_number
  )
where sample_type = 'BUILDING_BLOCK'
 
Can't parse 'AKOS_SAMPLES_B.BB_VIEW' view's SQL: 'select                                         r,  akos_number
  from (
    select distinct m.akos_number, b.sample_type, row_number() over (order by m.akos_number) r
    from akos_moltable m, akos_batchtable b
    where b.sample_type = 'BUILDING_BLOCK'
    and m.akos_number = b.akos_number
  )
where sample_type = 'BUILDING_BLOCK'
 '
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.BB_VIEW,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.BDA_NON_VIRTUALS_VIEW
Examining AKOS_SAMPLES_B.BDA_NON_VIRTUALS_VIEW view's SQL: SELECT DISTINCT AKOS_NUMBER
FROM akos_batchtable
where sample_type <> 'VIRTUAL'
ORDER BY AKOS_NUMBER
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.BDA_NON_VIRTUALS_VIEW involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'akos_batchtable' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.BDA_NON_VIRTUALS_VIEW,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.BDA_VIRTUALS_VIEW
Examining AKOS_SAMPLES_B.BDA_VIRTUALS_VIEW view's SQL: SELECT DISTINCT AKOS_NUMBER
FROM akos_batchtable
where sample_type = 'VIRTUAL'
ORDER BY AKOS_NUMBER
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.BDA_VIRTUALS_VIEW involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'akos_batchtable' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.BDA_VIRTUALS_VIEW,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.CATALOGUE
Examining AKOS_SAMPLES_B.CATALOGUE view's SQL: SELECT                                    distinct bpp.AKOS_NUMBER,   bpp.AVAILABILITY,  mt.PUBLISHED,  bpp.PUBLISHED_FLAG,   bpp.QUANTITY,   bpp.UNIT,   bpp.SAMPLE_TYPE, 'http://akosservice.de/akossamplesservice/php/akossamplesretrieval.php?IDNUMBERS=' || bpp.AKOS_NUMBER, bpp.CTNUM || ' ' || akos_price || ' ' || currency
FROM BATCH_PUBLISH_PRICES BPP, AKOS_MOLTABLE mt
WHERE bpp.AKOS_NUMBER = mt.AKOS_NUMBER
ORDER BY AKOS_NUMBER, UNIT desc, QUANTITY
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.CATALOGUE involves the following tables: {
 'mt' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'BPP' -> StandardTableSetInfo: Name=BATCH_PUBLISH_PRICES
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.CATALOGUE,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.CATALOGUE, tablesToInit = [AKOS_SAMPLES_B.CATALOGUE], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.CATALOGUE,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.CATALOGUE, tablesToInit = [AKOS_SAMPLES_B.CATALOGUE], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 250
-----------------------------------------
ms     %     Task name
-----------------------------------------
00141  056%  Building table names and types
00000  000%  Reading view definitions
00000  000%  Building column infos
00093  037%  Building constraint infos
00016  006%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.MOLECULE
Examining AKOS_SAMPLES_B.MOLECULE view's SQL: SELECT                     distinct   AKOS_NUMBER, 'http://akosservice.de/akossamplesservice/php/akossamplesretrieval.php?IDNUMBERS=' || AKOS_NUMBER
FROM AKOS_MOLTABLE
ORDER BY AKOS_NUMBER
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.MOLECULE involves the following tables: {
 'AKOS_MOLTABLE' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.MOLECULE,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.MOLECULE, tablesToInit = [AKOS_SAMPLES_B.MOLECULE], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.MOLECULE,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.MOLECULE, tablesToInit = [AKOS_SAMPLES_B.MOLECULE], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 250
-----------------------------------------
ms     %     Task name
-----------------------------------------
00141  056%  Building table names and types
00000  000%  Reading view definitions
00000  000%  Building column infos
00093  037%  Building constraint infos
00016  006%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.MOLTABLE_VIEW
Examining AKOS_SAMPLES_B.MOLTABLE_VIEW view's SQL: SELECT                                                CDBREGNO,    MolFormula,   MOLNAME,   CTAB,   MOLWEIGHT,  akos_number, akos_number
FROM AKOS_MOLTABLE
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.MOLTABLE_VIEW involves the following tables: {
 'AKOS_MOLTABLE' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.MOLTABLE_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.MOLTABLE_VIEW, tablesToInit = [AKOS_SAMPLES_B.MOLTABLE_VIEW], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.MOLTABLE_VIEW,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.MOLTABLE_VIEW, tablesToInit = [AKOS_SAMPLES_B.MOLTABLE_VIEW], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 250
-----------------------------------------
ms     %     Task name
-----------------------------------------
00125  050%  Building table names and types
00016  006%  Reading view definitions
00000  000%  Building column infos
00078  031%  Building constraint infos
00031  012%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.MOL_URL
Examining AKOS_SAMPLES_B.MOL_URL view's SQL: SELECT                     distinct   AKOS_NUMBER, 'http://akosservice.de/akossamplesservice/php/akossamplesretrieval.php?IDNUMBERS=' || AKOS_NUMBER
FROM AKOS_MOLTABLE
ORDER BY AKOS_NUMBER
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.MOL_URL involves the following tables: {
 'AKOS_MOLTABLE' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.MOL_URL,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.MOL_URL, tablesToInit = [AKOS_SAMPLES_B.MOL_URL], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.MOL_URL,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.MOL_URL, tablesToInit = [AKOS_SAMPLES_B.MOL_URL], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 234
-----------------------------------------
ms     %     Task name
-----------------------------------------
00125  053%  Building table names and types
00000  000%  Reading view definitions
00016  007%  Building column infos
00078  033%  Building constraint infos
00015  006%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.NS_VIEW
Examining AKOS_SAMPLES_B.NS_VIEW view's SQL: select                                         r,  akos_number
  from (
    select distinct m.akos_number, b.sample_type, row_number() over (order by m.akos_number) r
    from akos_moltable m, akos_batchtable b
    where b.sample_type <> 'BUILDING_BLOCK'
        and   b.sample_type <> 'SCREENING_SAMPLE'
    and m.akos_number = b.akos_number
  )
where sample_type <> 'BUILDING_BLOCK'
and sample_type   <> 'SCREENING_SAMPLE'
 
Can't parse 'AKOS_SAMPLES_B.NS_VIEW' view's SQL: 'select                                         r,  akos_number
  from (
    select distinct m.akos_number, b.sample_type, row_number() over (order by m.akos_number) r
    from akos_moltable m, akos_batchtable b
    where b.sample_type <> 'BUILDING_BLOCK'
        and   b.sample_type <> 'SCREENING_SAMPLE'
    and m.akos_number = b.akos_number
  )
where sample_type <> 'BUILDING_BLOCK'
and sample_type   <> 'SCREENING_SAMPLE'
 '
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.NS_VIEW,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.PACKAGE
Examining AKOS_SAMPLES_B.PACKAGE view's SQL: SELECT distinct                                   BT.CDBBATCHNO,  BT.BATCH_ID,  BT.AKOS_NUMBER,  BT.SUPPLIER_ID, BT.NOTE_ID_CPY,  NT1.NOTE,   SP.PRICEGROUP, SP.SUPPLIER_PRICE, SP.QUANTITY, SP.UNIT, SP.AKOS_PRICE, SP.CURRENCY, BT.AKOS_NUMBER || ' ' || bt.SUPPLIER_ID || ' ' ||sp.QUANTITY || sp.UNIT CATNO, NT2.NOTE
FROM AKOS_SUPPLIERPRICES_TABLE SP, AKOS_BATCHTABLE BT, AKOS_NOTES_TABLE NT1, AKOS_NOTES_TABLE NT2
WHERE  (SP.SUID (+) = BT.SUPPLIER_ID)
AND (SP.PRICEGROUP (+) = BT.PRICEGROUP)
AND BT.NOTE_ID_CPY = NT1.NOTE_ID
AND BT.NOTE_ID_MSG = NT2.NOTE_ID
ORDER BY BT.AKOS_NUMBER, SP.PRICEGROUP,  SP.QUANTITY,  SP.UNIT
 
Can't parse 'AKOS_SAMPLES_B.PACKAGE' view's SQL: 'SELECT distinct                                   BT.CDBBATCHNO,  BT.BATCH_ID,  BT.AKOS_NUMBER,  BT.SUPPLIER_ID, BT.NOTE_ID_CPY,  NT1.NOTE,   SP.PRICEGROUP, SP.SUPPLIER_PRICE, SP.QUANTITY, SP.UNIT, SP.AKOS_PRICE, SP.CURRENCY, BT.AKOS_NUMBER || ' ' || bt.SUPPLIER_ID || ' ' ||sp.QUANTITY || sp.UNIT CATNO, NT2.NOTE
FROM AKOS_SUPPLIERPRICES_TABLE SP, AKOS_BATCHTABLE BT, AKOS_NOTES_TABLE NT1, AKOS_NOTES_TABLE NT2
WHERE  (SP.SUID (+) = BT.SUPPLIER_ID)
AND (SP.PRICEGROUP (+) = BT.PRICEGROUP)
AND BT.NOTE_ID_CPY = NT1.NOTE_ID
AND BT.NOTE_ID_MSG = NT2.NOTE_ID
ORDER BY BT.AKOS_NUMBER, SP.PRICEGROUP,  SP.QUANTITY,  SP.UNIT
 '
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.PACKAGE,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.PACKAGE_PRODUCTS
Examining AKOS_SAMPLES_B.PACKAGE_PRODUCTS view's SQL: SELECT                                       BT.CDBBATCHNO,  BT.AKOS_NUMBER,  BT.PERCENTAGE_PURITY
FROM AKOS_BATCHTABLE BT
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.PACKAGE_PRODUCTS involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'BT' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.PACKAGE_PRODUCTS,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.PUBCHEM_VIEW
Examining AKOS_SAMPLES_B.PUBCHEM_VIEW view's SQL: SELECT                                                       AKOS_NUMBER,           'http://www.akosgmbh.de/AKosSamples/index.html', 'http://akosservice.de/akossamplesservice/php/akossamplesretrieval.php?IDNUMBERS=' || AKOS_NUMBER,  to_char(DATE_ADDED,'YYYY-MM-DD')
FROM akos_moltable
ORDER BY AKOS_NUMBER
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.PUBCHEM_VIEW involves the following tables: {
 'akos_moltable' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.PUBCHEM_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.PUBCHEM_VIEW, tablesToInit = [AKOS_SAMPLES_B.PUBCHEM_VIEW], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.PUBCHEM_VIEW,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.PUBCHEM_VIEW, tablesToInit = [AKOS_SAMPLES_B.PUBCHEM_VIEW], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 250
-----------------------------------------
ms     %     Task name
-----------------------------------------
00141  056%  Building table names and types
00000  000%  Reading view definitions
00000  000%  Building column infos
00078  031%  Building constraint infos
00031  012%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.PUBLISHED_BATCHES
Examining AKOS_SAMPLES_B.PUBLISHED_BATCHES view's SQL: select                                          AKOS_NUMBER,   SAMPLE_TYPE,   AVAILABILITY
from AKOS_BATCHTABLE
where PUBLISHED_FLAG = 'Y'
group by AKOS_NUMBER, SAMPLE_TYPE, AVAILABILITY
order by AKOS_NUMBER, SAMPLE_TYPE, AVAILABILITY
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.PUBLISHED_BATCHES involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'AKOS_BATCHTABLE' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.PUBLISHED_BATCHES,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW
Examining AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW view's SQL: select                                             mt.MDLNUMBER, mt.AKOS_NUMBER, SUPPLIER_ID, round(AKOS_PRICE * XCU.RATE / (QUANTITY * XUN.MULTIPLIER),0) AS NORM_PRICE, SUPPLIER_PRICE,   AKOS_PRICE , CURRENCY, QUANTITY, UNIT, QUANTITY * XUN.MULTIPLIER AS NORM_QUANT
from  AKOS_MOLTABLE mt, AKOS_BATCHTABLE bt, AKOS_SUPPLIERPRICES_TABLE sp, ACD.ACD2D_UNITS xun, ACD.ACD2D_CURRENCY_RATE xcu
where mt.akos_number = bt.akos_number
and   sp.SUID = bt.SUPPLIER_ID
and   sp.pricegroup = bt.pricegroup
and   xcu.CURR_ISO = sp.CURRENCY
and   xun.ORIG_UNITS = sp.UNIT
order by mt.akos_number, norm_quant
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'sp' -> StandardTableSetInfo: Name=AKOS_SUPPLIERPRICES_TABLE
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'xcu' -> null
 'mt' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'xun' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'bt' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW, tablesToInit = [AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW, tablesToInit = [AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 250
-----------------------------------------
ms     %     Task name
-----------------------------------------
00141  056%  Building table names and types
00000  000%  Reading view definitions
00000  000%  Building column infos
00093  037%  Building constraint infos
00016  006%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.SCD_CAS
Examining AKOS_SAMPLES_B.SCD_CAS view's SQL: SELECT                               cat.cas , mt.akos_number, xmt.mdlnumber
FROM  sCD.sCD2D_cas cat, akos_moltable mt,  sCD.sCD2D_MOLTABLE xmt
WHERE cat.cdbregno = xmt.cdbregno
and          xmt.mdlnumber = mt.mdlnumber
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.SCD_CAS involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'cat' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'xmt' -> null
 'mt' -> JChemCartridgeStandardTableSetInfo: TableName=AKOS_MOLTABLE, TableType=Molecules, TableVersion=5080100
  StructureColumnName=CTAB_CLOB, PropertyTable=AKOS_SAMPLES_B.JChemProperties
  AbsoluteStereo=true
  NumberOfOnes=2, NumberOfInts=16, NumberOfEdges=6
  Standardizer=null
  IndexName=AKOS_SAMPLES_B.AKOS_JC_MOLIX
  IndexTableName=AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX]
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for cartStd view DBTableInfoProxy{AKOS_SAMPLES_B.SCD_CAS,FULL}
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.SCD_CAS, tablesToInit = [AKOS_SAMPLES_B.SCD_CAS], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo for view: DBTableInfo{AKOS_SAMPLES_B.SCD_CAS,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.SCD_CAS, tablesToInit = [AKOS_SAMPLES_B.SCD_CAS], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 250
-----------------------------------------
ms     %     Task name
-----------------------------------------
00141  056%  Building table names and types
00000  000%  Reading view definitions
00000  000%  Building column infos
00078  031%  Building constraint infos
00031  012%  Building index infos
00000  000%  Assembling table infos for 0 tables
00000  000%  Assembling table infos for 1 views
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.SCD_MOLVIEW
Examining AKOS_SAMPLES_B.SCD_MOLVIEW view's SQL: SELECT                                               CDBREGNO,  MDLNUMBER
FROM scd.scd2d_moltable
 
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: View AKOS_SAMPLES_B.SCD_MOLVIEW involves the following tables: {
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]:  'scd.scd2d_moltable' -> null
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: }
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.SCD_MOLVIEW,LAZY}
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Examining view AKOS_SAMPLES_B.SC_VIEW
Examining AKOS_SAMPLES_B.SC_VIEW view's SQL: select                                         r,  akos_number
  from (
    select distinct m.akos_number, b.sample_type, row_number() over (order by m.akos_number) r
    from akos_moltable m, akos_batchtable b
    where b.sample_type = 'SCREENING_SAMPLE'
    and m.akos_number = b.akos_number
  )
where sample_type = 'SCREENING_SAMPLE'
 
Can't parse 'AKOS_SAMPLES_B.SC_VIEW' view's SQL: 'select                                         r,  akos_number
  from (
    select distinct m.akos_number, b.sample_type, row_number() over (order by m.akos_number) r
    from akos_moltable m, akos_batchtable b
    where b.sample_type = 'SCREENING_SAMPLE'
    and m.akos_number = b.akos_number
  )
where sample_type = 'SCREENING_SAMPLE'
 '
INFO [com.im.ijcs.impl.ddl.JChemTableManagerImpl]: Building TableSetInfo for std view DBTableInfoProxy{AKOS_SAMPLES_B.SC_VIEW,LAZY}
Initialising TableSetInfos took:
StopWatch '': running time (millis) = 7438
-----------------------------------------
ms     %     Task name
-----------------------------------------
00688  009%  Getting data for cartridge for schema AKOS_SAMPLES_B
00687  009%  Getting table infos for schema AKOS_SAMPLES_B
01516  020%  Building property table data
04547  061%  Building TableSetInfos
Driver: oracle.jdbc.driver.OracleDriver
URL: jdbc:oracle:thin:@localhost:1521:orak
User: akos_samples_b
JChemCartridgeIndexInfo[
  owner=JCHEM,
  JC_IDX_PROPERTY Table:
    AKOS_SAMPLES_B.AKOS_JC_MOLIX.JChemProperties => AKOS_SAMPLES_B.JChemProperties
    AKOS_SAMPLES_B.AKOS_JC_MOLIX.idxTable => AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
  Index table info:
    AKOS_SAMPLES_B.AKOS_JC_MOLIX => AKOS_SAMPLES_B.AKOS_MOLTABLE
  Index column info:
    AKOS_SAMPLES_B.AKOS_JC_MOLIX => CTAB_CLOB
]
DBItemsCache[
  All schemas: ACD AKOS AKOS_SAMPLES AKOS_SAMPLES_B AKOS_TEST1 AKOS_TEST2 ANONYMOUS APEX_PUBLIC_USER AUTH32 BI BINGO C$MDLICHEM62 C$MDLICHEM63 CIRX CMC CTXSYS DBSNMP DIP EXFSYS FLOWS_030000 FLOWS_FILES HR IX JCHEM JSM MDDATA MDDR MDSYS MES32 METAB MGMT_VIEW NCI OBJ32 OE OLAPSYS ORACLE_OCM ORDPLUGINS ORDSYS ORGSYN OUTLN OWBSYS PM REFLIB SCD SCOTT SH SI_INFORMTN_SCHEMA SPATIAL_CSW_ADMIN_USR SPATIAL_WFS_ADMIN_USR SPORE SPRESI SYS SYSMAN SYSTEM TEST1 TOXICITY TSMSYS WKPROXY WKSYS WK_TEST WMSYS XDB XS$NULL
  Default schema: AKOS_SAMPLES_B
  Extra schemas:
  TableSetInfos:
    AKOS_SAMPLES_B.JCHEMPROPERTIES Type=jchempropertytable
      TABLE: AKOS_SAMPLES_B.JCHEMPROPERTIES
      TABLE: AKOS_SAMPLES_B.JCHEMPROPERTIES_CR
    AKOS_SAMPLES_B.AKOS_ASTRAL_CS Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_ASTRAL_CS
    AKOS_SAMPLES_B.AKOS_AVAILABILITIES_TABLE Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_AVAILABILITIES_TABLE
    AKOS_SAMPLES_B.AKOS_COMMAND_TABLE Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_COMMAND_TABLE
    AKOS_SAMPLES_B.AKOS_IMPORTLOG_TABLE Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_IMPORTLOG_TABLE
    AKOS_SAMPLES_B.AKOS_IMPORT_ERRORS_TABLE Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_IMPORT_ERRORS_TABLE
    AKOS_SAMPLES_B.AKOS_MOLIX_CCLK Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_CCLK
    AKOS_SAMPLES_B.AKOS_MOLIX_CONV Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_CONV
    AKOS_SAMPLES_B.AKOS_MOLIX_CTAB Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_CTAB
    AKOS_SAMPLES_B.AKOS_MOLIX_FLEX Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_FLEX
    AKOS_SAMPLES_B.AKOS_MOLIX_FMLA Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_FMLA
    AKOS_SAMPLES_B.AKOS_MOLIX_FSDL Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_FSDL
    AKOS_SAMPLES_B.AKOS_MOLIX_FSIX Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_FSIX
    AKOS_SAMPLES_B.AKOS_MOLIX_FSUP Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_FSUP
    AKOS_SAMPLES_B.AKOS_MOLIX_IKY2 Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_IKY2
    AKOS_SAMPLES_B.AKOS_MOLIX_LOG Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_LOG
    AKOS_SAMPLES_B.AKOS_MOLIX_NEC Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_NEC
    AKOS_SAMPLES_B.AKOS_MOLIX_PROP Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_PROP
    AKOS_SAMPLES_B.AKOS_MOLIX_RSGP Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_RSGP
    AKOS_SAMPLES_B.AKOS_MOLIX_SKY2 Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLIX_SKY2
    AKOS_SAMPLES_B.AKOS_MOLTABLE Type=cart/std
      TABLE: AKOS_SAMPLES_B.AKOS_MOLTABLE
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.AKOS_NOTES_TABLE Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_NOTES_TABLE
    AKOS_SAMPLES_B.AKOS_REGLOG_BOOK Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_REGLOG_BOOK
    AKOS_SAMPLES_B.AKOS_SAMPLETYPE_TABLE Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_SAMPLETYPE_TABLE
    AKOS_SAMPLES_B.AKOS_SUPPLIERPRICES_TABLE Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_SUPPLIERPRICES_TABLE
    AKOS_SAMPLES_B.AKOS_SUPPLIERS Type=std
      TABLE: AKOS_SAMPLES_B.AKOS_SUPPLIERS
    AKOS_SAMPLES_B.ACD_CAS Type=cart/std
      VIEW: AKOS_SAMPLES_B.ACD_CAS
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.ACD_MOLVIEW Type=std
      VIEW: AKOS_SAMPLES_B.ACD_MOLVIEW
    AKOS_SAMPLES_B.AKISC Type=std
      VIEW: AKOS_SAMPLES_B.AKISC
    AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW Type=cart/std
      VIEW: AKOS_SAMPLES_B.AKOSNUMBER_URL_VIEW
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.AKOS_MOLVIEW Type=cart/std
      VIEW: AKOS_SAMPLES_B.AKOS_MOLVIEW
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.AKOS_VIEW Type=cart/std
      VIEW: AKOS_SAMPLES_B.AKOS_VIEW
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.ALL_SUPPLIERS Type=std
      VIEW: AKOS_SAMPLES_B.ALL_SUPPLIERS
    AKOS_SAMPLES_B.BATCHES_FOR_UPDATE Type=std
      VIEW: AKOS_SAMPLES_B.BATCHES_FOR_UPDATE
    AKOS_SAMPLES_B.BATCH_MYSQL_PUBLISH Type=std
      VIEW: AKOS_SAMPLES_B.BATCH_MYSQL_PUBLISH
    AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT Type=cart/std
      VIEW: AKOS_SAMPLES_B.BATCH_PUBLISH_CONCAT
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.BATCH_PUBLISH_PRICES Type=std
      VIEW: AKOS_SAMPLES_B.BATCH_PUBLISH_PRICES
    AKOS_SAMPLES_B.BATCH_PUBLISH_UPDATE Type=std
      VIEW: AKOS_SAMPLES_B.BATCH_PUBLISH_UPDATE
    AKOS_SAMPLES_B.BB_VIEW Type=std
      VIEW: AKOS_SAMPLES_B.BB_VIEW
    AKOS_SAMPLES_B.BDA_NON_VIRTUALS_VIEW Type=std
      VIEW: AKOS_SAMPLES_B.BDA_NON_VIRTUALS_VIEW
    AKOS_SAMPLES_B.BDA_VIRTUALS_VIEW Type=std
      VIEW: AKOS_SAMPLES_B.BDA_VIRTUALS_VIEW
    AKOS_SAMPLES_B.CATALOGUE Type=cart/std
      VIEW: AKOS_SAMPLES_B.CATALOGUE
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.MOLECULE Type=cart/std
      VIEW: AKOS_SAMPLES_B.MOLECULE
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.MOLTABLE_VIEW Type=cart/std
      VIEW: AKOS_SAMPLES_B.MOLTABLE_VIEW
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.MOL_URL Type=cart/std
      VIEW: AKOS_SAMPLES_B.MOL_URL
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.NS_VIEW Type=std
      VIEW: AKOS_SAMPLES_B.NS_VIEW
    AKOS_SAMPLES_B.PACKAGE Type=std
      VIEW: AKOS_SAMPLES_B.PACKAGE
    AKOS_SAMPLES_B.PACKAGE_PRODUCTS Type=std
      VIEW: AKOS_SAMPLES_B.PACKAGE_PRODUCTS
    AKOS_SAMPLES_B.PUBCHEM_VIEW Type=cart/std
      VIEW: AKOS_SAMPLES_B.PUBCHEM_VIEW
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.PUBLISHED_BATCHES Type=std
      VIEW: AKOS_SAMPLES_B.PUBLISHED_BATCHES
    AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW Type=cart/std
      VIEW: AKOS_SAMPLES_B.QC_NORMAL_PRICE_VIEW
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.SCD_CAS Type=cart/std
      VIEW: AKOS_SAMPLES_B.SCD_CAS
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX
      TABLE: AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX_UL
    AKOS_SAMPLES_B.SCD_MOLVIEW Type=std
      VIEW: AKOS_SAMPLES_B.SCD_MOLVIEW
    AKOS_SAMPLES_B.SC_VIEW Type=std
      VIEW: AKOS_SAMPLES_B.SC_VIEW
]
StopWatch 'Reading ModelInfo from metadata tables': running time (millis) = 17251
-----------------------------------------
ms     %     Task name
-----------------------------------------
00187  001%  Fetching items
00016  000%  Fetching lists
00000  000%  Extracting fields
09328  054%  Extracting entities
00000  000%  Extracting relationships
00016  000%  Fetching scripts
00000  000%  Extracting data trees
00016  000%  Extracting views
00031  000%  Extracting queries
00219  001%  Building SchemaInfo
07438  043%  Building ModelInfo
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.AKOS_MOLTABLE, tablesToInit = [AKOS_SAMPLES_B.AKOS_MOLTABLE], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo: DBTableInfo{AKOS_SAMPLES_B.AKOS_MOLTABLE,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.AKOS_MOLTABLE, tablesToInit = [AKOS_SAMPLES_B.AKOS_MOLTABLE], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 87707
-----------------------------------------
ms     %     Task name
-----------------------------------------
00125  000%  Building table names and types
00016  000%  Building column infos
00078  000%  Building constraint infos
00031  000%  Building index infos
87457  100%  Assembling table infos for 1 tables
00000  000%  Assembling table infos for 0 views
INFO [com.im.commons.db.AbstractDatabasePlatform]: Building table info for AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX, tablesToInit = [AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX], loadType = EAGER, lazyLoader = [email protected]
INFO [com.im.commons.db.AbstractDatabasePlatform]: Built DBTableInfo: DBTableInfo{AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX,FULL}
StopWatch 'Building table info for AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX, tablesToInit = [AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX], loadType = EAGER, lazyLoader = [email protected]': running time (millis) = 328
-----------------------------------------
ms     %     Task name
-----------------------------------------
00140  043%  Building table names and types
00016  005%  Building column infos
00078  024%  Building constraint infos
00016  005%  Building index infos
00078  024%  Assembling table infos for 1 tables
00000  000%  Assembling table infos for 0 views
StopWatch 'Deserializing schema from DTOs': running time (millis) = 92502
-----------------------------------------
ms     %     Task name
-----------------------------------------
01468  002%  Schema
00000  000%  xattributes
90988  098%  Entities
00000  000%  Relationships
00046  000%  Data trees
00000  000%  Scripts on schema
00000  000%  Activating schema
StopWatch 'Reading IJC Schema': running time (millis) = 109878
-----------------------------------------
ms     %     Task name
-----------------------------------------
17266  016%  Building DTOs
92612  084%  Assembling Schema from DTOs
WARNING [org.netbeans.modules.progress.spi.InternalHandle]: Setting ProgressHandle.setInitialDelay() after the task is started has no effect
INFO [com.im.df.impl.db.sprovider.RegisterCacheState]: DB schema AKOS_SAMPLES_B: Registering cache for 1 JChemProperties table(s).
INFO [com.im.df.impl.db.sprovider.RegisterCacheState]: JChem cache registered successfully for table AKOS_SAMPLES_B.JCHEMPROPERTIES
INFO [com.im.df.impl.db.DBSchemaImpl]: Adding ModelChangeListener: [email protected]
StopWatch 'Schema Init steps': running time (millis) = 160304
-----------------------------------------
ms     %     Task name
-----------------------------------------
00188  000%  Step 1: Reading connection info
38111  024%  Step 2: Connecting to database
07719  005%  Step 3: Authenticating IJC username/password
00359  000%  Step 4: Upgrading IJC Schema...
112427  070%  Step 5: Loading schema
01500  001%  Step 6: Registering to JChem cache
INFO [com.im.df.impl.db.DBSchemaDataProviderImpl]: Creating default result set for Akos Moltable. Reading all data: false
INFO [com.im.commons.db.datasource.BaseDataSource]: JDBC connection for jdbc:oracle:thin:@localhost:1521:orak: [email protected]
INFO [com.im.ijc.core.api.views.AbstractViewTopComponent]: ViewTC.setView: 1d1f40c, View=Grid view for Akos Moltable, id=F680F84B3F74D07CC5CBDE8118AA8958 / thread:AWT-EventQueue-1
INFO [com.im.ijc.sketchreg.chemdraw.bridge.ChemDrawBridge]: Loading Chemdraw bridge library (cdbridge.dll)...
INFO [com.im.ijc.sketchreg.chemdraw.bridge.ChemDrawBridge]: Loading Chemdraw bridge library successful.
WARNING [it.tidalwave.image.render.EditableImageRenderer]: Enabled workaround for MST-63
INFO [it.tidalwave.image.render.EditableImageRenderer]: setScaledImageCachingEnabled(true)
INFO [it.tidalwave.image.render.EditableImageRenderer]: setOptimizedImageEnabled(true)
INFO [it.tidalwave.image.render.EditableImageRenderer]: setFitToDisplaySize(true)
INFO [it.tidalwave.image.render.EditableImageRenderer]: fitToDisplaySize()
INFO [it.tidalwave.image.render.EditableImageRenderer]: setOptimizedImageEnabled(true)
INFO [it.tidalwave.image.render.EditableImageRenderer]: setScaledImageCachingEnabled(true)
WARNING [it.tidalwave.image.render.EditableImageRenderer]: Enabled workaround for MST-63
INFO [it.tidalwave.image.render.EditableImageRenderer]: setScaledImageCachingEnabled(true)
INFO [it.tidalwave.image.render.EditableImageRenderer]: setOptimizedImageEnabled(true)
INFO [it.tidalwave.image.render.EditableImageRenderer]: setFitToDisplaySize(true)
INFO [it.tidalwave.image.render.EditableImageRenderer]: fitToDisplaySize()
INFO [it.tidalwave.image.render.EditableImageRenderer]: setOptimizedImageEnabled(true)
INFO [it.tidalwave.image.render.EditableImageRenderer]: setScaledImageCachingEnabled(true)
WARNING [org.netbeans.core.TimableEventQueue]: Still previous controller [email protected]d
INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
INFO [org.springframework.jdbc.support.SQLErrorCodesFactory]: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
INFO [com.im.ijcs.impl.query.Executor]: Query interrupted, probably user initiated ps.cancel()
java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine
ORA-29532: Java call terminated by uncaught Java exception: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
        java.rmi.RemoteException: No valid license for JChem Cartridge
ORA-06512: at "JCHEM.JCHEM_CLOB_PKG", line 81
ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 362
        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661)
        at com.im.ijcs.impl.query.Executor.executeQuery(Executor.java:299)
        at com.im.ijcs.impl.query.Executor.visitSqlQuery(Executor.java:244)
        at com.im.ijcs.impl.query.Executor.execute(Executor.java:165)
        at com.im.df.server.local.LocalQueryExecutor.access$001(LocalQueryExecutor.java:26)
        at com.im.df.server.local.LocalQueryExecutor$1.doInTransactionWithoutResult(LocalQueryExecutor.java:60)
        at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
        at com.im.df.server.local.LocalQueryExecutor.execute(LocalQueryExecutor.java:58)
        at com.im.ijcs.impl.query.DefaultQueryService.findImpl(DefaultQueryService.java:138)
        at com.im.ijcs.impl.query.DefaultQueryService$FindExecutor.call(DefaultQueryService.java:117)
        at com.im.ijcs.impl.query.DefaultQueryService$FindExecutor.call(DefaultQueryService.java:101)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[catch] at java.lang.Thread.run(Unknown Source)
INFO [com.im.ijc.core.api.views.AbstractViewTopComponent]: Last executed query changed. Switching to browse mode.

ChemAxon fa971619eb

17-07-2012 13:40:26

From the log file I can see that its the CTAB_CLOB column that is indexed by the cartridge, but you are specifying the SMILES column in the jc_compare() operator.


Try using:


jc_compare(CTAB_CLOB, 'c1ccccc1', 't:d maxTime:15000') = 1

Tim

User 773d472e7f

18-07-2012 14:48:45

Yes this works and shows the cartridge does function from sqlplus:


SQL> select count(*) from akos_moltable where jc_compare(CTAB_CLOB, 'c1ccccc1', 't:d maxTime:15000') = 1;

  COUNT(*)
----------
         1


Does this now give more information regarding the the original IJC issue.


What about the license error in the IJC log file?


kind regards


 


Bernard.


 


 

ChemAxon fa971619eb

20-07-2012 10:22:24

Yes, the licence error in the log file is strange. It seems to come straight after trying to cancel a search. Presumably your cartridge license is properly installed, or you wouldn't be able to run searches from SQLPlus.


Could you verify if this is the case? e.g. run a structure search and see if you get the license error (or any other error) in the log file without cancelling.


Also, could you turn on SQL logging so that you can see the SQL for the query in the log file. To do this uuse Tools -> Options and then fidn the Miscellaneous section and then the Other settings tab. Then change the SQL logging setting and restart IJC. The SQL statements will be written to the log file. Remember to turn it off when finsished.


Tim

User 773d472e7f

01-08-2012 15:24:17

Thanks for your response: I have followed your instructions and I attach the IJC logfile with sql logging turned on.


It is becoming clear that this is not an IJC problem because but a cartridge problem:


I am able to do duplicate structure searching in both IJC and SQLPlus with instant results:


eg: select count(*) from akos_moltable where jc_compare(CTAB_CLOB, 'c1ccccc1', 't:d maxTime:15000') = 1


The problem occurs with substructure searching, in both IJC and SQLPlus. This is indicated in the IJC logfile which shows a memory issue eg: see line 1365. I repeated the substructure search with SQLPlus and this also fails:eg: 
select akos_number from akos_moltable where jc_compare(CTAB_CLOB, 'CC(C)(C)c1cc(n(n1)C(C)(C)C)NC(=O)CSc2nnnn2C3CCCC3', 't:s maxTime:15000') = 1;


this fails after a long time, perhaps 30-60 minutes (much longer than 15000 ms) with this message:


select akos_number from akos_moltable where jc_compare(CTAB_CLOB, 'CC(C)(C)c1cc(n(n1)C(C)(C)C)NC(=O)CSc2nnnn2C3CCCC3', 't:s maxTime:15000') = 1
*
FEHLER in Zeile 1:
ORA-29904: Fehler bei der Ausf³hrung von Routine ODCIIndexClose()
ORA-29532: Java-Aufruf durch nicht abgefangene Java-Exception beendet:
java.rmi.ServerException: RemoteException occurred in server thread; nested
exception is:
java.rmi.RemoteException: chemaxon.jchem.db.DatabaseSearchException:
chemaxon.jchem.db.DatabaseSearchException: ERROR: Table
"AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX" could not fit into structure cache (out of
memory).
Please visit
http://www.chemaxon.com/jchem/doc/admin/Performance.html#cacheSize
/>and
http://www.chemaxon.com/jchem/javaFAQ.html#outofmemory
/>Caused by:
ERROR: Table "AKOS_SAMPLES_B.AKOS_JC_MOLIX_JCX" could not fit into structure
cache (out of memory).
Please visit
http://www.chemaxon.com/jchem/doc/admin/Performance.html#cacheSize />and
http://www.chemaxon.com/jchem/javaFAQ.html#outofmemory />ORA-06512: in "JCHEM.JCHEM_CORE_PKG", Zeile 249
ORA-06512: in "JCHEM.JC_IDXTYPE_IM", Zeile 654
ORA-29903: Fehler bei der Ausf³hrung von Routine ODCIIndexFetch()
ORA-29532: Java-Aufruf durch ni

--------------------------------------------------------------------------


 The server I am running is Windows Server 2003 32 bit with 4GB RAM.


The maximum memory I am able to allocate to the JChem Cartridge 1600 MB (see extract from the properties file below). Any more than this and the JChem Cartridge service does not start up on this system.

using the formula on your website I have calculated the memory needed as follows:


15 million molecules,  fingerprint size 16*32=512 bits, average smiles length = 43:


15,000,000 * (0.5 * 43 + 512 / 8 + 13.5 = 1,477,500,000 bytes = 1478 MB.


this suggests 1600 MB should be sufficient. Is there some other possible problem?


What should I try next.



Thanks and regards,


Bernard


 




 # The maximum heap memory allocated to Java process in which the JChem Server
# is running. See
# http\://www.chemaxon.com/jchem/doc/admin/cartridge.html\#server_memory for
# details on how to calculate the required amount.
jcserver.maxmem=1600m

ChemAxon fa971619eb

03-08-2012 07:49:19

Can you check two things:


1. run a structure search directly from SQL (e.g. using SQLPlus) and confirn that it is working correctly.


2. look in the IJC log file and see if there are any errors when you perform a structure search. The log file can be displayed from the View menu.


Tim

ChemAxon fa971619eb

03-08-2012 07:59:48

Sorry, please ignore the last comment. I was responding to earlier post!


Tim

ChemAxon fa971619eb

03-08-2012 08:04:40

Its clear that you need to allocate more memory to the JChem cartridge server. You mention that you are only able to allocate 1600M. This is likley to be because you are running a 32 bit version of Java. If you switch to a 64 bit version you will be able to allocate much more. So try downloading and installing a 64 bit Java and that should fix the problem.


Tim