Uploaded image for project: 'Spring Framework'
  1. Spring Framework
  2. SPR-9550

Properties in the JDBC URL got stripped out for Mysql connector

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Invalid
    • Affects Version/s: 3.1.1
    • Fix Version/s: None
    • Component/s: Data:JDBC
    • Last commented by a User:
      true

      Description

      Mysql connector allows to specify many properties in the jdbc URL for different purposes. Some features are only available this way. However when a query is performed through Spring jdbcTemplate, the properties set in the URL have no effect.

      For example, using "jdbc:mysql://localhost:3306/mydb?includeThreadNamesAsStatementComment=true" with 5.1.15 connector can show the Java thread name in the "show processlist" output, a great feature for debugging. If jdbc API is used directly the thread name shows up as expected, but not so if the query is made through jdbc template.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              dumbird Rui Li
              Last updater:
              Juergen Hoeller
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 19 weeks, 1 day ago