RE: Database programming standards
- From: Leslie Tierstein <leslie_tierstein@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 3 Jun 2004 08:51:09 -0700 (PDT)
Not true.
See: http://www.orafaq.com/articles/archives/000036.htm
Excerpt follows:
The next question I had, though, was what about VB, Java and other applications
that fire SQL queries against an Oracle database. How do these use bind
variables? Do you have to in fact split your SQL into two statements, one to
set the bind variable, and one for the statement itself?
In fact, the answer to this is actually quite simple. When you put together an
SQL statement using Java, or VB, or whatever, you usually use an API for
accessing the database; ADO in the case of VB, JDBC in the case of Java. All of
these APIs have built-in support for bind variables, and it's just a case of
using this support rather than just concatenating a string yourself and
submitting it to the database.
For example, Java has PreparedStatement, which allows the use of bind
variables, and Statement, which uses the string concatenation approach. If you
use the method that supports bind variables, the API itself passes the bind
variable value to Oracle at runtime, and you just submit your SQL statement as
normal. There's no need to separately pass the bind variable value to Oracle,
and actually no additional work on your part. Support for bind variables isn't
just limited to Oracle - it's common to other RDBMS platforms such as Microsoft
SQL Server, so there's no excuse for not using them just because they might be
an Oracle-only feature.
"Duret, Kathy" <kduret@xxxxxxxxxxxxxxxxxxxx> wrote:
We have the same problem here, they don't want to write sql. They claim
there is no way to use bind variables in Java (we are using Jbosse). I
haven't had time to look into it. I would assume there is. Can someone
point me to a link or forum?
Thanks,
Kathy
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]
Sent: Thursday, June 03, 2004 9:46 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Database programming standards
Donald,
My assumption about #2 was that they would abandon all the stored procs &
packs that have been developed. That, to me, implies that they would also
create Java objects to perform sql without using bind variables. My
experience is that Java programmers do not want to learn about bind
variables - indeed - the Java programmers I see here *barely* know how to
right (sp???) decent sql. They don't have the experience or time to learn
how to do it right.
Just me pessimistic view of things.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Freeman, Donald [mailto:dofreeman@xxxxxxxxxxx]
Sent: Thursday, June 03, 2004 10:37 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Database programming standards
1 and 3 I understand. I'm missing something about number 2. If they code
their application, using bind variables, why will there be a sql-reuse
issue? I would expect that cursors would be shared etc.. And to be fair they
haven't said they want to move all of it but I'm not sure what criteria they
would use to move which functionality. I kind of expect that they will be
forced to learn pl/sql.
> 1). It will cost them time and money to move all of the
> logic to their application now.
> 2). Long term, you will guarantee that response-time of the
> application will slow because of the sql-reuse issue.
> 3). It is stupid idea to now change the implementation plan.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
This transmission contains information solely for intended recipient and may
be privileged, confidential and/or otherwise protect from disclosure. If
you are not the intended recipient, please contact the sender and delete all
copies of this transmission. This message and/or the materials contained
herein are not an offer to sell, or a solicitation of an offer to buy, any
securities or other instruments. The information has been obtained or
derived from sources believed by us to be reliable, but we do not represent
that it is accurate or complete. Any opinions or estimates contained in
this information constitute our judgment as of this date and are subject to
change without notice. Any information you share with us will be used in
the operation of our business, and we do not request and do not want any
material, nonpublic information. Absent an express prior written agreement,
we are not agreeing to treat any information confidentially and will use any
and all information and reserve the right to publish or disclose any
information you share with us.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
Other related posts:
