 |
|
|
| 19-07-2007 |
 Vervolg eclipse java :: HQL - FROM :: run application |
7.Eclipse : Run as java application
Resultaat eclipse :
0 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.0.3
0 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
0 [main] INFO org.hibernate.cfg.Environment - using CGLIB reflection optimizer
15 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
78 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
78 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
328 [main] DEBUG org.hibernate.util.DTDEntityResolver
.....
390 [main] DEBUG org.hibernate.util.DTDEntityResolver - http://hibernate.sourceforge.net/hibernate-
mapping-2.0.dtd not found in classpath
2078 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: bron.Leverancier -> leverancier
2078 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: id -> ID
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: firmanaam -> firmanaam
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: straat -> straat
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: nr -> nr
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: postcode -> postcode
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: gemeente -> gemeente
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: telefoon -> telefoon
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: fax -> fax
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: GSM -> GSM
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: email -> email
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: vertegenwoordiger -> vertegenwoordiger
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: vertegen_GSM -> vertegen_GSM
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: vertegen_email -> vertegen_email
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: tweede_naam -> tweede_naam
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: tweede_straat -> tweede_straat
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: tweede_nr -> tweede_nr
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: tweede_postcode -> tweede_postcode
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: tweede_gemeente -> tweede_gemeente
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: tweede_telefoon -> tweede_telefoon
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: tweede_GSM -> tweede_GSM
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: beschrijving -> beschrijving
2093 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: info -> info
2093 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
....
2093 [main] INFO org.hibernate.cfg.Configuration - processing extends queue
2093 [main] INFO org.hibernate.cfg.Configuration - processing collection mappings
2093 [main] INFO org.hibernate.cfg.Configuration - processing association property references
2093 [main] INFO org.hibernate.cfg.Configuration - processing foreign key constraints
2156 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider
....
2390 [main] INFO org.hibernate.cfg.SettingsFactory - RDBMS: MySQL, version: 5.0.24a-community-nt
....
3046 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - parse() - HQL: FROM bron.Leverancier as p
3062 [main] DEBUG org.hibernate.hql.AST - --- HQL AST ---
-[QUERY] 'query'
-[SELECT_FROM] 'SELECT_FROM'
-[FROM] 'FROM'
-[RANGE] 'RANGE'
+-[DOT] '.'
| +-[IDENT] 'bron'
| -[IDENT] 'Leverancier'
-[ALIAS] 'p'
3062 [main] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
3093 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - query() << begin, level = 1
3125 [main] DEBUG org.hibernate.hql.ast.FromElement - FromClause{level=1} : bron.Leverancier (p) -> leverancie0_
3125 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - query() : finishing up , level = 1
3125 [main] DEBUG org.hibernate.hql.ast.HqlSqlWalker - processQuery() : ( SELECT ( FromClause{level=1} leverancier leverancie0_ ) )
3125 [main] DEBUG org.hibernate.hql.ast.HqlSqlWalker - Derived SELECT clause created.
3125 [main] DEBUG org.hibernate.hql.ast.JoinProcessor - Using FROM fragment [leverancier leverancie0_]
3125 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - query() >> end, level = 1
3140 [main] DEBUG org.hibernate.hql.AST - --- SQL AST ---
-[SELECT] QueryNode: 'SELECT' querySpaces (leverancier)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| -[SELECT_EXPR] SelectExpressionImpl: 'leverancie0_.ID as col_0_0_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=p,role=null,tableName=leverancier,tableAlias=leverancie0_,colums={,className=
bron.Leverancier}}}
-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[p], fromElementByTableAlias=[leverancie0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
-[FROM_FRAGMENT] FromElement: 'leverancier leverancie0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=p,role=null,tableName=leverancier,tableAlias=leverancie0_,colums={,className =bron.Leverancier}}
3140 [main] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
3156 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - HQL: FROM bron.Leverancier as p
3156 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - SQL: select leverancie0_.ID as col_0_0_ from leverancier leverancie0_
3156 [main] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
3156 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
3156 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - opening JDBC connection
3156 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
3156 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - using pooled JDBC connection, pool size: 0
3156 [main] DEBUG org.hibernate.SQL - select leverancie0_.ID as col_0_0_ from leverancier leverancie0_
Hibernate: select leverancie0_.ID as col_0_0_ from leverancier leverancie0_
3156 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
3156 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
3171 [main] DEBUG org.hibernate.impl.IteratorImpl - retrieving next results
3171 [main] DEBUG org.hibernate.type.IntegerType - returning '1' as column: col_0_0_
3171 [main] DEBUG org.hibernate.event.def.DefaultLoadEventListener - loading entity: [bron.Leverancier#1]
3171 [main] DEBUG org.hibernate.event.def.DefaultLoadEventListener - creating new proxy for entity
3171 [main] DEBUG org.hibernate.impl.IteratorImpl - retrieving next results
3171 [main] DEBUG org.hibernate.type.IntegerType - returning '2' as column: col_0_0_
3171 [main] DEBUG org.hibernate.event.def.DefaultLoadEventListener - loading entity: [bron.Leverancier#2]
3171 [main] DEBUG org.hibernate.event.def.DefaultLoadEventListener - creating new proxy for entity
3171 [main] DEBUG org.hibernate.impl.IteratorImpl - returning current results
3171 [main] DEBUG org.hibernate.impl.SessionImpl - initializing proxy: [bron.Leverancier#1]
3171 [main] DEBUG org.hibernate.event.def.DefaultLoadEventListener - attempting to resolve: [bron.Leverancier#1]
3171 [main] DEBUG org.hibernate.event.def.DefaultLoadEventListener - object not resolved in any cache: [bron.Leverancier#1]
3171 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Materializing entity: [bron.Leverancier#1]
3171 [main] DEBUG org.hibernate.loader.Loader - loading entity: [bron.Leverancier#1]
3171 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 1, globally: 1)
....
3171 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
3171 [main] DEBUG org.hibernate.type.IntegerType - binding '1' to parameter: 1
3171 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 1, globally: 1)
3171 [main] DEBUG org.hibernate.loader.Loader - processing result set
3171 [main] DEBUG org.hibernate.loader.Loader - result set row: 0
3171 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[bron.Leverancier#1]
3171 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [bron.Leverancier#1]
3187 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Hydrating entity: [bron.Leverancier#1]
3187 [main] DEBUG org.hibernate.type.StringType - returning 'Sarcotem' as column: firmanaam0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'Industiepark' as column: straat0_0_
3187 [main] DEBUG org.hibernate.type.IntegerType - returning '11' as column: nr0_0_
3187 [main] DEBUG org.hibernate.type.IntegerType - returning '4562' as column: postcode0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'Bontem' as column: gemeente0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning '4144141' as column: telefoon0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning '141445' as column: fax0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning '14745456' as column: GSM0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'sarc@bottem.be' as column: email0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'Gulleman' as column: vertege11_0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning '147456458' as column: vertegen12_0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'sarc-gul@bottem.be' as column: vertegen13_0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'Torrens' as column: tweede14_0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'kortebeekstraat' as column: tweede15_0_0_
3187 [main] DEBUG org.hibernate.type.IntegerType - returning '14' as column: tweede16_0_0_
3187 [main] DEBUG org.hibernate.type.IntegerType - returning '5584' as column: tweede17_0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'Strandem' as column: tweede18_0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning '05785245' as column: tweede19_0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning '147569485' as column: tweede20_0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'verwarmingstoestellen' as column: beschri21_0_0_
3187 [main] DEBUG org.hibernate.type.StringType - returning 'info1' as column: info0_0_
3187 [main] DEBUG org.hibernate.loader.Loader - done processing result set (1 rows)
3187 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 2, globally: 2)
3187 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 2, globally: 2)
3187 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
3187 [main] DEBUG org.hibernate.loader.Loader - total objects hydrated: 1
3187 [main] DEBUG org.hibernate.engine.TwoPhaseLoad - resolving associations for [bron.Leverancier#1]
3203 [main] DEBUG org.hibernate.engine.TwoPhaseLoad - done materializing entity [bron.Leverancier#1]
3203 [main] DEBUG org.hibernate.engine.PersistenceContext - initializing non-lazy collections
3203 [main] DEBUG org.hibernate.loader.Loader - done entity load
Type: Sarcotem
Title: Industiepark
Title: Bontem
ID: 1
3203 [main] DEBUG org.hibernate.impl.IteratorImpl - exhausted results
3203 [main] DEBUG org.hibernate.impl.IteratorImpl - closing iterator
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1)
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
3203 [main] DEBUG org.hibernate.impl.IteratorImpl - returning current results
3203 [main] DEBUG org.hibernate.impl.SessionImpl - initializing proxy: [bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.event.def.DefaultLoadEventListener - attempting to resolve: [bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.event.def.DefaultLoadEventListener - object not resolved in any cache: [bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Materializing entity: [bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.loader.Loader - loading entity: [bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
...
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
3203 [main] DEBUG org.hibernate.type.IntegerType - binding '2' to parameter: 1
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
3203 [main] DEBUG org.hibernate.loader.Loader - processing result set
3203 [main] DEBUG org.hibernate.loader.Loader - result set row: 0
3203 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Hydrating entity: [bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.type.StringType - returning 'ADGE' as column: firmanaam0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'nieuwstraat' as column: straat0_0_
3203 [main] DEBUG org.hibernate.type.IntegerType - returning '11' as column: nr0_0_
3203 [main] DEBUG org.hibernate.type.IntegerType - returning '4562' as column: postcode0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'grimstad' as column: gemeente0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning '4144141' as column: telefoon0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning '141445544' as column: fax0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning '147458154' as column: GSM0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'mail@infotec.be' as column: email0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'Debreke' as column: vertege11_0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning '147658254' as column: vertegen12_0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'miel.mail@infotec.be' as column: vertegen13_0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'Tamin' as column: tweede14_0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'torenstraat' as column: tweede15_0_0_
3203 [main] DEBUG org.hibernate.type.IntegerType - returning '45' as column: tweede16_0_0_
3203 [main] DEBUG org.hibernate.type.IntegerType - returning '5466' as column: tweede17_0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'Bunzegem' as column: tweede18_0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning '05765489' as column: tweede19_0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'geen' as column: tweede20_0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'verlichtingsarmaturen' as column: beschri21_0_0_
3203 [main] DEBUG org.hibernate.type.StringType - returning 'info2' as column: info0_0_
3203 [main] DEBUG org.hibernate.loader.Loader - done processing result set (1 rows)
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1)
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
3203 [main] DEBUG org.hibernate.loader.Loader - total objects hydrated: 1
3203 [main] DEBUG org.hibernate.engine.TwoPhaseLoad - resolving associations for [bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.engine.TwoPhaseLoad - done materializing entity [bron.Leverancier#2]
3203 [main] DEBUG org.hibernate.engine.PersistenceContext - initializing non-lazy collections
3203 [main] DEBUG org.hibernate.loader.Loader - done entity load
Type: ADGE
Title: nieuwstraat
Title: grimstad
ID: 2
3203 [main] DEBUG org.hibernate.impl.SessionImpl - closing session
3203 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing JDBC connection (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)
3203 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - returning connection to pool, pool size: 1
3203 [main] DEBUG org.hibernate.jdbc.JDBCContext - after transaction completion
3203 [main] DEBUG org.hibernate.impl.SessionImpl - after transaction completion
end
|
|
|
|
|
Reacties op bericht (0)
|
