-
1. Re: inner joing queries don't work ?
davidjencks Feb 6, 2002 5:57 PM (in response to blackangel)I think you have to use non-inner join syntax
, custom where custom.cid = table.id and custom.desc = {0} -
2. Re: inner joing queries don't work ?
blackangel Feb 6, 2002 8:01 PM (in response to blackangel)Yeah, that's what I did and of course that helped
but I was just wondering whether it is a JBoss bug
or my particular JDBC driver's problems... -
3. Re: inner joing queries don't work ?
davidjencks Feb 6, 2002 8:29 PM (in response to blackangel)I'm not sure I'd dignify this behavior by calling it a bug... however you certainly went beyond jboss' sql generation capabilities.
I think Dain may have put more ways to explicitly specify the sql in the cmp2 pm, however I don't know exactly what-- the docs on it probably say. -
4. Re: inner joing queries don't work ?
blackangel Feb 7, 2002 5:05 PM (in response to blackangel)Did I ?
Well, 'inner join' requests are described in the
http://www.jboss.org/online-manual/HTML/ch06s07.html
Actually, I just noticed that this was 3.0 documentation
and I'm using 2.4.4... Anyway, it's still documented :) -
5. Re: inner joing queries don't work ?
davidjencks Feb 7, 2002 5:11 PM (in response to blackangel)So they are. That should be the same in 2.4 and 3.0. Now it looks more like a bug.