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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web10173

  • via Google Groups by kunal mahale, 6 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 openbravo by alostale
    , 1 year ago
    \_PROCESS.procedurename AS NAME,      '' AS TYPE, '' AS referencevalue,      '' AS defaultvalue, '' AS fieldlength, '' AS realname,      (CASE WHEN AD\_PROCESS\_TRL.description IS NULL THEN (CASE WHEN AD\_PROCESS.description IS NULL THEN '' ELSE '\*' END
  • via Pentaho BI Platform Tracking by Sarah Moursalien, 1 year ago
    NOT((sum("ORDERFACT"."TOTALPRICE") is null)) order by CASE WHEN "CUSTOMER_W_TER"."TERRITORY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."TERRITORY" ASC, CASE WHEN "CUSTOMER_W_TER"."COUNTRY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."COUNTRY" ASC]
  • Stack trace

    • 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.avatica.Helper.createException(Helper.java:40) at net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:80) at net.hydromatic.optiq.impl.mongodb.TestOptiq.main(TestOptiq.java:605) Caused by: java.lang.NullPointerException 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.jdbc.MetaImpl.prepare(MetaImpl.java:603) at net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:77) ... 1 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.