ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From =?ks_c_5601-1987?B?udrEobnO?= <cmp...@daumcorp.com>
Subject How can I use Oracle's "WITH" Clause?
Date Sun, 23 Mar 2008 09:15:07 GMT
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

 


Mime
View raw message