sample output from hibernatedemohql.java.txt

关于HEBERNATE使用的一个简单例子

2003-06-04 13:07:56,232 INFO  hibernate.cfg.Environment  -> Hibernate 2.0 beta 5
2003-06-04 13:07:56,232 INFO  hibernate.cfg.Environment  -> loaded properties from resource hibernate.properties: {hibernate.dbcp.ps.maxIdle=100, hibernate.dbcp.ps.whenExhaustedAction=1, hibernate.dbcp.whenExhaustedAction=1, hibernate.dbcp.ps.maxWait=120000, hibernate.connection.driver_class=COM.ibm.db2.jdbc.net.DB2Driver, hibernate.default_schema=db2admin, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=net.sf.hibernate.dialect.DB2Dialect, hibernate.dbcp.maxIdle=10, hibernate.dbcp.maxWait=120000, hibernate.dbcp.maxActive=100, hibernate.connection.username=db2admin, hibernate.connection.url=jdbc:db2://satldb2/sample, hibernate.show_sql=true, hibernate.connection.password=db2admin, hibernate.dbcp.ps.maxActive=100}
2003-06-04 13:07:56,248 INFO  hibernate.cfg.Environment  -> using CGLIB reflection optimizer
2003-06-04 13:07:56,248 INFO  hibernate.cfg.Environment  -> JVM proxy support: true
2003-06-04 13:07:56,248 INFO  hibernate.cfg.Configuration  -> Mapping resource: dbdemo/User.hbm.xml
2003-06-04 13:07:56,670 INFO  hibernate.mapping.Collection  -> Mapping class: dbdemo.User -> Users
2003-06-04 13:07:56,748 INFO  hibernate.mapping.Collection  -> Mapping collection: dbdemo.User.books -> Book_User_Link
2003-06-04 13:07:56,763 INFO  hibernate.cfg.Configuration  -> Mapping resource: dbdemo/Contact.hbm.xml
2003-06-04 13:07:56,795 INFO  hibernate.mapping.Collection  -> Mapping class: dbdemo.Contact -> Contacts
2003-06-04 13:07:56,795 INFO  hibernate.cfg.Configuration  -> Mapping resource: dbdemo/Book.hbm.xml
2003-06-04 13:07:56,826 INFO  hibernate.mapping.Collection  -> Mapping class: dbdemo.Book -> Books
2003-06-04 13:07:56,826 INFO  hibernate.mapping.Collection  -> Mapping collection: dbdemo.Book.users -> Book_User_Link
2003-06-04 13:07:56,826 INFO  hibernate.cfg.Configuration  -> Mapping resource: dbdemo/Address.hbm.xml
2003-06-04 13:07:56,857 INFO  hibernate.mapping.Collection  -> Mapping class: dbdemo.Address -> Address2
2003-06-04 13:07:56,857 INFO  hibernate.mapping.Collection  -> Mapping collection: dbdemo.User.contacts -> Contacts
2003-06-04 13:07:57,138 INFO  hibernate.impl.SessionFactoryImpl  -> building session factory
2003-06-04 13:07:57,138 INFO  hibernate.dialect.Dialect  -> Using dialect: net.sf.hibernate.dialect.DB2Dialect
2003-06-04 13:07:57,154 INFO  hibernate.connection.DBCPConnectionProvider  -> DBCP using driver: COM.ibm.db2.jdbc.net.DB2Driver at URL: jdbc:db2://satldb2/sample
2003-06-04 13:07:57,154 INFO  hibernate.connection.DBCPConnectionProvider  -> Connection properties: {user=db2admin, password=db2admin}
2003-06-04 13:07:57,170 INFO  hibernate.impl.SessionFactoryImpl  -> Use outer join fetching: true
2003-06-04 13:07:57,310 INFO  hibernate.impl.SessionFactoryImpl  -> Use scrollable result sets: true
2003-06-04 13:07:57,310 INFO  hibernate.impl.SessionFactoryImpl  -> Default schema set to: db2admin
2003-06-04 13:07:57,310 INFO  hibernate.impl.SessionFactoryImpl  -> echoing all SQL to stdout
2003-06-04 13:07:57,920 INFO  hibernate.impl.SessionFactoryObjectFactory  -> no JDNI name configured
2003-06-04 13:07:57,920 INFO  hibernate.impl.SessionFactoryImpl  -> Query language substitutions: {}
Hibernate: select user.Name as x0_0_, con0_.Name as x1_0_ from db2admin.Users user left outer join db2admin.Contacts con0_ on user.LogonID=con0_.User_ID
----Contact list-1--------
User = Joseph Cool Contact = 
User = Joseph Cool2 Contact = nobody6
User = Joseph Cool2 Contact = nobody1
--------------------------

Hibernate: select con0_.ID as x0_0_ from db2admin.Users user, db2admin.Contacts con0_ where user.LogonID=con0_.User_ID and ((user.LogonID='joe_cool2' ))
Hibernate: SELECT User1_.LogonID as LogonID0_, User1_.EmailAddress as EmailAdd2_0_, User1_.LastLogon as LastLogon0_, User1_.Password as Password0_, User1_.Name as Name0_, Addre2_.ID as ID1_, Addre2_.City as City1_, Addre2_.State as State1_, Addre2_.Zip as Zip1_, Conta0_.ID as ID2_, Conta0_.EmailAddress as EmailAdd2_2_, Conta0_.Name as Name2_, Conta0_.User_ID as User_ID2_ FROM db2admin.Contacts Conta0_ left outer join db2admin.Users User1_ on Conta0_.User_ID=User1_.LogonID left outer join db2admin.Address2 Addre2_ on User1_.LogonID=Addre2_.ID WHERE Conta0_.ID=?
Hibernate: SELECT Conta0_.ID as ID__, User1_.LogonID as LogonID0_, User1_.EmailAddress as EmailAdd2_0_, User1_.LastLogon as LastLogon0_, User1_.Password as Password0_, User1_.Name as Name0_, Addre2_.ID as ID1_, Addre2_.City as City1_, Addre2_.State as State1_, Addre2_.Zip as Zip1_, Conta0_.ID as ID2_, Conta0_.EmailAddress as EmailAdd2_2_, Conta0_.Name as Name2_, Conta0_.User_ID as User_ID2_ FROM db2admin.Contacts Conta0_ left outer join db2admin.Users User1_ on Conta0_.User_ID=User1_.LogonID left outer join db2admin.Address2 Addre2_ on User1_.LogonID=Addre2_.ID WHERE Conta0_.User_ID=?
Hibernate: SELECT Book_0_.BookID as BookID__, Book1_.ID as ID0_, Book1_.Name as Name0_ FROM db2admin.Book_User_Link Book_0_ left outer join db2admin.Books Book1_ on Book_0_.BookID=Book1_.ID WHERE Book_0_.UserID=?
Hibernate: SELECT Book_0_.UserID as UserID__, User1_.LogonID as LogonID0_, User1_.EmailAddress as EmailAdd2_0_, User1_.LastLogon as LastLogon0_, User1_.Password as Password0_, User1_.Name as Name0_, Addre2_.ID as ID1_, Addre2_.City as City1_, Addre2_.State as State1_, Addre2_.Zip as Zip1_ FROM db2admin.Book_User_Link Book_0_ left outer join db2admin.Users User1_ on Book_0_.UserID=User1_.LogonID left outer join db2admin.Address2 Addre2_ on User1_.LogonID=Addre2_.ID WHERE Book_0_.BookID=?
Hibernate: SELECT Conta0_.ID as ID__, User1_.LogonID as LogonID0_, User1_.EmailAddress as EmailAdd2_0_, User1_.LastLogon as LastLogon0_, User1_.Password as Password0_, User1_.Name as Name0_, Addre2_.ID as ID1_, Addre2_.City as City1_, Addre2_.State as State1_, Addre2_.Zip as Zip1_, Conta0_.ID as ID2_, Conta0_.EmailAddress as EmailAdd2_2_, Conta0_.Name as Name2_, Conta0_.User_ID as User_ID2_ FROM db2admin.Contacts Conta0_ left outer join db2admin.Users User1_ on Conta0_.User_ID=User1_.LogonID left outer join db2admin.Address2 Addre2_ on User1_.LogonID=Addre2_.ID WHERE Conta0_.User_ID=?
Hibernate: SELECT Book_0_.BookID as BookID__, Book1_.ID as ID0_, Book1_.Name as Name0_ FROM db2admin.Book_User_Link Book_0_ left outer join db2admin.Books Book1_ on Book_0_.BookID=Book1_.ID WHERE Book_0_.UserID=?
----Contact list-2--------
Contact = nobody6
Contact = nobody1
--------------------------

Hibernate: select boo0_.BookID as x0_0_ from db2admin.Users user, db2admin.Book_User_Link boo0_ where user.LogonID=boo0_.UserID and ((user.LogonID='joe_cool2' ))
----Book list----------
book = Book_4
--------------------------

Hibernate: select add0_.City as x0_0_ from db2admin.Users user, db2admin.Address2 add0_ where user.LogonID=add0_.ID and ((user.LogonID='joe_cool2' ))
----City----------
city = Los Angeles
--------------------------

Hibernate: select add0_.City as x0_0_ from db2admin.Users user, db2admin.Address2 add0_ where user.LogonID=add0_.ID and ((user.LogonID=? ))
----City-2----------------
city = Los Angeles
--------------------------

Hibernate: select add0_.City as x0_0_ from db2admin.Users user, db2admin.Address2 add0_ where user.LogonID=add0_.ID and ((user.LogonID='joe_cool2' ))
----City-3----------------
city = Los Angeles
--------------------------