Hibernate Community • View topic - PostgreSQLDialect can't handle order property

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

PostgreSQLDialect can't handle order property

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

blindmen

Post subject: PostgreSQLDialect can't handle order property

Posted: Mon Apr 05, 2010 5:33 pm

Newbie

Joined: Fri Apr 02, 2010 8:40 am
Posts: 9

Hi all

when performing :

Code:

insert into public.component (parent_id, component_type, name, order, id) values ('31e207e8-28e6-4bdb-82d3-a694747ce785', '70371eb6-e9b6-4d07-bc80-837e9cb20fea', 'delete me', NULL, '4028828227cfaf100127cfc708cf0004')

with org.hibernate.dialect.PostgreSQLDialect set
and
PostgreSQL 8.3 used as DB,
and
Hibernate 3.3.2 GA

I'm getting

Code:

SEVERE: ERROR: syntax error at or near "order"
  Position: 64
Apr 5, 2010 10:01:20 PM org.hibernate.event.def.AbstractFlushingEventListener performExecutions
SEVERE: Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

I know that order should be quoted, by I assume hibernate should handle this, shouldn't it ?

and btw do you know what is the difference between :
org.hibernate.dialect.PostgreSQLDialect
and
org.hibernate.dialect.ProgressDialect

Thanks

Top