sql command not ended properly -- java

Question

Getting error when executing below code.

java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

StringBuilder sb = new StringBuilder();
        sb.append("select");
        sb.append(" region_name,");
        sb.append(" sum(case when  SUBCASE_MEASURED = '1'");
        sb.append(" AND FE_TYPE = 'ASP'");
        sb.append(" AND MONTH = '2018-Jun'");
        sb.append(" then 1");
        sb.append(" else 0 end) count1,");
        sb.append(" sum(case when");
        sb.append(" SUBCASE_MEASURED = '1' AND FE_TYPE = 'ASP' AND QUARTER = 'Q2-2018' then 1 else 0 end) count2");
        sb.append(" from late_start_conf_dsptch_accu");
        sb.append(" GROUP BY region_name;");

It's interesting how you say you're getting the error from that code specifically. All your code is doing is creating a StringBuilder object. — Phylogenesis, Jul 06 '18 at 10:00
This isn't a duplicate of that questions; this isn't an update and the error isn't caused by joins. It's just the same error code... — Alex Poole, Jul 06 '18 at 10:21
Why are you even using StringBuilder for this? Just using plain concatenation it would be simpler to read and if everything is String literals as in your question, it will even produce a single string at **compile** time. — Mark Rotteveel, Jul 06 '18 at 13:11

score 1 · Answer 1 · answered Jul 06 '18 at 10:00

1

Try to remove ; at the end of your sql

answered Jul 06 '18 at 10:00

flyingfox

13,414
3
24
39

semicolon was the issue – simba Jul 06 '18 at 10:03

score 0 · Accepted Answer · edited Jul 19 '18 at 04:06

0

You should not have semi colon at the end of your sql command,

GROUP BY region_name;" should be " GROUP BY region_name

edited Jul 19 '18 at 04:06

soorapadman

4,451
7
35
47

answered Jul 06 '18 at 10:02

dursun

1,861
2
21
38

sql command not ended properly -- java

2 Answers2