content: /*
   * Copyright 1999-2018 Alibaba Group Holding Ltd.
   *
   * Licensed under the Apache License, Version 2.0 (the "License");
   * you may not use this file except in compliance with the License.
   * You may obtain a copy of the License at
   *
   *      http://www.apache.org/licenses/LICENSE-2.0
   *
   * Unless required by applicable law or agreed to in writing, software
   * distributed under the License is distributed on an "AS IS" BASIS,
   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   * See the License for the specific language governing permissions and
   * limitations under the License.
   */
  package com.alibaba.druid.pool;
  
  import com.alibaba.druid.pool.vendor.OracleExceptionSorter;
  import com.alibaba.druid.stat.JdbcStatManager;
  import com.alibaba.druid.support.json.JSONUtils;
  import junit.framework.TestCase;
  
  import java.sql.Connection;
  import java.sql.ResultSet;
  import java.sql.Statement;
  import java.util.concurrent.CountDownLatch;
  
  public class TestOracle_DruidDataSource extends TestCase {
      private String jdbcUrl;
      private String user;
      private String password;
  
      public void setUp() throws Exception {
          jdbcUrl = "jdbc:oracle:thin:@a.b.c.d:1521:ocnauto";
          // jdbcUrl = "jdbc:oracle:thin:@b.c.d.e:1521:ocnauto"; // error url
          user = "alibaba";
          password = "ccbuauto";
      }
  
      public void test_0() throws Exception {
          final String SQL = "SELECT SYSDATE FROM DUAL";
          final DruidDataSource dataSource = new DruidDataSource();
          dataSource.setInitialSize(1);
          dataSource.setUrl(jdbcUrl);
          dataSource.setUsername(user);
          dataSource.setPassword(password);
          dataSource.setFilters("stat");
          dataSource.setExceptionSorter(OracleExceptionSorter.class.getName());
  
          final int COUNT = 100 * 100;
          final int THREAD_COUNT = 10;
          final CountDownLatch startLatch = new CountDownLatch(1);
          final CountDownLatch endLatch = new CountDownLatch(THREAD_COUNT);
  
          for (int i = 0; i < THREAD_COUNT; ++i) {
              Thread thread = new Thread() {
                  public void run() {
                      try {
                          startLatch.await();
                          for (int i = 0; i < COUNT; ++i) {
                              Connection conn = dataSource.getConnection();
                              Statement stmt = conn.createStatement();
                              ResultSet rs = stmt.executeQuery(SQL);
                              rs.next();
                              rs.close();
                              stmt.close();
                              conn.close();
                          }
                      } catch (Exception e) {
                          e.printStackTrace();
                      } finally {
                          endLatch.countDown();
                      }
                  }
              };
              thread.start();
          }
          startLatch.countDown();
          endLatch.await();
  
          for (Object item : JdbcStatManager.getInstance().getDataSourceList().values()) {
              String text = JSONUtils.toJSONString(item);
              System.out.println(text);
          }
  
          for (Object item : JdbcStatManager.getInstance().getSqlList().values()) {
              String text = JSONUtils.toJSONString(item);
              System.out.println(text);
          }
      }
  }
  