Call SQL query from Java code

Question

I executed this SQL query in SQL developer successfully:

SELECT
    COUNT(*) "All",
    COUNT(CASE WHEN TYPE = 'Critical' THEN 1 END) "Critical",
    COUNT(CASE WHEN TYPE = 'Info' THEN 1 END) "Info",
    COUNT(CASE WHEN TYPE = 'Warning' THEN 1 END) "Warning",
    COUNT(CASE WHEN TYPE = 'Error' THEN 1 END) "Error"
FROM
    EVENT;

But when I try to execute the query this way i get error

dbRequest.setPreparedStatement("SELECT "
+ " COUNT(*) 'All',"
+ " COUNT(CASE WHEN TYPE = 'Critical' THEN 1 END) \"Critical\", "
+ " COUNT(CASE WHEN TYPE = 'Info' THEN 1 END) \"Info\", "
+ " COUNT(CASE WHEN TYPE = 'Warning' THEN 1 END) \"Warning\", "
+ " COUNT(CASE WHEN TYPE = 'Error' THEN 1 END) \"Error\" "
+ " FROM "
+ " EVENT");

Error:

SQL exception: Cannot get object 923: ORA-00923: FROM keyword not found where expected

Do you have any idea how i can fix this issue?

'All' should be \"All\"

Husqvik
– Husqvik

2015-12-27 22:19:01 +00:00
Commented Dec 27, 2015 at 22:19 — Husqvik
– Husqvik, Commented Dec 27, 2015 at 22:19

Anthony Raymond · Accepted Answer · 2016-06-21 13:25:47Z

2

You mixed up quotes in your request :

On line two, you must replace '' by "

dbRequest.setPreparedStatement("SELECT "
+ " COUNT(*) \"All\","
+ " COUNT(CASE WHEN TYPE = 'Critical' THEN 1 END) \"Critical\", "
+ " COUNT(CASE WHEN TYPE = 'Info' THEN 1 END) \"Info\", "
+ " COUNT(CASE WHEN TYPE = 'Warning' THEN 1 END) \"Warning\", "
+ " COUNT(CASE WHEN TYPE = 'Error' THEN 1 END) \"Error\" "
+ " FROM "
+ " EVENT");

edited Jun 21, 2016 at 13:25

answered Dec 27, 2015 at 22:42

Anthony Raymond

7,8726 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Call SQL query from Java code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related