用JDBC连接Vertica数据库的例子源代码

来源:互联网 发布:堺刀司 知乎 编辑:程序博客网 时间:2024/05/16 14:42
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();        }    }}
0 0
原创粉丝点击