Nirmala Sundarappa

162 posts

Nirmala Sundarappa banner
Nirmala Sundarappa

Nirmala Sundarappa

@nsundara

Principal Product Manager, Oracle

Redwood City, CA Katılım Eylül 2009
148 Takip Edilen121 Takipçiler
Nirmala Sundarappa
Nirmala Sundarappa@nsundara·
Starting from 23ai, DB supports native Boolean, but, if you are using the older versions and want to enable the old behavior of boolean treated as VARCHAR(1) then use oracle.jdbc.sendBooleanAsNativeBoolean=false. #JavaOracleDB #23ai
English
0
0
0
22
Nirmala Sundarappa
Nirmala Sundarappa@nsundara·
Using JKS for mTLS: (1) set SSL_CLIENT_AUTHENTICATION = TRUE on the server side (sqlnet.ora and listener.ora), (2) set both truststore and keystore properties, (3) Use TCPS and ssl_server_dn_match=yes in the URL. #JavaOracleDB #mTLS
English
0
0
1
31
Nirmala Sundarappa
Nirmala Sundarappa@nsundara·
Using JKS for one-way TLS: (1) set SSL_CLIENT_AUTHENTICATION = FALSE on the server side (sqlnet.ora) (2) set javax.net.ssl.trustStore and javax.net.ssl.trustStorePassword properties (3) Use TCPS and ssl_server_dn_match=yes in the URL. #JavaOracleDB
English
0
0
0
30
Nirmala Sundarappa
Nirmala Sundarappa@nsundara·
Using Oracle Wallets for TLS connections in 23ai. (1) Specify the Oracle wallets location using WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/path/))) or oracle.net.wallet_location property. (2) Add oraclepki.jar to the class path. #JavaOracleDB #23ai
English
0
1
0
133
Nirmala Sundarappa
Nirmala Sundarappa@nsundara·
JDBC Tip: TLS connections provide authentication, encryption, and data integrity. Refer to this Javadoc bit.ly/TLS-Props for a list of TLS connection properties to enable one-way TLS, two-way TLS and other features. #JavaOracleDB #23ai ,
English
0
0
0
28