[jira] [Resolved] (NETBEANS-5917) Services -> Database -> My SQL Connector (Jdriver) does not work with Netbean 12.4 but works with Netbean 8.1

["Vikhyat Baxi (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NETBEANS-5917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vikhyat Baxi resolved NETBEANS-5917.
------------------------------------
    Resolution: Fixed

I got this working, I have to set and enable TLS protocol version in connection property with mysql-connector-java-8.0.26.jar while in SSL mode. props.setProperty("enabledTLSProtocols", "TLSv1.2")
{code:java}
// code placeholder

Properties props = new Properties();
props.setProperty("user", USER_SSL);
props.setProperty("password", PASS_SSL);
props.setProperty("useSSL", "true");
props.setProperty("requireSSL", "true");
props.setProperty("verifyServerCertificate", "true");
props.setProperty("sslMode", "VERIFY_CA");
props.setProperty("javax.net.debug", "all");
props.setProperty("enabledTLSProtocols", "TLSv1.2");
props.setProperty("zeroDateTimeBehavior", "convertToNull");

// Setting the truststore
props.setProperty("trustCertificateKeyStoreUrl", TRUST_STORE_URL);
props.setProperty("trustCertificateKeyStorePassword", TRUST_STORE_PASSWORD);

// Setting the keystore
props.setProperty("clientCertificateKeyStoreUrl", KEYSTORE_URL);
props.setProperty("clientCertificateKeyStorePassword", KEYSTORE_PASSWORD);
try {
conn = DriverManager.getConnection(DB_URL, props);
} catch (Exception ex) 
{
Logger.debug(ex);
}
{code}
{{}}

> Services -> Database -> My SQL Connector (Jdriver) does not work with Netbean 12.4 but works with Netbean 8.1
> -------------------------------------------------------------------------------------------------------------
>
>                 Key: NETBEANS-5917
>                 URL: https://issues.apache.org/jira/browse/NETBEANS-5917
>             Project: NetBeans
>          Issue Type: Bug
>         Environment: # I am using same My SQL Jconnector for Netbean 8.1 and 12.4: mysql-connector-java-8.0.26.jar
>  # I am using same My SQL URL for Netbean 8.1 and 12.4: jdbc:mysql://server:3306/DatabaseTable?zeroDateTimeBehavior=convertToNull
>  # I am using same My SQL connection driver class for Netbean 8.1 and 12.4 : com.mysql.cj.jdbc.Driver
>  # 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|
>            Reporter: Vikhyat Baxi
>            Priority: Major
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@netbeans.apache.org
For additional commands, e-mail: commits-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists