IBM Support

The error message "java.sql.SQLException: ORA-00933: SQL command not properly ended" appears when using an alias in the "SELECT" statement

Technote (troubleshooting)


When using an alias in a SELECT statment on Oracle® database
for example,

SELECT a.column from table as a

the outcome is:
java.sql.SQLException: ORA-00933: SQL command not properly ended

and in the editor the SELECT statment becomes:

SELECT column from table as a

Resolving the problem

This issue has been identified as a product defect and has been logged under APAR PK62050.

Cross Reference information
Segment Product Component Platform Version Edition
Software Development Rational Software Architect Data Access Applications Windows 7.0,,,,, All Editions

Document information

More support for: Rational Application Developer for WebSphere Software
Data Access Applications

Software version: 7.0,,,,,

Operating system(s): Windows

Software edition: All Editions

Reference #: 1297000

Modified date: 23 November 2010