Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

HELP.oracle jdbc thin w/expression column throws exception

2 views
Skip to first unread message

Jon Williams

unread,
Jan 6, 2000, 3:00:00 AM1/6/00
to
howdy,

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


0 new messages