SQL Case Statement Problem with Maxdb

56 Views

Hello,

I'm running a J2E application on Netweaver AS. I have on problem that I just cannot figure out.

The statement works in SQL Studio but when I try to code it it does not work at all.

select COLA, SUM(CASE WHEN COLB=10 THEN 1 ELSE 0 END) from TABLE group by COLA

When executed as statement in Java I get:

Error [javax.servlet.ServletException: java.lang.IllegalStateException: illegal stack size: 4

contents:

com.sap.sql.tree.SelectStatement

com.sap.sql.tree.IntegerLiteral

com.sap.sql.tree.ComparisonPredicate], with root cause [java.lang.Exception: java.lang.IllegalStateException: illegal stack size: 4

contents:

com.sap.sql.tree.SelectStatement

com.sap.sql.tree.IntegerLiteral

com.sap.sql.tree.ComparisonPredicate].

Any thoughts on that? Thanks!

Edited by: MD on Feb 18, 2009 7:37 PM