When performing a simple query against a JDBC Oracle data source, if the query contains a "Group by" clause, the query fails with the error "ORA-00933: SQL Command not properly ended".

Steps to Reproduce

  1. Create an Oracle JDBC data source with a SQL statement containing a where clause and group by.
    For example:  select column1, count(*) from table1 where 1=1 group by column1
  2. Try to load 20 records.
    An error message is displayed.


Wrap the SQL statement with outer select and also add "where 1=1" at the end of the statement, such as in the following:

select * from (select column1, count(*) from table1 where 1=1 group by column1) where 1=1

Related Problem: PRB674204

Seen In

Fuji Patch 12 Hot Fix 1

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-08-02 12:34:08