User 8b13ef4f27
03-02-2014 16:14:10
We just installed Instant JChem version 6.2 but now we cannot open our schema. This is the error we receive:
StatementCallback; bad SQL grammar [select
C.OWNER OWNER, C.TABLE_NAME TABLE_NAME, COUNT(*) COUNT
from
ALL_TAB_COLUMNS C, ALL_TABLES T
where
C.TABLE_NAME = T.TABLE_NAME AND C.OWNER = T.OWNER
AND T.DROPPED = 'NO'
AND C.TABLE_NAME != 'JC_IDX_PROPERTY'
AND C.COLUMN_NAME in ('PROP_NAME', 'PROP_VALUE', 'PROP_VALUE_EXT')
group by
C.OWNER, C.TABLE_NAME]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "T"."DROPPED": invalid identifier
The open dialog box first shows: "The database is up to date. No upgrade is needed." but then gives the above error. Is this a problem with Version 6.2?
Bob