Hi all, When I was using the "validationQuery" and "testOnBorrow" properties to ensure connection works fine, did it mean two round-trip happened? Validation query and my SQL query? thus, how to reduce the db round-trip while the query became huge?
I knew iBatis to mysql would not ensure connection valid while disabling testOnBorrow, if it is the same toward oracle? is there any workaound to reduce db round-trip? any help is appreciated, thanks. Best regards, Joe
