foundation/eclipselink.core.test/src/it/java/org/eclipse/persistence/testing/tests/unitofwork/CommitUnitOfWorkForcingSQLExceptionTest.java

/*
 * Copyright (c) 1998, 2021 Oracle and/or its affiliates. All rights reserved.
 *
 * This program and the accompanying materials are made available under the
 * terms of the Eclipse Public License v. 2.0 which is available at
 * http://www.eclipse.org/legal/epl-2.0,
 * or the Eclipse Distribution License v. 1.0 which is available at
 * http://www.eclipse.org/org/documents/edl-v10.php.
 *
 * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause
 */

// Contributors:
//     Oracle - initial API and implementation from Oracle TopLink
package org.eclipse.persistence.testing.tests.unitofwork;

import java.util.Collections;

import org.eclipse.persistence.internal.sessions.UnitOfWorkImpl;
import org.eclipse.persistence.sessions.UnitOfWork;
import org.eclipse.persistence.testing.framework.TestWarningException;
import org.eclipse.persistence.testing.models.employee.domain.Employee;

/**
 * Bug# 219097
 * This test would normally pass, but we purposely invoke an SQLException on the firstName field
 * so that we can test that an UnsupportedOperationException is not thrown as part of the
 * roll-back exception handling code for an SQLException.
 * @author mobrien
 */
public class CommitUnitOfWorkForcingSQLExceptionTest extends UnitOfWorkEventTest {

    /** The field length for the firstname */
    public static final int MAX_FIRST_NAME_FIELD_LENGTH = 255;

    @Override
    public void setup() {
        super.setup();
        setDescription("Test force of SQLException to exercise the rollback exception handling code");
        if ( getSession().getLogin().getPlatform().isSybase() ) {
            throw new TestWarningException("Sybase silently truncates String data to match the field size");
        }
    }

    @Override
    public void test() {
        boolean exceptionThrown = false;
        // Set an immutable properties Map on the UOW session to test addition of properties to this map in the roll-back exception handler
        UnitOfWork uow = getSession().acquireUnitOfWork();
        ((UnitOfWorkImpl)uow).setProperties(Collections.emptyMap());
        Employee anEmployee = (Employee)uow.readObject(Employee.class);

        /*
         * Provoke an SQL exception by setting a field with a value greater than field length.
         * 1 - This test will not throw an exception without the Collections$emptyMap() set on the EntityhManager
         *       or the exceeded field length set on firstName.
         * 2 - This test will throw an UnsupportedOperationException if the map on AbstractSession is not cloned when immutable - bug fix
         * 3 - This test will throw an SQLException when operating normally due to the field length exception
         */
        StringBuffer firstName = new StringBuffer("firstName_maxfieldLength_");
        for(int i=0; i<MAX_FIRST_NAME_FIELD_LENGTH + 100; i++) {
            firstName.append("0");
        }
        anEmployee.setFirstName(firstName.toString());

        try {
            uow.commit();

        } catch (Exception e) {
            Throwable cause = e.getCause();
            if(cause instanceof UnsupportedOperationException) {
                exceptionThrown = true;
                fail(cause.getClass() + " Exception was thrown in error instead of expected SQLException.");
            } else {
                exceptionThrown = true;
            }
        } finally {
            // Release transaction mutex
            //((AbstractSession)uow).rollbackTransaction();
        }
        if(!exceptionThrown) {
            fail("An expected SQLException was not thrown.");
        }
    }
}