hi there wondering if anyone can shed any light on this prob i am having:
environment:
java 1.4
ojdbc 10.2.0.2
oracle 10.2
weblogic 9.1
have a query running sub second on sqlplus and through a
test class i generated to use
jdbc. however in the application it is taking 20secs and is taking this time once accessing the jdbc method ps.executeQuery(). Other queries (the same query without a predicate being added) runs sub second on the app so i am mighty confused.
Anyone? thanks in advance.
R.