Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-8272747

My SQL Connector (Jdriver) does not work with JDK16 but works with JDK8

    • generic
    • generic

      ADDITIONAL SYSTEM INFORMATION :
      JDK16 did not work ( windows and linux both) , JDK 8 worked ( windows and linux both)


      A DESCRIPTION OF THE PROBLEM :
      I have been able to connect to JDBC My SQL connector data base successfully with following environment settings with JDK8/Netbean8 but i am unable to connect with JDK16/netbean12.4

      I have ensured that all the settings are similar between both the Netbean versions and java code to connect to server is also same. I used netbean version to check connectivity only because same code did not work for different JDK. Since latest netbean version 12.4 also did not work with JDBC connection. I suspect it is JDK bug.


      REGRESSION : Last worked in version 8

      STEPS TO FOLLOW TO REPRODUCE THE PROBLEM :

      1. I am using same My SQL Jconnector for Netbean 8.1 and 12.4: mysql-connector-java-8.0.26.jar
      2. I am using same My SQL URL for Netbean 8.1 and 12.4: jdbc:mysql://server:3306/DatabaseTable?zeroDateTimeBehavior=convertToNull
      3. I am using same My SQL connection driver class for Netbean 8.1 and 12.4 : com.mysql.cj.jdbc.Driver
      4. I am using same My SQL connection properties for Netbean 8.1 and 12.4 database.
      clientCertificateKeyStoreUrl file path keyStore.jks
      verifyServerCertificate true
      trustCertificateKeyStorePassword password
      trustCertificateKeyStoreUrl trustStore.jks
      clientCertificateKeyStorePassword password
      useSSL true
      requireSSL true
      sslMode VERIFY_CA



      EXPECTED VERSUS ACTUAL BEHAVIOR :
      EXPECTED -
      Same as Netbean 8.1 connects to data based Netbean 12.4 should also connect to databased with same settings.
      Same as My code compiled for JDK8 works fine, same code compiled for JDK16 should also work fine.

      ---------- BEGIN SOURCE ----------
      Use mysql-connector-java-8.0.26.jar
      ---------- END SOURCE ----------

      CUSTOMER SUBMITTED WORKAROUND :
      No work around

      FREQUENCY : always


            tongwan Andrew Wang
            webbuggrp Webbug Group
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: