Sergey,
Thanks for reporting these issues!
> 1. We can not use "connect by" clause if we use "where" before in select
> statement, because of SelectConditionStep extends SelectGroupByStep instead
> of SelectConnectByStep.
True, that's a flaw in the DSL structure, nice finding. As a
workaround, you could either cast the SelectConditionStep manually to
SelectConnectByStep:
((SelectConnectByStep)
create.select()
.from(ABC)
.where(A.equal(B)))
.connectBy(...)
.startWith(...)
Or you can try adding the CONNECT BY clause using the SelectQuery API:
SelectQuery select =
create.select()
.from(ABC)
.where(A.equal(B))
.getQuery();
select.addConnectBy(...);
select.setConnectByStartWith(...);
I'll fix this ASAP on trunk and in the next 1.6.x maintenance release:
https://sourceforge.net/apps/trac/jooq/ticket/925
> 2. Operation AbstractRecord.into failed to copy member with type
> java.sql.Date (from record), to the member with type java.util.Date (in some
> bean). In our hot fix we replaced rows TypeUtils.convert:177
> if (toClass == fromClass) {
> return (T) from;
> }
> with:
> if (toClass.isAssignableFrom(fromClass)) {
> return (T) from;
> }
I'll have to verify this. There are currently no integration tests
checking up on this conversion. If I can reproduce this, this too will
be fixed in trunk and 1.6.x:
https://sourceforge.net/apps/trac/jooq/ticket/926
Cheers
Lukas
2011/11/11 Sergey Epik <[email protected]>:
> Hello Lukas,
>
> We found the following issues:
>
> 1. We can not use "connect by" clause if we use "where" before in select
> statement, because of SelectConditionStep extends SelectGroupByStep instead
> of SelectConnectByStep.
>
> 2. Operation AbstractRecord.into failed to copy member with type
> java.sql.Date (from record), to the member with type java.util.Date (in some
> bean). In our hot fix we replaced rows TypeUtils.convert:177
> if (toClass == fromClass) {
> return (T) from;
> }
> with:
> if (toClass.isAssignableFrom(fromClass)) {
> return (T) from;
> }
>
> Best regards,
> Sergey
>
>
