when developing servlet, inside of service i opened a connection, and and preparestatement(select empname from emp where id=?);
each time user connect to this page, i will soft parse this statement once.
how to code so i can softparse only once and forever?
or much less than 1 soft parse per execution?