vertica java_用JDBC连接Vertica数据库的例子源代码 | 学步园

import java.sql.*;

import java.util.Properties;

public class VerySimpleVerticaJDBCExample {

public static void main(String[] args) {

/* JDBC 3.0 以前的版本需要添加下边这段代码 */

/*

* try { Class.forName("com.vertica.jdbc.Driver"); } catch

* (ClassNotFoundException e) { // Could not find the driver class.

* Likely an issue // with finding the .jar file.

* System.err.println("Could not find the JDBC driver class.");

* e.printStackTrace(); return; // Bail out. We cannot do anything

* further. }

*/

Properties myProp = new Properties();

myProp.put("user", "dbadmin");

myProp.put("password", "vertica");

myProp.put("loginTimeout", "35");

myProp.put("binaryBatchInsert", "true");

Connection conn;

try {

conn = DriverManager.getConnection(

"jdbc:vertica://docd04.verticacorp.com:5433/dbname", myProp);

System.out.println("Connected!");

conn.close();

} catch (SQLTransientConnectionException connException) {

// There was a potentially temporary network error

// Could automatically retry a number of times here, but

// instead just report error and exit.

System.out.print("Network connection issue: ");

System.out.print(connException.getMessage());

System.out.println(" Try again later!");

return;

} catch (SQLInvalidAuthorizationSpecException authException) {

// Either the username or password was wrong

System.out.print("Could not log into database: ");

System.out.print(authException.getMessage());

System.out.println(" Check the login credentials and try again.");

return;

} catch (SQLException e) {

// Catch-all for other exceptions

e.printStackTrace();

}

}

}