openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Curtis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OPENJPA-2488) select with fixed column doesn't run
Date Fri, 11 Apr 2014 13:17:14 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13966470#comment-13966470
] 

Rick Curtis commented on OPENJPA-2488:
--------------------------------------

Do you get the same problem if you use JPQL rather than criteria? Rather than using your 'dirty'
work around, can you try adding another column to your Entity? I know I've encountered a problem
in the past where OpenJPA doesn't like Entities that only have one defined.

> select with fixed column doesn't run
> ------------------------------------
>
>                 Key: OPENJPA-2488
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2488
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 2.2.2
>            Reporter: Daniele Pirola
>
> Suppose to have a mapped Entity named Dual and want to retrieve the sysdate from the
db.
> If you try this code:
> Timestamp ts;
> CriteriaBuilder builder = entityManager.getCriteriaBuilder();
> CriteriaQuery<Timestamp> criteria = builder.createQuery(Timestamp.class);
> criteria.select(builder.currentTimestamp());
> criteria.from(Dual.class);
> ts =entityManager.createQuery(criteria).setMaxResults(1).getSingleResult();
> openjpa build a query like this:
> SELECT CURRENT_TIMESTAMP FROM  WHERE ROWNUM <= ?
> without the table Dual specified.
> This is the Dual class but the error always happens with other real table:
> @Entity
> @Table(name = "DUAL")
> @Access(AccessType.FIELD)
> public class Dual implements Serializable {
>     @Id
>     @Column(name = "DATE_VALUE")
>     @Temporal(TemporalType.TIMESTAMP)
>     private Date date;
>     public Date getDate() {
>         return date;
>     }
>     public void setDate(Date date) {
>         this.date = date;
>     }
> }



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message