You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Diddle (JIRA)" <ji...@apache.org> on 2010/05/08 21:22:47 UTC

[jira] Created: (OPENJPA-1655) @OrderBy on a Timestamp field fails with Postgres jdbc4 driver

@OrderBy on a Timestamp field fails with Postgres jdbc4 driver
--------------------------------------------------------------

                 Key: OPENJPA-1655
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1655
             Project: OpenJPA
          Issue Type: Bug
          Components: jpa
    Affects Versions: 1.2.2
         Environment: Tomcat 5.5, Eclipse J2ee preview jdbc4 Postgres 8.4
            Reporter: Diddle
            Priority: Minor


It doesn't matter if use @OrderBy on a Timestamp field. ASC DESC, it's all the same.
It seems to be sorting it on another field altogether. It's not the id order.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Re: [jira] Created: (OPENJPA-1655) @OrderBy on a Timestamp field fails with Postgres jdbc4 driver

Posted by Pinaki Poddar <pp...@apache.org>.

Hi
> It seems to be sorting it on another field altogether. It's not the id
> order. 

@OrderBy annotation on a field x is not meant sort query result on field
value of x. The annotation imposes ordering on collection-valued
relationship elements.

Can you please post the query that seemed to *not* sort on the timestamp
field?




-----
Pinaki 
-- 
View this message in context: http://openjpa.208410.n2.nabble.com/jira-Created-OPENJPA-1655-OrderBy-on-a-Timestamp-field-fails-with-Postgres-jdbc4-driver-tp5024311p5030924.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.

[jira] Updated: (OPENJPA-1655) @OrderBy on a Timestamp field fails with Postgres jdbc4 driver

Posted by "Diddle (JIRA)" <ji...@apache.org>.

     [ https://issues.apache.org/jira/browse/OPENJPA-1655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Diddle updated OPENJPA-1655:
----------------------------

    Environment: Tomcat 5.5, Eclipse J2ee preview jdbc4 Postgres 8.4, Java SE Runtime Environment (build 1.6.0_18-b07)  (was: Tomcat 5.5, Eclipse J2ee preview jdbc4 Postgres 8.4)

> @OrderBy on a Timestamp field fails with Postgres jdbc4 driver
> --------------------------------------------------------------
>
>                 Key: OPENJPA-1655
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1655
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jpa
>    Affects Versions: 1.2.2
>         Environment: Tomcat 5.5, Eclipse J2ee preview jdbc4 Postgres 8.4, Java SE Runtime Environment (build 1.6.0_18-b07)
>            Reporter: Diddle
>            Priority: Minor
>
> It doesn't matter if use @OrderBy on a Timestamp field. ASC DESC, it's all the same.
> It seems to be sorting it on another field altogether. It's not the id order.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.