Re: bind variables with jdbc
From: Eugene Staten (estaten_at_NOSPAMPLZcox.net)
Date: 03/31/04
- Previous message: mBird: "Best practices JDBC JSP"
- In reply to: Ivan: "bind variables with jdbc"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 30 Mar 2004 20:37:48 -0800
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@bigpond.net.au> wrote in message
news:90137e1b.0403301523.55aed707@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
- Previous message: mBird: "Best practices JDBC JSP"
- In reply to: Ivan: "bind variables with jdbc"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
