"AS" before column aliases in select clause

Gert Buys · **Joined:** Wed Jan 07, 2004 6:42 am **Posts:** 3

I'm using Hibernate in a WebLogic - DB2/VSE environment.

I noticed that the SQL generated by Hibernate always contains "as" before column aliases in the select clause. This seems not to be supported by our version of DB2/VSE (mainframe):
Hibernate: select paritairco0_.TAAL_CODE as TAAL_CODE0_, paritairco0_.CPGM_NAAM as CPGM_NAAM0_ from CB.T170TAAL paritairco0_ where paritairco0_.TAAL_CODE=?

The db2 driver returns an error:
[WARN] JDBCExceptionReporter - -SQL Error: -104, SQLState: 42601
[ERROR] JDBCExceptionReporter - -[IBM][CLI Driver][SQLDS/VSE] SQL0104N An unexpected token "AS" was found following "TAAL_CODE". Expected tokens may include: "". SQLSTATE=42601

This is clearly related to our version of DB2 cause it works fine on DB2/NT. The DB2Dialect doesn't change anything on this behavior. The "as" seems to be hardcoded in SelectFragment.toFragmentString(). Are there any means to skip the "as" and produce something like:
select paritairco0_.TAAL_CODE TAAL_CODE0_,....

I'd like to have your opinion on this.

Kind regards,
Gert

[/code]

michael · **Posted:** Wed Jan 07, 2004 9:01 am

As you said, this is hardcoded, but should be easy to patch if you build hibernate from source. Feel free to submit a JIRA entry to make this configurable. I am however quite surprised your DB2 does not support this, this is really basic SQL standard.

emmanuel · **Posted:** Wed Jan 07, 2004 9:45 am

If you patch that, implement that using the Dialect classes

Gert Buys · **Joined:** Wed Jan 07, 2004 6:42 am **Posts:** 3

In fact it's even worse than I thought... DB2/VSE doesn't support any column aliases at all. Patching this in the select clause won't be difficult.

I'm not sure what the consequences are when DB2/VSE is not supporting column aliases. Which approach should be taken in order to make it work with Hibernate? In the Hibernate reference (15.2):

15.2. Alias and property references
The {cat.*} notation used above is a shorthand for "all properties". You may even list the properties explicity,but you must let Hibernate provide SQL column aliases for each property.

How does this relate to the column alias issue?

gavin · **Posted:** Fri Jan 09, 2004 11:48 pm

Quote:

DB2/VSE doesn't support any column aliases at all.

wtf???! This can't possibly be correct .... can it?

(You will not be able to make Hibernate work without the use of column aliases.)

Gert Buys · **Joined:** Wed Jan 07, 2004 6:42 am **Posts:** 3

I'm afraid it IS true. I asked the DBA's about it.

OK, we'll use Hibernate then when we have a decent database system ;-)