ORA-01000: 超出打开游标的最大数

300,no exception:

 try {

    
     conn = DriverManager.getConnection(strUrl, "liu", "liu");
     for(int i=2100507;i<2100800;i++){
    
     st = conn.createStatement();
     rs = st.executeQuery("select * from mytest2 b where  id  ='"+i+"' ");
   
     out.println("ddddddddddd");
    while (rs.next()) {
     out.println(rs.getString("id") + "<br>");
    }
    }
      Thread.sleep(10000);

     for(int i=2100801;i<2100808;i++){
    
     st = conn.createStatement();
     rs = st.executeQuery("select * from mytest2 g where  id  ='"+i+"' ");
   
     out.println("ddddddddddd");
    while (rs.next()) {
     out.println(rs.getString("id") + "<br>");
    }
    }
   
   
   
   
   }  catch (SQLException e) {
    System.err.println("GetDataServer registry Exception=2222=25=3=4=7"+e.getMessage());
   }

 

 

 

 

>300,get exception:

 try {

    
     conn = DriverManager.getConnection(strUrl, "liu", "liu");
     for(int i=2100507;i<2100800;i++){
    
     st = conn.createStatement();
     rs = st.executeQuery("select * from mytest2 b where  id  ='"+i+"' ");
   
     out.println("ddddddddddd");
    while (rs.next()) {
     out.println(rs.getString("id") + "<br>");
    }
    }
      Thread.sleep(10000);

     for(int i=2100801;i<2100809;i++){
    
     st = conn.createStatement();
     rs = st.executeQuery("select * from mytest2 g where  id  ='"+i+"' ");
   
     out.println("ddddddddddd");
    while (rs.next()) {
     out.println(rs.getString("id") + "<br>");
    }
    }
   
   
   
   
   }  catch (SQLException e) {
    System.err.println("GetDataServer registry Exception=2222=25=3=4=7"+e.getMessage());
   }

 

1. 单次session中能open最大cursor；

session开始与：

     conn = DriverManager.getConnection(strUrl, "liu", "liu");

2.wls中，如果不重启，session id是不会变的，程序始终使用这些已经连接上的连接

LIU 638 2 INACTIVE Administrator SuDa-20100530IW JDBC Thin Client JDBC Thin Client
LIU 639 3 INACTIVE Administrator SuDa-20100530IW JDBC Thin Client JDBC Thin Client
LIU 640 9 INACTIVE Administrator SuDa-20100530IW JDBC Thin Client JDBC Thin Client
LIU 637 2 INACTIVE Administrator SuDa-20100530IW JDBC Thin Client JDBC Thin Client
LIU 634 6 INACTIVE Administrator SuDa-20100530IW JDBC Thin Client JDBC Thin Client