i have the following sql
which is valid in sql+
but blows up through the thin jdbc
now i've got valid sql (from an sql+ standpoint, it returns
results), but i'm getting an exception from the jdbc thin
.......
Select
to_char(creationDate, 'yyyy') as object1,
sum (amount) as object2,
count (*) as object3
from
donation
where
entityId = 367080 group by to_char(creationDate, 'yyyy')
java.sql.SQLException: Invalid column name
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:251)
at
oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java,
Compiled Code)
at
oracle.jdbc.driver.OracleResultSet.findColumn(OracleResultSet.java,
Compiled Code)
at oracle.jdbc.driver.OracleResultSet.getObject(OracleResultSet.java,
Compiled Code)
any suggestions?
thanks
jw