[
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-unsubscr...@netbeans.apache.org
For additional commands, e-mail: commits-h...@netbeans.apache.org
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
