Re: JDBC, PreparedStatement and named parameters

From:

=?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@vajhoej.dk>

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 20 Jul 2012 22:11:20 -0400

Message-ID:

<500a0fcb$0$292$14726298@news.sunsite.dk>

On 7/20/2012 5:39 AM, Andreas Leitgeb wrote:

I'm rather new to JDBC, and somewhat experienced with
database access in other languages, like with ProC or
with the sqlplus-shell.

While in C/C++ eSql with ProC (not sure about correct
nomenclature) I can use named variables for the parameters,
jdbc seems like it would only allow positional parameters.

With Google, I stumbled over this approach:

   http://www.javaworld.com/javaworld/jw-04-2007/jw-04-jdbc.html

which boils down to pre-processing the sql-statement, replacing
the named variables by "?" while creating an array of the parameters
such, that e.g. a snippet like this:
    "... :a :c :b :a ..." and setting a -> x1, b -> x2, c -> x3
would turn into
    "... ? ? ? ? ..." with an parameter array of { x1, x3, x2, x1 }

That almost looks like what I was hoping for, but when I see
that the article is 5 years old, then I'd hope that something
similar might meanwhile have been turned into a standard...

Does anyone here know of a way to use either named variables,
or at least something like these "foo {1} bar {0}" things
used in jsf4j and java.text.MessageFormat?

JDBC is designed to support all databases.

The only JDBC driver shipping with JDK was the ODBC-JDBC
brudge.

ODBC only support named parameters for SP calls not
for regular SQL statements.

Possibly other database API's does not support it either.

So JDBC does not support named parameters.

You can obviously do the string manipulation stuff and
maybe wrap it nicely. But I assume you do not need help
with that.

Arne