JDBC操作TimesTen

无论是操作本地的还是远程的TimesTen服务，客户端都需要安装Tiems Client，并配置客户端DSN。

基本信息如下：

1：创建客户端DSN

点击“添加”：

双击“TimesTen Client 11.2.2”.

配置server信息

输入Server Name,Network Address,Network Port等信息。

2：客户端JDBC测试

package tt_test01;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 * @author yan
 * @date
 * @version V1.0
 * @desc 
 */
public class Tt_test01 {
    
    /**
     * @param args 
     */
    public static void main(String[] args) {
        //连接本地timesten
        String URL = "jdbc:timesten:client:dsn=loctest;UID=test;PWD=test";
        
        Connection conn = null;
        
        try {
            Class.forName("com.timesten.jdbc.ObservableConnectionDS");
            
            conn = DriverManager.getConnection(URL);
            
            System.out.println("===conn:"+conn);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Tt_test01.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Tt_test01.class.getName()).log(Level.SEVERE, null, ex);
        } finally{
            try {
                if(null!=conn){
                    conn.close();
                }
            } catch (SQLException ex) {
                Logger.getLogger(Tt_test01.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
        
        
        
    }

}

 

final String tt_url = "jdbc:timesten:client:dsn=nssb_1122_cs;UID=test;PWD=test";
                TimesTenDataSource ttds = new TimesTenDataSource();
                ttds.setUrl(tt_url);
                TimesTenConnection ttcon = (TimesTenConnection) ttds.getConnection();
                
                System.out.println("====>ttcon:"+ttcon);
                
                final String sql = "insert into t01(nsrsbh,msg) values(?,?)";
                PreparedStatement ps = ttcon.prepareStatement(sql);
                ps.setString(1, nsrxx.getNsrsbh());
                ps.setString(2, nsrxx.getMsg());
                int flag = ps.executeUpdate();
                
                System.out.println("===>flag:"+flag);
                
                ps.close();
                ttcon.close();