java.sql.SQLException: while executing SQL: select e.NAME, CASE WHEN e.dept_ID = (select d.ID from PV_ADMIN.dept d where d.NAME = 'SALES') then 'SALES' ELSE 'Not Matched.' END as department from PV_ADMIN.EMP e

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Google Groups by kunal mahale, 10 months ago
while executing SQL: select e.NAME, CASE WHEN e.dept_ID = (select d.ID from PV_ADMIN.dept d where d.NAME = 'SALES') then 'SALES' ELSE 'Not Matched.' END as department from PV_ADMIN.EMP e
via Google Groups by Sanjay Mhaske, 1 year ago
while executing SQL: SELECT EMP_ID, EMP_NAME,MGR_ID FROM OPTIQ_EMPLOYEE CONNECT BY EMP_ID = MGR_ID
via GitHub by Yancey1989
, 10 months ago
error while executing SQL "select * from (select t2.brand from (select brand,count(1) from DEMO group by brand having count(1) >=2) t1 join (select brand from DEMO ) t2 on t1.brand = t2.brand group by t2.brand) t3 LIMIT 50000": null
via Apache's JIRA Issue Tracker by Victoria Markman, 1 year ago
While closing connection
via GitHub by corndolly
, 2 years ago
exception while executing query: java.lang.String cannot be cast to java.lang.Integer
via apache.org by Unknown author, 2 years ago
error while executing SQL "select "empid" from "hr"."emps" -- select": parse failed: Lexical error at line 2, column 10. Encountered: <EOF> after : ""
java.sql.SQLException: while executing SQL: select e.NAME, CASE WHEN e.dept_ID = (select d.ID from PV_ADMIN.dept d where d.NAME = 'SALES') then 'SALES' ELSE 'Not Matched.' END as department from PV_ADMIN.EMP e
at net.hydromatic.optiq.impl.jdbc.JdbcRules.addSelect(JdbcRules.java:76)
at net.hydromatic.optiq.impl.jdbc.JdbcRules.access$1300(JdbcRules.java:50)
at net.hydromatic.optiq.impl.jdbc.JdbcRules$JdbcAggregateRel.implement(JdbcRules.java:556)
at net.hydromatic.optiq.impl.jdbc.JdbcImplementor.visitChild(JdbcImplementor.java:93)
at net.hydromatic.optiq.impl.jdbc.JdbcRules$JdbcJoinRel.implement(JdbcRules.java:242)
at net.hydromatic.optiq.impl.jdbc.JdbcImplementor.visitChild(JdbcImplementor.java:93)
at net.hydromatic.optiq.impl.jdbc.JdbcRules$JdbcProjectRel.implement(JdbcRules.java:426)
at net.hydromatic.optiq.impl.jdbc.JdbcImplementor.visitChild(JdbcImplementor.java:93)
at net.hydromatic.optiq.impl.jdbc.JdbcToEnumerableConverter.generateSql(JdbcToEnumerableConverter.java:271)
at net.hydromatic.optiq.impl.jdbc.JdbcToEnumerableConverter.implement(JdbcToEnumerableConverter.java:81)
at net.hydromatic.optiq.rules.java.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:65)
at net.hydromatic.optiq.prepare.OptiqPrepareImpl$OptiqPreparingStmt.implement(OptiqPrepareImpl.java:699)
at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:276)
at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:178)
at net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.java:333)
at net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare_(OptiqPrepareImpl.java:242)
at net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepareSql(OptiqPrepareImpl.java:211)
at net.hydromatic.optiq.jdbc.OptiqConnectionImpl.parseQuery(OptiqConnectionImpl.java:142)
at net.hydromatic.optiq.impl.mongodb.TestOptiq.main(TestOptiq.java:605)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.