This seems like it should work, but I am just starting out in mapping inhieritance.
For some reason HIb thinks the supervisor_id is in User instead of Employee. By just changing the table prefix the SQL works correctly.
Any help would be appreciated.
Is there a good place study the more complex mapping. I have most of the books and have searched online. The javalobby example here is the best step by step Ive seen so far.
package com.javalobby.tnt.domain2;
import javax.persistence.*;
@Entity
@Table(name = "user")
public class User {
@Version
@Column(name = "version")
private long id;
private int version;
private String firstName;
private String lastName;
@Id @GeneratedValue(strategy=GenerationType.AUTO)
@Column(name = "user_id", nullable = false)
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
@Column(updatable = false, name = "first_name", nullable = false, length=45)
public String getFirstName() {
return firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
@Column(updatable = false, name = "last_name", nullable = false, length=45)
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
@Override
public String toString() {
StringBuffer userInfo = new StringBuffer().append("Class: ").append(
getClass()).append("\nID: ").append(getId()).append(
"\nFirst Name: ").append(getFirstName())
.append("\nLast Name: ").append(getLastName()).append(
"\nLast Version: ").append(getVersion());
return userInfo.toString();
}
@Column(nullable = false)
private int getVersion() {
return version;
}
private void setVersion(int version) {
this.version = version;
}
}
package com.javalobby.tnt.domain2;
public class Employee extends User {
private String jobTitle;
private Employee supervisor;
public String getJobTitle() {
return jobTitle;
}
public void setJobTitle(String jobTitle) {
this.jobTitle = jobTitle;
}
public Employee getSupervisor() {
return supervisor;
}
public void setSupervisor(Employee supervisor) {
this.supervisor = supervisor;
}
@Override public String toString() {
StringBuffer result = new StringBuffer()
.append(super.toString())
.append("\nJob Title: ").append(getJobTitle())
.append("\nSupervisor: ").append(getSupervisor());
return result.toString();
}
}
package com.javalobby.tnt.domain2;
import java.util.Set;
public class Employer extends Employee {
private Set<Employee> subordinates;
private String companyCarBrand;
public Set<Employee> getSubordinates() {
return subordinates;
}
public void setSubordinates(Set<Employee> newSubordinates) {
subordinates = newSubordinates;
}
public String getCompanyCarBrand() {
return companyCarBrand;
}
public void setCompanyCarBrand(String companyCarBrand) {
this.companyCarBrand = companyCarBrand;
}
@Override public String toString() {
StringBuffer result = new StringBuffer()
.append(super.toString())
.append("\nCompany Car Brand: ").append(getCompanyCarBrand());
// if (subordinates.size() > 0){ }
return result.toString();
}
}
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version:
3.2 core, 3.2 Annotations, Myeclipse 6.0.1
Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.javalobby.tnt.domain2.User" table="USER" lazy="false">
<id name="id" type="long" column="user_id">
<generator class="identity" />
</id>
<discriminator column="type" type="string"/>
<property name="firstName" column="first_name"/>
<property name="lastName" column="last_name"/>
<subclass name="com.javalobby.tnt.domain2.Employee" discriminator-value="employee">
<join table="employee">
<key column="employee_id"/>
<property name="jobTitle" column="job_title"/>
<many-to-one name="supervisor" column="supervisor_id" not-null="true" />
</join>
<subclass name="com.javalobby.tnt.domain2.Employer" discriminator-value="employer">
<set name="subordinates">
<key column="supervisor_id" not-null="true"/>
<one-to-many class="com.javalobby.tnt.domain2.Employee"/>
</set>
<join table="employer">
<key column="employer_id"/>
<property name="companyCarBrand" column="company_car_brand"/>
</join>
</subclass>
</subclass>
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
Session session = HibernateSessionFactory.currentSession();
try {
Employer empr = (Employer)session.load(Employer.class, new Long(1));
System.out.println(empr);
System.out.println(empr.getSubordinates().size());
}
catch (HibernateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally {
session.close();
}
Full stack trace of any exception that occurs:
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: select employer0_.user_id as user1_0_0_, employer0_.first_name as first3_0_0_, employer0_
.last_name as last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.supervisor_id as supervi
sor3_1_0_, employer0_2_.company_car_brand as company2_2_0_ from USER employer0_ inner join employee
employer0_1_ on employer0_.user_id=employer0_1_.employee_id inner join employer employer0_2_ on empl
oyer0_.user_id=employer0_2_.employer_id where employer0_.user_id=? and employer0_.type='employer'
Class: class com.javalobby.tnt.domain2.Employer
ID: 1
First Name: R.J.
Last Name: Lorimer
Last Version: 0
Job Title: Master of All
Supervisor: null
Company Car Brand: Ferrari
Hibernate: select subordinat0_.supervisor_id as supervisor5_1_, subordinat0_.user_id as user1_1_, su
bordinat0_.user_id as user1_0_0_, subordinat0_.first_name as first3_0_0_, subordinat0_.last_name as
last4_0_0_, subordinat0_1_.job_title as job2_1_0_, subordinat0_1_.supervisor_id as supervisor3_1_0_,
subordinat0_2_.company_car_brand as company2_2_0_, subordinat0_.type as type0_0_ from USER subordin
at0_ inner join employee subordinat0_1_ on subordinat0_.user_id=subordinat0_1_.employee_id left oute
r join employer subordinat0_2_ on subordinat0_.user_id=subordinat0_2_.employer_id where subordinat0_
.supervisor_id=?
org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.javalobby.tnt.d
omain2.Employer.subordinates#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadCollection(Loader.java:2001)
at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPers
ister.java:565)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultI
nitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.ja
va:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java
:109)
at org.hibernate.collection.PersistentSet.size(PersistentSet.java:139)
at com.javalobby.tnt.hib.Main2.main(Main2.java:32)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'subordinat0_.supervi
sor_id' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1626)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3031)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:943)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1049)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)
... 9 more
Name and version of the database you are using:
mysql 5.0.37
The generated SQL (show_sql=true):
see above
Debug level Hibernate log excerpt:
14:57:53,126 INFO Environment:514 - Hibernate 3.2.5
14:57:53,126 INFO Environment:547 - hibernate.properties not found
14:57:53,126 INFO Environment:681 - Bytecode provider name : cglib
14:57:53,142 INFO Environment:598 - using JDK 1.4 java.sql.Timestamp handling
14:57:53,204 INFO Configuration:1426 - configuring from resource: /hibernate.cfg.xml
14:57:53,204 INFO Configuration:1403 - Configuration resource: /hibernate.cfg.xml
14:57:53,424 DEBUG DTDEntityResolver:38 - trying to resolve system-id [http://hibernate.sourceforge.
net/hibernate-configuration-3.0.dtd]
14:57:53,424 DEBUG DTDEntityResolver:40 - recognized hibernate namespace; attempting to resolve on c
lasspath under org/hibernate/
14:57:53,424 DEBUG DTDEntityResolver:50 - located [http://hibernate.sourceforge.net/hibernate-config
uration-3.0.dtd] in classpath
14:57:53,471 DEBUG Configuration:1387 - connection.username=root
14:57:53,471 DEBUG Configuration:1387 - connection.url=jdbc:mysql://localhost:3306/javalobby
14:57:53,471 DEBUG Configuration:1387 - dialect=org.hibernate.dialect.MySQLDialect
14:57:53,471 DEBUG Configuration:1387 - myeclipse.connection.profile=mysql
14:57:53,471 DEBUG Configuration:1387 - connection.password=root
14:57:53,471 DEBUG Configuration:1387 - connection.driver_class=com.mysql.jdbc.Driver
14:57:53,471 DEBUG Configuration:1387 - max_fetch_depth=1
14:57:53,471 DEBUG Configuration:1387 - show_sql=true
14:57:53,471 DEBUG Configuration:1586 - null<-org.dom4j.tree.DefaultAttribute@13bd574 [Attribute: na
me resource value "com/javalobby/tnt/dao/hib/xml/User.hbm.xml"]
14:57:53,471 INFO Configuration:553 - Reading mappings from resource : com/javalobby/tnt/dao/hib/xm
l/User.hbm.xml
14:57:53,486 DEBUG DTDEntityResolver:38 - trying to resolve system-id [http://hibernate.sourceforge.
net/hibernate-mapping-3.0.dtd]
14:57:53,486 DEBUG DTDEntityResolver:40 - recognized hibernate namespace; attempting to resolve on c
lasspath under org/hibernate/
14:57:53,486 DEBUG DTDEntityResolver:50 - located [http://hibernate.sourceforge.net/hibernate-mappin
g-3.0.dtd] in classpath
14:57:53,596 INFO HbmBinder:300 - Mapping class: com.javalobby.tnt.domain2.User -> USER
14:57:53,596 DEBUG HbmBinder:1270 - Mapped property: id -> user_id
14:57:53,611 DEBUG HbmBinder:1270 - Mapped property: firstName -> first_name
14:57:53,611 DEBUG HbmBinder:1270 - Mapped property: lastName -> last_name
14:57:53,658 INFO HbmBinder:817 - Mapping subclass: com.javalobby.tnt.domain2.Employee -> USER
14:57:53,658 INFO HbmBinder:941 - Mapping class join: com.javalobby.tnt.domain2.Employee -> employe
e
14:57:53,658 DEBUG HbmBinder:1270 - Mapped property: jobTitle -> job_title
14:57:53,721 DEBUG HbmBinder:1270 - Mapped property: supervisor -> supervisor_id
14:57:53,721 INFO HbmBinder:817 - Mapping subclass: com.javalobby.tnt.domain2.Employer -> USER
14:57:53,737 DEBUG HbmBinder:1270 - Mapped property: subordinates
14:57:53,737 INFO HbmBinder:941 - Mapping class join: com.javalobby.tnt.domain2.Employer -> employe
r
14:57:53,737 DEBUG HbmBinder:1270 - Mapped property: companyCarBrand -> company_car_brand
14:57:53,737 INFO Configuration:1541 - Configured SessionFactory: null
14:57:53,737 DEBUG Configuration:1542 - properties: {hibernate.connection.password=root, java.runtim
e.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java
\jdk1.5.0_11\jre\bin, java.vm.version=1.5.0_11-b03, hibernate.connection.username=root, java.vm.vend
or=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java
HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.java.launcher=SUN_STANDARD, su
n.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user
.dir=C:\Documents and Settings\DG03118\My Documents\workspace\Hibernate, java.runtime.version=1.5.0_
11-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\J
ava\jdk1.5.0_11\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\DG03118\LOCALS~1\Temp\, li
ne.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.enc
oding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_11\bin;.;C:\WINDOWS\system32;C:\WINDO
WS;C:\Program Files\Java\jdk1.5.0_11\bin\..\jre\bin\client;C:\Program Files\Java\jdk1.5.0_11\bin\..\
jre\bin;C:\Program Files\Java\jdk1.5.0_11\bin;C:\AGILE\ANT\bin;C:\oracle\product\10.2.0\db_1\bin;C:\
php; C:\php\ext;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS
\System32\Wbem;C:\Program Files\Novell\ZENworks\;C:\WINDOWS\system32\nls;C:\WINDOWS\system32\nls\eng
lish;C:\Program Files\Attachmate\E!E2K\;C:\Program Files\IBM\WebSphere MQ\bin;C:\Program Files\IBM\W
ebSphere MQ\Java\bin;C:\Program Files\IBM\WebSphere MQ\WEMPS\bin;C:\Program Files\IBM\Rational\SDP\6
.0\runtimes\base_v51\bin;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v5\bin;C:\Program Files
\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\PROGRA~1\IBM\SQL
LIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\Program Files\Pointsec\Pointsec Media Encryption\Program\
;Z:.;, hibernate.myeclipse.connection.profile=mysql, java.specification.name=Java Platform API Speci
fication, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1,
connection.password=root, user.home=C:\Documents and Settings\DG03118, user.timezone=America/Chicago
, connection.username=root, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, j
ava.specification.version=1.5, hibernate.connection.driver_class=com.mysql.jdbc.Driver, myeclipse.co
nnection.profile=mysql, show_sql=true, user.name=DG03118, java.class.path=C:\Documents and Settings\
DG03118\My Documents\workspace\Hibernate\classes;C:\Documents and Settings\DG03118\My Documents\work
space\HibernateDemo\lib\mysql-connector-java-5.0.0-beta-bin.jar;C:\Program Files\MyEclipse 6.0\eclip
se\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\antlr
-2.7.6.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.z
myeclipse601200710\myeclipse-data\3.0\lib\asm.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com
.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.0\lib\asm-attrs.jar;C:\Pr
ogram Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse6012007
10\myeclipse-data\3.1\lib\cglib-2.1.3.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuite
c.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.0\lib\commons-collections-2.1.1.j
ar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclips
e601200710\myeclipse-data\3.0\lib\commons-logging-1.0.4.jar;C:\Program Files\MyEclipse 6.0\eclipse\p
lugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.1\lib\dom4j-1.6
.1.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyec
lipse601200710\myeclipse-data\3.2\lib\ehcache-1.2.3.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugi
ns\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\hibernate3.ja
r;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse
601200710\myeclipse-data\3.0\lib\jaas.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuite
c.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.1\lib\jaxen-1.1-beta-7.jar;C:\Pro
gram Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse60120071
0\myeclipse-data\3.2\lib\javassist.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.o
rg.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.0\lib\jdbc2_0-stdext.jar;C:\Program
Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\mye
clipse-data\3.0\lib\jta.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernat
e.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.1\lib\log4j-1.2.11.jar;C:\Program Files\MyEclip
se 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3
.0\lib\xerces-2.6.2.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.ec
lipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.0\lib\xml-apis.jar;C:\Program Files\MyEclipse 6.0\e
clipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\e
ntitymanager\hibernate-annotations.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.o
rg.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\entitymanager\hibernate-common
s-annotations.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_
6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\entitymanager\hibernate-entitymanager.jar;C:\Progra
m Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\m
yeclipse-data\3.2\lib\entitymanager\hibernate-validator.jar;C:\Program Files\MyEclipse 6.0\eclipse\p
lugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\entityman
ager\ejb3-persistence.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.
eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\entitymanager\jboss-archive-browsing.jar;C:
\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse60
1200710\data\2.0\dist\modules\spring-aop.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genu
itec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\dist\weavers\spring-agent.jar;C:\Pro
gram Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200
710\data\2.0\dist\weavers\spring-tomcat-weaver.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\co
m.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\lib\asm\asm-2.2.3.jar;C:\Progr
am Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse60120071
0\data\2.0\lib\asm\asm-commons-2.2.3.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec
.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\lib\asm\asm-util-2.2.3.jar;C:\Program Fi
les\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\dat
a\2.0\lib\aspectj\aspectjrt.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.
springframework_6.0.1.zmyeclipse601200710\data\2.0\lib\aspectj\aspectjweaver.jar;C:\Program Files\My
Eclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\
lib\aopalliance\aopalliance.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.
springframework_6.0.1.zmyeclipse601200710\data\1.2\lib\dependencies\cglib\cglib-nodep-2.1_3.jar;C:\P
rogram Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse6012
00710\data\1.2\lib\dependencies\oro\jakarta-oro-2.0.8.jar;C:\Program Files\MyEclipse 6.0\eclipse\plu
gins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\dist\modules\spring-bea
ns.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmy
eclipse601200710\data\2.0\dist\modules\spring-context.jar;C:\Program Files\MyEclipse 6.0\eclipse\plu
gins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\dist\modules\spring-cor
e.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmye
clipse601200710\data\1.2\lib\dependencies\jakarta-commons\commons-attributes-api.jar;C:\Program File
s\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\
1.2\lib\dependencies\jakarta-commons\commons-attributes-compiler.jar;C:\Program Files\MyEclipse 6.0\
eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\lib\jakarta-
commons\commons-logging.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.spri
ngframework_6.0.1.zmyeclipse601200710\data\2.0\lib\log4j\log4j-1.2.14.jar, hibernate.bytecode.use_re
flection_optimizer=false, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\P
rogram Files\Java\jdk1.5.0_11\jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.M
ySQLDialect, hibernate.connection.url=jdbc:mysql://localhost:3306/javalobby, user.language=en, java.
specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed
mode, java.version=1.5.0_11, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_11\jre\lib\ext, sun.boot.
class.path=C:\Program Files\Java\jdk1.5.0_11\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_11\jre\li
b\i18n.jar;C:\Program Files\Java\jdk1.5.0_11\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_1
1\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_11\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_
11\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_11\jre\classes, java.vendor=Sun Microsystems
Inc., connection.driver_class=com.mysql.jdbc.Driver, file.separator=\, max_fetch_depth=1, java.vendo
r.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.
endian=little, hibernate.max_fetch_depth=1, sun.desktop=windows, connection.url=jdbc:mysql://localho
st:3306/javalobby, dialect=org.hibernate.dialect.MySQLDialect, sun.cpu.isalist=pentium_pro+mmx penti
um_pro pentium+mmx pentium i486 i386 i86}
14:57:53,737 DEBUG Configuration:1285 - Preparing to build session factory with filters : {}
14:57:53,737 DEBUG Configuration:1120 - processing extends queue
14:57:53,737 DEBUG Configuration:1124 - processing collection mappings
14:57:53,737 DEBUG CollectionSecondPass:41 - Second pass for collection: com.javalobby.tnt.domain2.E
mployer.subordinates
14:57:53,737 INFO HbmBinder:2385 - Mapping collection: com.javalobby.tnt.domain2.Employer.subordina
tes -> USER
14:57:53,737 DEBUG CollectionSecondPass:57 - Mapped collection key: supervisor_id, one-to-many: com.
javalobby.tnt.domain2.Employee
14:57:53,737 DEBUG Configuration:1135 - processing native query and ResultSetMapping mappings
14:57:53,737 DEBUG Configuration:1143 - processing association property references
14:57:53,737 DEBUG Configuration:1165 - processing foreign key constraints
14:57:53,737 DEBUG Configuration:1248 - resolving reference to class: com.javalobby.tnt.domain2.Empl
oyer
14:57:53,737 DEBUG Configuration:1248 - resolving reference to class: com.javalobby.tnt.domain2.Empl
oyee
14:57:53,737 DEBUG Configuration:1248 - resolving reference to class: com.javalobby.tnt.domain2.Empl
oyee
14:57:53,737 DEBUG Configuration:1248 - resolving reference to class: com.javalobby.tnt.domain2.Empl
oyer
14:57:53,752 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (no
t for production use!)
14:57:53,752 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
14:57:53,752 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
14:57:53,752 INFO DriverManagerConnectionProvider:80 - using driver: com.mysql.jdbc.Driver at URL:
jdbc:mysql://localhost:3306/javalobby
14:57:53,752 INFO DriverManagerConnectionProvider:83 - connection properties: {user=root, password=
root}
14:57:53,752 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
14:57:53,768 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
14:57:54,003 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:mysql://localho
st:3306/javalobby, Isolation Level: 4
14:57:54,003 INFO SettingsFactory:89 - RDBMS: MySQL, version: 5.0.37-community-nt
14:57:54,003 INFO SettingsFactory:90 - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-
java-5.0.0-beta ( $Date: 2005-11-17 16:14:47 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
14:57:54,003 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
14:57:54,019 INFO Dialect:152 - Using dialect: org.hibernate.dialect.MySQLDialect
14:57:54,019 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC tr
ansactions)
14:57:54,019 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in J
TA environment, use of read-write or transactional second-level cache is not recommended)
14:57:54,019 INFO SettingsFactory:143 - Automatic flush during beforeCompletion(): disabled
14:57:54,019 INFO SettingsFactory:147 - Automatic session close at end of transaction: disabled
14:57:54,019 INFO SettingsFactory:154 - JDBC batch size: 15
14:57:54,019 INFO SettingsFactory:157 - JDBC batch updates for versioned data: disabled
14:57:54,034 INFO SettingsFactory:162 - Scrollable result sets: enabled
14:57:54,034 DEBUG SettingsFactory:166 - Wrap result sets: disabled
14:57:54,034 INFO SettingsFactory:170 - JDBC3 getGeneratedKeys(): enabled
14:57:54,034 INFO SettingsFactory:178 - Connection release mode: auto
14:57:54,034 INFO SettingsFactory:202 - Maximum outer join fetch depth: 1
14:57:54,034 INFO SettingsFactory:205 - Default batch fetch size: 1
14:57:54,034 INFO SettingsFactory:209 - Generate SQL with comments: disabled
14:57:54,034 INFO SettingsFactory:213 - Order SQL updates by primary key: disabled
14:57:54,034 INFO SettingsFactory:217 - Order SQL inserts for batching: disabled
14:57:54,034 INFO SettingsFactory:386 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorF
actory
14:57:54,034 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
14:57:54,034 INFO SettingsFactory:225 - Query language substitutions: {}
14:57:54,034 INFO SettingsFactory:230 - JPA-QL strict compliance: disabled
14:57:54,034 INFO SettingsFactory:235 - Second-level cache: enabled
14:57:54,034 INFO SettingsFactory:239 - Query cache: disabled
14:57:54,034 INFO SettingsFactory:373 - Cache provider: org.hibernate.cache.NoCacheProvider
14:57:54,034 INFO SettingsFactory:254 - Optimize cache for minimal puts: disabled
14:57:54,034 INFO SettingsFactory:263 - Structured second-level cache entries: disabled
14:57:54,034 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
14:57:54,050 INFO SettingsFactory:283 - Echoing all SQL to stdout
14:57:54,050 INFO SettingsFactory:290 - Statistics: disabled
14:57:54,050 INFO SettingsFactory:294 - Deleted entity synthetic identifier rollback: disabled
14:57:54,050 INFO SettingsFactory:309 - Default entity-mode: pojo
14:57:54,050 INFO SettingsFactory:313 - Named query checking : enabled
14:57:54,081 INFO SessionFactoryImpl:161 - building session factory
14:57:54,081 DEBUG SessionFactoryImpl:173 - Session factory constructed with filter configurations :
{}
14:57:54,081 DEBUG SessionFactoryImpl:177 - instantiating session factory with properties: {java.run
time.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=root, sun.
boot.library.path=C:\Program Files\Java\jdk1.5.0_11\jre\bin, java.vm.version=1.5.0_11-b03, hibernate
.connection.username=root, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com
/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country
=US, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 2, java.vm.specification.name=J
ava Virtual Machine Specification, user.dir=C:\Documents and Settings\DG03118\My Documents\workspace
\Hibernate, java.runtime.version=1.5.0_11-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_11\jre\lib\endorsed, os.arch=x86, java.io.tmpdir
=C:\DOCUME~1\DG03118\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.enc
oding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_11\bin;.;C:\WINDOWS\system32;C:\WINDO
WS;C:\Program Files\Java\jdk1.5.0_11\bin\..\jre\bin\client;C:\Program Files\Java\jdk1.5.0_11\bin\..\
jre\bin;C:\Program Files\Java\jdk1.5.0_11\bin;C:\AGILE\ANT\bin;C:\oracle\product\10.2.0\db_1\bin;C:\
php; C:\php\ext;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS
\System32\Wbem;C:\Program Files\Novell\ZENworks\;C:\WINDOWS\system32\nls;C:\WINDOWS\system32\nls\eng
lish;C:\Program Files\Attachmate\E!E2K\;C:\Program Files\IBM\WebSphere MQ\bin;C:\Program Files\IBM\W
ebSphere MQ\Java\bin;C:\Program Files\IBM\WebSphere MQ\WEMPS\bin;C:\Program Files\IBM\Rational\SDP\6
.0\runtimes\base_v51\bin;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v5\bin;C:\Program Files
\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\PROGRA~1\IBM\SQL
LIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\Program Files\Pointsec\Pointsec Media Encryption\Program\
;Z:.;, hibernate.myeclipse.connection.profile=mysql, java.specification.name=Java Platform API Speci
fication, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1,
user.home=C:\Documents and Settings\DG03118, connection.password=root, user.timezone=America/Chicago
, java.awt.printerjob=sun.awt.windows.WPrinterJob, connection.username=root, java.specification.vers
ion=1.5, file.encoding=Cp1252, myeclipse.connection.profile=mysql, hibernate.connection.driver_class
=com.mysql.jdbc.Driver, show_sql=true, java.class.path=C:\Documents and Settings\DG03118\My Document
s\workspace\Hibernate\classes;C:\Documents and Settings\DG03118\My Documents\workspace\HibernateDemo
\lib\mysql-connector-java-5.0.0-beta-bin.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genu
itec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\antlr-2.7.6.jar;C:\Progr
am Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\
myeclipse-data\3.0\lib\asm.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hiber
nate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.0\lib\asm-attrs.jar;C:\Program Files\MyEclip
se 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3
.1\lib\cglib-2.1.3.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.ecl
ipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.0\lib\commons-collections-2.1.1.jar;C:\Program Files
\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclips
e-data\3.0\lib\commons-logging-1.0.4.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec
.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.1\lib\dom4j-1.6.1.jar;C:\Program F
iles\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myec
lipse-data\3.2\lib\ehcache-1.2.3.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org
.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\hibernate3.jar;C:\Program Files\
MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse
-data\3.0\lib\jaas.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.ecl
ipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.1\lib\jaxen-1.1-beta-7.jar;C:\Program Files\MyEclips
e 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.
2\lib\javassist.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclips
e_6.0.1.zmyeclipse601200710\myeclipse-data\3.0\lib\jdbc2_0-stdext.jar;C:\Program Files\MyEclipse 6.0
\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.0\lib
\jta.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmy
eclipse601200710\myeclipse-data\3.1\lib\log4j-1.2.11.jar;C:\Program Files\MyEclipse 6.0\eclipse\plug
ins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.0\lib\xerces-2.6.2
.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyecli
pse601200710\myeclipse-data\3.0\lib\xml-apis.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.
genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\entitymanager\hibern
ate-annotations.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclips
e_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\entitymanager\hibernate-commons-annotations.jar;C
:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601
200710\myeclipse-data\3.2\lib\entitymanager\hibernate-entitymanager.jar;C:\Program Files\MyEclipse 6
.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\l
ib\entitymanager\hibernate-validator.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec
.org.hibernate.eclipse_6.0.1.zmyeclipse601200710\myeclipse-data\3.2\lib\entitymanager\ejb3-persisten
ce.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.org.hibernate.eclipse_6.0.1.zmyec
lipse601200710\myeclipse-data\3.2\lib\entitymanager\jboss-archive-browsing.jar;C:\Program Files\MyEc
lipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\di
st\modules\spring-aop.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.spring
framework_6.0.1.zmyeclipse601200710\data\2.0\dist\weavers\spring-agent.jar;C:\Program Files\MyEclips
e 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\dist\w
eavers\spring-tomcat-weaver.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.
springframework_6.0.1.zmyeclipse601200710\data\2.0\lib\asm\asm-2.2.3.jar;C:\Program Files\MyEclipse
6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\lib\asm\
asm-commons-2.2.3.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springfram
ework_6.0.1.zmyeclipse601200710\data\2.0\lib\asm\asm-util-2.2.3.jar;C:\Program Files\MyEclipse 6.0\e
clipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\lib\aspectj\a
spectjrt.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0
.1.zmyeclipse601200710\data\2.0\lib\aspectj\aspectjweaver.jar;C:\Program Files\MyEclipse 6.0\eclipse
\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\lib\aopalliance\aop
alliance.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0
.1.zmyeclipse601200710\data\1.2\lib\dependencies\cglib\cglib-nodep-2.1_3.jar;C:\Program Files\MyEcli
pse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\1.2\lib\
dependencies\oro\jakarta-oro-2.0.8.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.e
clipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\dist\modules\spring-beans.jar;C:\Program F
iles\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\da
ta\2.0\dist\modules\spring-context.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.e
clipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\dist\modules\spring-core.jar;C:\Program Fi
les\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\dat
a\1.2\lib\dependencies\jakarta-commons\commons-attributes-api.jar;C:\Program Files\MyEclipse 6.0\ecl
ipse\plugins\com.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\1.2\lib\dependencie
s\jakarta-commons\commons-attributes-compiler.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com
.genuitec.eclipse.springframework_6.0.1.zmyeclipse601200710\data\2.0\lib\jakarta-commons\commons-log
ging.jar;C:\Program Files\MyEclipse 6.0\eclipse\plugins\com.genuitec.eclipse.springframework_6.0.1.z
myeclipse601200710\data\2.0\lib\log4j\log4j-1.2.14.jar, user.name=DG03118, hibernate.bytecode.use_re
flection_optimizer=false, hibernate.show_sql=true, java.vm.specification.version=1.0, sun.arch.data.
model=32, java.home=C:\Program Files\Java\jdk1.5.0_11\jre, hibernate.connection.url=jdbc:mysql://loc
alhost:3306/javalobby, hibernate.dialect=org.hibernate.dialect.MySQLDialect, java.specification.vend
or=Sun Microsystems Inc., user.language=en, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed
mode, java.version=1.5.0_11, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_11\jre\lib\ext, sun.boot.
class.path=C:\Program Files\Java\jdk1.5.0_11\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_11\jre\li
b\i18n.jar;C:\Program Files\Java\jdk1.5.0_11\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_1
1\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_11\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_
11\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_11\jre\classes, java.vendor=Sun Microsystems
Inc., file.separator=\, connection.driver_class=com.mysql.jdbc.Driver, max_fetch_depth=1, java.vendo
r.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.cpu.endian=little, sun.io.unicode.encoding=
UnicodeLittle, sun.desktop=windows, hibernate.max_fetch_depth=1, connection.url=jdbc:mysql://localho
st:3306/javalobby, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86, di
alect=org.hibernate.dialect.MySQLDialect}
14:57:54,301 DEBUG AbstractEntityPersister:2738 - Static SQL for entity: com.javalobby.tnt.domain2.E
mployee
14:57:54,301 DEBUG AbstractEntityPersister:2743 - Version select: select user_id from USER where us
er_id =?
14:57:54,301 DEBUG AbstractEntityPersister:2746 - Snapshot select: select employee_.user_id, employ
ee_.first_name as first3_0_, employee_.last_name as last4_0_, employee_1_.job_title as job2_1_, empl
oyee_1_.supervisor_id as supervisor3_1_ from USER employee_ inner join employee employee_1_ on emplo
yee_.user_id=employee_1_.employee_id where employee_.user_id=?
14:57:54,301 DEBUG AbstractEntityPersister:2749 - Insert 0: insert into USER (first_name, last_name
, supervisor_id, type, user_id) values (?, ?, ?, 'employee', ?)
14:57:54,301 DEBUG AbstractEntityPersister:2750 - Update 0: update USER set first_name=?, last_name
=? where user_id=?
14:57:54,301 DEBUG AbstractEntityPersister:2751 - Delete 0: delete from USER where user_id=?
14:57:54,301 DEBUG AbstractEntityPersister:2749 - Insert 1: insert into employee (job_title, superv
isor_id, employee_id) values (?, ?, ?)
14:57:54,301 DEBUG AbstractEntityPersister:2750 - Update 1: update employee set job_title=?, superv
isor_id=? where employee_id=?
14:57:54,301 DEBUG AbstractEntityPersister:2751 - Delete 1: delete from employee where employee_id=
?
14:57:54,301 DEBUG AbstractEntityPersister:2755 - Identity insert: insert into USER (first_name, la
st_name, supervisor_id, type) values (?, ?, ?, 'employee')
14:57:54,316 DEBUG AbstractEntityPersister:2738 - Static SQL for entity: com.javalobby.tnt.domain2.E
mployer
14:57:54,316 DEBUG AbstractEntityPersister:2743 - Version select: select user_id from USER where us
er_id =?
14:57:54,316 DEBUG AbstractEntityPersister:2746 - Snapshot select: select employer_.user_id, employ
er_.first_name as first3_0_, employer_.last_name as last4_0_, employer_1_.job_title as job2_1_, empl
oyer_1_.supervisor_id as supervisor3_1_, employer_2_.company_car_brand as company2_2_ from USER empl
oyer_ inner join employee employer_1_ on employer_.user_id=employer_1_.employee_id inner join employ
er employer_2_ on employer_.user_id=employer_2_.employer_id where employer_.user_id=?
14:57:54,316 DEBUG AbstractEntityPersister:2749 - Insert 0: insert into USER (first_name, last_name
, supervisor_id, type, user_id) values (?, ?, ?, 'employer', ?)
14:57:54,316 DEBUG AbstractEntityPersister:2750 - Update 0: update USER set first_name=?, last_name
=? where user_id=?
14:57:54,316 DEBUG AbstractEntityPersister:2751 - Delete 0: delete from USER where user_id=?
14:57:54,316 DEBUG AbstractEntityPersister:2749 - Insert 1: insert into employee (job_title, superv
isor_id, employee_id) values (?, ?, ?)
14:57:54,316 DEBUG AbstractEntityPersister:2750 - Update 1: update employee set job_title=?, superv
isor_id=? where employee_id=?
14:57:54,316 DEBUG AbstractEntityPersister:2751 - Delete 1: delete from employee where employee_id=
?
14:57:54,316 DEBUG AbstractEntityPersister:2749 - Insert 2: insert into employer (company_car_brand
, employer_id) values (?, ?)
14:57:54,316 DEBUG AbstractEntityPersister:2750 - Update 2: update employer set company_car_brand=?
where employer_id=?
14:57:54,316 DEBUG AbstractEntityPersister:2751 - Delete 2: delete from employer where employer_id=
?
14:57:54,316 DEBUG AbstractEntityPersister:2755 - Identity insert: insert into USER (first_name, la
st_name, supervisor_id, type) values (?, ?, ?, 'employer')
14:57:54,316 DEBUG AbstractEntityPersister:2738 - Static SQL for entity: com.javalobby.tnt.domain2.U
ser
14:57:54,316 DEBUG AbstractEntityPersister:2743 - Version select: select user_id from USER where us
er_id =?
14:57:54,316 DEBUG AbstractEntityPersister:2746 - Snapshot select: select user_.user_id, user_.firs
t_name as first3_0_, user_.last_name as last4_0_ from USER user_ where user_.user_id=?
14:57:54,316 DEBUG AbstractEntityPersister:2749 - Insert 0: insert into USER (first_name, last_name
, type, user_id) values (?, ?, 'com.javalobby.tnt.domain2.User', ?)
14:57:54,316 DEBUG AbstractEntityPersister:2750 - Update 0: update USER set first_name=?, last_name
=? where user_id=?
14:57:54,316 DEBUG AbstractEntityPersister:2751 - Delete 0: delete from USER where user_id=?
14:57:54,316 DEBUG AbstractEntityPersister:2755 - Identity insert: insert into USER (first_name, la
st_name, type) values (?, ?, 'com.javalobby.tnt.domain2.User')
14:57:54,332 DEBUG AbstractCollectionPersister:548 - Static SQL for collection: com.javalobby.tnt.do
main2.Employer.subordinates
14:57:54,332 DEBUG AbstractCollectionPersister:550 - Row insert: update USER set supervisor_id=? wh
ere user_id=?
14:57:54,332 DEBUG AbstractCollectionPersister:556 - Row delete: update USER set supervisor_id=null
where supervisor_id=? and user_id=?
14:57:54,332 DEBUG AbstractCollectionPersister:559 - One-shot delete: update USER set supervisor_id
=null where supervisor_id=?
14:57:54,395 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employer: se
lect employer0_.user_id as user1_0_0_, employer0_.first_name as first3_0_0_, employer0_.last_name as
last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.supervisor_id as supervisor3_1_0_, em
ployer0_2_.company_car_brand as company2_2_0_ from USER employer0_ inner join employee employer0_1_
on employer0_.user_id=employer0_1_.employee_id inner join employer employer0_2_ on employer0_.user_i
d=employer0_2_.employer_id where employer0_.user_id=? and employer0_.type='employer'
14:57:54,395 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employer: se
lect employer0_.user_id as user1_0_0_, employer0_.first_name as first3_0_0_, employer0_.last_name as
last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.supervisor_id as supervisor3_1_0_, em
ployer0_2_.company_car_brand as company2_2_0_ from USER employer0_ inner join employee employer0_1_
on employer0_.user_id=employer0_1_.employee_id inner join employer employer0_2_ on employer0_.user_i
d=employer0_2_.employer_id where employer0_.user_id=? and employer0_.type='employer'
14:57:54,395 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employer: se
lect employer0_.user_id as user1_0_0_, employer0_.first_name as first3_0_0_, employer0_.last_name as
last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.supervisor_id as supervisor3_1_0_, em
ployer0_2_.company_car_brand as company2_2_0_ from USER employer0_ inner join employee employer0_1_
on employer0_.user_id=employer0_1_.employee_id inner join employer employer0_2_ on employer0_.user_i
d=employer0_2_.employer_id where employer0_.user_id=? and employer0_.type='employer' for update
14:57:54,395 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employer: se
lect employer0_.user_id as user1_0_0_, employer0_.first_name as first3_0_0_, employer0_.last_name as
last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.supervisor_id as supervisor3_1_0_, em
ployer0_2_.company_car_brand as company2_2_0_ from USER employer0_ inner join employee employer0_1_
on employer0_.user_id=employer0_1_.employee_id inner join employer employer0_2_ on employer0_.user_i
d=employer0_2_.employer_id where employer0_.user_id=? and employer0_.type='employer' for update
14:57:54,395 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employer: se
lect employer0_.user_id as user1_0_0_, employer0_.first_name as first3_0_0_, employer0_.last_name as
last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.supervisor_id as supervisor3_1_0_, em
ployer0_2_.company_car_brand as company2_2_0_ from USER employer0_ inner join employee employer0_1_
on employer0_.user_id=employer0_1_.employee_id inner join employer employer0_2_ on employer0_.user_i
d=employer0_2_.employer_id where employer0_.user_id=? and employer0_.type='employer' for update
14:57:54,410 DEBUG EntityLoader:34 - Static select for action ACTION_MERGE on entity com.javalobby.t
nt.domain2.Employer: select employer0_.user_id as user1_0_0_, employer0_.first_name as first3_0_0_,
employer0_.last_name as last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.supervisor_id
as supervisor3_1_0_, employer0_2_.company_car_brand as company2_2_0_ from USER employer0_ inner join
employee employer0_1_ on employer0_.user_id=employer0_1_.employee_id inner join employer employer0_
2_ on employer0_.user_id=employer0_2_.employer_id where employer0_.user_id=? and employer0_.type='em
ployer'
14:57:54,410 DEBUG EntityLoader:34 - Static select for action ACTION_REFRESH on entity com.javalobby
.tnt.domain2.Employer: select employer0_.user_id as user1_0_0_, employer0_.first_name as first3_0_0_
, employer0_.last_name as last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.supervisor_i
d as supervisor3_1_0_, employer0_2_.company_car_brand as company2_2_0_ from USER employer0_ inner jo
in employee employer0_1_ on employer0_.user_id=employer0_1_.employee_id inner join employer employer
0_2_ on employer0_.user_id=employer0_2_.employer_id where employer0_.user_id=? and employer0_.type='
employer'
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employee: se
lect employee0_.user_id as user1_0_0_, employee0_.first_name as first3_0_0_, employee0_.last_name as
last4_0_0_, employee0_1_.job_title as job2_1_0_, employee0_1_.supervisor_id as supervisor3_1_0_, em
ployee0_2_.company_car_brand as company2_2_0_, employee0_.type as type0_0_ from USER employee0_ inne
r join employee employee0_1_ on employee0_.user_id=employee0_1_.employee_id left outer join employer
employee0_2_ on employee0_.user_id=employee0_2_.employer_id where employee0_.user_id=? and employee
0_.type in ('employee', 'employer')
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employee: se
lect employee0_.user_id as user1_0_0_, employee0_.first_name as first3_0_0_, employee0_.last_name as
last4_0_0_, employee0_1_.job_title as job2_1_0_, employee0_1_.supervisor_id as supervisor3_1_0_, em
ployee0_2_.company_car_brand as company2_2_0_, employee0_.type as type0_0_ from USER employee0_ inne
r join employee employee0_1_ on employee0_.user_id=employee0_1_.employee_id left outer join employer
employee0_2_ on employee0_.user_id=employee0_2_.employer_id where employee0_.user_id=? and employee
0_.type in ('employee', 'employer')
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employee: se
lect employee0_.user_id as user1_0_0_, employee0_.first_name as first3_0_0_, employee0_.last_name as
last4_0_0_, employee0_1_.job_title as job2_1_0_, employee0_1_.supervisor_id as supervisor3_1_0_, em
ployee0_2_.company_car_brand as company2_2_0_, employee0_.type as type0_0_ from USER employee0_ inne
r join employee employee0_1_ on employee0_.user_id=employee0_1_.employee_id left outer join employer
employee0_2_ on employee0_.user_id=employee0_2_.employer_id where employee0_.user_id=? and employee
0_.type in ('employee', 'employer') for update
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employee: se
lect employee0_.user_id as user1_0_0_, employee0_.first_name as first3_0_0_, employee0_.last_name as
last4_0_0_, employee0_1_.job_title as job2_1_0_, employee0_1_.supervisor_id as supervisor3_1_0_, em
ployee0_2_.company_car_brand as company2_2_0_, employee0_.type as type0_0_ from USER employee0_ inne
r join employee employee0_1_ on employee0_.user_id=employee0_1_.employee_id left outer join employer
employee0_2_ on employee0_.user_id=employee0_2_.employer_id where employee0_.user_id=? and employee
0_.type in ('employee', 'employer') for update
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.Employee: se
lect employee0_.user_id as user1_0_0_, employee0_.first_name as first3_0_0_, employee0_.last_name as
last4_0_0_, employee0_1_.job_title as job2_1_0_, employee0_1_.supervisor_id as supervisor3_1_0_, em
ployee0_2_.company_car_brand as company2_2_0_, employee0_.type as type0_0_ from USER employee0_ inne
r join employee employee0_1_ on employee0_.user_id=employee0_1_.employee_id left outer join employer
employee0_2_ on employee0_.user_id=employee0_2_.employer_id where employee0_.user_id=? and employee
0_.type in ('employee', 'employer') for update
14:57:54,410 DEBUG EntityLoader:34 - Static select for action ACTION_MERGE on entity com.javalobby.t
nt.domain2.Employee: select employee0_.user_id as user1_0_0_, employee0_.first_name as first3_0_0_,
employee0_.last_name as last4_0_0_, employee0_1_.job_title as job2_1_0_, employee0_1_.supervisor_id
as supervisor3_1_0_, employee0_2_.company_car_brand as company2_2_0_, employee0_.type as type0_0_ fr
om USER employee0_ inner join employee employee0_1_ on employee0_.user_id=employee0_1_.employee_id l
eft outer join employer employee0_2_ on employee0_.user_id=employee0_2_.employer_id where employee0_
.user_id=? and employee0_.type in ('employee', 'employer')
14:57:54,410 DEBUG EntityLoader:34 - Static select for action ACTION_REFRESH on entity com.javalobby
.tnt.domain2.Employee: select employee0_.user_id as user1_0_0_, employee0_.first_name as first3_0_0_
, employee0_.last_name as last4_0_0_, employee0_1_.job_title as job2_1_0_, employee0_1_.supervisor_i
d as supervisor3_1_0_, employee0_2_.company_car_brand as company2_2_0_, employee0_.type as type0_0_
from USER employee0_ inner join employee employee0_1_ on employee0_.user_id=employee0_1_.employee_id
left outer join employer employee0_2_ on employee0_.user_id=employee0_2_.employer_id where employee
0_.user_id=? and employee0_.type in ('employee', 'employer')
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.User: select
user0_.user_id as user1_0_0_, user0_.first_name as first3_0_0_, user0_.last_name as last4_0_0_, use
r0_1_.job_title as job2_1_0_, user0_1_.supervisor_id as supervisor3_1_0_, user0_2_.company_car_brand
as company2_2_0_, user0_.type as type0_0_ from USER user0_ left outer join employee user0_1_ on use
r0_.user_id=user0_1_.employee_id left outer join employer user0_2_ on user0_.user_id=user0_2_.employ
er_id where user0_.user_id=?
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.User: select
user0_.user_id as user1_0_0_, user0_.first_name as first3_0_0_, user0_.last_name as last4_0_0_, use
r0_1_.job_title as job2_1_0_, user0_1_.supervisor_id as supervisor3_1_0_, user0_2_.company_car_brand
as company2_2_0_, user0_.type as type0_0_ from USER user0_ left outer join employee user0_1_ on use
r0_.user_id=user0_1_.employee_id left outer join employer user0_2_ on user0_.user_id=user0_2_.employ
er_id where user0_.user_id=?
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.User: select
user0_.user_id as user1_0_0_, user0_.first_name as first3_0_0_, user0_.last_name as last4_0_0_, use
r0_1_.job_title as job2_1_0_, user0_1_.supervisor_id as supervisor3_1_0_, user0_2_.company_car_brand
as company2_2_0_, user0_.type as type0_0_ from USER user0_ left outer join employee user0_1_ on use
r0_.user_id=user0_1_.employee_id left outer join employer user0_2_ on user0_.user_id=user0_2_.employ
er_id where user0_.user_id=? for update
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.User: select
user0_.user_id as user1_0_0_, user0_.first_name as first3_0_0_, user0_.last_name as last4_0_0_, use
r0_1_.job_title as job2_1_0_, user0_1_.supervisor_id as supervisor3_1_0_, user0_2_.company_car_brand
as company2_2_0_, user0_.type as type0_0_ from USER user0_ left outer join employee user0_1_ on use
r0_.user_id=user0_1_.employee_id left outer join employer user0_2_ on user0_.user_id=user0_2_.employ
er_id where user0_.user_id=? for update
14:57:54,410 DEBUG EntityLoader:79 - Static select for entity com.javalobby.tnt.domain2.User: select
user0_.user_id as user1_0_0_, user0_.first_name as first3_0_0_, user0_.last_name as last4_0_0_, use
r0_1_.job_title as job2_1_0_, user0_1_.supervisor_id as supervisor3_1_0_, user0_2_.company_car_brand
as company2_2_0_, user0_.type as type0_0_ from USER user0_ left outer join employee user0_1_ on use
r0_.user_id=user0_1_.employee_id left outer join employer user0_2_ on user0_.user_id=user0_2_.employ
er_id where user0_.user_id=? for update
14:57:54,426 DEBUG EntityLoader:34 - Static select for action ACTION_MERGE on entity com.javalobby.t
nt.domain2.User: select user0_.user_id as user1_0_0_, user0_.first_name as first3_0_0_, user0_.last_
name as last4_0_0_, user0_1_.job_title as job2_1_0_, user0_1_.supervisor_id as supervisor3_1_0_, use
r0_2_.company_car_brand as company2_2_0_, user0_.type as type0_0_ from USER user0_ left outer join e
mployee user0_1_ on user0_.user_id=user0_1_.employee_id left outer join employer user0_2_ on user0_.
user_id=user0_2_.employer_id where user0_.user_id=?
14:57:54,426 DEBUG EntityLoader:34 - Static select for action ACTION_REFRESH on entity com.javalobby
.tnt.domain2.User: select user0_.user_id as user1_0_0_, user0_.first_name as first3_0_0_, user0_.las
t_name as last4_0_0_, user0_1_.job_title as job2_1_0_, user0_1_.supervisor_id as supervisor3_1_0_, u
ser0_2_.company_car_brand as company2_2_0_, user0_.type as type0_0_ from USER user0_ left outer join
employee user0_1_ on user0_.user_id=user0_1_.employee_id left outer join employer user0_2_ on user0
_.user_id=user0_2_.employer_id where user0_.user_id=?
14:57:54,426 DEBUG OneToManyLoader:64 - Static select for one-to-many com.javalobby.tnt.domain2.Empl
oyer.subordinates: select subordinat0_.supervisor_id as supervisor5_1_, subordinat0_.user_id as user
1_1_, subordinat0_.user_id as user1_0_0_, subordinat0_.first_name as first3_0_0_, subordinat0_.last_
name as last4_0_0_, subordinat0_1_.job_title as job2_1_0_, subordinat0_1_.supervisor_id as superviso
r3_1_0_, subordinat0_2_.company_car_brand as company2_2_0_, subordinat0_.type as type0_0_ from USER
subordinat0_ inner join employee subordinat0_1_ on subordinat0_.user_id=subordinat0_1_.employee_id l
eft outer join employer subordinat0_2_ on subordinat0_.user_id=subordinat0_2_.employer_id where subo
rdinat0_.supervisor_id=?
14:57:54,442 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
14:57:54,442 DEBUG SessionFactoryObjectFactory:76 - registered: 8a2b48c217a871500117a871520a0000 (un
named)
14:57:54,442 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name config
ured
14:57:54,442 DEBUG SessionFactoryImpl:308 - instantiated session factory
14:57:54,442 DEBUG SessionFactoryImpl:392 - Checking 0 named HQL queries
14:57:54,442 DEBUG SessionFactoryImpl:412 - Checking 0 named SQL queries
14:57:54,489 DEBUG SessionImpl:220 - opened session at timestamp: 12011218744
14:57:54,489 DEBUG DefaultLoadEventListener:171 - loading entity: [com.javalobby.tnt.domain2.Employe
r#1]
14:57:54,489 DEBUG DefaultLoadEventListener:255 - creating new proxy for entity
14:57:54,489 DEBUG JDBCContext:233 - after autocommit
14:57:54,489 DEBUG ConnectionManager:404 - aggressively releasing JDBC connection
14:57:54,489 DEBUG SessionImpl:422 - after transaction completion
14:57:54,489 DEBUG SessionImpl:832 - initializing proxy: [com.javalobby.tnt.domain2.Employer#1]
14:57:54,489 DEBUG DefaultLoadEventListener:332 - attempting to resolve: [com.javalobby.tnt.domain2.
Employer#1]
14:57:54,489 DEBUG DefaultLoadEventListener:369 - object not resolved in any cache: [com.javalobby.t
nt.domain2.Employer#1]
14:57:54,489 DEBUG AbstractEntityPersister:3037 - Fetching entity: [com.javalobby.tnt.domain2.Employ
er#1]
14:57:54,489 DEBUG Loader:1852 - loading entity: [com.javalobby.tnt.domain2.Employer#1]
14:57:54,504 DEBUG AbstractBatcher:366 - about to open PreparedStatement (open PreparedStatements: 0
, globally: 0)
14:57:54,504 DEBUG ConnectionManager:421 - opening JDBC connection
14:57:54,504 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
14:57:54,504 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
14:57:54,504 DEBUG SQL:401 - select employer0_.user_id as user1_0_0_, employer0_.first_name as first
3_0_0_, employer0_.last_name as last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.superv
isor_id as supervisor3_1_0_, employer0_2_.company_car_brand as company2_2_0_ from USER employer0_ in
ner join employee employer0_1_ on employer0_.user_id=employer0_1_.employee_id inner join employer em
ployer0_2_ on employer0_.user_id=employer0_2_.employer_id where employer0_.user_id=? and employer0_.
type='employer'
Hibernate: select employer0_.user_id as user1_0_0_, employer0_.first_name as first3_0_0_, employer0_
.last_name as last4_0_0_, employer0_1_.job_title as job2_1_0_, employer0_1_.supervisor_id as supervi
sor3_1_0_, employer0_2_.company_car_brand as company2_2_0_ from USER employer0_ inner join employee
employer0_1_ on employer0_.user_id=employer0_1_.employee_id inner join employer employer0_2_ on empl
oyer0_.user_id=employer0_2_.employer_id where employer0_.user_id=? and employer0_.type='employer'
14:57:54,504 DEBUG AbstractBatcher:484 - preparing statement
14:57:54,520 DEBUG LongType:133 - binding '1' to parameter: 1
14:57:54,520 DEBUG AbstractBatcher:382 - about to open ResultSet (open ResultSets: 0, globally: 0)
14:57:54,520 DEBUG Loader:694 - processing result set
14:57:54,520 DEBUG Loader:699 - result set row: 0
14:57:54,520 DEBUG Loader:1173 - result row: EntityKey[com.javalobby.tnt.domain2.Employer#1]
14:57:54,520 DEBUG Loader:1355 - Initializing object from ResultSet: [com.javalobby.tnt.domain2.Empl
oyer#1]
14:57:54,536 DEBUG AbstractEntityPersister:2031 - Hydrating entity: [com.javalobby.tnt.domain2.Emplo
yer#1]
14:57:54,536 DEBUG StringType:172 - returning 'R.J.' as column: first3_0_0_
14:57:54,536 DEBUG StringType:172 - returning 'Lorimer' as column: last4_0_0_
14:57:54,536 DEBUG StringType:172 - returning 'Master of All' as column: job2_1_0_
14:57:54,536 DEBUG LongType:166 - returning null as column: supervisor3_1_0_
14:57:54,536 DEBUG StringType:172 - returning 'Ferrari' as column: company2_2_0_
14:57:54,536 DEBUG Loader:721 - done processing result set (1 rows)
14:57:54,536 DEBUG AbstractBatcher:389 - about to close ResultSet (open ResultSets: 1, globally: 1)
14:57:54,536 DEBUG AbstractBatcher:374 - about to close PreparedStatement (open PreparedStatements:
1, globally: 1)
14:57:54,536 DEBUG AbstractBatcher:533 - closing statement
14:57:54,536 DEBUG Loader:851 - total objects hydrated: 1
14:57:54,536 DEBUG TwoPhaseLoad:107 - resolving associations for [com.javalobby.tnt.domain2.Employer
#1]
14:57:54,536 DEBUG LoadContexts:183 - creating collection wrapper:[com.javalobby.tnt.domain2.Employe
r.subordinates#1]
14:57:54,551 DEBUG TwoPhaseLoad:206 - done materializing entity [com.javalobby.tnt.domain2.Employer#
1]
14:57:54,551 DEBUG StatefulPersistenceContext:790 - initializing non-lazy collections
14:57:54,551 DEBUG Loader:1883 - done entity load
Class: class com.javalobby.tnt.domain2.Employer
ID: 1
First Name: R.J.
Last Name: Lorimer
Last Version: 0
Job Title: Master of All
Supervisor: null
Company Car Brand: Ferrari
14:57:54,551 DEBUG DefaultInitializeCollectionEventListener:41 - initializing collection [com.javalo
bby.tnt.domain2.Employer.subordinates#1]
14:57:54,551 DEBUG DefaultInitializeCollectionEventListener:47 - checking second-level cache
14:57:54,551 DEBUG DefaultInitializeCollectionEventListener:59 - collection not cached
14:57:54,551 DEBUG Loader:1986 - loading collection: [com.javalobby.tnt.domain2.Employer.subordinate
s#1]
14:57:54,551 DEBUG AbstractBatcher:366 - about to open PreparedStatement (open PreparedStatements: 0
, globally: 0)
14:57:54,551 DEBUG SQL:401 - select subordinat0_.supervisor_id as supervisor5_1_, subordinat0_.user_
id as user1_1_, subordinat0_.user_id as user1_0_0_, subordinat0_.first_name as first3_0_0_, subordin
at0_.last_name as last4_0_0_, subordinat0_1_.job_title as job2_1_0_, subordinat0_1_.supervisor_id as
supervisor3_1_0_, subordinat0_2_.company_car_brand as company2_2_0_, subordinat0_.type as type0_0_
from USER subordinat0_ inner join employee subordinat0_1_ on subordinat0_.user_id=subordinat0_1_.emp
loyee_id left outer join employer subordinat0_2_ on subordinat0_.user_id=subordinat0_2_.employer_id
where subordinat0_.supervisor_id=?
Hibernate: select subordinat0_.supervisor_id as supervisor5_1_, subordinat0_.user_id as user1_1_, su
bordinat0_.user_id as user1_0_0_, subordinat0_.first_name as first3_0_0_, subordinat0_.last_name as
last4_0_0_, subordinat0_1_.job_title as job2_1_0_, subordinat0_1_.supervisor_id as supervisor3_1_0_,
subordinat0_2_.company_car_brand as company2_2_0_, subordinat0_.type as type0_0_ from USER subordin
at0_ inner join employee subordinat0_1_ on subordinat0_.user_id=subordinat0_1_.employee_id left oute
r join employer subordinat0_2_ on subordinat0_.user_id=subordinat0_2_.employer_id where subordinat0_
.supervisor_id=?
14:57:54,551 DEBUG AbstractBatcher:484 - preparing statement
14:57:54,567 DEBUG LongType:133 - binding '1' to parameter: 1
14:57:54,583 DEBUG AbstractBatcher:374 - about to close PreparedStatement (open PreparedStatements:
1, globally: 1)
14:57:54,583 DEBUG AbstractBatcher:533 - closing statement
14:57:54,583 DEBUG JDBCExceptionReporter:69 - could not initialize a collection: [com.javalobby.tnt.
domain2.Employer.subordinates#1] [select subordinat0_.supervisor_id as supervisor5_1_, subordinat0_.
user_id as user1_1_, subordinat0_.user_id as user1_0_0_, subordinat0_.first_name as first3_0_0_, sub
ordinat0_.last_name as last
Login
FAQ
Search