Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-6350729

named parameters

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Duplicate
    • Icon: P4 P4
    • None
    • 5.0
    • core-libs
    • x86
    • linux

      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.

            lancea Lance Andersen
            gmanwanisunw Girish Manwani (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:
              Imported:
              Indexed: