Wrong SQL-Statement in JiraJdbcProfileProvider?

XMLWordPrintable

    • Type: Bug
    • Resolution: Support Request
    • Priority: Medium
    • 2.0.3
    • Affects Version/s: 2.0.2
    • Component/s: None
    • Environment:

      Confluence 2.0.2 embedded in Jira 3.4.2 standalone with sapdb-Database and external confluence user management via jira

      Error message when starting Tomcat:

      2005-12-08 07:51:01,864 FATAL [user.providers.jira.JiraJdbcProfileProvider] Could not see if [administrator] is handled

      with the following important stack trace line: at com.atlassian.confluence.user.providers.jira.JiraJdbcProfileProvider.getJiraPropertySet(JiraJdbcProfileProvider.java:161)

      which is the following statement:
      ps = conn.prepareStatement("SELECT " + membershipIdCol + " FROM "+ membershipTable +" WHERE user_name = " + username);

      => in my opinion, the problem is the missing >>'<< around username which results in an SQL statement >>... WHERE user_name = administrator<< instead of >>... WHERE user_name = 'administrator'<<

      Could you please check?

              Assignee:
              Unassigned
              Reporter:
              Deleted Account (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: