bind variables with jdbc

From: Ivan (ilee_at_bigpond.net.au)
Date: 03/31/04

  • Next message: Jim Kennedy: "Re: bind variables with jdbc" 
    Date: 30 Mar 2004 15:23:53 -0800

    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

  • Next message: Jim Kennedy: "Re: bind variables with jdbc"

    Relevant Pages

    • Re: bind variables with jdbc
      ... > oracle database 8.1.7 via jdbc. ... > not using bind variables in my code and was wondering what i'll need ... Use prepared statements. ... Your DBA is correct. ...
      (comp.lang.java.databases)
    • RE: Clob insert problem on a Oracle db with DBI
      ... Use bind variables for your insert statement. ... Clob insert problem on a Oracle db with DBI ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • Re: bind variables with jdbc
      ... > CURSOR_SHARING instance parameter from EXACT to FORCE. ... > Not quite as efficient as using bind variables, ... >> It would not hurt to place some of your more common queries and inserts ... His DBA is correct. ...
      (comp.lang.java.databases)
    • Re: Oracle Shared Mode for Asp.net
      ... should be conducted to the door of unemployment. ... I am a developer, not a dba. ... You are responsibly for not using bind variables, ... horde of incompetent developers? ...
      (comp.databases.oracle.server)
    • Re: is there a JDBC equivalent to Oracles PRO*C DESCRIBE operation?
      ... In PRO*C, if I have a text which represents an unknown SQL statement, I can ... describe it and get the names of bind variables in it. ... Is there any JDBC equivalent for this (I know in JDBC binds are represented ... however oracle-specific JDBC drivers also support the above syntax). ...
      (comp.lang.java.programmer)