HWBOT
  1. HWBOT
  2. HWBOT-1048

jdbc connector might have problems with MySQL 5.6

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: hwbot v5.7.0
    • Labels:
      None

      Description

      I installed MySQL 5.6 on my laptop and they seem to have removed OPTION SQL_SELECT_LIMIT=<number>
      Apparently it has been deprecated for a long time but the jdbc connector hasn't been updated for this yet.

        Activity

        Hide
        Dennis Devriendt added a comment -
        Latest connector, 5.1.23 seems to fix it, only change to the source code I had to do was add Serializable interface to the class LibraryItem, other than that everything seems to work just fine. All tests succeed.

        Will close issue when Frederik doesn't have a problem with updating the mysql connector.
        Show
        Dennis Devriendt added a comment - Latest connector, 5.1.23 seems to fix it, only change to the source code I had to do was add Serializable interface to the class LibraryItem, other than that everything seems to work just fine. All tests succeed. Will close issue when Frederik doesn't have a problem with updating the mysql connector.
        Hide
        Build Server added a comment -
        Integrated in HWBOT v4 #2844 (See [http://dev.hwbot.org/job/HWBOT%20v4/2844/])
            HWBOT-1048

        jdbc connector might have problems with MySQL 5.6

        dennis :
        Files :
        * /hwbot/trunk/pom.xml
        * /hwbot/trunk/src/main/java/org/hwbot/persistence/LibraryItem.java
        Show
        Build Server added a comment - Integrated in HWBOT v4 #2844 (See [ http://dev.hwbot.org/job/HWBOT%20v4/2844/ ])      HWBOT-1048 jdbc connector might have problems with MySQL 5.6 dennis : Files : * /hwbot/trunk/pom.xml * /hwbot/trunk/src/main/java/org/hwbot/persistence/LibraryItem.java
        Hide
        Dennis Devriendt added a comment -
        reverted changes, keep dev and prod environment the same. Will update once we use MySQL 5.6 on production.
        Show
        Dennis Devriendt added a comment - reverted changes, keep dev and prod environment the same. Will update once we use MySQL 5.6 on production.
        Hide
        Build Server added a comment -
        Integrated in HWBOT v4 #2849 (See [http://dev.hwbot.org/job/HWBOT%20v4/2849/])
            HWBOT-1048

        jdbc connector might have problems with MySQL 5.6

        rollback, not yet

        dennis :
        Files :
        * /hwbot/trunk/pom.xml
        * /hwbot/trunk/src/main/java/org/hwbot/persistence/LibraryItem.java
        Show
        Build Server added a comment - Integrated in HWBOT v4 #2849 (See [ http://dev.hwbot.org/job/HWBOT%20v4/2849/ ])      HWBOT-1048 jdbc connector might have problems with MySQL 5.6 rollback, not yet dennis : Files : * /hwbot/trunk/pom.xml * /hwbot/trunk/src/main/java/org/hwbot/persistence/LibraryItem.java

          People

          • Assignee:
            Dennis Devriendt
            Reporter:
            Dennis Devriendt
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: