/*
 *  Licensed to the Apache Software Foundation (ASF) under one or more
 *  contributor license agreements.  See the NOTICE file distributed with
 *  this work for additional information regarding copyright ownership.
 *  The ASF licenses this file to You 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 org.apache.tomcat.jdbc.test;

import java.sql.Connection;

import org.junit.Assert;
import org.junit.Test;

public class TwoDataSources extends DefaultTestCase {

    @Test
    public void testTwoDataSources() throws Exception {
        org.apache.tomcat.jdbc.pool.DataSource d1 = this.createDefaultDataSource();
        org.apache.tomcat.jdbc.pool.DataSource d2 = this.createDefaultDataSource();
        d1.setRemoveAbandoned(true);
        d1.setRemoveAbandonedTimeout(10);
        d1.setTimeBetweenEvictionRunsMillis(1000);
        d2.setRemoveAbandoned(false);
        Connection c1 = d1.getConnection();
        Connection c2 = d2.getConnection();
        Thread.sleep(5000);
        try {
            c1.createStatement();
            Assert.assertTrue("Connection should have been abandoned.",false);
        }catch (Exception x) {
            Assert.assertTrue("This is correct, c1 is abandoned",true);
        }

        try {
            c2.createStatement();
            Assert.assertTrue("Connection should not have been abandoned.",true);
        }catch (Exception x) {
            Assert.assertTrue("Connection c2 should be working",false);
        }
        try {
            Assert.assertTrue("Connection should have been closed.",c1.isClosed());
        }catch (Exception x) {
            Assert.assertTrue("This is correct, c1 is closed",true);
        }
        try {
            Assert.assertFalse("Connection c2 should not have been closed.",c2.isClosed());
        }catch (Exception x) {
            Assert.assertTrue("Connection c2 should be working",false);
        }
    }
}

/*
 *  Licensed to the Apache Software Foundation (ASF) under one or more
 *  contributor license agreements.  See the NOTICE file distributed with
 *  this work for additional information regarding copyright ownership.
 *  The ASF licenses this file to You 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 org.apache.tomcat.jdbc.test;

import java.sql.Connection;

import org.junit.Assert;
import org.junit.Test;

public class TwoDataSources extends DefaultTestCase {

    @Test
    public void testTwoDataSources() throws Exception {
        org.apache.tomcat.jdbc.pool.DataSource d1 = this.createDefaultDataSource();
        org.apache.tomcat.jdbc.pool.DataSource d2 = this.createDefaultDataSource();
        d1.setRemoveAbandoned(true);
        d1.setRemoveAbandonedTimeout(2);
        d1.setTimeBetweenEvictionRunsMillis(1000);
        d2.setRemoveAbandoned(false);
        Connection c1 = d1.getConnection();
        Connection c2 = d2.getConnection();
        Thread.sleep(5000);
        try {
            c1.createStatement();
            Assert.assertTrue("Connection should have been abandoned.",false);
        }catch (Exception x) {
            Assert.assertTrue("This is correct, c1 is abandoned",true);
        }

        try {
            c2.createStatement();
            Assert.assertTrue("Connection should not have been abandoned.",true);
        }catch (Exception x) {
            Assert.assertTrue("Connection c2 should be working",false);
        }
        try {
            Assert.assertTrue("Connection should have been closed.",c1.isClosed());
        }catch (Exception x) {
            Assert.assertTrue("This is correct, c1 is closed",true);
        }
        try {
            Assert.assertFalse("Connection c2 should not have been closed.",c2.isClosed());
        }catch (Exception x) {
            Assert.assertTrue("Connection c2 should be working",false);
        }
    }
}

Fix broken test (it has been broken for a long time) The timeout needs to be shorter than the sleep time so the connection is abandoned