Re: bind variables with jdbc

Use prepared statments like Jim explained. It would not hurt to place some of your more common queries and inserts into Stored Procedures.

SPs help with big queries updates, or inserts.

"Ivan" <ilee_at_bigpond.net.au> wrote in message news: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 Tue Mar 30 2004 - 22:37:48 CST