hotfix/source/openejb-core_4.5.2/src/test/java/org/apache/openejb/resource/jdbc/UTManagedDataSourceTest.java

/**
 * 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.openejb.resource.jdbc;

import org.apache.openejb.jee.EjbJar;
import org.apache.openejb.jee.SingletonBean;
import org.apache.openejb.junit.ApplicationComposer;
import org.apache.openejb.testing.Configuration;
import org.apache.openejb.testing.Module;
import org.apache.openejb.resource.jdbc.managed.local.ManagedConnection;
import org.junit.After;
import org.junit.BeforeClass;
import org.junit.Test;
import org.junit.runner.RunWith;

import javax.annotation.Resource;
import javax.ejb.EJB;
import javax.ejb.LocalBean;
import javax.ejb.Singleton;
import javax.ejb.TransactionManagement;
import javax.ejb.TransactionManagementType;
import javax.sql.DataSource;
import javax.transaction.Transaction;
import javax.transaction.UserTransaction;
import java.lang.reflect.Field;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Map;
import java.util.Properties;

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertFalse;
import static org.junit.Assert.assertTrue;

@RunWith(ApplicationComposer.class)
public class UTManagedDataSourceTest {
    private static final String URL = "jdbc:hsqldb:mem:managed;hsqldb.tx=MVCC"; // mvcc otherwise multiple transaction tests will fail
    private static final String USER = "sa";
    private static final String PASSWORD = "";
    private static final String TABLE = "PUBLIC.MANAGED_DATASOURCE_TEST";

    @EJB
    private Persister persistManager;

    @BeforeClass
    public static void createTable() throws SQLException, ClassNotFoundException {
        Class.forName("org.hsqldb.jdbcDriver");

        final Connection connection = DriverManager.getConnection(URL, USER, PASSWORD);
        final Statement statement = connection.createStatement();
        statement.execute("CREATE TABLE " + TABLE + "(ID INTEGER)");
        statement.close();
        connection.commit();
        connection.close();
    }

    @Configuration
    public Properties config() {
        final Properties p = new Properties();
        p.put("openejb.jdbc.datasource-creator", "dbcp-alternative");

        p.put("managed", "new://Resource?type=DataSource");
        p.put("managed.JdbcDriver", "org.hsqldb.jdbcDriver");
        p.put("managed.JdbcUrl", URL);
        p.put("managed.UserName", USER);
        p.put("managed.Password", PASSWORD);
        p.put("managed.JtaManaged", "true");
        return p;
    }

    @Module
    public EjbJar app() throws Exception {
        return new EjbJar()
                .enterpriseBean(new SingletonBean(Persister.class).localBean())
                .enterpriseBean(new SingletonBean(OtherPersister.class).localBean());
    }

    @LocalBean
    @Singleton
    @TransactionManagement(TransactionManagementType.BEAN)
    public static class OtherPersister {
        @Resource(name = "managed")
        private DataSource ds;

        @Resource
        private UserTransaction ut;

        public void save() throws Exception {
            ut.begin();
            UTManagedDataSourceTest.save(ds, 10);
            ut.commit();
        }

        public void saveAndRollback() throws Exception {
            ut.begin();
            UTManagedDataSourceTest.save(ds, 11);
            ut.rollback();
        }
    }

    @LocalBean
    @Singleton
    @TransactionManagement(TransactionManagementType.BEAN)
    public static class Persister {
        @Resource(name = "managed")
        private DataSource ds;

        @EJB
        private OtherPersister other;

        @Resource
        private UserTransaction ut;

        public void save() throws Exception {
            ut.begin();
            UTManagedDataSourceTest.save(ds, 1);
            ut.commit();
        }

        public void saveAndRollback() throws Exception {
            ut.begin();
            UTManagedDataSourceTest.save(ds, 2);
            ut.rollback();
        }

        public void saveTwice() throws Exception {
            ut.begin();
            UTManagedDataSourceTest.save(ds, 3);
            UTManagedDataSourceTest.save(ds, 4);
            ut.commit();
        }

        public void rollbackMultipleSave() throws Exception {
            ut.begin();
            UTManagedDataSourceTest.save(ds, 5);
            UTManagedDataSourceTest.save(ds, 6);
            ut.rollback();
        }

        public void saveInThisTxAndAnotherOne() throws Exception {
            ut.begin();
            UTManagedDataSourceTest.save(ds, 7);
            other.save();
            ut.commit();
        }

        public void saveInThisTxAndRollbackInAnotherOne() throws Exception {
            ut.begin();
            UTManagedDataSourceTest.save(ds, 8);
            other.saveAndRollback();
            ut.commit();
        }
    }

    @Test
    public void commit() throws Exception {
        persistManager.save();
        assertTrue(exists(1));
    }

    @Test
    public void rollback() throws Exception {
        persistManager.saveAndRollback();
        assertFalse(exists(2));
    }

    @Test
    public void commit2() throws Exception {
        persistManager.saveTwice();
        assertTrue(exists(3));
        assertTrue(exists(4));
    }

    @Test
    public void rollback2() throws Exception {
        persistManager.rollbackMultipleSave();
        assertFalse(exists(5));
        assertFalse(exists(6));
    }

    @Test
    public void saveDifferentTx() throws Exception {
        persistManager.saveInThisTxAndAnotherOne();
        assertTrue(exists(7));
        assertTrue(exists(10));
    }

    @Test
    public void saveRollbackDifferentTx() throws Exception {
        persistManager.saveInThisTxAndRollbackInAnotherOne();
        assertTrue(exists(8));
        assertFalse(exists(12));
    }

    @After
    public void checkTxMapIsEmpty() throws Exception { // avoid memory leak
        final Field map = ManagedConnection.class.getDeclaredField("CONNECTION_BY_TX_BY_DS");
        map.setAccessible(true);
        final Map<DataSource, Map<Transaction, Connection>>  instance = (Map<DataSource, Map<Transaction, Connection>> ) map.get(null);
        assertEquals(1, instance.size());
        assertEquals(0, instance.values().iterator().next().size());
    }

    private static boolean exists(int id) throws Exception {
        final Connection connection = DriverManager.getConnection(URL, USER, PASSWORD);
        final Statement statement = connection.createStatement();
        final ResultSet result = statement.executeQuery("SELECT count(*) AS NB FROM " + TABLE + " WHERE ID = " + id);
        try {
            assertTrue(result.next());
            return result.getInt(1) == 1;
        } finally {
            statement.close();
            connection.close();
        }
    }

    private static void save(final DataSource ds, int id) throws Exception {
        execute(ds, "INSERT INTO " + TABLE + "(ID) VALUES(" + id + ")");
    }

    private static void execute(final DataSource ds, final String sql) throws Exception {
        final Connection connection = ds.getConnection();
        final Statement statement = connection.createStatement();
        statement.executeUpdate(sql);
        statement.close();
        connection.close();
    }
}