java.jdbc

Solve duplicate column label issue

Details

  • Type: Enhancement Enhancement
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Completed
  • Affects Version/s: None
  • Fix Version/s: None
  • Component/s: None
  • Labels:
    None

Description

Per Peter Siewart (and others):

– While working with clojure.java.jdbc, I kept running into the "ResultSet must have unique column labels" exception, so I rewrote it to automatically rename duplicate columns. Now, I can run "SELECT * FROM tbl1 JOIN tbl2 ON tbl1.id = tbl2.id" without causing any errors.

This would definitely be a nice enhancement but so far no one with a signed CA has offered a patch

Figuring out the appropriate renaming strategy is key - a sensible default with an optional function to allow users to specify how to do this? Or perhaps only renaming if users specify such a function?

Activity

Hide
Sean Corfield added a comment -

Applied a variant of Peter's patch and added unit tests.

Show
Sean Corfield added a comment - Applied a variant of Peter's patch and added unit tests.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: