3

I am using query

select x 
from table1 x 
order by x.it desc

It is working good when I use it with Postgres but whenever i change the database and start to use oracle it is throwing an error that is,

ERROR -- ORA-01722: invalid number
org.hibernate.exception.SQLGrammarException: could not execute query

Improve this question
7
  • Are you changing the database dialect also? Commented Apr 1, 2016 at 8:17
  • 1
    Show us your table definition. What is the type of the it column? Commented Apr 1, 2016 at 8:19
  • I have changed the database and my software is working good with all the HQL query , only this query is throwing an error while executing Commented Apr 1, 2016 at 8:20
  • It is x.id and it number type in oracle Commented Apr 1, 2016 at 8:22
  • 1
    I asked about database dialect? stackoverflow.com/questions/4369944/… Commented Apr 1, 2016 at 8:26
Related questions
1394
How do I limit the number of rows returned by an Oracle query after ordering?
238
error: ORA-65096: invalid common user or role name in Oracle database
0
DatabaseError: ORA-01722: invalid number
Load 4 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.