Oracle SQL - Reusing a bind variable on a query called through JDBC

Question

If i have a query that is similar to the one shown below

select first_name, author, location
from author_details
where first_name=?

The ? value is populated on the Java side using

statement = getConnection().prepareStatement(MY_QUERY);
            statement.setString(1, name);

I want to update the query for an additional check in the where clause:

select first_name, author, location
from author_details
where first_name=? or last_name=?

I want to use the same value that is passed in as the 'name' from the java code. Is it possible to use the same passed in value to check both the first_name and last_name or do i have to add another statement.setString(2, name) entry on the java code?

I know within SQLPlus i can declare a variable and use it later but im not sure how to do the same on an sql query executed through JDBC

rgettman · Accepted Answer · 2014-03-21 18:54:31Z

1

JDBC (for Oracle at least) creates distinct bind variable names for all ? placeholders in the PreparedStatement query. You can't have one setString call cover multiple bind variables. That means that you'll have to add another call to setString on the second parameter, even if you're passing in the same name variable.

answered Mar 21, 2014 at 18:54

rgettman

179k30 gold badges282 silver badges365 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle SQL - Reusing a bind variable on a query called through JDBC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related