Examples with SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper used on opensource projects

Example 1 with SqlExceptionHelper

use of org.hibernate.engine.jdbc.spi.SqlExceptionHelper in project hibernate-orm by hibernate.

the class AbstractRegionAccessStrategyTest method mockedSession.

protected SharedSessionContractImplementor mockedSession() {
    SessionMock session = mock(SessionMock.class);
    when(session.isClosed()).thenReturn(false);
    when(session.getTimestamp()).thenReturn(TIME_SERVICE.wallClockTime());
    if (jtaPlatform == BatchModeJtaPlatform.class) {
        BatchModeTransactionCoordinator txCoord = new BatchModeTransactionCoordinator();
        when(session.getTransactionCoordinator()).thenReturn(txCoord);
        when(session.beginTransaction()).then(invocation -> {
            Transaction tx = txCoord.newTransaction();
            tx.begin();
            return tx;
        });
    } else if (jtaPlatform == null) {
        Connection connection = mock(Connection.class);
        JdbcConnectionAccess jdbcConnectionAccess = mock(JdbcConnectionAccess.class);
        try {
            when(jdbcConnectionAccess.obtainConnection()).thenReturn(connection);
        } catch (SQLException e) {
        // never thrown from mock
        }
        JdbcSessionOwner jdbcSessionOwner = mock(JdbcSessionOwner.class);
        when(jdbcSessionOwner.getJdbcConnectionAccess()).thenReturn(jdbcConnectionAccess);
        SqlExceptionHelper sqlExceptionHelper = mock(SqlExceptionHelper.class);
        JdbcServices jdbcServices = mock(JdbcServices.class);
        when(jdbcServices.getSqlExceptionHelper()).thenReturn(sqlExceptionHelper);
        ServiceRegistry serviceRegistry = mock(ServiceRegistry.class);
        when(serviceRegistry.getService(JdbcServices.class)).thenReturn(jdbcServices);
        JdbcSessionContext jdbcSessionContext = mock(JdbcSessionContext.class);
        when(jdbcSessionContext.getServiceRegistry()).thenReturn(serviceRegistry);
        when(jdbcSessionOwner.getJdbcSessionContext()).thenReturn(jdbcSessionContext);
        NonJtaTransactionCoordinator txOwner = mock(NonJtaTransactionCoordinator.class);
        when(txOwner.getResourceLocalTransaction()).thenReturn(new JdbcResourceTransactionMock());
        when(txOwner.getJdbcSessionOwner()).thenReturn(jdbcSessionOwner);
        when(txOwner.isActive()).thenReturn(true);
        TransactionCoordinator txCoord = JdbcResourceLocalTransactionCoordinatorBuilderImpl.INSTANCE.buildTransactionCoordinator(txOwner, null);
        when(session.getTransactionCoordinator()).thenReturn(txCoord);
        when(session.beginTransaction()).then(invocation -> {
            Transaction tx = new TransactionImpl(txCoord, session.getExceptionConverter());
            tx.begin();
            return tx;
        });
    } else {
        throw new IllegalStateException("Unknown JtaPlatform: " + jtaPlatform);
    }
    return session;
}

Example 2 with SqlExceptionHelper

use of org.hibernate.engine.jdbc.spi.SqlExceptionHelper in project hibernate-orm by hibernate.

the class JdbcCoordinatorTest method testConnectionClose.

