will "select '1' from dual" gets to the server side?

I'm trying to config the "validationQuery" property of my tomcat 5.5, I'm wondering if I use "select '1' from dual' as my test query, will the jdbc driver send this to the db server side or just handl it in local, I guess it should send it to server side, because all statement is compiled in the db side not in the thin client side, right? Anybody has answer? thanks very much

BTW, my db is oracle 10g, the reason I want to use this test query is because it does not depend on any table.

Thanks very much

[529 byte] By [gt_gta] at [2007-11-27 3:45:58]
# 1
My bet is it will go to the server. You could snoop the tcp stream to verify or ask the driver implementor (oracle technet?), but to be sure it gets to the server you could change the select to a non-constant.
developer_jbsa at 2007-7-12 8:49:43 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...