Discussions

EJB design: Hibernate Puzzle

  1. Hibernate Puzzle (3 messages)

    Sorry guys for writing query in this section. But i did not find any appro. section to put this query.

    I have a table with PK field as Varchar2.
    accordingly I have value object representing the field with String member attribute.

    now currently the pk value is running serial number starting from 1 and onwards.

    in oracle we can write select max(to_number(pk_field)) from table;

    but hibernate is not taking this query to get me the records.

    Reason is to_number is not qualified method in hibernate scope.

    anyone with solution on this ?

    this is SOS message.

    Regards
    Chetan

    Threaded Messages (3)

  2. Hibernate Puzzle[ Go to top ]

    Hibernate lets you submit SQL queries. See Expression.sql()

    Also, you should post Hibernate questions on the forums at forum.hibernate.org where you will get incredibly fast turnaround and many more responses.
  3. Hibernate Puzzle[ Go to top ]

    Thanks Rob:

       I guess I shall do that :)
    somehow I rate theserverside much higher than any other forum.

    :)

    happy working
    Regards
    Chetan
  4. Hibernate Puzzle[ Go to top ]

    Wait 'til you try the Hibernate forums ;-)