Java测试Oracle连接数

当连接数达到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"

    }

}