User 0f1e393145
13-01-2014 20:53:54
Hey guys,
I was wondering if you could provide any insight to an issue I am having. Currently I am using:
Instant JChem Version: 6.1.3 (build: 201311051107-451960)
JChem Version: 6.1.3
JChem Table Version: 6120000
Marvin Version: 6.1.3 (build date: 2013-10-30)
Java: 1.6.0_41; Java HotSpot(TM) 64-Bit Server VM 20.14-b01
System: Windows 7 version 6.1 running on amd64; Cp1252; en_US (instantjchem)
NetBeans build: a903faa1d680-ijc-patched-9
Userdir: ------
Java Web Start: No
Plugins:
au.com.bytecode.opencsv [2.3 201307230132-380863]
chemaxon.ijc.export.api [6.1 201309180722-419638]
chemaxon.ijc.updatecenter [6.1 201309180722-419638]
chemaxon.ijc.webbrowser [6.1 201309180722-419638]
chemaxon.ijc.wrappers.datarequest/0 [6.1 201309180722-419638]
chemaxon.jchem/1 [6.1.3 201311051107-451960]
com.chemaxon.ijc.export.api.config [6.1 201309180722-419638]
com.chemaxon.ijc.mdif/0 [6.1 201309180722-419638]
com.chemaxon.ijc.wrappers.formsmodel/0 [6.1 201309180722-419638]
com.chemaxon.ijc.wrappers.ijcunit/0 [6.1 201309180722-419638]
com.codehaus.groovy [2.1.2 201307230132-380863]
com.compositesw.jdbc/1 [5.1.0 201307230132-380863]
com.google.common.guava [13.0.1 201307230132-380863]
com.im.commons [6.1 201309180722-419638]
com.im.commons.db [6.1.2 201311051107-451960]
com.im.commons.db.test [6.1.2 201311051107-451960]
com.im.commons.nbcommons [6.1 201309180722-419638]
com.im.commons.ui [6.1 201309180722-419638]
com.im.db.composite/1 [6.1 201309180722-419638]
com.im.df.api [6.1.2 201311051107-451960]
com.im.df.api.friend [6.1.2 201311051107-451960]
com.im.df.core.derby/1 [6.1 201309180722-419638]
com.im.df.core.oracle/1 [6.1.2 201311051107-451960]
com.im.df.db.mysql/1 [6.1 201309180722-419638]
com.im.df.exportimport [6.1 201309180722-419638]
com.im.df.localdb/1 [6.1 201309180722-419638]
com.im.df.server.local [6.1 201309180722-419638]
com.im.df/1 [6.1.3 201311051107-451960]
com.im.ijc.autoupdate/1 [6.1 201309180722-419638]
com.im.ijc.branding/1 [6.1.3 201311051107-451960]
com.im.ijc.cf [6.1 201309180722-419638]
com.im.ijc.cf.api [6.1 201309180722-419638]
com.im.ijc.cf.difbridge [6.1 201309180722-419638]
com.im.ijc.chem.overlap/1 [6.1 201309180722-419638]
com.im.ijc.core/1 [6.1.3 201311051107-451960]
com.im.ijc.etl.datamigrator.wrapper/0 [6.1 201309180722-419638]
com.im.ijc.extensions.spotfire [6.1 201309180722-419638]
com.im.ijc.extraloaders [6.1 201309180722-419638]
com.im.ijc.formview/1 [6.1.2 201311051107-451960]
com.im.ijc.gridview/1 [6.1 201309180722-419638]
com.im.ijc.groovy [6.1 201309180722-419638]
com.im.ijc.io [6.1 201309180722-419638]
com.im.ijc.jrprinting [6.1 201309180722-419638]
com.im.ijc.logviewer [6.1 201309180722-419638]
com.im.ijc.performance.probes [6.1 201309180722-419638]
com.im.ijc.project/1 [6.1.2 201311051107-451960]
com.im.ijc.querytextpanel [6.1 201309180722-419638]
com.im.ijc.reactor/1 [6.1 201309180722-419638]
com.im.ijc.renderers/1 [6.1 201309180722-419638]
com.im.ijc.scripting [6.1 201309180722-419638]
com.im.ijc.security/1 [6.1 201309180722-419638]
com.im.ijc.server.api [6.1.2 201311051107-451960]
com.im.ijc.server.impl [6.1.2 201311051107-451960]
com.im.ijc.sfs [6.1 201309180722-419638]
com.im.ijc.sketchreg [6.1 201309180722-419638]
com.im.ijc.sketchreg.chemdraw [6.1 201309180722-419638]
com.im.ijc.standardizer/1 [6.1 201309180722-419638]
com.im.ijc.structurefiles/1 [6.1 201309180722-419638]
com.im.ijc.training [6.1 201309180722-419638]
com.im.ijc.uitesting [6.1 201309180722-419638]
com.im.ijc.update.pack [6.1.3 201311051107-451960]
com.im.ijc.versionprovider [6.1.3 201311051107-451960]
com.im.ijc.welcome/1 [6.1.2 201311051107-451960]
com.im.ijc.widgets/1 [6.1.3 201311051107-451960]
com.im.ijcs.impl.odata/1 [6.1 201309180722-419638]
com.im.ijcs.server.personal [6.1 201309180722-419638]
com.im.uiutil [6.1 201309180722-419638]
com.jacob.com [1.0 201307230132-380863]
com.jamesmurty.util [0.5 201307230132-380863]
com.l2fprod.common.swing.outlookbar [1.0 201307230132-380863]
com.lowagie.iia [2.1.7 201307230132-380863]
com.michaelbaranov.microba/1 [0.4.4.3 201307230132-380863]
com.mysql.jdbc/1 [5.1.13 201307230132-380863]
it.tidalwave.image [0.9.6.1.1 201307230132-380863]
net.sf.cglib/1 [2.1.3 201307230132-380863]
net.sf.jasperreports/1 [5.1.2 201309180722-419638]
net.sf.jsqlparser/0 [0.7.0.1 201307230132-380863]
net.sf.log4jdbc [1.2 201307230132-380863]
oracle.jdbc/1 [11.2.0.3 201309180722-419638]
org.acegisecurity/1 [3.0.5.1 201307230132-380863]
org.apache.commons.beanutils/1 [1.8.3 201307230132-380863]
org.apache.commons.codec [1.3.0 1.3.0]
org.apache.commons.collections/1 [3.2.1 201307230132-380863]
org.apache.commons.configuration/1 [1.9 201307230132-380863]
org.apache.commons.dbcp/1 [1.4 201307230132-380863]
org.apache.commons.digester/1 [2.1 201307230132-380863]
org.apache.commons.lang [2.4.0 2.4.0]
org.apache.commons.logging [1.1.0 1.1.0]
org.apache.commons.pool/1 [1.6 201309180722-419638]
org.apache.derby/1 [10.10.1.1 201309180722-419638]
org.apache.http.clinet [1.0 4.1.2 201307230132-380863]
org.apache.tomcat [7.0.14 201307230132-380863]
org.apache.tools.ant/1 [1.8.2 201307230132-380863]
org.apache.xml.resolver [1.17.1.12 12 a903faa1d680-ijc-patched-9]
org.ccil.cowan.tagsoup [1.2 201307230132-380863]
org.codehaus.gpars [0.12 201307230132-380863]
org.custommonkey.xmlunit [1.4 201309180722-419638]
org.dom4j/1 [1.6.1 201307230132-380863]
org.eclipse.jdt.core.compiler [5.3.1 201307230132-380863]
org.fest [1.2 201307230132-380863]
org.freehep/1 [6.1 201309180722-419638]
org.jdesktop.layout/1 [1.19.1 a903faa1d680-ijc-patched-9]
org.jfree.chart [1.0.13.2 201307230132-380863]
org.mockito [1.8.5 201309180722-419638]
org.netbeans.api.annotations.common/1 [1.11.1 a903faa1d680-ijc-patched-9]
org.netbeans.api.java.classpath/1 [1.31.1 a903faa1d680-ijc-patched-9]
org.netbeans.api.progress/1 [1.26.1 a903faa1d680-ijc-patched-9]
org.netbeans.api.visual [2.30.1 a903faa1d680-ijc-patched-9]
org.netbeans.api.xml/1 [1.28.1 a903faa1d680-ijc-patched-9]
org.netbeans.bootstrap/1 [2.44.4 a903faa1d680-ijc-patched-9]
org.netbeans.core.execution/1 [1.26.1 a903faa1d680-ijc-patched-9]
org.netbeans.core.ide/1 [1.26.1 a903faa1d680-ijc-patched-9]
org.netbeans.core.io.ui/1 [1.14.1 a903faa1d680-ijc-patched-9]
org.netbeans.core.multiview/1 [1.26.2 a903faa1d680-ijc-patched-9]
org.netbeans.core.nativeaccess/1 [1.14.1 a903faa1d680-ijc-patched-9]
org.netbeans.core.netigso [1.12.3 a903faa1d680-ijc-patched-9]
org.netbeans.core.osgi [1.7.1 a903faa1d680-ijc-patched-9]
org.netbeans.core.output2/1 [1.24.2 a903faa1d680-ijc-patched-9]
org.netbeans.core.startup/1 [1.36.1 a903faa1d680-ijc-patched-9]
org.netbeans.core.ui/1 [1.29.1 a903faa1d680-ijc-patched-9]
org.netbeans.core.windows/2 [2.41.2 a903faa1d680-ijc-patched-9]
org.netbeans.core/2 [3.28.1.1 a903faa1d680-ijc-patched-9]
org.netbeans.insane/1 [1.15.1.1 1 a903faa1d680-ijc-patched-9]
org.netbeans.libs.felix [2.1.1 a903faa1d680-ijc-patched-9]
org.netbeans.libs.freemarker/1 [2.17.1.238 238 a903faa1d680-ijc-patched-9]
org.netbeans.libs.jna/1 [1.16.1 a903faa1d680-ijc-patched-9]
org.netbeans.libs.junit4 [1.14 a903faa1d680-ijc-patched-9]
org.netbeans.libs.nbi.ant [1.8.1 a903faa1d680-ijc-patched-9]
org.netbeans.libs.nbi.engine [1.7.1 a903faa1d680-ijc-patched-9]
org.netbeans.libs.osgi [1.7.1 a903faa1d680-ijc-patched-9]
org.netbeans.libs.swingx/1 [1.12.1 a903faa1d680-ijc-patched-9]
org.netbeans.libs.xerces/1 [1.24.1.280 280 a903faa1d680-ijc-patched-9]
org.netbeans.modules.apisupport.harness [1.28.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.applemenu/1 [1.22.2 a903faa1d680-ijc-patched-9]
org.netbeans.modules.autoupdate.services [1.28.2 a903faa1d680-ijc-patched-9]
org.netbeans.modules.autoupdate.ui [1.25.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.db.core [1.21.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.db.dataview [1.13.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.db.metadata.model/0 [0.15.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.db.sql.editor [1.21.1.30 a903faa1d680-ijc-patched-9]
org.netbeans.modules.db/1 [1.46.1.30 30 a903faa1d680-ijc-patched-9]
org.netbeans.modules.dbapi [1.19.1.30 a903faa1d680-ijc-patched-9]
org.netbeans.modules.defaults/1 [1.17.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.actions/1 [1.13.1.25 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.completion/1 [1.28.1.1 1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.deprecated.pre65formatting/0 [1.6.1.1.5.19.25 1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.fold/1 [1.27.1.25 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.indent/2 [1.26.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.lib/3 [3.17.1.19.25 19 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.lib2/1 [1.53.2.25 25 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.mimelookup.impl/1 [1.16.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.mimelookup/1 [1.24.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.plain.lib/1 [1.19.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.plain/2 [1.20.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.settings.storage/1 [1.31.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.settings/1 [1.38.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor.util/1 [1.45.2 a903faa1d680-ijc-patched-9]
org.netbeans.modules.editor/3 [1.59.2.5.19.25 5 a903faa1d680-ijc-patched-9]
org.netbeans.modules.extbrowser/1 [1.26.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.favorites/1 [1.27.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.javahelp/1 [2.24.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.jellytools.platform/3 [3.11.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.jemmy/3 [3.12.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.keyring [1.8.1.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.keyring.impl [1.5.2 a903faa1d680-ijc-patched-9]
org.netbeans.modules.lexer/2 [1.42.2.1 1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.masterfs/2 [2.34.2 a903faa1d680-ijc-patched-9]
org.netbeans.modules.nbjunit/1 [1.72.2 a903faa1d680-ijc-patched-9]
org.netbeans.modules.netbinox [1.24.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.options.api/1 [1.24.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.options.keymap [1.16.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.progress.ui [1.18.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.project.ant/1 [1.45.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.project.libraries/1 [1.32.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.projectapi/1 [1.40.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.projectui [1.30.1.8 a903faa1d680-ijc-patched-9]
org.netbeans.modules.projectuiapi/1 [1.53.1.8 8 a903faa1d680-ijc-patched-9]
org.netbeans.modules.queries/1 [1.25.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.sendopts/2 [2.15.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.settings/1 [1.33.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.spi.actions/1 [1.13.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.timers/1 [1.16.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.usersguide/1 [1.34.1 a903faa1d680-ijc-patched-9]
org.netbeans.modules.utilities/1 [1.42.2 a903faa1d680-ijc-patched-9]
org.netbeans.modules.xml.catalog/2 [1.26.1.4 4 a903faa1d680-ijc-patched-9]
org.netbeans.spi.navigator/1 [1.20.1 a903faa1d680-ijc-patched-9]
org.netbeans.spi.palette/1 [1.29.1 a903faa1d680-ijc-patched-9]
org.netbeans.spi.quicksearch [1.12.1 a903faa1d680-ijc-patched-9]
org.netbeans.swing.outline [1.17.2 a903faa1d680-ijc-patched-9]
org.netbeans.swing.plaf [1.23.1 a903faa1d680-ijc-patched-9]
org.netbeans.swing.tabcontrol [1.29.1 a903faa1d680-ijc-patched-9]
org.odata4j [0.7 201307230132-380863]
org.opends.server [2.4.6 201307230132-380863]
org.openide.actions [6.24.1 a903faa1d680-ijc-patched-9]
org.openide.awt [7.39.1 a903faa1d680-ijc-patched-9]
org.openide.dialogs [7.23.1 a903faa1d680-ijc-patched-9]
org.openide.execution [1.24.1 a903faa1d680-ijc-patched-9]
org.openide.explorer [6.40.1 a903faa1d680-ijc-patched-9]
org.openide.filesystems [7.53.2 a903faa1d680-ijc-patched-9]
org.openide.io [1.29.1 a903faa1d680-ijc-patched-9]
org.openide.loaders [7.32.1 a903faa1d680-ijc-patched-9]
org.openide.modules [7.27.1 a903faa1d680-ijc-patched-9]
org.openide.nodes [7.25.1 a903faa1d680-ijc-patched-9]
org.openide.text [6.43.2 a903faa1d680-ijc-patched-9]
org.openide.util [8.19.1.1 a903faa1d680-ijc-patched-9]
org.openide.util.lookup [8.11.1 a903faa1d680-ijc-patched-9]
org.openide.windows [6.48.2 a903faa1d680-ijc-patched-9]
org.openidex.util/3 [3.32.1 a903faa1d680-ijc-patched-9]
org.quartz/1 [1.8.4.2 201307230132-380863]
org.samba.jcifs [1.3.17 201307230132-380863]
org.slf4j [1.0 201307230132-380863]
org.springframework/1 [3.0.5.3 201309180722-419638]
org.xhtmlrenderer [8.0 201307230132-380863]
swingx/1 [1.6 201307230132-380863]
When I try to open structure entities as a Schema Administrator there is no issue. All scripts, grid views and form views open appropriately. When I log out and log back in as a Normal User I am prompted with the following: (FYI, using IJC authentication)
java.sql.SQLSyntaxErrorException: ORA-00904: "CHROMOCELL_LIBRARY"."STAGE"."cd_id": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
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)
Caused: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT CHROMOCELL_LIBRARY.STAGE."cd_id" FROM CHROMOCELL_LIBRARY.STAGE]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "CHROMOCELL_LIBRARY"."STAGE"."cd_id": invalid identifier
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
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:376)
at com.im.ijcs.impl.query.Executor.visitSqlQuery(Executor.java:280)
at com.im.ijcs.impl.query.Executor.execute(Executor.java:208)
at com.im.ijcs.impl.query.LocalQueryExecutor.access$001(LocalQueryExecutor.java:25)
at com.im.ijcs.impl.query.LocalQueryExecutor$1.doInTransactionWithoutResult(LocalQueryExecutor.java:62)
at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
at com.im.ijcs.impl.query.LocalQueryExecutor.execute(LocalQueryExecutor.java:59)
at com.im.ijcs.impl.query.DefaultQueryService.findImpl(DefaultQueryService.java:162)
at com.im.ijcs.impl.query.DefaultQueryService$FindExecutor.call(DefaultQueryService.java:130)
at com.im.ijcs.impl.query.DefaultQueryService$FindExecutor.call(DefaultQueryService.java:105)
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)
The database is running Oracle SE1 11.2.0.2.v5. All other data tables and views open correctly. Also, when in Oracle SQL Developer I can run the above script and receive all records correctly if I remove the WHERE clause of (1=0) in addition to removing "" from cd_id. (see below)
PASTED: SELECT CHROMOCELL_LIBRARY.COMPOUNDS."cd_id" FROM CHROMOCELL_LIBRARY.COMPOUNDS WHERE (1 = 0) ORDER BY CHROMOCELL_LIBRARY.COMPOUNDS."cd_id" DESC
MODIFIED: SELECT CHROMOCELL_LIBRARY.COMPOUNDS.cd_id FROM CHROMOCELL_LIBRARY.COMPOUNDS ORDER BY CHROMOCELL_LIBRARY.COMPOUNDS.cd_id DESC
Any help would be greatly appreciated. Thanks!
Best,
Adam