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.1.0</version>
</dependency>
Founder at Kode Java Org
A programmer, runner and recreational diver, lives on the island of Bali, Indonesia. Programming in Java, Spring, Hibernate / JPA. You can support me working on this project, buy me a cup of coffee ☕, every little bit helps. Thank you 🙏
Latest posts by Wayan (see all)
- How do I create a table with multiple header in iText 8? - March 16, 2024
- How do I add Image to a Table in iText 8? - March 11, 2024
- How do I downgrade Android SDK emulator version? - February 12, 2024