inner joing queries don't work ?

[blackangel]

Hi !

I'm using Inner Joing queries to perform a cross selection
and it shows up that the word 'inner' is appended to the
table name.



findByCustom
inner join custom on custom.cid = table.id where custom.desc = {0}
id



The SQL engine shows up the following:

14:31:07: Con ID: 3814691 [druid] com.pointbase.jdbc.jdbcConnection::prepareStatement( java.lang.String )( "SELECT TABLE.id FROM TABLEinner join custom on custom.cid = table.id where custom.desc = ? ORDER BY id" )

If I insert space after the tag then of course
it comes out as

select TABLE.id where inner join custom.cid.....


And that is either an error.

Does anybody else saw that ?

By the way, is there anyway to specify a pure complete
query for a finder without writing only the clauses for
it ?

Thanks !
Pawel.

[davidjencks]

I think you have to use non-inner join syntax

, custom where custom.cid = table.id and custom.desc = {0}

[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...

[davidjencks]

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.

[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 :)

[davidjencks]

So they are. That should be the same in 2.4 and 3.0. Now it looks more like a bug.