oracle查询连接池最小数,测试oracle连接池最大连接数

测试oracle连接池最大连接数，这样有什么问题吗？测试中一直没报错。

Java code

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class JDBC_Test {

public static void main(String args[]) {

Connection connection = null;

Statement statement = null;

ResultSet resultSet = null;

try {

String driverName = "oracle.jdbc.driver.OracleDriver";

Class.forName(driverName);

String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

for (int i = 0; i < 1000; i++) {

System.out.println("连接到oracl成功!----"+i++);

connection= DriverManager.getConnection(url, "bschis", "bschis");

statement= connection.createStatement();

statement.executeQuery("select * from EHR_HealthRecord");

}

} catch (Exception e) {

e.printStackTrace();

}

}

}

但是如果换成数组的，就ok了！如下：

Java code

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class JDBC_Test {

public static void main(String args[]) {

Connection[] connection = new Connection[1000];

Statement[] statement = new Statement[1000];

ResultSet resultSet = null;

try {

String driverName = "oracle.jdbc.driver.OracleDriver";

Class.forName(driverName);

String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

for (int i = 0; i < 1000; i++) {

System.out.println("连接到oracl成功!----"+i++);

connection[i] = DriverManager.getConnection(url, "bschis", "bschis");

statement[i] = connection[i].createStatement();

statement[i].executeQuery("select * from EHR_HealthRecord");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

}

}

}