<!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/7029b7a7c9e7549f5a7e2a73e15aa277?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="msimka" id="email_msimka" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=msimka" style="color:#6c797f;; color: #3b73af; text-decoration: none">Martin Šimka</a> <strong>created</strong> an issue
</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 class="page-title-pattern-first-line " style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; padding-top: 10px"> <a href="https://hibernate.atlassian.net/browse/HHH" style="color: #3b73af; text-decoration: none">Hibernate ORM</a> / <a href="https://hibernate.atlassian.net/browse/HHH-9202" style="color: #3b73af; text-decoration: none"><img src="cid:jira-generated-image-static-bug-0377cd21-8459-44d4-8b8b-3f860fb3bd22" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom" /></a> <a href="https://hibernate.atlassian.net/browse/HHH-9202" style="color: #3b73af; text-decoration: none">HHH-9202</a>
</td>
</tr>
<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-9202" style="color: #3b73af; text-decoration: none">NPE in OneToOneLinkTest on oracle12c</a> </span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand wrapper-special-margin" 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; padding-top: 10px; padding-bottom: 5px">
<table class="keyvalue-table" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Issue Type:
</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-static-bug-0377cd21-8459-44d4-8b8b-3f860fb3bd22" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom" /> Bug
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Affects Versions:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
4.2.12
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Assignee:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <a class="user-hover" rel="gbadner" id="email_gbadner" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=gbadner" style="color:#6c797f;; color: #3b73af; text-decoration: none">Gail Badner</a>
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Components:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
testsuite
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Created:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
19/May/14 1:53 AM
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Environment:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
oracle12c
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Priority:
</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-static-minor-ec350d0b-3366-43de-9c26-5ae22ec35712" height="16" width="16" border="0" align="absmiddle" alt="Minor" style="vertical-align: text-bottom" /> Minor
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Reporter:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <a class="user-hover" rel="msimka" id="email_msimka" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=msimka" style="color:#6c797f;; color: #3b73af; text-decoration: none">Martin Šimka</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand issue-description-container" 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; padding-top: 5px; padding-bottom: 10px">
<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-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Stacktrace:</p>
<div class="preformatted 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="preformattedContent panelContent" style="padding: 9px 12px">
<pre style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal; white-space: pre; word-break: normal; word-wrap: break-word; word-break: break-word; white-space: pre-wrap">java.lang.NullPointerException
        at org.hibernate.test.onetoone.link.OneToOneLinkTest.testOneToOneViaAssociationTable(OneToOneLinkTest.java:76)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
        at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
        at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
        at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:63)
        at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
        at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
        at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
        at org.junit.internal.runners.statements.FailOnTimeout$StatementThread.run(FailOnTimeout.java:74)
