content: package com.alibaba.druid.bvt.pool.exception;
  
  import com.alibaba.druid.mock.MockConnection;
  import com.alibaba.druid.pool.DruidDataSource;
  import com.alibaba.druid.pool.DruidPooledConnection;
  import com.alibaba.druid.pool.vendor.OracleExceptionSorter;
  import com.alibaba.druid.stat.JdbcStatManager;
  import com.alibaba.druid.test.util.OracleMockDriver;
  import com.alibaba.druid.util.JdbcUtils;
  import junit.framework.TestCase;
  
  import java.sql.Connection;
  import java.sql.PreparedStatement;
  import java.sql.SQLException;
  
  public class OracleExceptionSorterTest_setSavepointWithName extends TestCase {
      private DruidDataSource dataSource;
  
      protected void setUp() throws Exception {
          assertEquals(0, JdbcStatManager.getInstance().getSqlList().size());
  
          dataSource = new DruidDataSource();
  
          dataSource.setExceptionSorter(new OracleExceptionSorter());
  
          dataSource.setDriver(new OracleMockDriver());
          dataSource.setUrl("jdbc:mock:xxx");
          dataSource.setFilters("log4j");
          dataSource.setPoolPreparedStatements(true);
          dataSource.setMaxOpenPreparedStatements(100);
      }
  
      protected void tearDown() throws Exception {
          JdbcUtils.close(dataSource);
      }
  
      public void test_connect() throws Exception {
          String sql = "SELECT 1";
          {
              DruidPooledConnection conn = dataSource.getConnection();
  
              PreparedStatement pstmt = conn.prepareStatement(sql);
              pstmt.execute();
              pstmt.close();
              conn.close();
  
              assertEquals(0, dataSource.getActiveCount());
              assertEquals(1, dataSource.getPoolingCount());
              assertEquals(1, dataSource.getCreateCount());
          }
  
          DruidPooledConnection conn = dataSource.getConnection();
          MockConnection mockConn = conn.unwrap(MockConnection.class);
          assertNotNull(mockConn);
  
          SQLException exception = new SQLException("xx", "xxx", 28);
          mockConn.setError(exception);
  
          Exception setError = null;
          try {
              conn.setSavepoint("xxx");
          } catch (Exception ex) {
              setError = ex;
          }
          assertNotNull(setError);
  
          conn.close();
  
          {
              Connection conn2 = dataSource.getConnection();
              conn2.close();
          }
          assertEquals(0, dataSource.getActiveCount());
          assertTrue(dataSource.getPoolingCount() >= 1);
          assertTrue(dataSource.getCreateCount() >= 2);
      }
  }
  