java.sql.SQLException: ORA-01000: 超出打开游标的最大数 解决方法
来源：互联网
import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class Test { public Connection getConnection() { String url = "jdbc:oracle:thin:@localhost:1521:ora9i"; String user = "scott" String password = "tiger"; Connection con = null; try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); con = DriverManager.getConnection(url, user, password); } catch (Exception e) { e.printStackTrace(); } return con; } public static void main(String[] args) throws SQLException { long a = 13819100000L; long b = 13819100600L; // 问题点 Connection con = null; Statement stmt = null; Test insert = new Test(); try { con = insert.getConnection(); for (long c = a; c <= b; c++) { String sql = "insert into telepnum values(" + c + ")"; stmt = con.createStatement(); // 这里是问题的所在 stmt.executeUpdate(sql); } System.out.println("OK"); } catch (Exception e) { e.printStackTrace(); } finally { if (con != null) { con.close(); } } }}import java.sql.Connection;import java.sql.DriverM