</pre>
</div>
</div>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Output:</p>
<div class="preformatted 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="preformattedContent panelContent" style="padding: 9px 12px">
<pre style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal; white-space: pre; word-break: normal; word-wrap: break-word; word-break: break-word; white-space: pre-wrap">17:20:44,587 INFO Configuration:709 - HHH000221: Reading mappings from resource: org/hibernate/test/onetoone/link/Person.hbm.xml
17:20:44,651 WARN DriverManagerConnectionProviderImpl:98 - HHH000402: Using Hibernate built-in connection pool (not for production use!)
17:20:44,652 INFO DriverManagerConnectionProviderImpl:134 - HHH000115: Hibernate connection pool size: 5
17:20:44,659 INFO DriverManagerConnectionProviderImpl:137 - HHH000006: Autocommit mode: false
17:20:44,659 INFO DriverManagerConnectionProviderImpl:151 - HHH000401: using driver [oracle.jdbc.driver.OracleDriver] at URL [jdbc:oracle:thin:@dev151.mw.lab.eng.bos.redhat.com:1521:qaora12]
17:20:44,660 INFO DriverManagerConnectionProviderImpl:156 - HHH000046: Connection properties: {user=dballo03, password=****}
17:20:44,730 INFO Dialect:130 - HHH000400: Using dialect: org.hibernate.dialect.Oracle10gDialect
17:20:44,734 INFO TransactionFactoryInitiator:68 - HHH000399: Using default transaction strategy (direct JDBC transactions)
17:20:44,736 INFO ASTQueryTranslatorFactory:48 - HHH000397: Using ASTQueryTranslatorFactory
17:20:44,741 WARN CachingRegionFactory:58 - CachingRegionFactory should be only used for testing.
17:20:44,848 INFO SchemaExport:343 - HHH000227: Running hbm2ddl schema export
17:20:44,853 DEBUG SchemaExport:353 - Import file not found: /import.sql
17:20:44,859 DEBUG SQL:104 - drop table Customer cascade constraints
17:20:44,868 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table Customer cascade constraints
17:20:44,869 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:44,871 DEBUG SQL:104 - drop table Employee cascade constraints
17:20:44,880 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table Employee cascade constraints
17:20:44,881 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:44,882 DEBUG SQL:104 - drop table Person cascade constraints
17:20:44,885 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table Person cascade constraints
17:20:44,886 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:44,889 DEBUG SQL:104 - drop table customerPerson cascade constraints
17:20:44,894 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table customerPerson cascade constraints
17:20:44,896 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:44,897 DEBUG SQL:104 - drop table employeePerson cascade constraints
17:20:44,905 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table employeePerson cascade constraints
17:20:44,906 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:44,907 DEBUG SQL:104 - drop sequence hibernate_sequence
17:20:44,913 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop sequence hibernate_sequence
17:20:44,914 ERROR SchemaExport:426 - ORA-02289: sequence does not exist
17:20:44,916 DEBUG SQL:104 - create table Customer (customerId number(19,0) not null, primary key (customerId))
17:20:44,931 DEBUG SQL:104 - create table Employee (employeeId number(19,0) not null, primary key (employeeId))
17:20:44,938 DEBUG SQL:104 - create table Person (name varchar2(255 char) not null, dob date, primary key (name))
17:20:44,946 DEBUG SQL:104 - create table customerPerson (personId varchar2(255 char) not null, customerId number(19,0) not null, primary key (customerId))
17:20:44,956 DEBUG SQL:104 - create table employeePerson (personId varchar2(255 char) not null, employeeId number(19,0) not null, primary key (employeeId))
17:20:44,964 DEBUG SQL:104 - alter table customerPerson add constraint UK_s9qdd2ped3twuxopit9nub2tt unique (personId)
17:20:44,975 DEBUG SQL:104 - alter table employeePerson add constraint UK_rab6rrs48h2552tf4ur1kwgve unique (personId)
17:20:44,983 DEBUG SQL:104 - alter table customerPerson add constraint FK_s9qdd2ped3twuxopit9nub2tt foreign key (personId) references Person
17:20:44,993 DEBUG SQL:104 - alter table customerPerson add constraint FK_f85cgu4oh6ifbnp621bhitvs5 foreign key (customerId) references Customer
17:20:45,001 DEBUG SQL:104 - alter table employeePerson add constraint FK_rab6rrs48h2552tf4ur1kwgve foreign key (personId) references Person
17:20:45,009 DEBUG SQL:104 - alter table employeePerson add constraint FK_jgdrcq5xf8dxo0l0alb7au40r foreign key (employeeId) references Employee
17:20:45,017 DEBUG SQL:104 - create sequence hibernate_sequence
17:20:45,020 INFO SchemaExport:405 - HHH000230: Schema export complete
17:20:45,028 DEBUG SQL:104 - select hibernate_sequence.nextval from dual
17:20:45,035 DEBUG SQL:104 - insert into Employee (employeeId) values (?)
17:20:45,042 DEBUG SQL:104 - insert into Person (dob, name) values (?, ?)
17:20:45,417 DEBUG SQL:104 - insert into employeePerson (personId, employeeId) values (?, ?)
17:20:50,148 INFO StatisticalLoggingSessionEventListener:275 - Session Metrics {
6765 nanoseconds spent acquiring 1 JDBC connections;
0 nanoseconds spent releasing 0 JDBC connections;
160426 nanoseconds spent preparing 4 JDBC statements;
1128338910 nanoseconds spent executing 4 JDBC statements;
0 nanoseconds spent executing 0 JDBC batches;
0 nanoseconds spent performing 0 L2C puts;
0 nanoseconds spent performing 0 L2C hits;
0 nanoseconds spent performing 0 L2C misses;
5113557222 nanoseconds spent executing 1 flushes (flushing a total of 2 entities and 0 collections);
0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)
}
17:20:50,149 DEBUG QueryTranslatorImpl:267 - parse() - HQL: from org.hibernate.test.onetoone.link.Employee e where e.person.name like 'Gavin%'
17:20:50,158 DEBUG QueryTranslatorImpl:285 - --- HQL AST ---
\-[QUERY] Node: 'query'
+-[SELECT_FROM] Node: 'SELECT_FROM'
| \-[FROM] Node: 'from'
| \-[RANGE] Node: 'RANGE'
| +-[DOT] Node: '.'
| | +-[DOT] Node: '.'
| | | +-[DOT] Node: '.'
| | | | +-[DOT] Node: '.'
| | | | | +-[DOT] Node: '.'
| | | | | | +-[IDENT] Node: 'org'
| | | | | | \-[IDENT] Node: 'hibernate'
| | | | | \-[IDENT] Node: 'test'
| | | | \-[IDENT] Node: 'onetoone'
| | | \-[IDENT] Node: 'link'
| | \-[IDENT] Node: 'Employee'
| \-[ALIAS] Node: 'e'
\-[WHERE] Node: 'where'
\-[LIKE] Node: 'like'
+-[DOT] Node: '.'
| +-[DOT] Node: '.'
| | +-[IDENT] Node: 'e'
| | \-[IDENT] Node: 'person'
| \-[IDENT] Node: 'name'
\-[QUOTED_STRING] Node: ''Gavin%''
17:20:50,159 DEBUG ErrorCounter:82 - throwQueryException() : no errors
17:20:50,166 DEBUG FromElement:157 - FromClause{level=1} : org.hibernate.test.onetoone.link.Employee (e) -> employee0_
17:20:50,167 DEBUG FromReferenceNode:75 - Resolved : e -> employee0_.employeeId
17:20:50,174 DEBUG DotNode:620 - getDataType() : person -> org.hibernate.type.ManyToOneType(org.hibernate.test.onetoone.link.Person)
17:20:50,180 DEBUG DotNode:583 - dereferenceShortcut() : property name in org.hibernate.test.onetoone.link.Employee does not require a join.
17:20:50,181 DEBUG DotNode:606 - Unresolved property path is now 'person.name'
17:20:50,186 DEBUG FromReferenceNode:75 - Resolved : e.person -> employee0_1_.personId
17:20:50,186 DEBUG DotNode:620 - getDataType() : person.name -> org.hibernate.type.StringType@1197f46
17:20:50,192 DEBUG FromReferenceNode:75 - Resolved : e.person.name -> employee0_1_.personId
17:20:50,193 DEBUG HqlSqlWalker:631 - processQuery() : ( SELECT ( FromClause{level=1} Employee employee0_ ) ( where ( like ( employee0_1_.personId ( employee0_1_.personId employee0_.employeeId person ) name ) 'Gavin%' ) ) )
17:20:50,194 DEBUG HqlSqlWalker:871 - Derived SELECT clause created.
17:20:50,200 DEBUG JoinProcessor:177 - Using FROM fragment [Employee employee0_ left outer join employeePerson employee0_1_ on employee0_.employeeId=employee0_1_.employeeId]
17:20:50,201 DEBUG QueryTranslatorImpl:254 - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (employeePerson,Employee)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'employee0_.employeeId as employee1_1_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=e,role=null,tableName=Employee,tableAlias=employee0_,origin=null,columns={,className=org.hibernate.test.onetoone.link.Employee}}}
| \-[SQL_TOKEN] SqlFragment: 'employee0_1_.personId as personId1_4_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[e], fromElementByTableAlias=[employee0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'Employee employee0_ left outer join employeePerson employee0_1_ on employee0_.employeeId=employee0_1_.employeeId' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=e,role=null,tableName=Employee,tableAlias=employee0_,origin=null,columns={,className=org.hibernate.test.onetoone.link.Employee}}
\-[WHERE] SqlNode: 'where'
\-[LIKE] BinaryLogicOperatorNode: 'like'
+-[DOT] DotNode: 'employee0_1_.personId' {propertyName=name,dereferenceType=ALL,propertyPath=person.name,path=e.person.name,tableAlias=employee0_,className=org.hibernate.test.onetoone.link.Employee,classAlias=e}
| +-[DOT] DotNode: 'employee0_1_.personId' {propertyName=name,dereferenceType=0,propertyPath=person.name,path=e.person,tableAlias=employee0_,className=org.hibernate.test.onetoone.link.Employee,classAlias=e}
| | +-[ALIAS_REF] IdentNode: 'employee0_.employeeId' {alias=e, className=org.hibernate.test.onetoone.link.Employee, tableAlias=employee0_}
| | \-[IDENT] IdentNode: 'person' {originalText=person}
| \-[IDENT] IdentNode: 'name' {originalText=name}
\-[QUOTED_STRING] LiteralNode: ''Gavin%''
17:20:50,202 DEBUG ErrorCounter:82 - throwQueryException() : no errors
17:20:50,209 DEBUG QueryTranslatorImpl:237 - HQL: from org.hibernate.test.onetoone.link.Employee e where e.person.name like 'Gavin%'
17:20:50,209 DEBUG QueryTranslatorImpl:238 - SQL: select employee0_.employeeId as employee1_1_, employee0_1_.personId as personId1_4_ from Employee employee0_ left outer join employeePerson employee0_1_ on employee0_.employeeId=employee0_1_.employeeId where employee0_1_.personId like 'Gavin%'
17:20:50,210 DEBUG ErrorCounter:82 - throwQueryException() : no errors
17:20:50,211 DEBUG SQL:104 - select employee0_.employeeId as employee1_1_, employee0_1_.personId as personId1_4_ from Employee employee0_ left outer join employeePerson employee0_1_ on employee0_.employeeId=employee0_1_.employeeId where employee0_1_.personId like 'Gavin%'
17:20:50,224 DEBUG SQL:104 - select person0_.name as name1_2_0_, person0_.dob as dob2_2_0_, person0_1_.employeeId as employee2_4_0_, person0_2_.customerId as customer2_3_0_ from Person person0_ left outer join employeePerson person0_1_ on person0_.name=person0_1_.personId left outer join customerPerson person0_2_ on person0_.name=person0_2_.personId where person0_.name=?
17:20:50,230 DEBUG QueryTranslatorImpl:267 - parse() - HQL: from org.hibernate.test.onetoone.link.Employee e where e.person.dob = :date
17:20:50,241 DEBUG QueryTranslatorImpl:285 - --- HQL AST ---
\-[QUERY] Node: 'query'
+-[SELECT_FROM] Node: 'SELECT_FROM'
| \-[FROM] Node: 'from'
| \-[RANGE] Node: 'RANGE'
| +-[DOT] Node: '.'
| | +-[DOT] Node: '.'
| | | +-[DOT] Node: '.'
| | | | +-[DOT] Node: '.'
| | | | | +-[DOT] Node: '.'
| | | | | | +-[IDENT] Node: 'org'
| | | | | | \-[IDENT] Node: 'hibernate'
| | | | | \-[IDENT] Node: 'test'
| | | | \-[IDENT] Node: 'onetoone'
| | | \-[IDENT] Node: 'link'
| | \-[IDENT] Node: 'Employee'
| \-[ALIAS] Node: 'e'
\-[WHERE] Node: 'where'
\-[EQ] Node: '='
+-[DOT] Node: '.'
| +-[DOT] Node: '.'
| | +-[IDENT] Node: 'e'
| | \-[IDENT] Node: 'person'
| \-[IDENT] Node: 'dob'
\-[COLON] Node: ':'
\-[IDENT] Node: 'date'
17:20:50,241 DEBUG ErrorCounter:82 - throwQueryException() : no errors
17:20:50,242 DEBUG FromElement:157 - FromClause{level=1} : org.hibernate.test.onetoone.link.Employee (e) -> employee0_
17:20:50,249 DEBUG FromReferenceNode:75 - Resolved : e -> employee0_.employeeId
17:20:50,250 DEBUG DotNode:620 - getDataType() : person -> org.hibernate.type.ManyToOneType(org.hibernate.test.onetoone.link.Person)
17:20:50,251 DEBUG DotNode:410 - dereferenceEntityJoin() : generating join for person in org.hibernate.test.onetoone.link.Employee (<no alias>) parent = [ ( . ( . employee0_.employeeId person ) dob ) ]
17:20:50,252 DEBUG FromElement:157 - FromClause{level=1} : org.hibernate.test.onetoone.link.Person (<no alias>) -> person1_
17:20:50,259 DEBUG FromClause:282 - addJoinByPathMap() : e.person -> ImpliedFromElement{implied,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=Person,tableAlias=person1_,origin=Employee employee0_,columns={employee0_1_.personId ,className=org.hibernate.test.onetoone.link.Person}}
17:20:50,260 DEBUG FromElementFactory:257 - createEntityJoin() : Implied multi-table entity join
17:20:50,261 DEBUG FromReferenceNode:75 - Resolved : e.person -> employee0_1_.personId
17:20:50,262 DEBUG DotNode:620 - getDataType() : dob -> org.hibernate.type.DateType@f99965
17:20:50,269 DEBUG FromReferenceNode:75 - Resolved : e.person.dob -> person1_.dob
17:20:50,270 DEBUG HqlSqlWalker:631 - processQuery() : ( SELECT ( FromClause{level=1} Employee employee0_ Person person1_ ) ( where ( = ( person1_.dob ( employee0_1_.personId employee0_.employeeId person ) dob ) ? ) ) )
17:20:50,271 DEBUG HqlSqlWalker:871 - Derived SELECT clause created.
17:20:50,276 DEBUG JoinProcessor:177 - Using FROM fragment [Employee employee0_ left outer join employeePerson employee0_1_ on employee0_.employeeId=employee0_1_.employeeId]
17:20:50,277 DEBUG JoinProcessor:177 - Using FROM fragment [Person person1_ left outer join employeePerson person1_1_ on person1_.name=person1_1_.personId left outer join customerPerson person1_2_ on person1_.name=person1_2_.personId]
17:20:50,278 DEBUG SyntheticAndFactory:92 - Using unprocessed WHERE-fragment [employee0_1_.personId=person1_.name]
17:20:50,286 DEBUG SyntheticAndFactory:124 - Using processed WHERE-fragment [employee0_1_.personId=person1_.name]
17:20:50,288 DEBUG QueryTranslatorImpl:254 - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (customerPerson,employeePerson,Employee,Person)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'employee0_.employeeId as employee1_1_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=e,role=null,tableName=Employee,tableAlias=employee0_,origin=null,columns={,className=org.hibernate.test.onetoone.link.Employee}}}
| \-[SQL_TOKEN] SqlFragment: 'employee0_1_.personId as personId1_4_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=2, fromElements=2, fromElementByClassAlias=[e], fromElementByTableAlias=[employee0_, person1_], fromElementsByPath=[e.person], collectionJoinFromElementsByPath=[], impliedElements=[]}
| +-[FROM_FRAGMENT] FromElement: 'Employee employee0_ left outer join employeePerson employee0_1_ on employee0_.employeeId=employee0_1_.employeeId' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=e,role=null,tableName=Employee,tableAlias=employee0_,origin=null,columns={,className=org.hibernate.test.onetoone.link.Employee}}
| \-[FROM_FRAGMENT] ImpliedFromElement: 'Person person1_ left outer join employeePerson person1_1_ on person1_.name=person1_1_.personId left outer join customerPerson person1_2_ on person1_.name=person1_2_.personId' ImpliedFromElement{implied,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=Person,tableAlias=person1_,origin=Employee employee0_ left outer join employeePerson employee0_1_ on employee0_.employeeId=employee0_1_.employeeId,columns={employee0_1_.personId ,className=org.hibernate.test.onetoone.link.Person}}
\-[WHERE] SqlNode: 'where'
+-[THETA_JOINS] SqlNode: '{theta joins}'
| \-[SQL_TOKEN] SqlFragment: 'employee0_1_.personId=person1_.name'
\-[EQ] BinaryLogicOperatorNode: '='
+-[DOT] DotNode: 'person1_.dob' {propertyName=dob,dereferenceType=ALL,propertyPath=dob,path=e.person.dob,tableAlias=person1_,className=org.hibernate.test.onetoone.link.Person,classAlias=null}
| +-[DOT] DotNode: 'employee0_1_.personId' {propertyName=person,dereferenceType=EOF,propertyPath=person,path=e.person,tableAlias=person1_,className=org.hibernate.test.onetoone.link.Person,classAlias=null}
| | +-[ALIAS_REF] IdentNode: 'employee0_.employeeId' {alias=e, className=org.hibernate.test.onetoone.link.Employee, tableAlias=employee0_}
| | \-[IDENT] IdentNode: 'person' {originalText=person}
| \-[IDENT] IdentNode: 'dob' {originalText=dob}
\-[NAMED_PARAM] ParameterNode: '?' {name=date, expectedType=org.hibernate.type.DateType@f99965}
17:20:50,288 DEBUG ErrorCounter:82 - throwQueryException() : no errors
17:20:50,296 DEBUG QueryTranslatorImpl:237 - HQL: from org.hibernate.test.onetoone.link.Employee e where e.person.dob = :date
17:20:50,296 DEBUG QueryTranslatorImpl:238 - SQL: select employee0_.employeeId as employee1_1_, employee0_1_.personId as personId1_4_ from Employee employee0_ left outer join employeePerson employee0_1_ on employee0_.employeeId=employee0_1_.employeeId, Person person1_ left outer join employeePerson person1_1_ on person1_.name=person1_1_.personId left outer join customerPerson person1_2_ on person1_.name=person1_2_.personId where employee0_1_.personId=person1_.name and person1_.dob=?
17:20:50,297 DEBUG ErrorCounter:82 - throwQueryException() : no errors
17:20:50,298 DEBUG SQL:104 - select employee0_.employeeId as employee1_1_, employee0_1_.personId as personId1_4_ from Employee employee0_ left outer join employeePerson employee0_1_ on employee0_.employeeId=employee0_1_.employeeId, Person person1_ left outer join employeePerson person1_1_ on person1_.name=person1_1_.personId left outer join customerPerson person1_2_ on person1_.name=person1_2_.personId where employee0_1_.personId=person1_.name and person1_.dob=?
17:20:50,306 INFO StatisticalLoggingSessionEventListener:275 - Session Metrics {
5152 nanoseconds spent acquiring 1 JDBC connections;
0 nanoseconds spent releasing 0 JDBC connections;
123019 nanoseconds spent preparing 3 JDBC statements;
12529955 nanoseconds spent executing 3 JDBC statements;
0 nanoseconds spent executing 0 JDBC batches;
0 nanoseconds spent performing 0 L2C puts;
0 nanoseconds spent performing 0 L2C hits;
0 nanoseconds spent performing 0 L2C misses;
0 nanoseconds spent executing 0 flushes (flushing a total of 0 entities and 0 collections);
11491 nanoseconds spent executing 2 partial-flushes (flushing a total of 0 entities and 0 collections)
}
17:20:50,309 INFO SchemaExport:343 - HHH000227: Running hbm2ddl schema export
17:20:50,310 DEBUG SchemaExport:353 - Import file not found: /import.sql
17:20:50,313 DEBUG SQL:104 - drop table Customer cascade constraints
17:20:50,331 DEBUG SQL:104 - drop table Employee cascade constraints
17:20:50,350 DEBUG SQL:104 - drop table Person cascade constraints
17:20:50,370 DEBUG SQL:104 - drop table customerPerson cascade constraints
17:20:50,393 DEBUG SQL:104 - drop table employeePerson cascade constraints
17:20:50,418 DEBUG SQL:104 - drop sequence hibernate_sequence
17:20:50,423 INFO SchemaExport:405 - HHH000230: Schema export complete
17:20:50,424 INFO DriverManagerConnectionProviderImpl:160 - HHH000030: Cleaning up connection pool [jdbc:oracle:thin:@dev151.mw.lab.eng.bos.redhat.com:1521:qaora12]
17:20:50,428 WARN DriverManagerConnectionProviderImpl:98 - HHH000402: Using Hibernate built-in connection pool (not for production use!)
17:20:50,429 INFO DriverManagerConnectionProviderImpl:134 - HHH000115: Hibernate connection pool size: 5
17:20:50,435 INFO DriverManagerConnectionProviderImpl:137 - HHH000006: Autocommit mode: false
17:20:50,439 INFO DriverManagerConnectionProviderImpl:151 - HHH000401: using driver [oracle.jdbc.driver.OracleDriver] at URL [jdbc:oracle:thin:@dev151.mw.lab.eng.bos.redhat.com:1521:qaora12]
17:20:50,440 INFO DriverManagerConnectionProviderImpl:156 - HHH000046: Connection properties: {user=dballo03, password=****}
17:20:50,508 INFO Dialect:130 - HHH000400: Using dialect: org.hibernate.dialect.Oracle10gDialect
17:20:50,515 INFO TransactionFactoryInitiator:68 - HHH000399: Using default transaction strategy (direct JDBC transactions)
17:20:50,516 INFO ASTQueryTranslatorFactory:48 - HHH000397: Using ASTQueryTranslatorFactory
17:20:50,525 WARN CachingRegionFactory:58 - CachingRegionFactory should be only used for testing.
17:20:50,527 WARN TypeFactory:68 - HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@15a8ed4 after already scoped org.hibernate.internal.SessionFactoryImpl@5723de
17:20:50,605 INFO SchemaExport:343 - HHH000227: Running hbm2ddl schema export
17:20:50,606 DEBUG SchemaExport:353 - Import file not found: /import.sql
17:20:50,615 DEBUG SQL:104 - drop table Customer cascade constraints
17:20:50,624 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table Customer cascade constraints
17:20:50,625 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:50,627 DEBUG SQL:104 - drop table Employee cascade constraints
17:20:50,630 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table Employee cascade constraints
17:20:50,631 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:50,632 DEBUG SQL:104 - drop table Person cascade constraints
17:20:50,643 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table Person cascade constraints
17:20:50,644 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:50,645 DEBUG SQL:104 - drop table customerPerson cascade constraints
17:20:50,653 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table customerPerson cascade constraints
17:20:50,654 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:50,654 DEBUG SQL:104 - drop table employeePerson cascade constraints
17:20:50,662 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop table employeePerson cascade constraints
17:20:50,662 ERROR SchemaExport:426 - ORA-00942: table or view does not exist
17:20:50,663 DEBUG SQL:104 - drop sequence hibernate_sequence
17:20:50,671 ERROR SchemaExport:425 - HHH000389: Unsuccessful: drop sequence hibernate_sequence
17:20:50,672 ERROR SchemaExport:426 - ORA-02289: sequence does not exist
17:20:50,673 DEBUG SQL:104 - create table Customer (customerId number(19,0) not null, primary key (customerId))
17:20:50,688 DEBUG SQL:104 - create table Employee (employeeId number(19,0) not null, primary key (employeeId))
17:20:50,695 DEBUG SQL:104 - create table Person (name varchar2(255 char) not null, dob date, primary key (name))
17:20:50,702 DEBUG SQL:104 - create table customerPerson (personId varchar2(255 char) not null, customerId number(19,0) not null, primary key (customerId))
17:20:50,710 DEBUG SQL:104 - create table employeePerson (personId varchar2(255 char) not null, employeeId number(19,0) not null, primary key (employeeId))
17:20:50,719 DEBUG SQL:104 - alter table customerPerson add constraint UK_s9qdd2ped3twuxopit9nub2tt unique (personId)
17:20:50,730 DEBUG SQL:104 - alter table employeePerson add constraint UK_rab6rrs48h2552tf4ur1kwgve unique (personId)
17:20:50,737 DEBUG SQL:104 - alter table customerPerson add constraint FK_s9qdd2ped3twuxopit9nub2tt foreign key (personId) references Person
17:20:50,747 DEBUG SQL:104 - alter table customerPerson add constraint FK_f85cgu4oh6ifbnp621bhitvs5 foreign key (customerId) references Customer
17:20:50,756 DEBUG SQL:104 - alter table employeePerson add constraint FK_rab6rrs48h2552tf4ur1kwgve foreign key (personId) references Person
17:20:50,765 DEBUG SQL:104 - alter table employeePerson add constraint FK_jgdrcq5xf8dxo0l0alb7au40r foreign key (employeeId) references Employee
17:20:50,773 DEBUG SQL:104 - create sequence hibernate_sequence
17:20:50,776 INFO SchemaExport:405 - HHH000230: Schema export complete
17:20:50,779 INFO SchemaExport:343 - HHH000227: Running hbm2ddl schema export
17:20:50,781 DEBUG SchemaExport:353 - Import file not found: /import.sql
17:20:50,787 DEBUG SQL:104 - drop table Customer cascade constraints
17:20:50,805 DEBUG SQL:104 - drop table Employee cascade constraints
17:20:50,822 DEBUG SQL:104 - drop table Person cascade constraints
17:20:50,840 DEBUG SQL:104 - drop table customerPerson cascade constraints
17:20:50,862 DEBUG SQL:104 - drop table employeePerson cascade constraints
17:20:50,884 DEBUG SQL:104 - drop sequence hibernate_sequence
17:20:50,889 INFO SchemaExport:405 - HHH000230: Schema export complete
17:20:50,889 INFO DriverManagerConnectionProviderImpl:160 - HHH000030: Cleaning up connection pool [jdbc:oracle:thin:@dev151.mw.lab.eng.bos.redhat.com:1521:qaora12]
</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-9202#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="cid:jira-generated-image-static-comment-icon-3ce946b5-eaa5-4cee-89fd-05bb435a99a1" 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-9202#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.3-OD-04-019#6322-<span title="5ba1e997140606d61a6d783a06f6ffadb05787c3" data-commit-id="5ba1e997140606d61a6d783a06f6ffadb05787c3}">sha1:5ba1e99</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="cid:jira-generated-image-static-footer-desktop-logo-fe197967-4016-447b-9e27-53ad6bb55f62" alt="Atlassian logo" title="Atlassian logo" width="169" height="36" class="image_fix" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>