[
https://issues.apache.org/jira/browse/OPENJPA-1233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12741331#action_12741331
]
Donald Woods commented on OPENJPA-1233:
---------------------------------------
Rev802801 resolves the 112 test failures due to using column name "none", but
there are still 2 other test failures that need to be addressed before we can
upgrade to a newer Derby level.
testVariableHaving(org.apache.openjpa.persistence.jdbc.query.TestJDBCGrouping)
Time elapsed: 0.093 sec <<< ERROR!
<openjpa-2.0.0-SNAPSHOT-r422266:802138M nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Java exception: ':
java.lang.NullPointerExc
eption'. {prepstmnt 2022464090 SELECT MAX(t0.longField), t2.byteField FROM
AllFieldTypes t0 INNER JOIN AllFieldTypes_AllFieldTypes t1 ON t0.id =
t1.ALLFIELDTYPE
S_ID JOIN AllFieldTypes t2 ON (1 = 1) WHERE (t1.SELFONEMANY_ID = t2.id) GROUP BY
t2.byteField HAVING SUM(t2.intField) = ? [params=(long) 2]} [code=0, state=XJ00
1] at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4554)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4507)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
at
org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1239)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1000)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:856)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:787)
at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:525)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:291)
at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:303)
testAggregateExpressionInHavingExpression(org.apache.openjpa.persistence.jdbc.query.TestMultipleEntityProjection)
Time elapsed: 0.055 sec <<< ERROR!
<openjpa-2.0.0-SNAPSHOT-r422266:802138M fatal general error>
org.apache.openjpa.persistence.PersistenceException: An attempt was made to get
a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4548)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4507)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
at
org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1239)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1000)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:856)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:787)
at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:525)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:291)
at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:303)
at
org.apache.openjpa.persistence.jdbc.query.TestMultipleEntityProjection.testAggregateExpressionInHavingExpression(TestMultipleEntityProjection.java:159)
> Update DerbyDictionary with new reserved words
> ----------------------------------------------
>
> Key: OPENJPA-1233
> URL: https://issues.apache.org/jira/browse/OPENJPA-1233
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 1.0.3, 1.1.0, 1.2.1, 1.3.0, 2.0.0-M2
> Reporter: Donald Woods
> Assignee: Donald Woods
> Fix For: 1.3.0, 2.0.0
>
> Attachments: OPENJPA-1233.patch
>
>
> Derby 10.4.1.3 [DERBY-3460] added new reserved words:NONE and CURRENT_ROLE.
> Derby 10.5.2.0 [DERBY-4268] added new reserved word: SECURITY.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
