<dependencies>
<dependency>
<groupId>com.kinetica.jdbc</groupId>
<artifactId>kinetica-jdbc-driver</artifactId>
<version>3.2.0</version>
</dependency>
</dependencies>
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class KineticaJDBCExample {
public static void main(String[] args) {
String jdbcUrl = "jdbc:kinetica://localhost:9191;URL=https://kinetica.example.com:9191;DB=kdb;UID=admin;PWD=admin";
String jdbcDriver = "com.kinetica.jdbc.Driver";
Connection connection = null;
try {
Class.forName(jdbcDriver);
connection = DriverManager.getConnection(jdbcUrl);
Statement statement = connection.createStatement();
String sql = "SELECT * FROM your_table";
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
System.out.println("ID: " + id + ", Name: " + name);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
