Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.LazyLoadingTest STANDARD_OUT
- 08:03:33,143 INFO DriverManagerConnectionProviderImpl:96 - HHH000402: Using Hibernate built-in connection pool (not for production use!)
- 08:03:33,143 INFO DriverManagerConnectionProviderImpl:130 - HHH000115: Hibernate connection pool size: 5
- 08:03:33,143 INFO DriverManagerConnectionProviderImpl:133 - HHH000006: Autocommit mode: false
- 08:03:33,144 INFO DriverManagerConnectionProviderImpl:147 - HHH000401: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://postgresql04.mw.lab.eng.bos.redhat.com:5432/dballo02]
- 08:03:33,144 INFO DriverManagerConnectionProviderImpl:152 - HHH000046: Connection properties: {user=dballo02, password=****}
- 08:03:33,271 INFO Dialect:125 - HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL82Dialect
- 08:03:33,272 INFO LobCreatorBuilder:120 - HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
- 08:03:33,272 INFO TransactionFactoryInitiator:68 - HHH000399: Using default transaction strategy (direct JDBC transactions)
- 08:03:33,273 INFO ASTQueryTranslatorFactory:48 - HHH000397: Using ASTQueryTranslatorFactory
- 08:03:33,273 WARN CachingRegionFactory:56 - CachingRegionFactory should be only used for testing.
- 08:03:33,296 INFO SchemaExport:343 - HHH000227: Running hbm2ddl schema export
- 08:03:33,297 DEBUG SchemaExport:353 - Import file not found: /import.sql
- 08:03:33,297 DEBUG SQL:104 -
- alter table O_CUSTINVENTORY
- drop constraint FK223174592F7D6A92
- Hibernate:
- alter table O_CUSTINVENTORY
- drop constraint FK223174592F7D6A92
- 08:03:33,298 ERROR SchemaExport:425 - HHH000389: Unsuccessful: alter table O_CUSTINVENTORY drop constraint FK223174592F7D6A92
- 08:03:33,298 ERROR SchemaExport:426 - ERROR: relation "o_custinventory" does not exist
- 08:03:33,298 DEBUG SQL:104 -
- alter table O_CUSTINVENTORY
- drop constraint FK22317459157493FC
- Hibernate:
- alter table O_CUSTINVENTORY
- drop constraint FK22317459157493FC
- 08:03:33,299 ERROR SchemaExport:425 - HHH000389: Unsuccessful: alter table O_CUSTINVENTORY drop constraint FK22317459157493FC
- 08:03:33,299 ERROR SchemaExport:426 - ERROR: relation "o_custinventory" does not exist
- 08:03:33,299 DEBUG SQL:104 -
- drop table if exists O_CUSTINVENTORY cascade
- Hibernate:
- drop table if exists O_CUSTINVENTORY cascade
- 08:03:33,300 DEBUG SQL:104 -
- drop table if exists O_CUSTOMERDEMAND cascade
- Hibernate:
- drop table if exists O_CUSTOMERDEMAND cascade
- 08:03:33,300 DEBUG SQL:104 -
- drop table if exists O_ITEM cascade
- Hibernate:
- drop table if exists O_ITEM cascade
- 08:03:33,301 DEBUG SQL:104 -
- drop table if exists U_SEQUENCES cascade
- Hibernate:
- drop table if exists U_SEQUENCES cascade
- 08:03:33,301 DEBUG SQL:104 -
- create table O_CUSTINVENTORY (
- CI_CUSTOMERID int4 not null,
- CI_ID int4 not null,
- CI_QUANTITY int4,
- CI_VALUE numeric(19, 2),
- CI_VERSION int4,
- CI_ITEMID varchar(255),
- primary key (CI_CUSTOMERID, CI_ID)
- )
- Hibernate:
- create table O_CUSTINVENTORY (
- CI_CUSTOMERID int4 not null,
- CI_ID int4 not null,
- CI_QUANTITY int4,
- CI_VALUE numeric(19, 2),
- CI_VERSION int4,
- CI_ITEMID varchar(255),
- primary key (CI_CUSTOMERID, CI_ID)
- )
- 08:03:33,317 DEBUG SQL:104 -
- create table O_CUSTOMERDEMAND (
- C_ID int4 not null,
- C_BALANCE numeric(19, 2),
- C_CONTACT varchar(255),
- C_CREDIT varchar(255),
- C_CREDIT_LIMIT numeric(19, 2),
- C_FIRST varchar(255),
- C_LAST varchar(255),
- C_SINCE date,
- C_VERSION int4,
- C_YTD_PAYMENT numeric(19, 2),
- primary key (C_ID)
- )
- Hibernate:
- create table O_CUSTOMERDEMAND (
- C_ID int4 not null,
- C_BALANCE numeric(19, 2),
- C_CONTACT varchar(255),
- C_CREDIT varchar(255),
- C_CREDIT_LIMIT numeric(19, 2),
- C_FIRST varchar(255),
- C_LAST varchar(255),
- C_SINCE date,
- C_VERSION int4,
- C_YTD_PAYMENT numeric(19, 2),
- primary key (C_ID)
- )
- 08:03:33,325 DEBUG SQL:104 -
- create table O_ITEM (
- I_ID varchar(255) not null,
- I_CATEGORY int4,
- I_DESC varchar(255),
- I_DISCOUNT numeric(19, 2),
- I_NAME varchar(255),
- I_PRICE numeric(19, 2),
- I_VERSION int4,
- primary key (I_ID)
- )
- Hibernate:
- create table O_ITEM (
- I_ID varchar(255) not null,
- I_CATEGORY int4,
- I_DESC varchar(255),
- I_DISCOUNT numeric(19, 2),
- I_NAME varchar(255),
- I_PRICE numeric(19, 2),
- I_VERSION int4,
- primary key (I_ID)
- )
- 08:03:33,333 DEBUG SQL:104 -
- alter table O_CUSTINVENTORY
- add constraint FK223174592F7D6A92
- foreign key (CI_CUSTOMERID)
- references O_CUSTOMERDEMAND
- Hibernate:
- alter table O_CUSTINVENTORY
- add constraint FK223174592F7D6A92
- foreign key (CI_CUSTOMERID)
- references O_CUSTOMERDEMAND
- 08:03:33,336 DEBUG SQL:104 -
- alter table O_CUSTINVENTORY
- add constraint FK22317459157493FC
- foreign key (CI_ITEMID)
- references O_ITEM
- Hibernate:
- alter table O_CUSTINVENTORY
- add constraint FK22317459157493FC
- foreign key (CI_ITEMID)
- references O_ITEM
- 08:03:33,340 DEBUG SQL:104 -
- create table U_SEQUENCES (
- S_ID varchar(255) not null ,
- S_NEXTNUM int8,
- primary key ( S_ID )
- )
- Hibernate:
- create table U_SEQUENCES (
- S_ID varchar(255) not null ,
- S_NEXTNUM int8,
- primary key ( S_ID )
- )
- 08:03:33,343 INFO SchemaExport:405 - HHH000230: Schema export complete
- 08:03:33,344 DEBUG QueryTranslatorImpl:265 - parse() - HQL: select a from org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerInventoryDemand a
- 08:03:33,363 DEBUG QueryTranslatorImpl:283 - --- 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: '.'
- | | | | | | +-[DOT] Node: '.'
- | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | | +-[IDENT] Node: 'org'
- | | | | | | | | | | \-[IDENT] Node: 'hibernate'
- | | | | | | | | | \-[IDENT] Node: 'test'
- | | | | | | | | \-[IDENT] Node: 'annotations'
- | | | | | | | \-[IDENT] Node: 'derivedidentities'
- | | | | | | \-[IDENT] Node: 'e1'
- | | | | | \-[IDENT] Node: 'b'
- | | | | \-[IDENT] Node: 'specjmapid'
- | | | \-[IDENT] Node: 'ondemand'
- | | \-[IDENT] Node: 'CustomerInventoryDemand'
- | \-[ALIAS] Node: 'a'
- \-[SELECT] Node: 'select'
- \-[IDENT] Node: 'a'
- 08:03:33,363 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,363 DEBUG FromElement:157 - FromClause{level=1} : org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerInventoryDemand (a) -> customerin0_
- 08:03:33,364 DEBUG FromReferenceNode:74 - Resolved : a -> customerin0_.CI_ID
- 08:03:33,364 DEBUG HqlSqlWalker:629 - processQuery() : ( SELECT ( {select clause} customerin0_.CI_ID ) ( FromClause{level=1} O_CUSTINVENTORY customerin0_ ) )
- 08:03:33,364 DEBUG JoinProcessor:175 - Using FROM fragment [O_CUSTINVENTORY customerin0_]
- 08:03:33,365 DEBUG QueryTranslatorImpl:252 - --- SQL AST ---
- \-[SELECT] QueryNode: 'SELECT' querySpaces (O_CUSTINVENTORY)
- +-[SELECT_CLAUSE] SelectClause: '{select clause}'
- | +-[ALIAS_REF] IdentNode: 'customerin0_.CI_CUSTOMERID as CI1_627_, customerin0_.CI_ID as CI2_627_' {alias=a, className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerInventoryDemand, tableAlias=customerin0_}
- | \-[SQL_TOKEN] SqlFragment: 'customerin0_.CI_QUANTITY as CI3_627_, customerin0_.CI_VALUE as CI4_627_, customerin0_.CI_ITEMID as CI6_627_, customerin0_.CI_VERSION as CI5_627_'
- \-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[a], fromElementByTableAlias=[customerin0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
- \-[FROM_FRAGMENT] FromElement: 'O_CUSTINVENTORY customerin0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=a,role=null,tableName=O_CUSTINVENTORY,tableAlias=customerin0_,origin=null,columns={,className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerInventoryDemand}}
- 08:03:33,365 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,365 DEBUG QueryTranslatorImpl:235 - HQL: select a from org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerInventoryDemand a
- 08:03:33,365 DEBUG QueryTranslatorImpl:236 - SQL: select customerin0_.CI_CUSTOMERID as CI1_627_, customerin0_.CI_ID as CI2_627_, customerin0_.CI_QUANTITY as CI3_627_, customerin0_.CI_VALUE as CI4_627_, customerin0_.CI_ITEMID as CI6_627_, customerin0_.CI_VERSION as CI5_627_ from O_CUSTINVENTORY customerin0_
- 08:03:33,365 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,366 DEBUG QueryTranslatorImpl:265 - parse() - HQL: select COUNT(a) from org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand a
- 08:03:33,367 DEBUG QueryTranslatorImpl:283 - --- 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: '.'
- | | | | | | +-[DOT] Node: '.'
- | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | | +-[IDENT] Node: 'org'
- | | | | | | | | | | \-[IDENT] Node: 'hibernate'
- | | | | | | | | | \-[IDENT] Node: 'test'
- | | | | | | | | \-[IDENT] Node: 'annotations'
- | | | | | | | \-[IDENT] Node: 'derivedidentities'
- | | | | | | \-[IDENT] Node: 'e1'
- | | | | | \-[IDENT] Node: 'b'
- | | | | \-[IDENT] Node: 'specjmapid'
- | | | \-[IDENT] Node: 'ondemand'
- | | \-[IDENT] Node: 'CustomerDemand'
- | \-[ALIAS] Node: 'a'
- \-[SELECT] Node: 'select'
- \-[COUNT] Node: 'COUNT'
- \-[IDENT] Node: 'a'
- 08:03:33,368 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,368 DEBUG FromElement:157 - FromClause{level=1} : org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand (a) -> customerde0_
- 08:03:33,369 DEBUG FromReferenceNode:74 - Resolved : a -> customerde0_.C_ID
- 08:03:33,369 DEBUG HqlSqlWalker:629 - processQuery() : ( SELECT ( {select clause} ( COUNT customerde0_.C_ID ) ) ( FromClause{level=1} O_CUSTOMERDEMAND customerde0_ ) )
- 08:03:33,369 DEBUG JoinProcessor:175 - Using FROM fragment [O_CUSTOMERDEMAND customerde0_]
- 08:03:33,370 DEBUG QueryTranslatorImpl:252 - --- SQL AST ---
- \-[SELECT] QueryNode: 'SELECT' querySpaces (O_CUSTOMERDEMAND)
- +-[SELECT_CLAUSE] SelectClause: '{select clause}'
- | +-[COUNT] CountNode: 'COUNT'
- | | \-[ALIAS_REF] IdentNode: 'customerde0_.C_ID' {alias=a, className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand, tableAlias=customerde0_}
- | \-[SELECT_COLUMNS] SqlNode: ' as col_0_0_'
- \-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[a], fromElementByTableAlias=[customerde0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
- \-[FROM_FRAGMENT] FromElement: 'O_CUSTOMERDEMAND customerde0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=a,role=null,tableName=O_CUSTOMERDEMAND,tableAlias=customerde0_,origin=null,columns={,className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand}}
- 08:03:33,370 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,370 DEBUG QueryTranslatorImpl:235 - HQL: select COUNT(a) from org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand a
- 08:03:33,370 DEBUG QueryTranslatorImpl:236 - SQL: select count(customerde0_.C_ID) as col_0_0_ from O_CUSTOMERDEMAND customerde0_
- 08:03:33,370 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,371 DEBUG QueryTranslatorImpl:265 - parse() - HQL: select a from org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand a
- 08:03:33,372 DEBUG QueryTranslatorImpl:283 - --- 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: '.'
- | | | | | | +-[DOT] Node: '.'
- | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | | +-[IDENT] Node: 'org'
- | | | | | | | | | | \-[IDENT] Node: 'hibernate'
- | | | | | | | | | \-[IDENT] Node: 'test'
- | | | | | | | | \-[IDENT] Node: 'annotations'
- | | | | | | | \-[IDENT] Node: 'derivedidentities'
- | | | | | | \-[IDENT] Node: 'e1'
- | | | | | \-[IDENT] Node: 'b'
- | | | | \-[IDENT] Node: 'specjmapid'
- | | | \-[IDENT] Node: 'ondemand'
- | | \-[IDENT] Node: 'CustomerDemand'
- | \-[ALIAS] Node: 'a'
- \-[SELECT] Node: 'select'
- \-[IDENT] Node: 'a'
- 08:03:33,372 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,373 DEBUG FromElement:157 - FromClause{level=1} : org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand (a) -> customerde0_
- 08:03:33,373 DEBUG FromReferenceNode:74 - Resolved : a -> customerde0_.C_ID
- 08:03:33,373 DEBUG HqlSqlWalker:629 - processQuery() : ( SELECT ( {select clause} customerde0_.C_ID ) ( FromClause{level=1} O_CUSTOMERDEMAND customerde0_ ) )
- 08:03:33,374 DEBUG JoinProcessor:175 - Using FROM fragment [O_CUSTOMERDEMAND customerde0_]
- 08:03:33,374 DEBUG QueryTranslatorImpl:252 - --- SQL AST ---
- \-[SELECT] QueryNode: 'SELECT' querySpaces (O_CUSTOMERDEMAND)
- +-[SELECT_CLAUSE] SelectClause: '{select clause}'
- | +-[ALIAS_REF] IdentNode: 'customerde0_.C_ID as C1_626_' {alias=a, className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand, tableAlias=customerde0_}
- | \-[SQL_TOKEN] SqlFragment: 'customerde0_.C_BALANCE as C2_626_, customerde0_.C_CONTACT as C3_626_, customerde0_.C_CREDIT as C4_626_, customerde0_.C_CREDIT_LIMIT as C5_626_, customerde0_.C_FIRST as C6_626_, customerde0_.C_LAST as C7_626_, customerde0_.C_SINCE as C8_626_, customerde0_.C_VERSION as C9_626_, customerde0_.C_YTD_PAYMENT as C10_626_'
- \-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[a], fromElementByTableAlias=[customerde0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
- \-[FROM_FRAGMENT] FromElement: 'O_CUSTOMERDEMAND customerde0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=a,role=null,tableName=O_CUSTOMERDEMAND,tableAlias=customerde0_,origin=null,columns={,className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand}}
- 08:03:33,374 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,374 DEBUG QueryTranslatorImpl:235 - HQL: select a from org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand a
- 08:03:33,375 DEBUG QueryTranslatorImpl:236 - SQL: select customerde0_.C_ID as C1_626_, customerde0_.C_BALANCE as C2_626_, customerde0_.C_CONTACT as C3_626_, customerde0_.C_CREDIT as C4_626_, customerde0_.C_CREDIT_LIMIT as C5_626_, customerde0_.C_FIRST as C6_626_, customerde0_.C_LAST as C7_626_, customerde0_.C_SINCE as C8_626_, customerde0_.C_VERSION as C9_626_, customerde0_.C_YTD_PAYMENT as C10_626_ from O_CUSTOMERDEMAND customerde0_
- 08:03:33,375 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,375 DEBUG QueryTranslatorImpl:265 - parse() - HQL: SELECT c.id FROM org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand c WHERE c.creditLimit > :limit
- 08:03:33,378 DEBUG QueryTranslatorImpl:283 - --- 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: '.'
- | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | | | +-[IDENT] Node: 'org'
- | | | | | | | | | | | \-[IDENT] Node: 'hibernate'
- | | | | | | | | | | \-[IDENT] Node: 'test'
- | | | | | | | | | \-[IDENT] Node: 'annotations'
- | | | | | | | | \-[IDENT] Node: 'derivedidentities'
- | | | | | | | \-[IDENT] Node: 'e1'
- | | | | | | \-[IDENT] Node: 'b'
- | | | | | \-[IDENT] Node: 'specjmapid'
- | | | | \-[IDENT] Node: 'ondemand'
- | | | \-[IDENT] Node: 'CustomerDemand'
- | | \-[ALIAS] Node: 'c'
- | \-[SELECT] Node: 'SELECT'
- | \-[DOT] Node: '.'
- | +-[IDENT] Node: 'c'
- | \-[IDENT] Node: 'id'
- \-[WHERE] Node: 'WHERE'
- \-[GT] Node: '>'
- +-[DOT] Node: '.'
- | +-[IDENT] Node: 'c'
- | \-[IDENT] Node: 'creditLimit'
- \-[COLON] Node: ':'
- \-[IDENT] Node: 'limit'
- 08:03:33,378 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,379 DEBUG FromElement:157 - FromClause{level=1} : org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand (c) -> customerde0_
- 08:03:33,379 DEBUG FromReferenceNode:74 - Resolved : c -> customerde0_.C_ID
- 08:03:33,379 DEBUG DotNode:599 - getDataType() : id -> org.hibernate.type.IntegerType@3e4d6ff
- 08:03:33,379 DEBUG FromReferenceNode:74 - Resolved : c.id -> customerde0_.C_ID
- 08:03:33,380 DEBUG FromReferenceNode:74 - Resolved : c -> customerde0_.C_ID
- 08:03:33,380 DEBUG DotNode:599 - getDataType() : creditLimit -> org.hibernate.type.BigDecimalType@278f0471
- 08:03:33,380 DEBUG FromReferenceNode:74 - Resolved : c.creditLimit -> customerde0_.C_CREDIT_LIMIT
- 08:03:33,380 DEBUG HqlSqlWalker:629 - processQuery() : ( SELECT ( {select clause} ( customerde0_.C_ID customerde0_.C_ID id ) ) ( FromClause{level=1} O_CUSTOMERDEMAND customerde0_ ) ( WHERE ( > ( customerde0_.C_CREDIT_LIMIT customerde0_.C_ID creditLimit ) ? ) ) )
- 08:03:33,381 DEBUG JoinProcessor:175 - Using FROM fragment [O_CUSTOMERDEMAND customerde0_]
- 08:03:33,381 DEBUG QueryTranslatorImpl:252 - --- SQL AST ---
- \-[SELECT] QueryNode: 'SELECT' querySpaces (O_CUSTOMERDEMAND)
- +-[SELECT_CLAUSE] SelectClause: '{select clause}'
- | +-[DOT] DotNode: 'customerde0_.C_ID' {propertyName=id,dereferenceType=ALL,propertyPath=id,path=c.id,tableAlias=customerde0_,className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand,classAlias=c}
- | | +-[ALIAS_REF] IdentNode: 'customerde0_.C_ID' {alias=c, className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand, tableAlias=customerde0_}
- | | \-[IDENT] IdentNode: 'id' {originalText=id}
- | \-[SELECT_COLUMNS] SqlNode: ' as col_0_0_'
- +-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[c], fromElementByTableAlias=[customerde0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
- | \-[FROM_FRAGMENT] FromElement: 'O_CUSTOMERDEMAND customerde0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=c,role=null,tableName=O_CUSTOMERDEMAND,tableAlias=customerde0_,origin=null,columns={,className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand}}
- \-[WHERE] SqlNode: 'WHERE'
- \-[GT] BinaryLogicOperatorNode: '>'
- +-[DOT] DotNode: 'customerde0_.C_CREDIT_LIMIT' {propertyName=creditLimit,dereferenceType=ALL,propertyPath=creditLimit,path=c.creditLimit,tableAlias=customerde0_,className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand,classAlias=c}
- | +-[ALIAS_REF] IdentNode: 'customerde0_.C_ID' {alias=c, className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand, tableAlias=customerde0_}
- | \-[IDENT] IdentNode: 'creditLimit' {originalText=creditLimit}
- \-[NAMED_PARAM] ParameterNode: '?' {name=limit, expectedType=org.hibernate.type.BigDecimalType@278f0471}
- 08:03:33,381 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,382 DEBUG QueryTranslatorImpl:235 - HQL: SELECT c.id FROM org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.CustomerDemand c WHERE c.creditLimit > :limit
- 08:03:33,382 DEBUG QueryTranslatorImpl:236 - SQL: select customerde0_.C_ID as col_0_0_ from O_CUSTOMERDEMAND customerde0_ where customerde0_.C_CREDIT_LIMIT>?
- 08:03:33,382 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,382 DEBUG QueryTranslatorImpl:265 - parse() - HQL: SELECT i FROM org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.ItemDemand i WHERE i.category=:category ORDER BY i.id
- 08:03:33,385 DEBUG QueryTranslatorImpl:283 - --- 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: '.'
- | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | | +-[DOT] Node: '.'
- | | | | | | | | | | | +-[IDENT] Node: 'org'
- | | | | | | | | | | | \-[IDENT] Node: 'hibernate'
- | | | | | | | | | | \-[IDENT] Node: 'test'
- | | | | | | | | | \-[IDENT] Node: 'annotations'
- | | | | | | | | \-[IDENT] Node: 'derivedidentities'
- | | | | | | | \-[IDENT] Node: 'e1'
- | | | | | | \-[IDENT] Node: 'b'
- | | | | | \-[IDENT] Node: 'specjmapid'
- | | | | \-[IDENT] Node: 'ondemand'
- | | | \-[IDENT] Node: 'ItemDemand'
- | | \-[ALIAS] Node: 'i'
- | \-[SELECT] Node: 'SELECT'
- | \-[IDENT] Node: 'i'
- +-[WHERE] Node: 'WHERE'
- | \-[EQ] Node: '='
- | +-[DOT] Node: '.'
- | | +-[IDENT] Node: 'i'
- | | \-[IDENT] Node: 'category'
- | \-[COLON] Node: ':'
- | \-[IDENT] Node: 'category'
- \-[ORDER] Node: 'ORDER'
- \-[DOT] Node: '.'
- +-[IDENT] Node: 'i'
- \-[IDENT] Node: 'id'
- 08:03:33,385 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,386 DEBUG FromElement:157 - FromClause{level=1} : org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.ItemDemand (i) -> itemdemand0_
- 08:03:33,386 DEBUG FromReferenceNode:74 - Resolved : i -> itemdemand0_.I_ID
- 08:03:33,387 DEBUG FromReferenceNode:74 - Resolved : i -> itemdemand0_.I_ID
- 08:03:33,387 DEBUG DotNode:599 - getDataType() : category -> org.hibernate.type.IntegerType@3e4d6ff
- 08:03:33,387 DEBUG FromReferenceNode:74 - Resolved : i.category -> itemdemand0_.I_CATEGORY
- 08:03:33,387 DEBUG FromReferenceNode:74 - Resolved : i -> itemdemand0_.I_ID
- 08:03:33,388 DEBUG DotNode:599 - getDataType() : id -> org.hibernate.type.StringType@55daeaa2
- 08:03:33,388 DEBUG FromReferenceNode:74 - Resolved : i.id -> itemdemand0_.I_ID
- 08:03:33,388 DEBUG HqlSqlWalker:629 - processQuery() : ( SELECT ( {select clause} itemdemand0_.I_ID ) ( FromClause{level=1} O_ITEM itemdemand0_ ) ( WHERE ( = ( itemdemand0_.I_CATEGORY itemdemand0_.I_ID category ) ? ) ) ( ORDER ( itemdemand0_.I_ID itemdemand0_.I_ID id ) ) )
- 08:03:33,388 DEBUG JoinProcessor:175 - Using FROM fragment [O_ITEM itemdemand0_]
- 08:03:33,389 DEBUG QueryTranslatorImpl:252 - --- SQL AST ---
- \-[SELECT] QueryNode: 'SELECT' querySpaces (O_ITEM)
- +-[SELECT_CLAUSE] SelectClause: '{select clause}'
- | +-[ALIAS_REF] IdentNode: 'itemdemand0_.I_ID as I1_628_' {alias=i, className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.ItemDemand, tableAlias=itemdemand0_}
- | \-[SQL_TOKEN] SqlFragment: 'itemdemand0_.I_CATEGORY as I2_628_, itemdemand0_.I_DESC as I3_628_, itemdemand0_.I_DISCOUNT as I4_628_, itemdemand0_.I_NAME as I5_628_, itemdemand0_.I_PRICE as I6_628_, itemdemand0_.I_VERSION as I7_628_'
- +-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[i], fromElementByTableAlias=[itemdemand0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
- | \-[FROM_FRAGMENT] FromElement: 'O_ITEM itemdemand0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=i,role=null,tableName=O_ITEM,tableAlias=itemdemand0_,origin=null,columns={,className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.ItemDemand}}
- +-[WHERE] SqlNode: 'WHERE'
- | \-[EQ] BinaryLogicOperatorNode: '='
- | +-[DOT] DotNode: 'itemdemand0_.I_CATEGORY' {propertyName=category,dereferenceType=ALL,propertyPath=category,path=i.category,tableAlias=itemdemand0_,className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.ItemDemand,classAlias=i}
- | | +-[ALIAS_REF] IdentNode: 'itemdemand0_.I_ID' {alias=i, className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.ItemDemand, tableAlias=itemdemand0_}
- | | \-[IDENT] IdentNode: 'category' {originalText=category}
- | \-[NAMED_PARAM] ParameterNode: '?' {name=category, expectedType=org.hibernate.type.IntegerType@3e4d6ff}
- \-[ORDER] OrderByClause: 'ORDER'
- \-[DOT] DotNode: 'itemdemand0_.I_ID' {propertyName=id,dereferenceType=ALL,propertyPath=id,path=i.id,tableAlias=itemdemand0_,className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.ItemDemand,classAlias=i}
- +-[ALIAS_REF] IdentNode: 'itemdemand0_.I_ID' {alias=i, className=org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.ItemDemand, tableAlias=itemdemand0_}
- \-[IDENT] IdentNode: 'id' {originalText=id}
- 08:03:33,389 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- 08:03:33,389 DEBUG QueryTranslatorImpl:235 - HQL: SELECT i FROM org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.ItemDemand i WHERE i.category=:category ORDER BY i.id
- 08:03:33,390 DEBUG QueryTranslatorImpl:236 - SQL: select itemdemand0_.I_ID as I1_628_, itemdemand0_.I_CATEGORY as I2_628_, itemdemand0_.I_DESC as I3_628_, itemdemand0_.I_DISCOUNT as I4_628_, itemdemand0_.I_NAME as I5_628_, itemdemand0_.I_PRICE as I6_628_, itemdemand0_.I_VERSION as I7_628_ from O_ITEM itemdemand0_ where itemdemand0_.I_CATEGORY=? order by itemdemand0_.I_ID
- 08:03:33,390 DEBUG ErrorCounter:82 - throwQueryException() : no errors
- org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.LazyLoadingTest > testOnDemandLoading STANDARD_OUT
- 08:03:33,396 DEBUG SQL:104 -
- select
- tbl.S_NEXTNUM
- from
- U_SEQUENCES tbl
- where
- tbl.S_ID=? for update
- Hibernate:
- select
- tbl.S_NEXTNUM
- from
- U_SEQUENCES tbl
- where
- tbl.S_ID=? for update
- 08:03:33,400 DEBUG SQL:104 -
- insert
- into
- U_SEQUENCES
- (S_ID, S_NEXTNUM)
- values
- (?,?)
- Hibernate:
- insert
- into
- U_SEQUENCES
- (S_ID, S_NEXTNUM)
- values
- (?,?)
- 08:03:33,401 DEBUG SQL:104 -
- update
- U_SEQUENCES
- set
- S_NEXTNUM=?
- where
- S_NEXTNUM=?
- and S_ID=?
- Hibernate:
- update
- U_SEQUENCES
- set
- S_NEXTNUM=?
- where
- S_NEXTNUM=?
- and S_ID=?
- 08:03:33,403 DEBUG SQL:104 -
- select
- tbl.S_NEXTNUM
- from
- U_SEQUENCES tbl
- where
- tbl.S_ID=? for update
- Hibernate:
- select
- tbl.S_NEXTNUM
- from
- U_SEQUENCES tbl
- where
- tbl.S_ID=? for update
- 08:03:33,404 DEBUG SQL:104 -
- update
- U_SEQUENCES
- set
- S_NEXTNUM=?
- where
- S_NEXTNUM=?
- and S_ID=?
- Hibernate:
- update
- U_SEQUENCES
- set
- S_NEXTNUM=?
- where
- S_NEXTNUM=?
- and S_ID=?
- 08:03:33,407 DEBUG SQL:104 -
- insert
- into
- O_CUSTOMERDEMAND
- (C_BALANCE, C_CONTACT, C_CREDIT, C_CREDIT_LIMIT, C_FIRST, C_LAST, C_SINCE, C_VERSION, C_YTD_PAYMENT, C_ID)
- values
- (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
- Hibernate:
- insert
- into
- O_CUSTOMERDEMAND
- (C_BALANCE, C_CONTACT, C_CREDIT, C_CREDIT_LIMIT, C_FIRST, C_LAST, C_SINCE, C_VERSION, C_YTD_PAYMENT, C_ID)
- values
- (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
- 08:03:33,409 DEBUG SQL:104 -
- insert
- into
- O_ITEM
- (I_CATEGORY, I_DESC, I_DISCOUNT, I_NAME, I_PRICE, I_VERSION, I_ID)
- values
- (?, ?, ?, ?, ?, ?, ?)
- Hibernate:
- insert
- into
- O_ITEM
- (I_CATEGORY, I_DESC, I_DISCOUNT, I_NAME, I_PRICE, I_VERSION, I_ID)
- values
- (?, ?, ?, ?, ?, ?, ?)
- 08:03:33,411 DEBUG SQL:104 -
- insert
- into
- O_CUSTINVENTORY
- (CI_QUANTITY, CI_VALUE, CI_ITEMID, CI_VERSION, CI_CUSTOMERID, CI_ID)
- values
- (?, ?, ?, ?, ?, ?)
- Hibernate:
- insert
- into
- O_CUSTINVENTORY
- (CI_QUANTITY, CI_VALUE, CI_ITEMID, CI_VERSION, CI_CUSTOMERID, CI_ID)
- values
- (?, ?, ?, ?, ?, ?)
- 08:03:33,419 DEBUG SQL:104 -
- select
- customerde0_.C_ID as C1_626_0_,
- customerde0_.C_BALANCE as C2_626_0_,
- customerde0_.C_CONTACT as C3_626_0_,
- customerde0_.C_CREDIT as C4_626_0_,
- customerde0_.C_CREDIT_LIMIT as C5_626_0_,
- customerde0_.C_FIRST as C6_626_0_,
- customerde0_.C_LAST as C7_626_0_,
- customerde0_.C_SINCE as C8_626_0_,
- customerde0_.C_VERSION as C9_626_0_,
- customerde0_.C_YTD_PAYMENT as C10_626_0_
- from
- O_CUSTOMERDEMAND customerde0_
- where
- customerde0_.C_ID=?
- Hibernate:
- select
- customerde0_.C_ID as C1_626_0_,
- customerde0_.C_BALANCE as C2_626_0_,
- customerde0_.C_CONTACT as C3_626_0_,
- customerde0_.C_CREDIT as C4_626_0_,
- customerde0_.C_CREDIT_LIMIT as C5_626_0_,
- customerde0_.C_FIRST as C6_626_0_,
- customerde0_.C_LAST as C7_626_0_,
- customerde0_.C_SINCE as C8_626_0_,
- customerde0_.C_VERSION as C9_626_0_,
- customerde0_.C_YTD_PAYMENT as C10_626_0_
- from
- O_CUSTOMERDEMAND customerde0_
- where
- customerde0_.C_ID=?
- 08:03:33,421 DEBUG SQL:104 -
- select
- customerin0_.CI_CUSTOMERID as CI1_626_2_,
- customerin0_.CI_CUSTOMERID as CI1_2_,
- customerin0_.CI_ID as CI2_2_,
- customerin0_.CI_CUSTOMERID as CI1_627_1_,
- customerin0_.CI_ID as CI2_627_1_,
- customerin0_.CI_QUANTITY as CI3_627_1_,
- customerin0_.CI_VALUE as CI4_627_1_,
- customerin0_.CI_ITEMID as CI6_627_1_,
- customerin0_.CI_VERSION as CI5_627_1_,
- itemdemand1_.I_ID as I1_628_0_,
- itemdemand1_.I_CATEGORY as I2_628_0_,
- itemdemand1_.I_DESC as I3_628_0_,
- itemdemand1_.I_DISCOUNT as I4_628_0_,
- itemdemand1_.I_NAME as I5_628_0_,
- itemdemand1_.I_PRICE as I6_628_0_,
- itemdemand1_.I_VERSION as I7_628_0_
- from
- O_CUSTINVENTORY customerin0_
- left outer join
- O_ITEM itemdemand1_
- on customerin0_.CI_ITEMID=itemdemand1_.I_ID
- where
- customerin0_.CI_CUSTOMERID=?
- Hibernate:
- select
- customerin0_.CI_CUSTOMERID as CI1_626_2_,
- customerin0_.CI_CUSTOMERID as CI1_2_,
- customerin0_.CI_ID as CI2_2_,
- customerin0_.CI_CUSTOMERID as CI1_627_1_,
- customerin0_.CI_ID as CI2_627_1_,
- customerin0_.CI_QUANTITY as CI3_627_1_,
- customerin0_.CI_VALUE as CI4_627_1_,
- customerin0_.CI_ITEMID as CI6_627_1_,
- customerin0_.CI_VERSION as CI5_627_1_,
- itemdemand1_.I_ID as I1_628_0_,
- itemdemand1_.I_CATEGORY as I2_628_0_,
- itemdemand1_.I_DESC as I3_628_0_,
- itemdemand1_.I_DISCOUNT as I4_628_0_,
- itemdemand1_.I_NAME as I5_628_0_,
- itemdemand1_.I_PRICE as I6_628_0_,
- itemdemand1_.I_VERSION as I7_628_0_
- from
- O_CUSTINVENTORY customerin0_
- left outer join
- O_ITEM itemdemand1_
- on customerin0_.CI_ITEMID=itemdemand1_.I_ID
- where
- customerin0_.CI_CUSTOMERID=?
- 08:03:33,424 DEBUG SQL:104 -
- select
- customerde0_.C_ID as C1_626_0_,
- customerde0_.C_BALANCE as C2_626_0_,
- customerde0_.C_CONTACT as C3_626_0_,
- customerde0_.C_CREDIT as C4_626_0_,
- customerde0_.C_CREDIT_LIMIT as C5_626_0_,
- customerde0_.C_FIRST as C6_626_0_,
- customerde0_.C_LAST as C7_626_0_,
- customerde0_.C_SINCE as C8_626_0_,
- customerde0_.C_VERSION as C9_626_0_,
- customerde0_.C_YTD_PAYMENT as C10_626_0_
- from
- O_CUSTOMERDEMAND customerde0_
- where
- customerde0_.C_ID=?
- Hibernate:
- select
- customerde0_.C_ID as C1_626_0_,
- customerde0_.C_BALANCE as C2_626_0_,
- customerde0_.C_CONTACT as C3_626_0_,
- customerde0_.C_CREDIT as C4_626_0_,
- customerde0_.C_CREDIT_LIMIT as C5_626_0_,
- customerde0_.C_FIRST as C6_626_0_,
- customerde0_.C_LAST as C7_626_0_,
- customerde0_.C_SINCE as C8_626_0_,
- customerde0_.C_VERSION as C9_626_0_,
- customerde0_.C_YTD_PAYMENT as C10_626_0_
- from
- O_CUSTOMERDEMAND customerde0_
- where
- customerde0_.C_ID=?
- org.hibernate.test.annotations.derivedidentities.e1.b.specjmapid.ondemand.LazyLoadingTest STANDARD_OUT
- 08:03:33,426 INFO SchemaExport:343 - HHH000227: Running hbm2ddl schema export
- 08:03:33,427 DEBUG SchemaExport:353 - Import file not found: /import.sql
- 08:03:33,427 DEBUG SQL:104 -
- alter table O_CUSTINVENTORY
- drop constraint FK223174592F7D6A92
- Hibernate:
- alter table O_CUSTINVENTORY
- drop constraint FK223174592F7D6A92
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement