Hibernate version:
3

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
ORA-01747: invalid user.table.column, table.column, or column specification

Name and version of the database you are using:
Oracle 9i

The generated SQL (show_sql=true):
SELECT new tbook.mod.ResponseData(count(add), add, weight) FROM Nphcdata WHERE year = 2006 GROUP BY add, weight ORDER BY weight, add

Debug level Hibernate log excerpt:

15:14:25,329 WARN [JDBCExceptionReporter] SQL Error: 1747, SQLState: 42000
15:14:25,329 ERROR [JDBCExceptionReporter] ORA-01747: invalid user.table.column, table.column, or column specification

There is a column in my table called ADD. It looks like hibernate does not entertain this reserved word. I tried using single quotes but it does not work.

In Oracle sql, it works if ADD is in double quotes like
SELECT "ADD", WEIGHT FROM Nphcdata WHERE year = 2006 GROUP BY "ADD"

This does not work in HQL.

Please advise if there is any work around for this problem.

Thank You.
Himanshu

For mysql you can define the table in the mapping file as

Try that and see if it works. Otherwise try something like the following or some other variation



Good luck!

Marius

Thanks for your reply Marius.

I had tried this but it didn't help.

I even tried in the mapping file,

<property name="add" type="java.lang.Long">
<column name='"ADD"' precision="10" scale="0" />
</property>

But no luck.

Thanks though...

- Himanshu

It worked with

<property name="add" type="java.lang.Long">
<column name='"ADD"' precision="10" scale="0" />
</property>


Put the reserved word in the double quotes and wrap it with single quote for the column name.

Thank You.
Himanshu

Thanks for sharing, will make a note of it :)

It seems I did send you on the proper path, if you agree please rate my posting. Thanks!

Marius