Following simple query doesn’t work!
with test as (
select 1 from dual
)
select * from test
I logged all message from iBatis with log4j.
There are no error message, no result log.
DEBUG - JakartaCommonsLoggingImpl.debug(27) | {conn-100013} Preparing
Statement: with test as ( select 1 from dual ) select * from test
DEBUG - JakartaCommonsLoggingImpl.debug(27) | {pstm-100014} Executing
Statement: with test as ( select 1 from dual ) select * from test
DEBUG - JakartaCommonsLoggingImpl.debug(27) | {pstm-100014} Parameters:
[]
DEBUG - JakartaCommonsLoggingImpl.debug(27) | {pstm-100014} Types: []
It just gives no result!
I tried searching on archives but it didn’t work well…
Is this impossible? Or is there other way I can use this?
Thanks!
Chimin Park
