HHH-9202

NPE in OneToOneLinkTest on oracle12c

Description

Stacktrace:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 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)

Output:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 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]

Environment

oracle12c

Status

Assignee

Brett Meyer

Reporter

Martin Šimka

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

4.2.12

Priority

Minor