Maven:
<dependency>
<groupId>org.duckdb</groupId>
<artifactId>duckdb-jdbc</artifactId>
<version>0.2.7</version>
</dependency>
Gradle:
groovy
implementation 'org.duckdb:duckdb-jdbc:0.2.7'
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DuckDBExample {
public static void main(String[] args) {
String jdbcUrl = "jdbc:duckdb:localhost:5000";
String username = "your_username";
String password = "your_password";
try (Connection conn = DriverManager.getConnection(jdbcUrl, username, password)) {
// ...
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DuckDBExample {
public static void main(String[] args) {
String jdbcUrl = "jdbc:duckdb:localhost:5000";
String username = "your_username";
String password = "your_password";
try (Connection conn = DriverManager.getConnection(jdbcUrl, username, password)) {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM my_table");
while (rs.next()) {
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class DuckDBExample {
public static void main(String[] args) {
String jdbcUrl = "jdbc:duckdb:localhost:5000";
String username = "your_username";
String password = "your_password";
Properties properties = new Properties();
properties.setProperty("maxConnections", "10");
properties.setProperty("loginTimeout", "60");
try (Connection conn = DriverManager.getConnection(jdbcUrl, properties)) {
// ...
} catch (SQLException e) {
e.printStackTrace();
}
}
}
