Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1201

3.4.x has major breaking datetime and timestamp issues

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.4.0, 3.4.1
    • 3.5.0
    • JDBC compatibility
    • None
    • server is 10.11.9 on debian 12

    Description

      Our cloud environment runs with db servers hosted for particular customers in THEIR local headquarter timezone (say MDT). The mid-tier is Java and runs in UTC. The webclient run's in the user's local time zone.

      Prior to 3.4.x series of JDBC drivers everything worked for many years without issue. Changing from 3.3.3 driver to 3.4.x breaks datetime handling generally.

      For example, with 3.3.3 SELECT NOW() yields the correct server time.
      With 3.4.1 this returns UTC.

      Further, if you try to correct this behavior with JDBC connection string parameter connectionTimeZone=SERVER I get the following error:

      ERROR: Unknown zoneId MDT

      It seems to me that whatever the default 3.4.x behavior is it should be compatible with prior versions and not introduce breaking changes.

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            rdyas Robert Dyas
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.