bind variables with jdbc
From: Ivan <ilee_at_bigpond.net.au>
Date: 30 Mar 2004 15:23:53 -0800
Message-ID: <90137e1b.0403301523.55aed707_at_posting.google.com>
Hi all,
Date: 30 Mar 2004 15:23:53 -0800
Message-ID: <90137e1b.0403301523.55aed707_at_posting.google.com>
Hi all,
I have an application that is written in servlets that connects to an oracle database 8.1.7 via jdbc. My DBA has just notify me that I am not using bind variables in my code and was wondering what i'll need to change to utilise this.
At the moment i am just opening a connection, making a statement (sql query) and executing it to return a resultset. Would i need to change all my queries to stored procedures so that bind variables are used or is there another way.
thanks all
Received on Wed Mar 31 2004 - 01:23:53 CEST