Hibernate Community • View topic - Column alias not supported with db2/vm (sql/ds) database

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Column alias not supported with db2/vm (sql/ds) database

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

jean-fran

Post subject: Column alias not supported with db2/vm (sql/ds) database

Posted: Fri Oct 08, 2004 1:00 pm

Newbie

Joined: Wed Oct 22, 2003 11:52 am
Posts: 3
Location: Qu

Hibernate version:2.1.6

Name and version of the database you are using:DB2/VM

The generated SQL (show_sql=true):select membre0_.no_membre as no_membre from f_membre membre0_ where (membre0_.no_membre=? )

Debug level Hibernate log excerpt:An unexpected token "AS" was found following "NO_MEMBRE". Expected tokens may include: "". SQLSTATE=42601

We use a DB2/VM database. This old DB does not support coloumn alias.

i.e. I can't do : Select toto as t form table.

Is it possible to use hibernate with this limitation. Any workaround ?

thank you.

Top

michael

Post subject:

Posted: Sun Oct 10, 2004 1:36 pm

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

No, not possible. Hibernate depends on using column name aliases.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum