<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <base href="https://hibernate.atlassian.net" />
<title>Message Title</title>
</head>
<body class="jira" style="color: #333; font-family: Arial, sans-serif; font-size: 14px; line-height: 1.429">
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f5f5f5; border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<!-- header here -->
<tr>
<td id="header-pattern-container" style="padding: 0px; border-collapse: collapse; padding: 10px 20px">
<table id="header-pattern" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="header-avatar-image-container" valign="top" style="padding: 0px; border-collapse: collapse; vertical-align: top; width: 32px; padding-right: 8px"> <img id="header-avatar-image" class="image_fix" src="https://secure.gravatar.com/avatar/0effcb0f1da79bf6c86e530025242421?d=mm&s=48" height="32" width="32" border="0" style="border-radius: 3px; vertical-align: top" />
</td>
<td id="header-text-container" valign="middle" style="padding: 0px; border-collapse: collapse; vertical-align: middle; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px"> <a class="user-hover" rel="bob lai" id="email_bob lai" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=bob+lai" style="color:#6c797f;; color: #3b73af; text-decoration: none">Bob Lai</a> <strong>commented</strong> on <a href="https://hibernate.atlassian.net/browse/HHH-8057" style="color: #3b73af; text-decoration: none"><img src="https://hibernate.atlassian.net/images/icons/issuetypes/bug.png" height="16" width="16" border="0" align="absmiddle" alt="Bug" /> HHH-8057</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="email-content-container" style="padding: 0px; border-collapse: collapse; padding: 0 20px">
<table id="email-content-table" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-spacing: 0; border-collapse: separate">
<tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<td class="email-content-rounded-top mobile-expand" style="padding: 0px; border-collapse: collapse; color: #fff; padding: 0 15px 0 16px; height: 15px; background-color: #fff; border-left: 1px solid #ccc; border-top: 1px solid #ccc; border-right: 1px solid #ccc; border-bottom: 0; border-top-right-radius: 5px; border-top-left-radius: 5px; height: 10px; line-height: 10px; padding: 0 15px 0 16px; mso-line-height-rule: exactly">
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff">
<table class="page-title-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td style="vertical-align: top;; padding: 0px; border-collapse: collapse; padding-right: 5px; font-size: 20px; line-height: 30px; mso-line-height-rule: exactly" class="page-title-pattern-header-container"> <span class="page-title-pattern-header" style="font-family: Arial, sans-serif; padding: 0; font-size: 20px; line-height: 30px; mso-text-raise: 2px; mso-line-height-rule: exactly; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-8057" style="color: #3b73af; text-decoration: none">Re: Bad proxy behavior when using store_data_at_delete and audited parent/child relationships</a> </span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="text-paragraph-pattern-top" class="email-content-main mobile-expand comment-top-pattern" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff; border-bottom: none; padding-bottom: 0">
<table class="text-paragraph-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 2px">
<tr>
<td class="text-paragraph-pattern-container mobile-resize-text " style="padding: 0px; border-collapse: collapse; padding: 0 0 10px 0">
<p style="margin: 10px 0 0 0">Hi All,<br /> I test the code from Hibernate 4.2.1 and 4.2.6Final<br /> in the auditReader , It generate the sql seem for the child's REV for delete action is not treat as insert and update action.<br /> below the generated result</p>
<div class="code panel" style="border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
/* select
e__
from
tpdrg.Child_AUD e__
where
e__.parent_name = :parent_name
and (
(
e__.originalId.REV.id = (
select
max(e2__.originalId.REV.id)
from
tpdrg.Child_AUD e2__
where
e2__.originalId.REV.id <= :revision
and e__.originalId.name = e2__.originalId.name
)
and REVTYPE != :delrevisiontype
)
or (
originalId.REV.id = :revision
and REVTYPE = :delrevisiontype
)
) */ select
child_aud0_.name as name1_1_,
child_aud0_.REV as REV2_1_,
child_aud0_.REVTYPE as REVTYPE3_1_,
child_aud0_.parent_name as parent_n4_1_
from
Child_AUD child_aud0_
where
child_aud0_.parent_name=?
and (
child_aud0_.REV=(
select
max(child_aud1_.REV)
from
Child_AUD child_aud1_
where
child_aud1_.REV<=?
and child_aud0_.name=child_aud1_.name
)
and child_aud0_.REVTYPE<>?
or child_aud0_.REV=?
and child_aud0_.REVTYPE=?
)
03 Dec 2013 16:02:52 [main ] TRACE BasicBinder - binding parameter [1] as [VARCHAR] - Parent
03 Dec 2013 16:02:52 [main ] TRACE BasicBinder - binding parameter [2] as [INTEGER] - 2147483647
03 Dec 2013 16:02:52 [main ] TRACE BasicBinder - binding parameter [3] as [INTEGER] - 2
03 Dec 2013 16:02:52 [main ] TRACE BasicBinder - binding parameter [4] as [INTEGER] - 2147483647
03 Dec 2013 16:02:52 [main ] TRACE BasicBinder - binding parameter [5] as [INTEGER] - 2
</pre>
</div>
</div>
<p style="margin: 10px 0 0 0">below is the full test case for your reference</p>
<div class="code panel" style="border-style: solid;border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;; border-bottom: 1px solid #ccc; padding: 9px 12px">
<b>pom.xml</b>
</div>
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
<?xml version=<span class="code-quote" style="color: #009100">"1.0"</span> encoding=<span class="code-quote" style="color: #009100">"UTF-8"</span>?>
<project xmlns=<span class="code-quote" style="color: #009100">"http:<span class="code-comment" style="color: #808080">//maven.apache.org/POM/4.0.0"</span>
</span> xmlns:xsi=<span class="code-quote" style="color: #009100">"http:<span class="code-comment" style="color: #808080">//www.w3.org/2001/XMLSchema-instance"</span>
</span> xsi:schemaLocation=<span class="code-quote" style="color: #009100">"http:<span class="code-comment" style="color: #808080">//maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"</span>>
</span> <modelVersion>4.0.0</modelVersion>
<groupId>TestHibernate</groupId>
<artifactId>TestHibernate</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>com.googlecode.flyway</groupId>
<artifactId>flyway-core</artifactId>
<version>2.2.1</version>
</dependency>
<dependency>
<groupId>net.sourceforge.jtds</groupId>
<artifactId>jtds</artifactId>
<version>1.2.7</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
<version>4.2.6.Final</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>4.2.6.Final</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-envers</artifactId>
<version>4.2.6.Final</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework.data</groupId>
<artifactId>spring-data-jpa</artifactId>
<version>1.3.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jms</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-core</artifactId>
<version>3.1.4.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-web</artifactId>
<version>3.1.4.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-config</artifactId>
<version>3.1.4.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>3.2.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.testng</groupId>
<artifactId>testng</artifactId>
<version>6.8.5</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.5</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.5</version>
</dependency>
</dependencies>
</project>
</pre>
</div>
</div>
<div class="code panel" style="border-style: solid;border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;; border-bottom: 1px solid #ccc; padding: 9px 12px">
<b>Parent.java</b>
</div>
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
<span class="code-keyword" style="color: #000091">package</span> tpdrg;
<span class="code-keyword" style="color: #000091">import</span> org.hibernate.envers.Audited;
<span class="code-keyword" style="color: #000091">import</span> javax.persistence.*;
<span class="code-keyword" style="color: #000091">import</span> java.util.List;
@Entity
@Audited
<span class="code-keyword" style="color: #000091">public</span> class Parent {
<span class="code-keyword" style="color: #000091">private</span> <span class="code-object" style="color: #910091">String</span> name;
@Id
<span class="code-keyword" style="color: #000091">public</span> <span class="code-object" style="color: #910091">String</span> getName() {
<span class="code-keyword" style="color: #000091">return</span> name;
}
<span class="code-keyword" style="color: #000091">public</span> void setName(<span class="code-object" style="color: #910091">String</span> name) {
<span class="code-keyword" style="color: #000091">this</span>.name = name;
}
<span class="code-keyword" style="color: #000091">private</span> List<Child> child;
@OneToMany(cascade = CascadeType.ALL,mappedBy = <span class="code-quote" style="color: #009100">"parent"</span>,orphanRemoval = <span class="code-keyword" style="color: #000091">true</span>)
<span class="code-keyword" style="color: #000091">public</span> List<Child> getChild() {
<span class="code-keyword" style="color: #000091">return</span> child;
}
<span class="code-keyword" style="color: #000091">public</span> void setChild(List<Child> child) {
<span class="code-keyword" style="color: #000091">this</span>.child = child;
}
}
</pre>
</div>
</div>
<div class="code panel" style="border-style: solid;border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;; border-bottom: 1px solid #ccc; padding: 9px 12px">
<b>Child.java</b>
</div>
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
<span class="code-keyword" style="color: #000091">package</span> tpdrg;
<span class="code-keyword" style="color: #000091">import</span> org.hibernate.envers.Audited;
<span class="code-keyword" style="color: #000091">import</span> javax.persistence.Entity;
<span class="code-keyword" style="color: #000091">import</span> javax.persistence.Id;
<span class="code-keyword" style="color: #000091">import</span> javax.persistence.ManyToOne;
@Entity
@Audited
<span class="code-keyword" style="color: #000091">public</span> class Child {
<span class="code-keyword" style="color: #000091">private</span> <span class="code-object" style="color: #910091">String</span> name;
@Id
<span class="code-keyword" style="color: #000091">public</span> <span class="code-object" style="color: #910091">String</span> getName() {
<span class="code-keyword" style="color: #000091">return</span> name;
}
<span class="code-keyword" style="color: #000091">public</span> void setName(<span class="code-object" style="color: #910091">String</span> name) {
<span class="code-keyword" style="color: #000091">this</span>.name = name;
}
<span class="code-keyword" style="color: #000091">private</span> Parent parent;
@ManyToOne
<span class="code-keyword" style="color: #000091">public</span> Parent getParent() {
<span class="code-keyword" style="color: #000091">return</span> parent;
}
<span class="code-keyword" style="color: #000091">public</span> void setParent(Parent parent) {
<span class="code-keyword" style="color: #000091">this</span>.parent = parent;
}
}
</pre>
</div>
</div>
<div class="code panel" style="border-style: solid;border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;; border-bottom: 1px solid #ccc; padding: 9px 12px">
<b>Test.java</b>
</div>
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
<span class="code-keyword" style="color: #000091">package</span> tpdrg;
<span class="code-keyword" style="color: #000091">import</span> org.hibernate.Session;
<span class="code-keyword" style="color: #000091">import</span> org.hibernate.Transaction;
<span class="code-keyword" style="color: #000091">import</span> org.hibernate.envers.AuditReader;
<span class="code-keyword" style="color: #000091">import</span> org.hibernate.envers.AuditReaderFactory;
<span class="code-keyword" style="color: #000091">import</span> org.springframework.beans.factory.annotation.Autowired;
<span class="code-keyword" style="color: #000091">import</span> org.springframework.beans.factory.annotation.Qualifier;
<span class="code-keyword" style="color: #000091">import</span> org.springframework.test.context.ContextConfiguration;
<span class="code-keyword" style="color: #000091">import</span> org.springframework.test.context.testng.AbstractTestNGSpringContextTests;
<span class="code-keyword" style="color: #000091">import</span> org.testng.annotations.AfterMethod;
<span class="code-keyword" style="color: #000091">import</span> org.testng.annotations.BeforeMethod;
<span class="code-keyword" style="color: #000091">import</span> org.testng.annotations.Test;
<span class="code-keyword" style="color: #000091">import</span> java.util.ArrayList;
<span class="code-keyword" style="color: #000091">import</span> java.util.List;
@Test
@ContextConfiguration(locations = <span class="code-quote" style="color: #009100">"classpath*:spring-config.xml"</span>)
<span class="code-keyword" style="color: #000091">public</span> class TEST <span class="code-keyword" style="color: #000091">extends</span> AbstractTestNGSpringContextTests {
@Autowired
@Qualifier(<span class="code-quote" style="color: #009100">"Deals"</span>)
<span class="code-keyword" style="color: #000091">protected</span> org.hibernate.SessionFactory sf;
Session session;
@BeforeMethod
<span class="code-keyword" style="color: #000091">public</span> void init() {
session = sf.openSession();
}
@AfterMethod
<span class="code-keyword" style="color: #000091">public</span> void close() {
session.close();
}
@Test
<span class="code-keyword" style="color: #000091">public</span> void AddNew(){
Parent p = <span class="code-keyword" style="color: #000091">new</span> Parent();
p.setName(<span class="code-quote" style="color: #009100">"Parent"</span>);
ArrayList children = <span class="code-keyword" style="color: #000091">new</span> ArrayList();
<span class="code-keyword" style="color: #000091">for</span> (<span class="code-object" style="color: #910091">int</span> i = 0 ; i < 3 ;i++){
Child c = <span class="code-keyword" style="color: #000091">new</span> Child();
c.setName(<span class="code-quote" style="color: #009100">"child "</span>+i);
c.setParent(p);
children.add(c);
}
p.setChild(children);
Transaction tx = session.getTransaction();
tx.begin();
session.saveOrUpdate(p);
tx.commit();
}
@Test(dependsOnMethods = {<span class="code-quote" style="color: #009100">"AddNew"</span>})
<span class="code-keyword" style="color: #000091">public</span> void Remove(){
Transaction tx = session.getTransaction();
tx.begin();
Parent p = (Parent)session.get(Parent.class,<span class="code-quote" style="color: #009100">"Parent"</span>);
session.delete(p);
tx.commit();
}
@Test(dependsOnMethods = {<span class="code-quote" style="color: #009100">"Remove"</span>})
<span class="code-keyword" style="color: #000091">public</span> void AuditReader(){
Transaction tx = session.getTransaction();
tx.begin();
AuditReader reader = AuditReaderFactory.get(session);
Parent deletedObject = reader.find(Parent.class,Parent.class.getName(), <span class="code-quote" style="color: #009100">"Parent"</span>, <span class="code-object" style="color: #910091">Integer</span>.MAX_VALUE, <span class="code-keyword" style="color: #000091">true</span>);
List<Child> children = (List<Child>)deletedObject.getChild();
<span class="code-keyword" style="color: #000091">assert</span> children.size()>0:<span class="code-quote" style="color: #009100">"Expect the result should not zero"</span>;
tx.commit();
}
</pre>
</div>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff">
<table id="actions-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px">
<tr>
<td id="actions-pattern-container" valign="middle" style="padding: 0px; border-collapse: collapse; padding: 10px 0 10px 24px; vertical-align: middle; padding-left: 0">
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td class="actions-pattern-action-icon-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 0px; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-8057#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="https://hibernate.atlassian.net/images/mail/comment-icon.png" alt="Add Comment" title="Add Comment" height="16" width="16" border="0" style="vertical-align: middle" /> </a>
</td>
<td class="actions-pattern-action-text-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 4px; padding-left: 5px"> <a href="https://hibernate.atlassian.net/browse/HHH-8057#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none">Add Comment</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<tr>
<td class="email-content-rounded-bottom mobile-expand" style="padding: 0px; border-collapse: collapse; color: #fff; padding: 0 15px 0 16px; height: 5px; line-height: 5px; background-color: #fff; border-top: 0; border-left: 1px solid #ccc; border-bottom: 1px solid #ccc; border-right: 1px solid #ccc; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; mso-line-height-rule: exactly">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="footer-pattern" style="padding: 0px; border-collapse: collapse; padding: 12px 20px">
<table id="footer-pattern-container" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0px; border-collapse: collapse; color: #999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px">
This message was sent by Atlassian JIRA <span id="footer-build-information">(v6.2-OD-03#6206-<span title="14444503aa87c48a61ab99005f20a349f3a79824" data-commit-id="14444503aa87c48a61ab99005f20a349f3a79824}">sha1:1444450</span>)</span>
</td>
<td id="footer-pattern-logo-desktop-container" valign="top" style="padding: 0px; border-collapse: collapse; padding-left: 20px; vertical-align: top">
<table style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="footer-pattern-logo-desktop-padding" style="padding: 0px; border-collapse: collapse; padding-top: 3px"> <img id="footer-pattern-logo-desktop" src="https://hibernate.atlassian.net/images/mail/footer-desktop-logo.png" alt="Atlassian logo" title="Atlassian logo" width="169" height="36" class="image_fix" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>