just having a bit of trouble with hsql syntax. I've read the other posts and I guess I'm stupid cos I still dont get it.

Ideally i can use a prepared statement using session.find the problem is I've a joing table thats not a java object.

I want to do this in a find method or query if i must

select distinct c.* from category as c, category_season cs where c.id = ? and cs.id = ?


the problem is there's not java class modeling category_season so i've been trying

list = session.find("from com.foo.Category as c , category_season as cs where c.id = ? and cs = ?",new Object[] {catId,seasonId},Type[] {..});

of course to no avail.

I read the post linked on the FAQ's .. do i have to use createSQLQuery and do all that jazz with the braces or is there a way using find.

Cheers Mark

I'm sure there must be something I'm missing although it could be the black team as moved from sql docs to java api's.

I've gone through the docs and I'm very happy that cats have kittens and such like but how do i do a select statement like the one i described when one of the tables isn't a java object?

This must come up all the time wit many-to-many relationships so please someone show me how stupid i am , and/or point to me to some concise documention that i've been too stupid to notice.

Cheers Mark

if category_season is an association table, you should have mapped Category, Season and a many-to-many between them,
so
does the job.
If categorySeason has property (property inside the association link), then you should map it.