Problem with columns named "id"?

blake1024 · **Joined:** Fri Dec 08, 2006 5:44 pm **Posts:** 13

I have a table which looks as follows:

Code:

CREATE TABLE screen_group
(
  screen_group_id varchar(16) NOT NULL, -- Primary key.
  id varchar(30) NOT NULL, -- Name of screen group.
  name varchar(100), -- TODO: what is this for?
  CONSTRAINT screen_group_pkey PRIMARY KEY (screen_group_id),
  CONSTRAINT screen_group_id_key UNIQUE (id)
) 

I am doing:

Code:

...Expression.like("id", ...

The query being generated is:

Code:

... where this_.screen_group_id like .....

Why is it using the field "screen_group_id"? I told it to use the "id" field.
Are fields named "id" treated special?

Thanks.

Blake McBride

MikePloed · **Posted:** Sat Dec 09, 2006 4:52 am

Please post your mapping file!