@Test
public void testConnectionClose() throws NoSuchFieldException, IllegalAccessException, SQLException {
    Connection connection = Mockito.mock(Connection.class);
    JdbcSessionOwner sessionOwner = Mockito.mock(JdbcSessionOwner.class);
    JdbcConnectionAccess jdbcConnectionAccess = Mockito.mock(JdbcConnectionAccess.class);
    when(jdbcConnectionAccess.obtainConnection()).thenReturn(connection);
    when(jdbcConnectionAccess.supportsAggressiveRelease()).thenReturn(false);
    JdbcSessionContext sessionContext = Mockito.mock(JdbcSessionContext.class);
    when(sessionOwner.getJdbcSessionContext()).thenReturn(sessionContext);
    when(sessionOwner.getJdbcConnectionAccess()).thenReturn(jdbcConnectionAccess);
    ServiceRegistry serviceRegistry = Mockito.mock(ServiceRegistry.class);
    when(sessionContext.getServiceRegistry()).thenReturn(serviceRegistry);
    when(sessionContext.getPhysicalConnectionHandlingMode()).thenReturn(PhysicalConnectionHandlingMode.IMMEDIATE_ACQUISITION_AND_HOLD);
    JdbcObserver jdbcObserver = Mockito.mock(JdbcObserver.class);
    when(sessionContext.getObserver()).thenReturn(jdbcObserver);
    JdbcServices jdbcServices = Mockito.mock(JdbcServices.class);
    when(serviceRegistry.getService(eq(JdbcServices.class))).thenReturn(jdbcServices);
    ConfigurationService configurationService = Mockito.mock(ConfigurationService.class);
    when(serviceRegistry.getService(eq(ConfigurationService.class))).thenReturn(configurationService);
    when(configurationService.getSetting(eq(AvailableSettings.CONNECTION_PROVIDER_DISABLES_AUTOCOMMIT), same(StandardConverters.BOOLEAN), eq(false))).thenReturn(false);
    SqlExceptionHelper sqlExceptionHelper = Mockito.mock(SqlExceptionHelper.class);
    when(jdbcServices.getSqlExceptionHelper()).thenReturn(sqlExceptionHelper);
    JdbcCoordinatorImpl jdbcCoordinator = new JdbcCoordinatorImpl(null, sessionOwner);
    Batch currentBatch = Mockito.mock(Batch.class);
    Field currentBatchField = JdbcCoordinatorImpl.class.getDeclaredField("currentBatch");
    currentBatchField.setAccessible(true);
    currentBatchField.set(jdbcCoordinator, currentBatch);
    doThrow(IllegalStateException.class).when(currentBatch).release();
    try {
        jdbcCoordinator.close();
        fail("Should throw IllegalStateException");
    } catch (Exception expected) {
        assertEquals(IllegalStateException.class, expected.getClass());
    }
    verify(jdbcConnectionAccess, times(1)).releaseConnection(same(connection));
}

Example 3 with SqlExceptionHelper

use of org.hibernate.engine.jdbc.spi.SqlExceptionHelper in project hibernate-orm by hibernate.

the class JdbcEnvironmentImpl method buildSqlExceptionHelper.

@SuppressWarnings("deprecation")
private SqlExceptionHelper buildSqlExceptionHelper(Dialect dialect, boolean logWarnings) {
    final StandardSQLExceptionConverter sqlExceptionConverter = new StandardSQLExceptionConverter();
    sqlExceptionConverter.addDelegate(dialect.buildSQLExceptionConversionDelegate());
    sqlExceptionConverter.addDelegate(new SQLExceptionTypeDelegate(dialect));
    // todo : vary this based on extractedMetaDataSupport.getSqlStateType()
    sqlExceptionConverter.addDelegate(new SQLStateConversionDelegate(dialect));
    return new SqlExceptionHelper(sqlExceptionConverter, logWarnings);
}

Example 4 with SqlExceptionHelper

use of org.hibernate.engine.jdbc.spi.SqlExceptionHelper in project uPortal by Jasig.

the class FixedDatabaseMetadata method getTableMetadata.

@Override
public TableMetadata getTableMetadata(String name, String schema, String catalog, boolean isQuoted) throws HibernateException {
    Object identifier = identifier(catalog, schema, name);
    TableMetadata table = (TableMetadata) tables.get(identifier);
    if (table != null) {
        return table;
    } else {
        try {
            ResultSet rs = null;
            try {
                if ((isQuoted && meta.storesMixedCaseQuotedIdentifiers())) {
                    rs = meta.getTables(catalog, schema, name, TYPES);
                } else if ((isQuoted && meta.storesUpperCaseQuotedIdentifiers()) || (!isQuoted && meta.storesUpperCaseIdentifiers())) {
                    rs = meta.getTables(StringHelper.toUpperCase(catalog), StringHelper.toUpperCase(schema), StringHelper.toUpperCase(name), TYPES);
                } else if ((isQuoted && meta.storesLowerCaseQuotedIdentifiers()) || (!isQuoted && meta.storesLowerCaseIdentifiers())) {
                    rs = meta.getTables(StringHelper.toLowerCase(catalog), StringHelper.toLowerCase(schema), StringHelper.toLowerCase(name), TYPES);
                } else {
                    rs = meta.getTables(catalog, schema, name, TYPES);
                }
                while (rs.next()) {
                    String tableName = rs.getString("TABLE_NAME");
                    if (name.equalsIgnoreCase(tableName)) {
                        table = new TableMetadata(rs, meta, extras);
                        tables.put(identifier, table);
                        return table;
                    }
                }
                LOG.tableNotFound(name);
                return null;
            } finally {
                if (rs != null)
                    rs.close();
            }
        } catch (SQLException sqlException) {
            throw new SqlExceptionHelper(sqlExceptionConverter).convert(sqlException, "could not get table metadata: " + name);
        }
    }
}