java直接访问Timesten的数据库

2019独角兽企业重金招聘Python工程师标准>>>

只测试在linux本地访问Timesten的数据库

1，需要3个so的库，在Timesten/tt1122/lib中

libtten.so    libttco.so     libttjdbc.so

2，需要1个jar包，在Timesten/tt1122/lib中

jdbctt8.jar  在java8的环境

jdbctt7.jar  在java7的环境

3，测试的源代码

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.timesten.jdbc.TimesTenDataSource;

public class Test {
        public static void main(String[] args) throws SQLException {
                String URL = "jdbc:timesten:direct:dsn=tt_1122;uid=datacenter;pwd=datacenter;";
                Connection conn = null;
                Statement stmt = null;
                ResultSet rs = null;
                try {
                        Class.forName("com.timesten.jdbc.TimesTenDriver");
                } catch (ClassNotFoundException e) {
                        e.printStackTrace();
                }
                try {
                        TimesTenDataSource ds = new TimesTenDataSource();
                        ds.setUrl(URL);
                        conn = ds.getConnection();
                        stmt = conn.createStatement();
                        rs = stmt.executeQuery("SELECT T.imei FROM ct_all_imei T;");
                        while (rs.next()) {
                                System.out.println("imei:" + rs.getString(1));
                        }
                } catch (Exception e) {
                        e.printStackTrace();
                } finally {
                        if (rs != null) {
                                rs.close();
                        }
                        if (stmt != null) {
                                stmt.close();
                        }
                        if (conn != null) {
                                conn.close();
                        }
                }
        }
}

 

转载于:https://my.oschina.net/yuanhotel/blog/735828