You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Fay Wang (JIRA)" <ji...@apache.org> on 2009/12/04 00:16:20 UTC
[jira] Created: (OPENJPA-1413) NPE when update using CASE statement
on Derby
NPE when update using CASE statement on Derby
---------------------------------------------
Key: OPENJPA-1413
URL: https://issues.apache.org/jira/browse/OPENJPA-1413
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Reporter: Fay Wang
Assignee: Fay Wang
Fix For: 2.0.0
Derby Error:
<openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
<openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:822)
at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:893)
at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:889)
at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:565)
at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:341)
at apitests.Client.queryAPITest22(Client.java:133)
at apitests.Client.main(Client.java:77)
Caused by: java.lang.NullPointerException
at org.apache.openjpa.jdbc.kernel.exps.CompareEqualExpression.appendTo(CompareEqualExpression.java:109)
at org.apache.openjpa.jdbc.kernel.exps.WhenCondition.appendTo(WhenCondition.java:70)
at org.apache.openjpa.jdbc.kernel.exps.GeneralCaseExpression.appendTo(GeneralCaseExpression.java:114)
at org.apache.openjpa.jdbc.sql.DBDictionary.appendUpdates(DBDictionary.java:2149)
at org.apache.openjpa.jdbc.sql.DBDictionary.toBulkOperation(DBDictionary.java:2017)
at org.apache.openjpa.jdbc.sql.DBDictionary.toUpdate(DBDictionary.java:1950)
at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:511)
at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:451)
at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:761)
at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1049)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:817)
... 6 more
The following fails agsint Derby:
Query q = em.createQuery(
"update Department d set d.name= " +
" CASE WHEN d.id = 1 THEN 'SoilEngineering'" +
" WHEN d.id = 2 THEN 'Mettalurgy'" +
" ELSE 'Aero'" +
" END");
result_size = q.executeUpdate(); // <--- Error here
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OPENJPA-1413) NPE when update using CASE statement
on Derby
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang closed OPENJPA-1413.
-----------------------------
> NPE when update using CASE statement on Derby
> ---------------------------------------------
>
> Key: OPENJPA-1413
> URL: https://issues.apache.org/jira/browse/OPENJPA-1413
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.0.0
>
>
> Derby Error:
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:822)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:893)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:889)
> at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:565)
> at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:341)
> at apitests.Client.queryAPITest22(Client.java:133)
> at apitests.Client.main(Client.java:77)
> Caused by: java.lang.NullPointerException
> at org.apache.openjpa.jdbc.kernel.exps.CompareEqualExpression.appendTo(CompareEqualExpression.java:109)
> at org.apache.openjpa.jdbc.kernel.exps.WhenCondition.appendTo(WhenCondition.java:70)
> at org.apache.openjpa.jdbc.kernel.exps.GeneralCaseExpression.appendTo(GeneralCaseExpression.java:114)
> at org.apache.openjpa.jdbc.sql.DBDictionary.appendUpdates(DBDictionary.java:2149)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toBulkOperation(DBDictionary.java:2017)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toUpdate(DBDictionary.java:1950)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:511)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:451)
> at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:761)
> at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1049)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:817)
> ... 6 more
> The following fails agsint Derby:
> Query q = em.createQuery(
> "update Department d set d.name= " +
> " CASE WHEN d.id = 1 THEN 'SoilEngineering'" +
> " WHEN d.id = 2 THEN 'Mettalurgy'" +
> " ELSE 'Aero'" +
> " END");
> result_size = q.executeUpdate(); // <--- Error here
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1413) NPE when update using CASE statement
on Derby
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated OPENJPA-1413:
----------------------------------
Affects Version/s: 2.0.0-M3
2.0.0-beta
Fix Version/s: (was: 2.0.0)
2.0.0-beta2
> NPE when update using CASE statement on Derby
> ---------------------------------------------
>
> Key: OPENJPA-1413
> URL: https://issues.apache.org/jira/browse/OPENJPA-1413
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0-M3, 2.0.0-beta
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.0.0-beta2
>
>
> Derby Error:
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:822)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:893)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:889)
> at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:565)
> at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:341)
> at apitests.Client.queryAPITest22(Client.java:133)
> at apitests.Client.main(Client.java:77)
> Caused by: java.lang.NullPointerException
> at org.apache.openjpa.jdbc.kernel.exps.CompareEqualExpression.appendTo(CompareEqualExpression.java:109)
> at org.apache.openjpa.jdbc.kernel.exps.WhenCondition.appendTo(WhenCondition.java:70)
> at org.apache.openjpa.jdbc.kernel.exps.GeneralCaseExpression.appendTo(GeneralCaseExpression.java:114)
> at org.apache.openjpa.jdbc.sql.DBDictionary.appendUpdates(DBDictionary.java:2149)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toBulkOperation(DBDictionary.java:2017)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toUpdate(DBDictionary.java:1950)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:511)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:451)
> at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:761)
> at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1049)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:817)
> ... 6 more
> The following fails agsint Derby:
> Query q = em.createQuery(
> "update Department d set d.name= " +
> " CASE WHEN d.id = 1 THEN 'SoilEngineering'" +
> " WHEN d.id = 2 THEN 'Mettalurgy'" +
> " ELSE 'Aero'" +
> " END");
> result_size = q.executeUpdate(); // <--- Error here
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1413) NPE when update using CASE statement
on Derby
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated OPENJPA-1413:
----------------------------------
Affects Version/s: (was: 2.0.0-beta)
Fix Version/s: (was: 2.0.0-beta2)
2.0.0-beta
> NPE when update using CASE statement on Derby
> ---------------------------------------------
>
> Key: OPENJPA-1413
> URL: https://issues.apache.org/jira/browse/OPENJPA-1413
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0-M3
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 1.3.0, 2.0.0-beta
>
>
> Derby Error:
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:822)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:893)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:889)
> at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:565)
> at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:341)
> at apitests.Client.queryAPITest22(Client.java:133)
> at apitests.Client.main(Client.java:77)
> Caused by: java.lang.NullPointerException
> at org.apache.openjpa.jdbc.kernel.exps.CompareEqualExpression.appendTo(CompareEqualExpression.java:109)
> at org.apache.openjpa.jdbc.kernel.exps.WhenCondition.appendTo(WhenCondition.java:70)
> at org.apache.openjpa.jdbc.kernel.exps.GeneralCaseExpression.appendTo(GeneralCaseExpression.java:114)
> at org.apache.openjpa.jdbc.sql.DBDictionary.appendUpdates(DBDictionary.java:2149)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toBulkOperation(DBDictionary.java:2017)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toUpdate(DBDictionary.java:1950)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:511)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:451)
> at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:761)
> at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1049)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:817)
> ... 6 more
> The following fails agsint Derby:
> Query q = em.createQuery(
> "update Department d set d.name= " +
> " CASE WHEN d.id = 1 THEN 'SoilEngineering'" +
> " WHEN d.id = 2 THEN 'Mettalurgy'" +
> " ELSE 'Aero'" +
> " END");
> result_size = q.executeUpdate(); // <--- Error here
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1413) NPE when update using CASE statement
on Derby
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated OPENJPA-1413:
----------------------------------
Fix Version/s: 1.3.0
> NPE when update using CASE statement on Derby
> ---------------------------------------------
>
> Key: OPENJPA-1413
> URL: https://issues.apache.org/jira/browse/OPENJPA-1413
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0-M3, 2.0.0-beta
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 1.3.0, 2.0.0-beta2
>
>
> Derby Error:
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:822)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:893)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:889)
> at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:565)
> at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:341)
> at apitests.Client.queryAPITest22(Client.java:133)
> at apitests.Client.main(Client.java:77)
> Caused by: java.lang.NullPointerException
> at org.apache.openjpa.jdbc.kernel.exps.CompareEqualExpression.appendTo(CompareEqualExpression.java:109)
> at org.apache.openjpa.jdbc.kernel.exps.WhenCondition.appendTo(WhenCondition.java:70)
> at org.apache.openjpa.jdbc.kernel.exps.GeneralCaseExpression.appendTo(GeneralCaseExpression.java:114)
> at org.apache.openjpa.jdbc.sql.DBDictionary.appendUpdates(DBDictionary.java:2149)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toBulkOperation(DBDictionary.java:2017)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toUpdate(DBDictionary.java:1950)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:511)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:451)
> at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:761)
> at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1049)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:817)
> ... 6 more
> The following fails agsint Derby:
> Query q = em.createQuery(
> "update Department d set d.name= " +
> " CASE WHEN d.id = 1 THEN 'SoilEngineering'" +
> " WHEN d.id = 2 THEN 'Mettalurgy'" +
> " ELSE 'Aero'" +
> " END");
> result_size = q.executeUpdate(); // <--- Error here
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (OPENJPA-1413) NPE when update using CASE
statement on Derby
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang resolved OPENJPA-1413.
-------------------------------
Resolution: Fixed
> NPE when update using CASE statement on Derby
> ---------------------------------------------
>
> Key: OPENJPA-1413
> URL: https://issues.apache.org/jira/browse/OPENJPA-1413
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.0.0
>
>
> Derby Error:
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> <openjpa-2.0.0-SNAPSHOT-r422266:883808 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: null
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:822)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:893)
> at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:889)
> at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:565)
> at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:341)
> at apitests.Client.queryAPITest22(Client.java:133)
> at apitests.Client.main(Client.java:77)
> Caused by: java.lang.NullPointerException
> at org.apache.openjpa.jdbc.kernel.exps.CompareEqualExpression.appendTo(CompareEqualExpression.java:109)
> at org.apache.openjpa.jdbc.kernel.exps.WhenCondition.appendTo(WhenCondition.java:70)
> at org.apache.openjpa.jdbc.kernel.exps.GeneralCaseExpression.appendTo(GeneralCaseExpression.java:114)
> at org.apache.openjpa.jdbc.sql.DBDictionary.appendUpdates(DBDictionary.java:2149)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toBulkOperation(DBDictionary.java:2017)
> at org.apache.openjpa.jdbc.sql.DBDictionary.toUpdate(DBDictionary.java:1950)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:511)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:451)
> at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:761)
> at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1049)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:817)
> ... 6 more
> The following fails agsint Derby:
> Query q = em.createQuery(
> "update Department d set d.name= " +
> " CASE WHEN d.id = 1 THEN 'SoilEngineering'" +
> " WHEN d.id = 2 THEN 'Mettalurgy'" +
> " ELSE 'Aero'" +
> " END");
> result_size = q.executeUpdate(); // <--- Error here
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.