alibaba / wasp

megastore-like system
http://alibaba.github.io/wasp/
Apache License 2.0
189 stars 80 forks source link

connection.close()方法阻塞 #15

Open ihadoop opened 11 years ago

ihadoop commented 11 years ago

名称: main-SendThread(hx2:2181) 状态: RUNNABLE 总阻止数: 5, 总等待数: 0

堆栈跟踪: sun.nio.ch.WindowsSelectorImpl$SubSelector.poll0(Native Method) sun.nio.ch.WindowsSelectorImpl$SubSelector.poll(Unknown Source) sun.nio.ch.WindowsSelectorImpl$SubSelector.access$400(Unknown Source) sun.nio.ch.WindowsSelectorImpl.doSelect(Unknown Source) sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)

jaywong85 commented 11 years ago

代码怎么写的呢。我试了下没这种情况

ihadoop commented 11 years ago

Properties prop = new Properties();

    prop.setProperty("wasp.zookeeper.quorum", "192.168.6.152,192.168.6.154,192.168.6.155,192.168.6.156");

    prop.setProperty("wasp.zookeeper.property.clientPort","2181");

    com.alibaba.wasp.jdbc.Driver.load();
    Connection conn = DriverManager.getConnection("jdbc:wasp:", prop);
    conn.setAutoCommit(false);

    Statement  stat = conn.createStatement();

    ResultSet rs = stat.executeQuery("select *   from WP_T_PASSCAR_YYYY_MM  where   WK_KKID='1398000004' AND WP_CAPTIME>1 and WP_CAPTIME<1376292466807");

    long l = System.currentTimeMillis();
    int k=0;
    while(rs.next())
    {
        System.out.println(rs.getString("WP_CARPLATE"));
        k++;
    }

    System.out.println(System.currentTimeMillis()-l);
    System.out.println(k);
    stat.close();
    conn.close();

------------------ 原始邮件 ------------------ 发件人: "jaywong"notifications@github.com; 发送时间: 2013年9月2日(星期一) 下午3:25 收件人: "alibaba/wasp"wasp@noreply.github.com; 抄送: "sunshine"13574798@qq.com; 主题: Re: [wasp] connection.close()方法阻塞 (#15)

代码怎么写的呢。我试了下没这种情况

— Reply to this email directly or view it on GitHub.