ORA-01722 invalid number error with oracle database in hibernate query language

Asked Apr 01 '16 at 08:15

Active Jun 27 '16 at 13:38

Viewed 1,212 times

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

edited Apr 01 '16 at 08:22

asked Apr 01 '16 at 08:15

Madhvendra Thakur

Are you changing the database dialect also? – Predrag Maric Apr 01 '16 at 08:17
1

Show us your table definition. What is the type of the `it` column? – Anton Sarov Apr 01 '16 at 08: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 – Madhvendra Thakur Apr 01 '16 at 08:20
It is x.id and it number type in oracle – Madhvendra Thakur Apr 01 '16 at 08:22
1

I asked about database **dialect**? http://stackoverflow.com/questions/4369944/hibernate-dialect-for-oracle-database-11g – Predrag Maric Apr 01 '16 at 08:26
org.hibernate.dialect.Oracle10gDialect for 11g and I am using this dialect – Madhvendra Thakur Apr 01 '16 at 08:28
Turn on SQL logging, see what exact query is being generated by Hibernate and try to find what's wrong with it. – Predrag Maric Apr 01 '16 at 09:24

0 Answers0