_session.beginTransaction();  // Need explicit control over the transaction
        try {
            SomeEntity entity = createEntity();  // Use session to create an entity
            LegacySearchObject search = createSearch(entity); // Creates new Connection since Hibernate 4 doesn't allow us to get a handle on existing connection

            SearchResults searchResults = _session.executeQuery(search); // Flushes session as expected but since search is using a different connection, it can't retrieve the uncommitted data.
            assertEquals(1, searchResults.getRowCount()); // fails.  No results found.
        } finally {
            _session.rollback();
        }