当连接数达到600多个时，会报下面的错误：
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection The Connection descriptor used by the client was:10.16.0.31:1521:polyfilm
类的代码如下：
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.IOException;
public class TestMaxConnection {
public static void main(String args[]) {
int count = 0;
Connection[] conn = new Connection[1000];
Statement[] stmt = new Statement[1000];
ResultSet[] rs = new ResultSet[1000];
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
for (count = 0; count < 990; count++) {
conn[count] = DriverManager.getConnection("jdbc:oracle:thin:@10.16.0.31:1521:polyfilm",
"shilin", "shilin");
stmt[count] = conn[count].createStatement();
rs[count] = stmt[count].executeQuery("SELECT * FROM ad_user");
while (rs[count].next()) {
//System.out.println(rs[count].getString(1) + "\ "+ rs[count].getString(2));
}
System.out.print(count + "\");
}
} catch (SQLException ex1) {
System.out.println("\\n" + ex1.toString());
} catch (InstantiationException ex2) {
System.out.println("\\n" + ex2.toString());
} catch (ClassNotFoundException ex3) {
System.out.println("\\n" + ex3.toString());
} catch (IllegalAccessException ex4) {
System.out.println("\\n" + ex4.toString());
} finally {
try {
System.out.println("\\nSystem has opened "+ count--
+ " connections.\\nPress Enter key to close the connections");
System.in.read();
System.out.println("\\nClose the Connections:");
for (; count >= 0; count--) {
rs[count].close();
stmt[count].close();
conn[count].close();
System.out.print(count + "\");
}
} catch (SQLException ex) {
System.out.println("\\n Close connection exception:"+ ex.toString());
} catch (IOException io_ex) {
}
}//end the first "try"
}
}下载本文
