openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald Woods (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-1233) Update DerbyDictionary with new reserved words
Date Mon, 10 Aug 2009 14:08:14 GMT

    [ 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.


Mime
View raw message