hi
i got a problem with a sql string in jdbc
i almways obtain error message
General error;-2009 POS(1) Join columns too long.
but each iddb field are Integer (fixed 10)
so join size must be 60 and not upper than 250 ?
select
item0_.iddb as iddb,
item0_.typ as typ,
item0_.code as code,
item0_.instance as instance,
item0_.partner as partner,
item0_.labe as labe,
item0_.weight as weight,
item0_.score as score
from
ic_item item0_,
ic_feature features1_,
ic_feature features2_,
ic_feature features3_,
ic_feature features4_,
ic_feature features5_,
ic_feature features6_
where
item0_.iddb=features1_.item(+)
and item0_.iddb=features2_.item(+)
and item0_.iddb=features3_.item(+)
and item0_.iddb=features4_.item(+)
and item0_.iddb=features5_.item(+)
and item0_.iddb=features6_.item(+)
and ((
((features1_.valu is null )or(features1_.valu=? ))and((features1_.typ
is
null )or(features1_.typ=? ))and(features1_.code=? )
and((features2_.valu is
null )or(features2_.valu=? ))and(features2_.code=? )
and((features3_.valu is
null )or(features3_.valu=? ))and(features3_.code=? )
and((features4_.valu is
null )or(features4_.valu=? ))and(features4_.code=? )
and((features5_.valu is
null )or(features5_.valu=? ))and(features5_.code=? )
and((features6_.valu is
null )or(features6_.valu=? ))and(features6_.code=? )
))
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
