A DESCRIPTION OF THE REQUEST :
it would be nice to have named parameters in jdbc like
select * from table where field1=:param1 and field2=:param2
JUSTIFICATION :
one have sometimes query containing one parameter multiple times.
e.g. select * from table where (field1=:param1 and field2=:param2) or (field1=:param1 and field2=:param3)
additionally complex queries are more readable.
EXPECTED VERSUS ACTUAL BEHAVIOR :
EXPECTED -
1. see example obove or
2. via jdbc-escape
ACTUAL -
only anonymous parameters allowed.
it would be nice to have named parameters in jdbc like
select * from table where field1=:param1 and field2=:param2
JUSTIFICATION :
one have sometimes query containing one parameter multiple times.
e.g. select * from table where (field1=:param1 and field2=:param2) or (field1=:param1 and field2=:param3)
additionally complex queries are more readable.
EXPECTED VERSUS ACTUAL BEHAVIOR :
EXPECTED -
1. see example obove or
2. via jdbc-escape
ACTUAL -
only anonymous parameters allowed.
- duplicates
-
JDK-6253535 NamedPreparedStatement - Setting the values in PreparedStatement
-
- Closed
-