public TestOracleBasicDataSource(String testName) 
{
        super(testName);
}

 protected Connection getConnection() throws Exception 
{
        return ds.getConnection();
}

 public  void setUp() throws Exception 
{
         
        super.setUp();
        ds = new BasicDataSource();
        ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
        ds.setUrl("jdbc:oracle:thin:@localhost:1521:DEMO");
        ds.setMaxActive(10);
        ds.setMaxWait(100);
        ds.setDefaultAutoCommit(true);
        ds.setDefaultReadOnly(true);
        ds.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
        // ds.setDefaultCatalog(CATALOG);
        ds.setUsername("SCOTT");
        ds.setPassword("TIGER");
        ds.setValidationQuery("SELECT DUMMY FROM DUAL");
}

 public static Test suite() 
{
        return new TestSuite(TestOracleBasicDataSource.class);
}

 public  void tearDown() throws Exception 
{
        super.tearDown();
        ds = null;
}

 public  void testSimple() throws Exception 
{
         Connection conn = getConnection();
         assertTrue(null != conn);
         PreparedStatement stmt = conn.prepareStatement("select * from dual");
         assertTrue(null != stmt);
         ResultSet rset = stmt.executeQuery();
         assertTrue(null != rset);
         assertTrue(rset.next());
         rset.close();
         stmt.close();
         conn.close();
}