The example below shows you how to get the information about the possible properties for the corresponding JDBC driver.
package org.kodejava.jdbc;
import java.sql.*;
public class DriverPropertyInfoDemo {
private static final String URL = "jdbc:mysql://localhost/kodejava";
public static void main(String[] args) {
try {
// Gets information about the possible properties for this
// driver.
Driver driver = DriverManager.getDriver(URL);
DriverPropertyInfo[] props = driver.getPropertyInfo(URL, null);
for (DriverPropertyInfo info : props) {
System.out.println("Name : " + info.name);
System.out.println("Description: " + info.description);
System.out.println("Value : " + info.value);
System.out.println("-----------------------------------");
String[] choices = info.choices;
if (choices != null) {
StringBuilder sb = new StringBuilder("Choices : ");
for (String choice : choices) {
sb.append(choice).append(",");
}
System.out.println(sb);
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
The example result of the code snippet above:
Name : host
Description: Hostname of MySQL Server
Value : localhost
-----------------------------------
Name : port
Description: Port number of MySQL Server
Value : 3306
-----------------------------------
Name : dbname
Description: Database name;
Value : kodejava
-----------------------------------
Name : user
Description: Username to authenticate as
Value : null
-----------------------------------
Name : password
Description: Password to use for authentication
Value : null
-----------------------------------
Name : clientCertificateKeyStorePassword
Description: Password for the client certificates key store.
Value : null
-----------------------------------
Name : serverRSAPublicKeyFile
Description: File path to the server RSA public key file for sha256_password authentication. If not specified, the public key will be retrieved from the server.
Value : null
-----------------------------------
Name : cacheDefaultTimeZone
Description: Caches clients default time zone. This results in better performance when dealing with time zone conversions in Date and Time data types, however it wont be aware of time zone changes if they happen at runtime.
Value : true
-----------------------------------
Choices : TRUE,FALSE,YES,NO,
...
...
...
Maven Dependencies
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>8.4.0</version>
</dependency>
Latest posts by Wayan (see all)
- How do I get number of each day for a certain month in Java? - September 8, 2024
- How do I get operating system process information using ProcessHandle? - July 22, 2024
- How do I sum a BigDecimal property of a list of objects using Java Stream API? - July 22, 2024