GetAllRevisions.log

10:51:52,378 DEBUG SQL:92 - 
    select
        book_aud0_.REV as col_0_0_ 
    from
        Book_AUD book_aud0_ cross 
    join
        REVINFO defaultrev1_ 
    where
        book_aud0_.id=? 
        and book_aud0_.REV=defaultrev1_.REV 
    order by
        book_aud0_.REV asc
10:51:52,407 DEBUG SQL:92 - 
    select
        book_aud0_.id as id1_3_,
        book_aud0_.REV as REV2_3_,
        book_aud0_.REVTYPE as REVTYPE3_3_,
        book_aud0_.publishingDate as publishi4_3_,
        book_aud0_.title as title5_3_,
        book_aud0_.publisherid as publishe6_3_ 
    from
        Book_AUD book_aud0_ 
    where
        book_aud0_.REV=(
            select
                max(book_aud1_.REV) 
            from
                Book_AUD book_aud1_ 
            where
                book_aud1_.REV<=? 
                and book_aud0_.id=book_aud1_.id
        ) 
        and book_aud0_.REVTYPE<>? 
        and book_aud0_.id=?
10:51:52,418  INFO TestEnvers:118 - Book [Book title: Hibernate Tips] at revision [2].
10:51:52,419 DEBUG SQL:92 - 
    select
        book_aud0_.id as id1_3_,
        book_aud0_.REV as REV2_3_,
        book_aud0_.REVTYPE as REVTYPE3_3_,
        book_aud0_.publishingDate as publishi4_3_,
        book_aud0_.title as title5_3_,
        book_aud0_.publisherid as publishe6_3_ 
    from
        Book_AUD book_aud0_ 
    where
        book_aud0_.REV=(
            select
                max(book_aud1_.REV) 
            from
                Book_AUD book_aud1_ 
            where
                book_aud1_.REV<=? 
                and book_aud0_.id=book_aud1_.id
        ) 
        and book_aud0_.REVTYPE<>? 
        and book_aud0_.id=?
10:51:52,421  INFO TestEnvers:118 - Book [Book title: Hibernate Tips - 64 Tips for your day to day work] at revision [3].

GetRevisionAtDate.log

10:52:52,067 DEBUG SQL:92 - 
    select
        max(defaultrev0_.REV) as col_0_0_ 
    from
        REVINFO defaultrev0_ 
    where
        defaultrev0_.REVTSTMP<=?
10:52:52,117 DEBUG SQL:92 - 
    select
        book_aud0_.id as id1_3_,
        book_aud0_.REV as REV2_3_,
        book_aud0_.REVTYPE as REVTYPE3_3_,
        book_aud0_.publishingDate as publishi4_3_,
        book_aud0_.title as title5_3_,
        book_aud0_.publisherid as publishe6_3_ 
    from
        Book_AUD book_aud0_ 
    where
        book_aud0_.REV=(
            select
                max(book_aud1_.REV) 
            from
                Book_AUD book_aud1_ 
            where
                book_aud1_.REV<=? 
                and book_aud0_.id=book_aud1_.id
        ) 
        and book_aud0_.REVTYPE<>? 
        and book_aud0_.id=?

PersistEntitiesWithAudit.log

10:50:30,950 DEBUG SQL:92 - 
    select
        nextval ('hibernate_sequence')
10:50:30,989 DEBUG SQL:92 - 
    select
        nextval ('hibernate_sequence')
10:50:31,013 DEBUG SQL:92 - 
    insert 
    into
        Author
        (firstName, lastName, version, id) 
    values
        (?, ?, ?, ?)
10:50:31,024 DEBUG SQL:92 - 
    insert 
    into
        Book
        (publisherid, publishingDate, title, version, id) 
    values
        (?, ?, ?, ?, ?)
10:50:31,029 DEBUG SQL:92 - 
    insert 
    into
        BookAuthor
        (bookId, authorId) 
    values
        (?, ?)
10:50:31,042 DEBUG SQL:92 - 
    select
        nextval ('hibernate_sequence')
10:50:31,046 DEBUG SQL:92 - 
    insert 
    into
        REVINFO
        (REVTSTMP, REV) 
    values
        (?, ?)
10:50:31,048 DEBUG SQL:92 - 
    insert 
    into
        Author_AUD
        (REVTYPE, firstName, lastName, id, REV) 
    values
        (?, ?, ?, ?, ?)
10:50:31,051 DEBUG SQL:92 - 
    insert 
    into
        Book_AUD
        (REVTYPE, publishingDate, title, publisherid, id, REV) 
    values
        (?, ?, ?, ?, ?, ?)
10:50:31,054 DEBUG SQL:92 - 
    insert 
    into
        BookAuthor_AUD
        (REVTYPE, REV, bookId, authorId) 
    values
        (?, ?, ?, ?)

UpdateEntitiesWithAudit.log

10:49:29,465 DEBUG SQL:92 - 
    select
        book0_.id as id1_2_0_,
        book0_.publisherid as publishe5_2_0_,
        book0_.publishingDate as publishi2_2_0_,
        book0_.title as title3_2_0_,
        book0_.version as version4_2_0_,
        publisher1_.id as id1_6_1_,
        publisher1_.name as name2_6_1_,
        publisher1_.version as version3_6_1_ 
    from
        Book book0_ 
    left outer join
        Publisher publisher1_ 
            on book0_.publisherid=publisher1_.id 
    where
        book0_.id=?
10:49:29,483 DEBUG SQL:92 - 
    update
        Book 
    set
        publisherid=?,
        publishingDate=?,
        title=?,
        version=? 
    where
        id=? 
        and version=?
10:49:29,487 DEBUG SQL:92 - 
    select
        nextval ('hibernate_sequence')
10:49:29,489 DEBUG SQL:92 - 
    insert 
    into
        REVINFO
        (REVTSTMP, REV) 
    values
        (?, ?)
10:49:29,491 DEBUG SQL:92 - 
    insert 
    into
        Book_AUD
        (REVTYPE, publishingDate, title, publisherid, id, REV) 
    values
        (?, ?, ?, ?, ?, ?)