-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 
Author Message
 Post subject: Upgrade Hibernate 3.0.5: Not able to obtain connection
PostPosted: Mon Aug 15, 2005 12:03 pm 
Newbie

Joined: Mon Aug 15, 2005 6:57 am
Posts: 7
After upgrading from Hibernate 2 to 3.0.5, the following function is not working anymore. For some reason hibernate cannot obtain the connection.

public static PrincipalImpl getPrincipalByDsnKey(String dsnKey) {
try {
Session session = SessionManager.currentSession();
Query query = session.createQuery("from PrincipalImpl where DSN_KEY = :key");
query.setParameter("key", dsnKey, Hibernate.STRING);
return (PrincipalImpl) query.uniqueResult();
} catch (Exception e){
e.printStackTrace();
}
return null;
}

My hibernate mapping is:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<!-- Created Wed Jun 01 13:20:07 CEST 2005 -->
<hibernate-mapping package="nl.uva.hum.hibernate.persistent">

<class name="PrincipalImpl" table="PFX_PRINCIPAL" discriminator-value="user">
<id name="id" column="ID" type="long">
<generator class="sequence">
<param name="sequence">PFX_PRINCIPAL_SEQ</param>
</generator>
</id>
<discriminator column="TYPE" type="java.lang.String"/>
<property name="type" column="TYPE" type="java.lang.String" insert="false" update="false" />
<property name="name" column="NAME" type="java.lang.String" />
<property name="dsnKey" column="DSN_KEY" type="java.lang.String" />
<property name="password" column="PASSWORD" type="java.lang.String" />
<property name="metadata" column="METADATA" type="java.lang.String" />
<property name="creationDatetime" column="CREATION_DATETIME" type="java.util.Date" />
<property name="expiredDatetime" column="EXPIRED_DATETIME" type="java.util.Date" />
<set name="members" table="PFX_ATBL_PRINCIPAL_PRINCIPAL" lazy="false" cascade="none">
<key column="PARENT_FK"/>
<many-to-many class="PrincipalImpl" column="CHILD_FK"/>
</set>
<set name="membership" lazy="false" table="PFX_ATBL_PRINCIPAL_PRINCIPAL" cascade="none">
<key column="CHILD_FK" />
<many-to-many class="PrincipalImpl" column="PARENT_FK"/>
</set>
<many-to-one name="profile" column="PROFILE_FK" class="Profile" />
<set name="signatures" lazy="false" table="PFX_SIGNATURE" cascade="none">
<key column="PRINCIPAL_FK" />
<one-to-many class="Signature"/>
</set>
<subclass lazy="false" name="GroupImpl" discriminator-value="group"/>
</class>
</hibernate-mapping>

I get the following error:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: select administra0_.ID as ID, administra0_.ISIS_ADMINKODE as ISIS2_7_ from PFX_ADMINISTRATION administra0_ where ISIS_ADMINKODE=?
Hibernate: select subjects0_.ADMINISTRATION_FK as ADMINIST3_1_, subjects0_.ID as ID1_, subjects0_.ID as ID0_, subjects0_.ISIS_VAKKODE as ISIS2_2_0_, subjects0_.ADMINISTRATION_FK as ADMINIST3_2_0_ from PFX_SUBJECT subjects0_ where subjects0_.ADMINISTRATION_FK=?
Hibernate: select examinatio0_.SUBJECT_FK as SUBJECT7_1_, examinatio0_.ID as ID1_, examinatio0_.ID as ID0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT2_5_0_, examinatio0_.EXAMINATION_DATETIME as EXAMINAT3_5_0_, examinatio0_.EXPIRATION_DATETIME as EXPIRATION4_5_0_, examinatio0_.STUDYLOAD as STUDYLOAD5_0_, examinatio0_.DOCENT_FK as DOCENT6_5_0_, examinatio0_.SUBJECT_FK as SUBJECT7_5_0_ from PFX_EXAMINATION_OCCURRENCE examinatio0_ where examinatio0_.SUBJECT_FK=?
org.hibernate.HibernateException: Not able to obtain connection
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:113)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:603)
at nl.uva.hum.registration.ManagerImpl.getPrincipalByDsnKey(ManagerImpl.java:558)
at nl.uva.hum.registration.ManagerImpl.getEmployeeByDsnKey(ManagerImpl.java:516)
at nl.uva.hum.hibernate.test.CijferregistratieTest.testAdministration(CijferregistratieTest.java:45)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:474)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:342)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:194)
org.hibernate.HibernateException: Not able to obtain connection
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:113)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
.....

Can anyone help me out?

Thanx.


Top
 Profile  
 
 Post subject: cfg
PostPosted: Mon Aug 15, 2005 12:22 pm 
Expert
Expert

Joined: Fri Jul 22, 2005 2:42 pm
Posts: 670
Location: Seattle, WA
And what is in your hibernate.properties or hibernate.cfg.xml?

_________________
--------------
Konstantin

SourceLabs - dependable OpenSource systems


Top
 Profile  
 
 Post subject: Hibernate configurration file
PostPosted: Tue Aug 16, 2005 3:34 am 
Newbie

Joined: Mon Aug 15, 2005 6:57 am
Posts: 7
My hibernate.cfg.xml is as follows:

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<hibernate-configuration>

<session-factory>
<!-- properties -->
<property name="connection.username">secret</property>
<property name="connection.url">jdbc:oracle:thin:@domain:port:database</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="connection.password">secret</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.show_sql">true</property>

<!-- mapping files -->
<mapping resource="nl/uva/hum/hibernate/xml/Principal.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/Subject.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/ExaminationResult.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/Permission.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/ExaminationOccurrence.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/Signature.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/Administration.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/Profile.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/Exportbatch.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/AclEntry.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/Acl.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/Tancode.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/DhzExaminationOccurrenceView.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/PfxExaminationOccurrenceView.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/DhzExaminationCandidateView.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/PfxExaminationCandidateView.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/ExaminationCandidateViewTotalCount.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/ExaminationCandidateViewStatusCount.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/ExaminationOccurrenceView.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/OwnStudentsResultView.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/VwPfxMcCorrespondence.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/DhzAdministratie.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/DhzDocent.hbm.xml"/>
<mapping resource="nl/uva/hum/hibernate/xml/PfxAppMcCorrespondence.hbm.xml"/>

</session-factory>

</hibernate-configuration>


Top
 Profile  
 
 Post subject:
PostPosted: Tue Aug 16, 2005 3:58 am 
Senior
Senior

Joined: Thu Aug 04, 2005 4:54 am
Posts: 153
Location: Birmingham, UK
Code:
<property name="connection.url">jdbc:oracle:thin:@domain:port:database</property>


Is your database really on a domain called domain and a port numbered port?

Is your db really called database or have you posted a sample file which doesn't contain the correct values?


Top
 Profile  
 
 Post subject: Dummy date in hibernate.cfg.xml
PostPosted: Tue Aug 16, 2005 4:03 am 
Newbie

Joined: Mon Aug 15, 2005 6:57 am
Posts: 7
For security reasons I cannot give out the real values. So <domain>, <port> and <database>, as well as the values for connection.username and connection.password are dummy values.
I do not think they have anything to do with my connection problem? Connection is being made on on other simpler tables the code is working fine.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Aug 16, 2005 4:12 am 
Senior
Senior

Joined: Thu Aug 04, 2005 4:54 am
Posts: 153
Location: Birmingham, UK
Ah no problem. I'm just very wary about making assumptions about peoples intelligence. You can never be sure if someone is being clever or very very stupid.

So onto the next thing. Could you enable the logger and set it to debug to see if any more information can be extracted?


Top
 Profile  
 
 Post subject: Logging information
PostPosted: Tue Aug 16, 2005 4:48 am 
Newbie

Joined: Mon Aug 15, 2005 6:57 am
Posts: 7
Sure, here it comes:

10:44:22,672 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationOccurrenceView: select examinatio0_.ID as ID0_, examinatio0_.EXAMINATION_DATE as EXAMINAT2_21_0_, examinatio0_.EXPIRATION_DATE as EXPIRATION3_21_0_, examinatio0_.PRINCIPAL_INITIALS as PRINCIPAL4_21_0_, examinatio0_.PRINCIPAL_INFIX as PRINCIPAL5_21_0_, examinatio0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_21_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST7_21_0_, examinatio0_.SUBJECT_CODE as SUBJECT8_21_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT9_21_0_, examinatio0_.SUBJECT_DESCRIPTION as SUBJECT10_21_0_, examinatio0_.LONG_SUBJECT_NAME as LONG11_21_0_, examinatio0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_21_0_, examinatio0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_21_0_, examinatio0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_21_0_, examinatio0_.PREFIX as PREFIX21_0_ from VW_EXAMINATION_OCCURRENCE examinatio0_ where examinatio0_.ID=?
10:44:22,672 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationOccurrenceView: select examinatio0_.ID as ID0_, examinatio0_.EXAMINATION_DATE as EXAMINAT2_21_0_, examinatio0_.EXPIRATION_DATE as EXPIRATION3_21_0_, examinatio0_.PRINCIPAL_INITIALS as PRINCIPAL4_21_0_, examinatio0_.PRINCIPAL_INFIX as PRINCIPAL5_21_0_, examinatio0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_21_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST7_21_0_, examinatio0_.SUBJECT_CODE as SUBJECT8_21_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT9_21_0_, examinatio0_.SUBJECT_DESCRIPTION as SUBJECT10_21_0_, examinatio0_.LONG_SUBJECT_NAME as LONG11_21_0_, examinatio0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_21_0_, examinatio0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_21_0_, examinatio0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_21_0_, examinatio0_.PREFIX as PREFIX21_0_ from VW_EXAMINATION_OCCURRENCE examinatio0_ where examinatio0_.ID=? for update
10:44:22,672 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationOccurrenceView: select examinatio0_.ID as ID0_, examinatio0_.EXAMINATION_DATE as EXAMINAT2_21_0_, examinatio0_.EXPIRATION_DATE as EXPIRATION3_21_0_, examinatio0_.PRINCIPAL_INITIALS as PRINCIPAL4_21_0_, examinatio0_.PRINCIPAL_INFIX as PRINCIPAL5_21_0_, examinatio0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_21_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST7_21_0_, examinatio0_.SUBJECT_CODE as SUBJECT8_21_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT9_21_0_, examinatio0_.SUBJECT_DESCRIPTION as SUBJECT10_21_0_, examinatio0_.LONG_SUBJECT_NAME as LONG11_21_0_, examinatio0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_21_0_, examinatio0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_21_0_, examinatio0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_21_0_, examinatio0_.PREFIX as PREFIX21_0_ from VW_EXAMINATION_OCCURRENCE examinatio0_ where examinatio0_.ID=? for update nowait
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationCandidateViewTotalCount: select examinatio0_.id as id0_, examinatio0_.CANDIDATE_COUNT as CANDIDATE2_19_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST3_19_0_, examinatio0_.SUBJECT_CODE as SUBJECT4_19_0_, examinatio0_.EXAMINATION_DATE as EXAMINAT5_19_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT6_19_0_ from VW_TOTAL_CANDIDATE_COUNT examinatio0_ where examinatio0_.id=?
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationCandidateViewTotalCount: select examinatio0_.id as id0_, examinatio0_.CANDIDATE_COUNT as CANDIDATE2_19_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST3_19_0_, examinatio0_.SUBJECT_CODE as SUBJECT4_19_0_, examinatio0_.EXAMINATION_DATE as EXAMINAT5_19_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT6_19_0_ from VW_TOTAL_CANDIDATE_COUNT examinatio0_ where examinatio0_.id=?
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationCandidateViewTotalCount: select examinatio0_.id as id0_, examinatio0_.CANDIDATE_COUNT as CANDIDATE2_19_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST3_19_0_, examinatio0_.SUBJECT_CODE as SUBJECT4_19_0_, examinatio0_.EXAMINATION_DATE as EXAMINAT5_19_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT6_19_0_ from VW_TOTAL_CANDIDATE_COUNT examinatio0_ where examinatio0_.id=? for update
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationCandidateViewTotalCount: select examinatio0_.id as id0_, examinatio0_.CANDIDATE_COUNT as CANDIDATE2_19_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST3_19_0_, examinatio0_.SUBJECT_CODE as SUBJECT4_19_0_, examinatio0_.EXAMINATION_DATE as EXAMINAT5_19_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT6_19_0_ from VW_TOTAL_CANDIDATE_COUNT examinatio0_ where examinatio0_.id=? for update nowait
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxExaminationOccurrenceView: select pfxexamina0_.ID as ID0_, pfxexamina0_.EXAMINATION_DATE as EXAMINAT2_16_0_, pfxexamina0_.EXPIRATION_DATE as EXPIRATION3_16_0_, pfxexamina0_.PRINCIPAL_INITIALS as PRINCIPAL4_16_0_, pfxexamina0_.PRINCIPAL_INFIX as PRINCIPAL5_16_0_, pfxexamina0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_16_0_, pfxexamina0_.ADMINISTRATION_CODE as ADMINIST7_16_0_, pfxexamina0_.SUBJECT_CODE as SUBJECT8_16_0_, pfxexamina0_.EXAMINATION_NUMBER as EXAMINAT9_16_0_, pfxexamina0_.SUBJECT_DESCRIPTION as SUBJECT10_16_0_, pfxexamina0_.LONG_SUBJECT_NAME as LONG11_16_0_, pfxexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_16_0_, pfxexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_16_0_, pfxexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_16_0_ from VW_EXAMINATION_OCCURRENCE_PFX pfxexamina0_ where pfxexamina0_.ID=?
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxExaminationOccurrenceView: select pfxexamina0_.ID as ID0_, pfxexamina0_.EXAMINATION_DATE as EXAMINAT2_16_0_, pfxexamina0_.EXPIRATION_DATE as EXPIRATION3_16_0_, pfxexamina0_.PRINCIPAL_INITIALS as PRINCIPAL4_16_0_, pfxexamina0_.PRINCIPAL_INFIX as PRINCIPAL5_16_0_, pfxexamina0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_16_0_, pfxexamina0_.ADMINISTRATION_CODE as ADMINIST7_16_0_, pfxexamina0_.SUBJECT_CODE as SUBJECT8_16_0_, pfxexamina0_.EXAMINATION_NUMBER as EXAMINAT9_16_0_, pfxexamina0_.SUBJECT_DESCRIPTION as SUBJECT10_16_0_, pfxexamina0_.LONG_SUBJECT_NAME as LONG11_16_0_, pfxexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_16_0_, pfxexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_16_0_, pfxexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_16_0_ from VW_EXAMINATION_OCCURRENCE_PFX pfxexamina0_ where pfxexamina0_.ID=?
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxExaminationOccurrenceView: select pfxexamina0_.ID as ID0_, pfxexamina0_.EXAMINATION_DATE as EXAMINAT2_16_0_, pfxexamina0_.EXPIRATION_DATE as EXPIRATION3_16_0_, pfxexamina0_.PRINCIPAL_INITIALS as PRINCIPAL4_16_0_, pfxexamina0_.PRINCIPAL_INFIX as PRINCIPAL5_16_0_, pfxexamina0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_16_0_, pfxexamina0_.ADMINISTRATION_CODE as ADMINIST7_16_0_, pfxexamina0_.SUBJECT_CODE as SUBJECT8_16_0_, pfxexamina0_.EXAMINATION_NUMBER as EXAMINAT9_16_0_, pfxexamina0_.SUBJECT_DESCRIPTION as SUBJECT10_16_0_, pfxexamina0_.LONG_SUBJECT_NAME as LONG11_16_0_, pfxexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_16_0_, pfxexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_16_0_, pfxexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_16_0_ from VW_EXAMINATION_OCCURRENCE_PFX pfxexamina0_ where pfxexamina0_.ID=? for update
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxExaminationOccurrenceView: select pfxexamina0_.ID as ID0_, pfxexamina0_.EXAMINATION_DATE as EXAMINAT2_16_0_, pfxexamina0_.EXPIRATION_DATE as EXPIRATION3_16_0_, pfxexamina0_.PRINCIPAL_INITIALS as PRINCIPAL4_16_0_, pfxexamina0_.PRINCIPAL_INFIX as PRINCIPAL5_16_0_, pfxexamina0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_16_0_, pfxexamina0_.ADMINISTRATION_CODE as ADMINIST7_16_0_, pfxexamina0_.SUBJECT_CODE as SUBJECT8_16_0_, pfxexamina0_.EXAMINATION_NUMBER as EXAMINAT9_16_0_, pfxexamina0_.SUBJECT_DESCRIPTION as SUBJECT10_16_0_, pfxexamina0_.LONG_SUBJECT_NAME as LONG11_16_0_, pfxexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_16_0_, pfxexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_16_0_, pfxexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_16_0_ from VW_EXAMINATION_OCCURRENCE_PFX pfxexamina0_ where pfxexamina0_.ID=? for update nowait
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Tancode: select tancode0_.ID as ID0_, tancode0_.TANCODE_NR as TANCODE2_14_0_, tancode0_.DATETIME as DATETIME14_0_, tancode0_.PRINCIPAL_FK as PRINCIPAL4_14_0_ from PFX_TANCODE tancode0_ where tancode0_.ID=?
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Tancode: select tancode0_.ID as ID0_, tancode0_.TANCODE_NR as TANCODE2_14_0_, tancode0_.DATETIME as DATETIME14_0_, tancode0_.PRINCIPAL_FK as PRINCIPAL4_14_0_ from PFX_TANCODE tancode0_ where tancode0_.ID=?
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Tancode: select tancode0_.ID as ID0_, tancode0_.TANCODE_NR as TANCODE2_14_0_, tancode0_.DATETIME as DATETIME14_0_, tancode0_.PRINCIPAL_FK as PRINCIPAL4_14_0_ from PFX_TANCODE tancode0_ where tancode0_.ID=? for update
10:44:22,703 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Tancode: select tancode0_.ID as ID0_, tancode0_.TANCODE_NR as TANCODE2_14_0_, tancode0_.DATETIME as DATETIME14_0_, tancode0_.PRINCIPAL_FK as PRINCIPAL4_14_0_ from PFX_TANCODE tancode0_ where tancode0_.ID=? for update nowait
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Subject: select subject0_.ID as ID0_, subject0_.ISIS_VAKKODE as ISIS2_2_0_, subject0_.ADMINISTRATION_FK as ADMINIST3_2_0_ from PFX_SUBJECT subject0_ where subject0_.ID=?
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Subject: select subject0_.ID as ID0_, subject0_.ISIS_VAKKODE as ISIS2_2_0_, subject0_.ADMINISTRATION_FK as ADMINIST3_2_0_ from PFX_SUBJECT subject0_ where subject0_.ID=?
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Subject: select subject0_.ID as ID0_, subject0_.ISIS_VAKKODE as ISIS2_2_0_, subject0_.ADMINISTRATION_FK as ADMINIST3_2_0_ from PFX_SUBJECT subject0_ where subject0_.ID=? for update
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Subject: select subject0_.ID as ID0_, subject0_.ISIS_VAKKODE as ISIS2_2_0_, subject0_.ADMINISTRATION_FK as ADMINIST3_2_0_ from PFX_SUBJECT subject0_ where subject0_.ID=? for update nowait
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationCandidateViewStatusCount: select examinatio0_.id as id0_, examinatio0_.GRADED_CANDIDATE_COUNT as GRADED2_20_0_, examinatio0_.ONHOLD_CANDIDATE_COUNT as ONHOLD3_20_0_, examinatio0_.REJECTED_CANDIDATE_COUNT as REJECTED4_20_0_, examinatio0_.SIGNED_CANDIDATE_COUNT as SIGNED5_20_0_, examinatio0_.AUTHORISED_CANDIDATE_COUNT as AUTHORISED6_20_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST7_20_0_, examinatio0_.SUBJECT_CODE as SUBJECT8_20_0_, examinatio0_.EXAMINATION_DATE as EXAMINAT9_20_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINA10_20_0_ from VW_STATUS_CANDIDATE_COUNT_PFX examinatio0_ where examinatio0_.id=?
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationCandidateViewStatusCount: select examinatio0_.id as id0_, examinatio0_.GRADED_CANDIDATE_COUNT as GRADED2_20_0_, examinatio0_.ONHOLD_CANDIDATE_COUNT as ONHOLD3_20_0_, examinatio0_.REJECTED_CANDIDATE_COUNT as REJECTED4_20_0_, examinatio0_.SIGNED_CANDIDATE_COUNT as SIGNED5_20_0_, examinatio0_.AUTHORISED_CANDIDATE_COUNT as AUTHORISED6_20_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST7_20_0_, examinatio0_.SUBJECT_CODE as SUBJECT8_20_0_, examinatio0_.EXAMINATION_DATE as EXAMINAT9_20_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINA10_20_0_ from VW_STATUS_CANDIDATE_COUNT_PFX examinatio0_ where examinatio0_.id=?
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationCandidateViewStatusCount: select examinatio0_.id as id0_, examinatio0_.GRADED_CANDIDATE_COUNT as GRADED2_20_0_, examinatio0_.ONHOLD_CANDIDATE_COUNT as ONHOLD3_20_0_, examinatio0_.REJECTED_CANDIDATE_COUNT as REJECTED4_20_0_, examinatio0_.SIGNED_CANDIDATE_COUNT as SIGNED5_20_0_, examinatio0_.AUTHORISED_CANDIDATE_COUNT as AUTHORISED6_20_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST7_20_0_, examinatio0_.SUBJECT_CODE as SUBJECT8_20_0_, examinatio0_.EXAMINATION_DATE as EXAMINAT9_20_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINA10_20_0_ from VW_STATUS_CANDIDATE_COUNT_PFX examinatio0_ where examinatio0_.id=? for update
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationCandidateViewStatusCount: select examinatio0_.id as id0_, examinatio0_.GRADED_CANDIDATE_COUNT as GRADED2_20_0_, examinatio0_.ONHOLD_CANDIDATE_COUNT as ONHOLD3_20_0_, examinatio0_.REJECTED_CANDIDATE_COUNT as REJECTED4_20_0_, examinatio0_.SIGNED_CANDIDATE_COUNT as SIGNED5_20_0_, examinatio0_.AUTHORISED_CANDIDATE_COUNT as AUTHORISED6_20_0_, examinatio0_.ADMINISTRATION_CODE as ADMINIST7_20_0_, examinatio0_.SUBJECT_CODE as SUBJECT8_20_0_, examinatio0_.EXAMINATION_DATE as EXAMINAT9_20_0_, examinatio0_.EXAMINATION_NUMBER as EXAMINA10_20_0_ from VW_STATUS_CANDIDATE_COUNT_PFX examinatio0_ where examinatio0_.id=? for update nowait
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.AclEntryImpl: select aclentryim0_.ID as ID0_, aclentryim0_.ENTRY_TYPE as ENTRY2_10_0_, aclentryim0_.PRINCIPAL_FK as PRINCIPAL3_10_0_ from PFX_ACL_ENTRY aclentryim0_ where aclentryim0_.ID=?
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.AclEntryImpl: select aclentryim0_.ID as ID0_, aclentryim0_.ENTRY_TYPE as ENTRY2_10_0_, aclentryim0_.PRINCIPAL_FK as PRINCIPAL3_10_0_ from PFX_ACL_ENTRY aclentryim0_ where aclentryim0_.ID=?
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.AclEntryImpl: select aclentryim0_.ID as ID0_, aclentryim0_.ENTRY_TYPE as ENTRY2_10_0_, aclentryim0_.PRINCIPAL_FK as PRINCIPAL3_10_0_ from PFX_ACL_ENTRY aclentryim0_ where aclentryim0_.ID=? for update
10:44:22,719 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.AclEntryImpl: select aclentryim0_.ID as ID0_, aclentryim0_.ENTRY_TYPE as ENTRY2_10_0_, aclentryim0_.PRINCIPAL_FK as PRINCIPAL3_10_0_ from PFX_ACL_ENTRY aclentryim0_ where aclentryim0_.ID=? for update nowait
10:44:22,766 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzExaminationOccurrenceView: select dhzexamina0_.ID as ID0_, dhzexamina0_.EXAMINATION_DATE as EXAMINAT2_15_0_, dhzexamina0_.EXPIRATION_DATE as EXPIRATION3_15_0_, dhzexamina0_.PRINCIPAL_INITIALS as PRINCIPAL4_15_0_, dhzexamina0_.PRINCIPAL_INFIX as PRINCIPAL5_15_0_, dhzexamina0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_15_0_, dhzexamina0_.ADMINISTRATION_CODE as ADMINIST7_15_0_, dhzexamina0_.SUBJECT_CODE as SUBJECT8_15_0_, dhzexamina0_.EXAMINATION_NUMBER as EXAMINAT9_15_0_, dhzexamina0_.SUBJECT_DESCRIPTION as SUBJECT10_15_0_, dhzexamina0_.LONG_SUBJECT_NAME as LONG11_15_0_, dhzexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_15_0_, dhzexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_15_0_, dhzexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_15_0_ from VW_EXAMINATION_OCCURRENCE_DHZ dhzexamina0_ where dhzexamina0_.ID=?
10:44:22,766 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzExaminationOccurrenceView: select dhzexamina0_.ID as ID0_, dhzexamina0_.EXAMINATION_DATE as EXAMINAT2_15_0_, dhzexamina0_.EXPIRATION_DATE as EXPIRATION3_15_0_, dhzexamina0_.PRINCIPAL_INITIALS as PRINCIPAL4_15_0_, dhzexamina0_.PRINCIPAL_INFIX as PRINCIPAL5_15_0_, dhzexamina0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_15_0_, dhzexamina0_.ADMINISTRATION_CODE as ADMINIST7_15_0_, dhzexamina0_.SUBJECT_CODE as SUBJECT8_15_0_, dhzexamina0_.EXAMINATION_NUMBER as EXAMINAT9_15_0_, dhzexamina0_.SUBJECT_DESCRIPTION as SUBJECT10_15_0_, dhzexamina0_.LONG_SUBJECT_NAME as LONG11_15_0_, dhzexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_15_0_, dhzexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_15_0_, dhzexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_15_0_ from VW_EXAMINATION_OCCURRENCE_DHZ dhzexamina0_ where dhzexamina0_.ID=?
10:44:22,766 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzExaminationOccurrenceView: select dhzexamina0_.ID as ID0_, dhzexamina0_.EXAMINATION_DATE as EXAMINAT2_15_0_, dhzexamina0_.EXPIRATION_DATE as EXPIRATION3_15_0_, dhzexamina0_.PRINCIPAL_INITIALS as PRINCIPAL4_15_0_, dhzexamina0_.PRINCIPAL_INFIX as PRINCIPAL5_15_0_, dhzexamina0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_15_0_, dhzexamina0_.ADMINISTRATION_CODE as ADMINIST7_15_0_, dhzexamina0_.SUBJECT_CODE as SUBJECT8_15_0_, dhzexamina0_.EXAMINATION_NUMBER as EXAMINAT9_15_0_, dhzexamina0_.SUBJECT_DESCRIPTION as SUBJECT10_15_0_, dhzexamina0_.LONG_SUBJECT_NAME as LONG11_15_0_, dhzexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_15_0_, dhzexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_15_0_, dhzexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_15_0_ from VW_EXAMINATION_OCCURRENCE_DHZ dhzexamina0_ where dhzexamina0_.ID=? for update
10:44:22,781 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzExaminationOccurrenceView: select dhzexamina0_.ID as ID0_, dhzexamina0_.EXAMINATION_DATE as EXAMINAT2_15_0_, dhzexamina0_.EXPIRATION_DATE as EXPIRATION3_15_0_, dhzexamina0_.PRINCIPAL_INITIALS as PRINCIPAL4_15_0_, dhzexamina0_.PRINCIPAL_INFIX as PRINCIPAL5_15_0_, dhzexamina0_.PRINCIPAL_LAST_NAME as PRINCIPAL6_15_0_, dhzexamina0_.ADMINISTRATION_CODE as ADMINIST7_15_0_, dhzexamina0_.SUBJECT_CODE as SUBJECT8_15_0_, dhzexamina0_.EXAMINATION_NUMBER as EXAMINAT9_15_0_, dhzexamina0_.SUBJECT_DESCRIPTION as SUBJECT10_15_0_, dhzexamina0_.LONG_SUBJECT_NAME as LONG11_15_0_, dhzexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL12_15_0_, dhzexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL13_15_0_, dhzexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL14_15_0_ from VW_EXAMINATION_OCCURRENCE_DHZ dhzexamina0_ where dhzexamina0_.ID=? for update nowait
10:44:22,781 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PermissionImpl: select permission0_.ID as ID0_, permission0_.PERMISSION_NAME as PERMISSION2_4_0_ from PFX_PERMISSION permission0_ where permission0_.ID=?
10:44:22,781 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PermissionImpl: select permission0_.ID as ID0_, permission0_.PERMISSION_NAME as PERMISSION2_4_0_ from PFX_PERMISSION permission0_ where permission0_.ID=?
10:44:22,781 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PermissionImpl: select permission0_.ID as ID0_, permission0_.PERMISSION_NAME as PERMISSION2_4_0_ from PFX_PERMISSION permission0_ where permission0_.ID=? for update
10:44:22,781 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PermissionImpl: select permission0_.ID as ID0_, permission0_.PERMISSION_NAME as PERMISSION2_4_0_ from PFX_PERMISSION permission0_ where permission0_.ID=? for update nowait
10:44:22,781 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzExaminationCandidateView: select dhzexamina0_.ID as ID0_, dhzexamina0_.ADMINISTRATION_CODE as ADMINIST2_17_0_, dhzexamina0_.SUBJECT_CODE as SUBJECT3_17_0_, dhzexamina0_.EXAMINATION_DATE as EXAMINAT4_17_0_, dhzexamina0_.STUDENT_NUMBER as STUDENT5_17_0_, dhzexamina0_.EXAMINATION_NUMBER as EXAMINAT6_17_0_, dhzexamina0_.STUDENT_LAST_NAME as STUDENT7_17_0_, dhzexamina0_.STUDENT_INFIX as STUDENT8_17_0_, dhzexamina0_.STUDENT_INITIALS as STUDENT9_17_0_, dhzexamina0_.STUDENT_SEX as STUDENT10_17_0_, dhzexamina0_.STUDENT_ACTIVITY_CODE as STUDENT11_17_0_, dhzexamina0_.SUBJECT_DESCRIPTION as SUBJECT12_17_0_, dhzexamina0_.LONG_SUBJECT_NAME as LONG13_17_0_, dhzexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL14_17_0_, dhzexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL15_17_0_, dhzexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL16_17_0_, dhzexamina0_.RESIT as RESIT17_0_ from VW_EXAMINATION_CANDIDATE_DHZ dhzexamina0_ where dhzexamina0_.ID=?
10:44:22,781 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzExaminationCandidateView: select dhzexamina0_.ID as ID0_, dhzexamina0_.ADMINISTRATION_CODE as ADMINIST2_17_0_, dhzexamina0_.SUBJECT_CODE as SUBJECT3_17_0_, dhzexamina0_.EXAMINATION_DATE as EXAMINAT4_17_0_, dhzexamina0_.STUDENT_NUMBER as STUDENT5_17_0_, dhzexamina0_.EXAMINATION_NUMBER as EXAMINAT6_17_0_, dhzexamina0_.STUDENT_LAST_NAME as STUDENT7_17_0_, dhzexamina0_.STUDENT_INFIX as STUDENT8_17_0_, dhzexamina0_.STUDENT_INITIALS as STUDENT9_17_0_, dhzexamina0_.STUDENT_SEX as STUDENT10_17_0_, dhzexamina0_.STUDENT_ACTIVITY_CODE as STUDENT11_17_0_, dhzexamina0_.SUBJECT_DESCRIPTION as SUBJECT12_17_0_, dhzexamina0_.LONG_SUBJECT_NAME as LONG13_17_0_, dhzexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL14_17_0_, dhzexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL15_17_0_, dhzexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL16_17_0_, dhzexamina0_.RESIT as RESIT17_0_ from VW_EXAMINATION_CANDIDATE_DHZ dhzexamina0_ where dhzexamina0_.ID=?
10:44:22,781 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzExaminationCandidateView: select dhzexamina0_.ID as ID0_, dhzexamina0_.ADMINISTRATION_CODE as ADMINIST2_17_0_, dhzexamina0_.SUBJECT_CODE as SUBJECT3_17_0_, dhzexamina0_.EXAMINATION_DATE as EXAMINAT4_17_0_, dhzexamina0_.STUDENT_NUMBER as STUDENT5_17_0_, dhzexamina0_.EXAMINATION_NUMBER as EXAMINAT6_17_0_, dhzexamina0_.STUDENT_LAST_NAME as STUDENT7_17_0_, dhzexamina0_.STUDENT_INFIX as STUDENT8_17_0_, dhzexamina0_.STUDENT_INITIALS as STUDENT9_17_0_, dhzexamina0_.STUDENT_SEX as STUDENT10_17_0_, dhzexamina0_.STUDENT_ACTIVITY_CODE as STUDENT11_17_0_, dhzexamina0_.SUBJECT_DESCRIPTION as SUBJECT12_17_0_, dhzexamina0_.LONG_SUBJECT_NAME as LONG13_17_0_, dhzexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL14_17_0_, dhzexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL15_17_0_, dhzexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL16_17_0_, dhzexamina0_.RESIT as RESIT17_0_ from VW_EXAMINATION_CANDIDATE_DHZ dhzexamina0_ where dhzexamina0_.ID=? for update
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzExaminationCandidateView: select dhzexamina0_.ID as ID0_, dhzexamina0_.ADMINISTRATION_CODE as ADMINIST2_17_0_, dhzexamina0_.SUBJECT_CODE as SUBJECT3_17_0_, dhzexamina0_.EXAMINATION_DATE as EXAMINAT4_17_0_, dhzexamina0_.STUDENT_NUMBER as STUDENT5_17_0_, dhzexamina0_.EXAMINATION_NUMBER as EXAMINAT6_17_0_, dhzexamina0_.STUDENT_LAST_NAME as STUDENT7_17_0_, dhzexamina0_.STUDENT_INFIX as STUDENT8_17_0_, dhzexamina0_.STUDENT_INITIALS as STUDENT9_17_0_, dhzexamina0_.STUDENT_SEX as STUDENT10_17_0_, dhzexamina0_.STUDENT_ACTIVITY_CODE as STUDENT11_17_0_, dhzexamina0_.SUBJECT_DESCRIPTION as SUBJECT12_17_0_, dhzexamina0_.LONG_SUBJECT_NAME as LONG13_17_0_, dhzexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL14_17_0_, dhzexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL15_17_0_, dhzexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL16_17_0_, dhzexamina0_.RESIT as RESIT17_0_ from VW_EXAMINATION_CANDIDATE_DHZ dhzexamina0_ where dhzexamina0_.ID=? for update nowait
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationOccurrence: select examinatio0_.ID as ID0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT2_5_0_, examinatio0_.EXAMINATION_DATETIME as EXAMINAT3_5_0_, examinatio0_.EXPIRATION_DATETIME as EXPIRATION4_5_0_, examinatio0_.STUDYLOAD as STUDYLOAD5_0_, examinatio0_.DOCENT_FK as DOCENT6_5_0_, examinatio0_.SUBJECT_FK as SUBJECT7_5_0_ from PFX_EXAMINATION_OCCURRENCE examinatio0_ where examinatio0_.ID=?
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationOccurrence: select examinatio0_.ID as ID0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT2_5_0_, examinatio0_.EXAMINATION_DATETIME as EXAMINAT3_5_0_, examinatio0_.EXPIRATION_DATETIME as EXPIRATION4_5_0_, examinatio0_.STUDYLOAD as STUDYLOAD5_0_, examinatio0_.DOCENT_FK as DOCENT6_5_0_, examinatio0_.SUBJECT_FK as SUBJECT7_5_0_ from PFX_EXAMINATION_OCCURRENCE examinatio0_ where examinatio0_.ID=?
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationOccurrence: select examinatio0_.ID as ID0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT2_5_0_, examinatio0_.EXAMINATION_DATETIME as EXAMINAT3_5_0_, examinatio0_.EXPIRATION_DATETIME as EXPIRATION4_5_0_, examinatio0_.STUDYLOAD as STUDYLOAD5_0_, examinatio0_.DOCENT_FK as DOCENT6_5_0_, examinatio0_.SUBJECT_FK as SUBJECT7_5_0_ from PFX_EXAMINATION_OCCURRENCE examinatio0_ where examinatio0_.ID=? for update
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationOccurrence: select examinatio0_.ID as ID0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT2_5_0_, examinatio0_.EXAMINATION_DATETIME as EXAMINAT3_5_0_, examinatio0_.EXPIRATION_DATETIME as EXPIRATION4_5_0_, examinatio0_.STUDYLOAD as STUDYLOAD5_0_, examinatio0_.DOCENT_FK as DOCENT6_5_0_, examinatio0_.SUBJECT_FK as SUBJECT7_5_0_ from PFX_EXAMINATION_OCCURRENCE examinatio0_ where examinatio0_.ID=? for update nowait
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxAppMcCorrespondence: select pfxappmcco0_.ID as ID0_, pfxappmcco0_.LETTER_ID as LETTER2_26_0_, pfxappmcco0_.STUDENT_NUMBER as STUDENT3_26_0_, pfxappmcco0_.STUDENT_NAME as STUDENT4_26_0_, pfxappmcco0_.DATE_IN as DATE5_26_0_, pfxappmcco0_.FK_COMMITTEE_MEETING_ID as FK6_26_0_, pfxappmcco0_.TYPE as TYPE26_0_, pfxappmcco0_.SOURCE_FILE as SOURCE8_26_0_, pfxappmcco0_.ARCHIVE_TYPE as ARCHIVE9_26_0_, pfxappmcco0_.ARCHIVE_ID as ARCHIVE10_26_0_, pfxappmcco0_.SUBJECT as SUBJECT26_0_, pfxappmcco0_.NOTES as NOTES26_0_, pfxappmcco0_.EMAIL_SUBJECT as EMAIL13_26_0_, pfxappmcco0_.EMAIL_CONTENT as EMAIL14_26_0_, pfxappmcco0_.INSERT_DATE as INSERT15_26_0_, pfxappmcco0_.INSERT_UVANET_ID as INSERT16_26_0_, pfxappmcco0_.HANDLING_DATE as HANDLING17_26_0_, pfxappmcco0_.HANDLING_UVANET_ID as HANDLING18_26_0_ from PFX_APP_MC_CORRESPONDENCE pfxappmcco0_ where pfxappmcco0_.ID=?
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxAppMcCorrespondence: select pfxappmcco0_.ID as ID0_, pfxappmcco0_.LETTER_ID as LETTER2_26_0_, pfxappmcco0_.STUDENT_NUMBER as STUDENT3_26_0_, pfxappmcco0_.STUDENT_NAME as STUDENT4_26_0_, pfxappmcco0_.DATE_IN as DATE5_26_0_, pfxappmcco0_.FK_COMMITTEE_MEETING_ID as FK6_26_0_, pfxappmcco0_.TYPE as TYPE26_0_, pfxappmcco0_.SOURCE_FILE as SOURCE8_26_0_, pfxappmcco0_.ARCHIVE_TYPE as ARCHIVE9_26_0_, pfxappmcco0_.ARCHIVE_ID as ARCHIVE10_26_0_, pfxappmcco0_.SUBJECT as SUBJECT26_0_, pfxappmcco0_.NOTES as NOTES26_0_, pfxappmcco0_.EMAIL_SUBJECT as EMAIL13_26_0_, pfxappmcco0_.EMAIL_CONTENT as EMAIL14_26_0_, pfxappmcco0_.INSERT_DATE as INSERT15_26_0_, pfxappmcco0_.INSERT_UVANET_ID as INSERT16_26_0_, pfxappmcco0_.HANDLING_DATE as HANDLING17_26_0_, pfxappmcco0_.HANDLING_UVANET_ID as HANDLING18_26_0_ from PFX_APP_MC_CORRESPONDENCE pfxappmcco0_ where pfxappmcco0_.ID=?
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxAppMcCorrespondence: select pfxappmcco0_.ID as ID0_, pfxappmcco0_.LETTER_ID as LETTER2_26_0_, pfxappmcco0_.STUDENT_NUMBER as STUDENT3_26_0_, pfxappmcco0_.STUDENT_NAME as STUDENT4_26_0_, pfxappmcco0_.DATE_IN as DATE5_26_0_, pfxappmcco0_.FK_COMMITTEE_MEETING_ID as FK6_26_0_, pfxappmcco0_.TYPE as TYPE26_0_, pfxappmcco0_.SOURCE_FILE as SOURCE8_26_0_, pfxappmcco0_.ARCHIVE_TYPE as ARCHIVE9_26_0_, pfxappmcco0_.ARCHIVE_ID as ARCHIVE10_26_0_, pfxappmcco0_.SUBJECT as SUBJECT26_0_, pfxappmcco0_.NOTES as NOTES26_0_, pfxappmcco0_.EMAIL_SUBJECT as EMAIL13_26_0_, pfxappmcco0_.EMAIL_CONTENT as EMAIL14_26_0_, pfxappmcco0_.INSERT_DATE as INSERT15_26_0_, pfxappmcco0_.INSERT_UVANET_ID as INSERT16_26_0_, pfxappmcco0_.HANDLING_DATE as HANDLING17_26_0_, pfxappmcco0_.HANDLING_UVANET_ID as HANDLING18_26_0_ from PFX_APP_MC_CORRESPONDENCE pfxappmcco0_ where pfxappmcco0_.ID=? for update
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxAppMcCorrespondence: select pfxappmcco0_.ID as ID0_, pfxappmcco0_.LETTER_ID as LETTER2_26_0_, pfxappmcco0_.STUDENT_NUMBER as STUDENT3_26_0_, pfxappmcco0_.STUDENT_NAME as STUDENT4_26_0_, pfxappmcco0_.DATE_IN as DATE5_26_0_, pfxappmcco0_.FK_COMMITTEE_MEETING_ID as FK6_26_0_, pfxappmcco0_.TYPE as TYPE26_0_, pfxappmcco0_.SOURCE_FILE as SOURCE8_26_0_, pfxappmcco0_.ARCHIVE_TYPE as ARCHIVE9_26_0_, pfxappmcco0_.ARCHIVE_ID as ARCHIVE10_26_0_, pfxappmcco0_.SUBJECT as SUBJECT26_0_, pfxappmcco0_.NOTES as NOTES26_0_, pfxappmcco0_.EMAIL_SUBJECT as EMAIL13_26_0_, pfxappmcco0_.EMAIL_CONTENT as EMAIL14_26_0_, pfxappmcco0_.INSERT_DATE as INSERT15_26_0_, pfxappmcco0_.INSERT_UVANET_ID as INSERT16_26_0_, pfxappmcco0_.HANDLING_DATE as HANDLING17_26_0_, pfxappmcco0_.HANDLING_UVANET_ID as HANDLING18_26_0_ from PFX_APP_MC_CORRESPONDENCE pfxappmcco0_ where pfxappmcco0_.ID=? for update nowait
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzDocent: select dhzdocent0_.KODE as KODE0_, dhzdocent0_.FAC_KODE as FAC2_25_0_, dhzdocent0_.NAAM as NAAM25_0_, dhzdocent0_.ACHTERNAAM as ACHTERNAAM25_0_, dhzdocent0_.VOORVOEGSELS as VOORVOEG5_25_0_, dhzdocent0_.VOORLETTERS as VOORLETT6_25_0_, dhzdocent0_.TITELS_VOOR as TITELS7_25_0_, dhzdocent0_.TITELS_NA as TITELS8_25_0_, dhzdocent0_.INST_ISAT_KODE as INST9_25_0_, dhzdocent0_.OPL_KODE as OPL10_25_0_, dhzdocent0_.IND_TEKENBEVOEGD as IND11_25_0_, dhzdocent0_.IND_EXAMINATOR as IND12_25_0_, dhzdocent0_.IND_DOCENT as IND13_25_0_, dhzdocent0_.WERKADRES_DOCENT as WERKADRES14_25_0_, dhzdocent0_.TELEFOONNUMMER_DOCENT as TELEFOO15_25_0_, dhzdocent0_.EMAIL_ADRES_DOCENT as EMAIL16_25_0_, dhzdocent0_.IND_EINDE_DIENSTVERBAND as IND17_25_0_, dhzdocent0_.COMMENTAAR as COMMENTAAR25_0_ from DHZ_DOCENTEN dhzdocent0_ where dhzdocent0_.KODE=?
10:44:22,797 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzDocent: select dhzdocent0_.KODE as KODE0_, dhzdocent0_.FAC_KODE as FAC2_25_0_, dhzdocent0_.NAAM as NAAM25_0_, dhzdocent0_.ACHTERNAAM as ACHTERNAAM25_0_, dhzdocent0_.VOORVOEGSELS as VOORVOEG5_25_0_, dhzdocent0_.VOORLETTERS as VOORLETT6_25_0_, dhzdocent0_.TITELS_VOOR as TITELS7_25_0_, dhzdocent0_.TITELS_NA as TITELS8_25_0_, dhzdocent0_.INST_ISAT_KODE as INST9_25_0_, dhzdocent0_.OPL_KODE as OPL10_25_0_, dhzdocent0_.IND_TEKENBEVOEGD as IND11_25_0_, dhzdocent0_.IND_EXAMINATOR as IND12_25_0_, dhzdocent0_.IND_DOCENT as IND13_25_0_, dhzdocent0_.WERKADRES_DOCENT as WERKADRES14_25_0_, dhzdocent0_.TELEFOONNUMMER_DOCENT as TELEFOO15_25_0_, dhzdocent0_.EMAIL_ADRES_DOCENT as EMAIL16_25_0_, dhzdocent0_.IND_EINDE_DIENSTVERBAND as IND17_25_0_, dhzdocent0_.COMMENTAAR as COMMENTAAR25_0_ from DHZ_DOCENTEN dhzdocent0_ where dhzdocent0_.KODE=?
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzDocent: select dhzdocent0_.KODE as KODE0_, dhzdocent0_.FAC_KODE as FAC2_25_0_, dhzdocent0_.NAAM as NAAM25_0_, dhzdocent0_.ACHTERNAAM as ACHTERNAAM25_0_, dhzdocent0_.VOORVOEGSELS as VOORVOEG5_25_0_, dhzdocent0_.VOORLETTERS as VOORLETT6_25_0_, dhzdocent0_.TITELS_VOOR as TITELS7_25_0_, dhzdocent0_.TITELS_NA as TITELS8_25_0_, dhzdocent0_.INST_ISAT_KODE as INST9_25_0_, dhzdocent0_.OPL_KODE as OPL10_25_0_, dhzdocent0_.IND_TEKENBEVOEGD as IND11_25_0_, dhzdocent0_.IND_EXAMINATOR as IND12_25_0_, dhzdocent0_.IND_DOCENT as IND13_25_0_, dhzdocent0_.WERKADRES_DOCENT as WERKADRES14_25_0_, dhzdocent0_.TELEFOONNUMMER_DOCENT as TELEFOO15_25_0_, dhzdocent0_.EMAIL_ADRES_DOCENT as EMAIL16_25_0_, dhzdocent0_.IND_EINDE_DIENSTVERBAND as IND17_25_0_, dhzdocent0_.COMMENTAAR as COMMENTAAR25_0_ from DHZ_DOCENTEN dhzdocent0_ where dhzdocent0_.KODE=? for update
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzDocent: select dhzdocent0_.KODE as KODE0_, dhzdocent0_.FAC_KODE as FAC2_25_0_, dhzdocent0_.NAAM as NAAM25_0_, dhzdocent0_.ACHTERNAAM as ACHTERNAAM25_0_, dhzdocent0_.VOORVOEGSELS as VOORVOEG5_25_0_, dhzdocent0_.VOORLETTERS as VOORLETT6_25_0_, dhzdocent0_.TITELS_VOOR as TITELS7_25_0_, dhzdocent0_.TITELS_NA as TITELS8_25_0_, dhzdocent0_.INST_ISAT_KODE as INST9_25_0_, dhzdocent0_.OPL_KODE as OPL10_25_0_, dhzdocent0_.IND_TEKENBEVOEGD as IND11_25_0_, dhzdocent0_.IND_EXAMINATOR as IND12_25_0_, dhzdocent0_.IND_DOCENT as IND13_25_0_, dhzdocent0_.WERKADRES_DOCENT as WERKADRES14_25_0_, dhzdocent0_.TELEFOONNUMMER_DOCENT as TELEFOO15_25_0_, dhzdocent0_.EMAIL_ADRES_DOCENT as EMAIL16_25_0_, dhzdocent0_.IND_EINDE_DIENSTVERBAND as IND17_25_0_, dhzdocent0_.COMMENTAAR as COMMENTAAR25_0_ from DHZ_DOCENTEN dhzdocent0_ where dhzdocent0_.KODE=? for update nowait
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.VwPfxMcCorrespondence: select vwpfxmccor0_.ID as ID0_, vwpfxmccor0_.STUDENT_NUMBER as STUDENT2_23_0_, vwpfxmccor0_.LETTER_ID as LETTER3_23_0_, vwpfxmccor0_.DATE_IN as DATE4_23_0_, vwpfxmccor0_.TYPE as TYPE23_0_, vwpfxmccor0_.SOURCE_FILE as SOURCE6_23_0_, vwpfxmccor0_.ARCHIVE_TYPE as ARCHIVE7_23_0_, vwpfxmccor0_.ARCHIVE_ID as ARCHIVE8_23_0_, vwpfxmccor0_.SUBJECT as SUBJECT23_0_, vwpfxmccor0_.NOTES as NOTES23_0_, vwpfxmccor0_.EMAIL_SUBJECT as EMAIL11_23_0_, vwpfxmccor0_.EMAIL_CONTENT as EMAIL12_23_0_, vwpfxmccor0_.INSERT_UVANET_ID as INSERT13_23_0_, vwpfxmccor0_.INSERT_DATE as INSERT14_23_0_, vwpfxmccor0_.HANDLING_UVANET_ID as HANDLING15_23_0_, vwpfxmccor0_.HANDLING_DATE as HANDLING16_23_0_, vwpfxmccor0_.COMMITTEE_DATE as COMMITTEE17_23_0_ from VW_PFX_MC_CORRESPONDENCE vwpfxmccor0_ where vwpfxmccor0_.ID=?
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.VwPfxMcCorrespondence: select vwpfxmccor0_.ID as ID0_, vwpfxmccor0_.STUDENT_NUMBER as STUDENT2_23_0_, vwpfxmccor0_.LETTER_ID as LETTER3_23_0_, vwpfxmccor0_.DATE_IN as DATE4_23_0_, vwpfxmccor0_.TYPE as TYPE23_0_, vwpfxmccor0_.SOURCE_FILE as SOURCE6_23_0_, vwpfxmccor0_.ARCHIVE_TYPE as ARCHIVE7_23_0_, vwpfxmccor0_.ARCHIVE_ID as ARCHIVE8_23_0_, vwpfxmccor0_.SUBJECT as SUBJECT23_0_, vwpfxmccor0_.NOTES as NOTES23_0_, vwpfxmccor0_.EMAIL_SUBJECT as EMAIL11_23_0_, vwpfxmccor0_.EMAIL_CONTENT as EMAIL12_23_0_, vwpfxmccor0_.INSERT_UVANET_ID as INSERT13_23_0_, vwpfxmccor0_.INSERT_DATE as INSERT14_23_0_, vwpfxmccor0_.HANDLING_UVANET_ID as HANDLING15_23_0_, vwpfxmccor0_.HANDLING_DATE as HANDLING16_23_0_, vwpfxmccor0_.COMMITTEE_DATE as COMMITTEE17_23_0_ from VW_PFX_MC_CORRESPONDENCE vwpfxmccor0_ where vwpfxmccor0_.ID=?
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.VwPfxMcCorrespondence: select vwpfxmccor0_.ID as ID0_, vwpfxmccor0_.STUDENT_NUMBER as STUDENT2_23_0_, vwpfxmccor0_.LETTER_ID as LETTER3_23_0_, vwpfxmccor0_.DATE_IN as DATE4_23_0_, vwpfxmccor0_.TYPE as TYPE23_0_, vwpfxmccor0_.SOURCE_FILE as SOURCE6_23_0_, vwpfxmccor0_.ARCHIVE_TYPE as ARCHIVE7_23_0_, vwpfxmccor0_.ARCHIVE_ID as ARCHIVE8_23_0_, vwpfxmccor0_.SUBJECT as SUBJECT23_0_, vwpfxmccor0_.NOTES as NOTES23_0_, vwpfxmccor0_.EMAIL_SUBJECT as EMAIL11_23_0_, vwpfxmccor0_.EMAIL_CONTENT as EMAIL12_23_0_, vwpfxmccor0_.INSERT_UVANET_ID as INSERT13_23_0_, vwpfxmccor0_.INSERT_DATE as INSERT14_23_0_, vwpfxmccor0_.HANDLING_UVANET_ID as HANDLING15_23_0_, vwpfxmccor0_.HANDLING_DATE as HANDLING16_23_0_, vwpfxmccor0_.COMMITTEE_DATE as COMMITTEE17_23_0_ from VW_PFX_MC_CORRESPONDENCE vwpfxmccor0_ where vwpfxmccor0_.ID=? for update
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.VwPfxMcCorrespondence: select vwpfxmccor0_.ID as ID0_, vwpfxmccor0_.STUDENT_NUMBER as STUDENT2_23_0_, vwpfxmccor0_.LETTER_ID as LETTER3_23_0_, vwpfxmccor0_.DATE_IN as DATE4_23_0_, vwpfxmccor0_.TYPE as TYPE23_0_, vwpfxmccor0_.SOURCE_FILE as SOURCE6_23_0_, vwpfxmccor0_.ARCHIVE_TYPE as ARCHIVE7_23_0_, vwpfxmccor0_.ARCHIVE_ID as ARCHIVE8_23_0_, vwpfxmccor0_.SUBJECT as SUBJECT23_0_, vwpfxmccor0_.NOTES as NOTES23_0_, vwpfxmccor0_.EMAIL_SUBJECT as EMAIL11_23_0_, vwpfxmccor0_.EMAIL_CONTENT as EMAIL12_23_0_, vwpfxmccor0_.INSERT_UVANET_ID as INSERT13_23_0_, vwpfxmccor0_.INSERT_DATE as INSERT14_23_0_, vwpfxmccor0_.HANDLING_UVANET_ID as HANDLING15_23_0_, vwpfxmccor0_.HANDLING_DATE as HANDLING16_23_0_, vwpfxmccor0_.COMMITTEE_DATE as COMMITTEE17_23_0_ from VW_PFX_MC_CORRESPONDENCE vwpfxmccor0_ where vwpfxmccor0_.ID=? for update nowait
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.OwnStudentsResultView: select ownstudent0_.ID as ID0_, ownstudent0_.STUDENT_NUMBER as STUDENT2_22_0_, ownstudent0_.ADMINISTRATION_CODE as ADMINIST3_22_0_, ownstudent0_.SUBJECT_CODE as SUBJECT4_22_0_, ownstudent0_.SUBJECT_DESCRIPTION as SUBJECT5_22_0_, ownstudent0_.EXAMINATION_DATE as EXAMINAT6_22_0_, ownstudent0_.GRADE as GRADE22_0_, ownstudent0_.ADD_GEGEVEN as ADD8_22_0_, ownstudent0_.GRADE_INSERT_DATE as GRADE9_22_0_, ownstudent0_.STUDY_LOAD as STUDY10_22_0_, ownstudent0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL11_22_0_, ownstudent0_.PRINCIPAL_ISIS_CODE as PRINCIPAL12_22_0_, ownstudent0_.BEOORDELING as BEOORDE13_22_0_, ownstudent0_.ATTEMPT as ATTEMPT22_0_ from VW_OWN_STUDENTS_RESULTS_DHZ ownstudent0_ where ownstudent0_.ID=?
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.OwnStudentsResultView: select ownstudent0_.ID as ID0_, ownstudent0_.STUDENT_NUMBER as STUDENT2_22_0_, ownstudent0_.ADMINISTRATION_CODE as ADMINIST3_22_0_, ownstudent0_.SUBJECT_CODE as SUBJECT4_22_0_, ownstudent0_.SUBJECT_DESCRIPTION as SUBJECT5_22_0_, ownstudent0_.EXAMINATION_DATE as EXAMINAT6_22_0_, ownstudent0_.GRADE as GRADE22_0_, ownstudent0_.ADD_GEGEVEN as ADD8_22_0_, ownstudent0_.GRADE_INSERT_DATE as GRADE9_22_0_, ownstudent0_.STUDY_LOAD as STUDY10_22_0_, ownstudent0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL11_22_0_, ownstudent0_.PRINCIPAL_ISIS_CODE as PRINCIPAL12_22_0_, ownstudent0_.BEOORDELING as BEOORDE13_22_0_, ownstudent0_.ATTEMPT as ATTEMPT22_0_ from VW_OWN_STUDENTS_RESULTS_DHZ ownstudent0_ where ownstudent0_.ID=?
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.OwnStudentsResultView: select ownstudent0_.ID as ID0_, ownstudent0_.STUDENT_NUMBER as STUDENT2_22_0_, ownstudent0_.ADMINISTRATION_CODE as ADMINIST3_22_0_, ownstudent0_.SUBJECT_CODE as SUBJECT4_22_0_, ownstudent0_.SUBJECT_DESCRIPTION as SUBJECT5_22_0_, ownstudent0_.EXAMINATION_DATE as EXAMINAT6_22_0_, ownstudent0_.GRADE as GRADE22_0_, ownstudent0_.ADD_GEGEVEN as ADD8_22_0_, ownstudent0_.GRADE_INSERT_DATE as GRADE9_22_0_, ownstudent0_.STUDY_LOAD as STUDY10_22_0_, ownstudent0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL11_22_0_, ownstudent0_.PRINCIPAL_ISIS_CODE as PRINCIPAL12_22_0_, ownstudent0_.BEOORDELING as BEOORDE13_22_0_, ownstudent0_.ATTEMPT as ATTEMPT22_0_ from VW_OWN_STUDENTS_RESULTS_DHZ ownstudent0_ where ownstudent0_.ID=? for update
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.OwnStudentsResultView: select ownstudent0_.ID as ID0_, ownstudent0_.STUDENT_NUMBER as STUDENT2_22_0_, ownstudent0_.ADMINISTRATION_CODE as ADMINIST3_22_0_, ownstudent0_.SUBJECT_CODE as SUBJECT4_22_0_, ownstudent0_.SUBJECT_DESCRIPTION as SUBJECT5_22_0_, ownstudent0_.EXAMINATION_DATE as EXAMINAT6_22_0_, ownstudent0_.GRADE as GRADE22_0_, ownstudent0_.ADD_GEGEVEN as ADD8_22_0_, ownstudent0_.GRADE_INSERT_DATE as GRADE9_22_0_, ownstudent0_.STUDY_LOAD as STUDY10_22_0_, ownstudent0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL11_22_0_, ownstudent0_.PRINCIPAL_ISIS_CODE as PRINCIPAL12_22_0_, ownstudent0_.BEOORDELING as BEOORDE13_22_0_, ownstudent0_.ATTEMPT as ATTEMPT22_0_ from VW_OWN_STUDENTS_RESULTS_DHZ ownstudent0_ where ownstudent0_.ID=? for update nowait
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Exportbatch: select exportbatc0_.ID as ID0_, exportbatc0_.DATETIME as DATETIME9_0_, exportbatc0_.PRINCIPAL_FK as PRINCIPAL3_9_0_ from PFX_EXPORTBATCH exportbatc0_ where exportbatc0_.ID=?
10:44:22,813 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Exportbatch: select exportbatc0_.ID as ID0_, exportbatc0_.DATETIME as DATETIME9_0_, exportbatc0_.PRINCIPAL_FK as PRINCIPAL3_9_0_ from PFX_EXPORTBATCH exportbatc0_ where exportbatc0_.ID=?
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Exportbatch: select exportbatc0_.ID as ID0_, exportbatc0_.DATETIME as DATETIME9_0_, exportbatc0_.PRINCIPAL_FK as PRINCIPAL3_9_0_ from PFX_EXPORTBATCH exportbatc0_ where exportbatc0_.ID=? for update
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Exportbatch: select exportbatc0_.ID as ID0_, exportbatc0_.DATETIME as DATETIME9_0_, exportbatc0_.PRINCIPAL_FK as PRINCIPAL3_9_0_ from PFX_EXPORTBATCH exportbatc0_ where exportbatc0_.ID=? for update nowait
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Administration: select administra0_.ID as ID0_, administra0_.ISIS_ADMINKODE as ISIS2_7_0_ from PFX_ADMINISTRATION administra0_ where administra0_.ID=?
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Administration: select administra0_.ID as ID0_, administra0_.ISIS_ADMINKODE as ISIS2_7_0_ from PFX_ADMINISTRATION administra0_ where administra0_.ID=?
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Administration: select administra0_.ID as ID0_, administra0_.ISIS_ADMINKODE as ISIS2_7_0_ from PFX_ADMINISTRATION administra0_ where administra0_.ID=? for update
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Administration: select administra0_.ID as ID0_, administra0_.ISIS_ADMINKODE as ISIS2_7_0_ from PFX_ADMINISTRATION administra0_ where administra0_.ID=? for update nowait
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Signature: select signature0_.ID as ID0_, signature0_.GRADE as GRADE6_0_, signature0_.STATUS as STATUS6_0_, signature0_.TANCODE as TANCODE6_0_, signature0_.TANCODE_NR as TANCODE5_6_0_, signature0_.HASH as HASH6_0_, signature0_.DATETIME as DATETIME6_0_, signature0_.PREVIOUS_SIGNATURE_FK as PREVIOUS8_6_0_, signature0_.RESULT_FK as RESULT9_6_0_, signature0_.PRINCIPAL_FK as PRINCIPAL10_6_0_ from PFX_SIGNATURE signature0_ where signature0_.ID=?
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Signature: select signature0_.ID as ID0_, signature0_.GRADE as GRADE6_0_, signature0_.STATUS as STATUS6_0_, signature0_.TANCODE as TANCODE6_0_, signature0_.TANCODE_NR as TANCODE5_6_0_, signature0_.HASH as HASH6_0_, signature0_.DATETIME as DATETIME6_0_, signature0_.PREVIOUS_SIGNATURE_FK as PREVIOUS8_6_0_, signature0_.RESULT_FK as RESULT9_6_0_, signature0_.PRINCIPAL_FK as PRINCIPAL10_6_0_ from PFX_SIGNATURE signature0_ where signature0_.ID=?
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Signature: select signature0_.ID as ID0_, signature0_.GRADE as GRADE6_0_, signature0_.STATUS as STATUS6_0_, signature0_.TANCODE as TANCODE6_0_, signature0_.TANCODE_NR as TANCODE5_6_0_, signature0_.HASH as HASH6_0_, signature0_.DATETIME as DATETIME6_0_, signature0_.PREVIOUS_SIGNATURE_FK as PREVIOUS8_6_0_, signature0_.RESULT_FK as RESULT9_6_0_, signature0_.PRINCIPAL_FK as PRINCIPAL10_6_0_ from PFX_SIGNATURE signature0_ where signature0_.ID=? for update
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.Signature: select signature0_.ID as ID0_, signature0_.GRADE as GRADE6_0_, signature0_.STATUS as STATUS6_0_, signature0_.TANCODE as TANCODE6_0_, signature0_.TANCODE_NR as TANCODE5_6_0_, signature0_.HASH as HASH6_0_, signature0_.DATETIME as DATETIME6_0_, signature0_.PREVIOUS_SIGNATURE_FK as PREVIOUS8_6_0_, signature0_.RESULT_FK as RESULT9_6_0_, signature0_.PRINCIPAL_FK as PRINCIPAL10_6_0_ from PFX_SIGNATURE signature0_ where signature0_.ID=? for update nowait
10:44:22,828 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxExaminationCandidateView: select pfxexamina0_.ID as ID0_, pfxexamina0_.ADMINISTRATION_CODE as ADMINIST2_18_0_, pfxexamina0_.SUBJECT_CODE as SUBJECT3_18_0_, pfxexamina0_.EXAMINATION_DATE as EXAMINAT4_18_0_, pfxexamina0_.STUDENT_NUMBER as STUDENT5_18_0_, pfxexamina0_.EXAMINATION_NUMBER as EXAMINAT6_18_0_, pfxexamina0_.STUDENT_LAST_NAME as STUDENT7_18_0_, pfxexamina0_.STUDENT_INFIX as STUDENT8_18_0_, pfxexamina0_.STUDENT_INITIALS as STUDENT9_18_0_, pfxexamina0_.STUDENT_SEX as STUDENT10_18_0_, pfxexamina0_.STUDENT_ACTIVITY_CODE as STUDENT11_18_0_, pfxexamina0_.SUBJECT_DESCRIPTION as SUBJECT12_18_0_, pfxexamina0_.LONG_SUBJECT_NAME as LONG13_18_0_, pfxexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL14_18_0_, pfxexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL15_18_0_, pfxexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL16_18_0_, pfxexamina0_.GRADE as GRADE18_0_, pfxexamina0_.RESIT as RESIT18_0_, pfxexamina0_.STATUS as STATUS18_0_ from VW_EXAMINATION_CANDIDATE_PFXU pfxexamina0_ where pfxexamina0_.ID=?
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxExaminationCandidateView: select pfxexamina0_.ID as ID0_, pfxexamina0_.ADMINISTRATION_CODE as ADMINIST2_18_0_, pfxexamina0_.SUBJECT_CODE as SUBJECT3_18_0_, pfxexamina0_.EXAMINATION_DATE as EXAMINAT4_18_0_, pfxexamina0_.STUDENT_NUMBER as STUDENT5_18_0_, pfxexamina0_.EXAMINATION_NUMBER as EXAMINAT6_18_0_, pfxexamina0_.STUDENT_LAST_NAME as STUDENT7_18_0_, pfxexamina0_.STUDENT_INFIX as STUDENT8_18_0_, pfxexamina0_.STUDENT_INITIALS as STUDENT9_18_0_, pfxexamina0_.STUDENT_SEX as STUDENT10_18_0_, pfxexamina0_.STUDENT_ACTIVITY_CODE as STUDENT11_18_0_, pfxexamina0_.SUBJECT_DESCRIPTION as SUBJECT12_18_0_, pfxexamina0_.LONG_SUBJECT_NAME as LONG13_18_0_, pfxexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL14_18_0_, pfxexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL15_18_0_, pfxexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL16_18_0_, pfxexamina0_.GRADE as GRADE18_0_, pfxexamina0_.RESIT as RESIT18_0_, pfxexamina0_.STATUS as STATUS18_0_ from VW_EXAMINATION_CANDIDATE_PFXU pfxexamina0_ where pfxexamina0_.ID=?
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxExaminationCandidateView: select pfxexamina0_.ID as ID0_, pfxexamina0_.ADMINISTRATION_CODE as ADMINIST2_18_0_, pfxexamina0_.SUBJECT_CODE as SUBJECT3_18_0_, pfxexamina0_.EXAMINATION_DATE as EXAMINAT4_18_0_, pfxexamina0_.STUDENT_NUMBER as STUDENT5_18_0_, pfxexamina0_.EXAMINATION_NUMBER as EXAMINAT6_18_0_, pfxexamina0_.STUDENT_LAST_NAME as STUDENT7_18_0_, pfxexamina0_.STUDENT_INFIX as STUDENT8_18_0_, pfxexamina0_.STUDENT_INITIALS as STUDENT9_18_0_, pfxexamina0_.STUDENT_SEX as STUDENT10_18_0_, pfxexamina0_.STUDENT_ACTIVITY_CODE as STUDENT11_18_0_, pfxexamina0_.SUBJECT_DESCRIPTION as SUBJECT12_18_0_, pfxexamina0_.LONG_SUBJECT_NAME as LONG13_18_0_, pfxexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL14_18_0_, pfxexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL15_18_0_, pfxexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL16_18_0_, pfxexamina0_.GRADE as GRADE18_0_, pfxexamina0_.RESIT as RESIT18_0_, pfxexamina0_.STATUS as STATUS18_0_ from VW_EXAMINATION_CANDIDATE_PFXU pfxexamina0_ where pfxexamina0_.ID=? for update
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.PfxExaminationCandidateView: select pfxexamina0_.ID as ID0_, pfxexamina0_.ADMINISTRATION_CODE as ADMINIST2_18_0_, pfxexamina0_.SUBJECT_CODE as SUBJECT3_18_0_, pfxexamina0_.EXAMINATION_DATE as EXAMINAT4_18_0_, pfxexamina0_.STUDENT_NUMBER as STUDENT5_18_0_, pfxexamina0_.EXAMINATION_NUMBER as EXAMINAT6_18_0_, pfxexamina0_.STUDENT_LAST_NAME as STUDENT7_18_0_, pfxexamina0_.STUDENT_INFIX as STUDENT8_18_0_, pfxexamina0_.STUDENT_INITIALS as STUDENT9_18_0_, pfxexamina0_.STUDENT_SEX as STUDENT10_18_0_, pfxexamina0_.STUDENT_ACTIVITY_CODE as STUDENT11_18_0_, pfxexamina0_.SUBJECT_DESCRIPTION as SUBJECT12_18_0_, pfxexamina0_.LONG_SUBJECT_NAME as LONG13_18_0_, pfxexamina0_.PRINCIPAL_FACULTY_CODE as PRINCIPAL14_18_0_, pfxexamina0_.PRINCIPAL_ISIS_CODE as PRINCIPAL15_18_0_, pfxexamina0_.PRINCIPAL_EMAIL_ADDRESS as PRINCIPAL16_18_0_, pfxexamina0_.GRADE as GRADE18_0_, pfxexamina0_.RESIT as RESIT18_0_, pfxexamina0_.STATUS as STATUS18_0_ from VW_EXAMINATION_CANDIDATE_PFXU pfxexamina0_ where pfxexamina0_.ID=? for update nowait
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.AclImpl: select aclimpl0_.ID as ID0_, aclimpl0_.ACL_NAME as ACL2_12_0_ from PFX_ACL aclimpl0_ where aclimpl0_.ID=?
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.AclImpl: select aclimpl0_.ID as ID0_, aclimpl0_.ACL_NAME as ACL2_12_0_ from PFX_ACL aclimpl0_ where aclimpl0_.ID=?
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.AclImpl: select aclimpl0_.ID as ID0_, aclimpl0_.ACL_NAME as ACL2_12_0_ from PFX_ACL aclimpl0_ where aclimpl0_.ID=? for update
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.AclImpl: select aclimpl0_.ID as ID0_, aclimpl0_.ACL_NAME as ACL2_12_0_ from PFX_ACL aclimpl0_ where aclimpl0_.ID=? for update nowait
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzAdministratie: select dhzadminis0_.KODE as KODE0_, dhzadminis0_.OMSCHRIJVING as OMSCHRIJ2_24_0_, dhzadminis0_.CLU_KODE as CLU3_24_0_, dhzadminis0_.NAAM_CONTACTPERSOON as NAAM4_24_0_, dhzadminis0_.ADRES as ADRES24_0_, dhzadminis0_.TELEFOONNUMMER as TELEFOON6_24_0_, dhzadminis0_.INDICATIE_HOOFDADM as INDICATIE7_24_0_ from DHZ_ADMINISTRATIES dhzadminis0_ where dhzadminis0_.KODE=?
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzAdministratie: select dhzadminis0_.KODE as KODE0_, dhzadminis0_.OMSCHRIJVING as OMSCHRIJ2_24_0_, dhzadminis0_.CLU_KODE as CLU3_24_0_, dhzadminis0_.NAAM_CONTACTPERSOON as NAAM4_24_0_, dhzadminis0_.ADRES as ADRES24_0_, dhzadminis0_.TELEFOONNUMMER as TELEFOON6_24_0_, dhzadminis0_.INDICATIE_HOOFDADM as INDICATIE7_24_0_ from DHZ_ADMINISTRATIES dhzadminis0_ where dhzadminis0_.KODE=?
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzAdministratie: select dhzadminis0_.KODE as KODE0_, dhzadminis0_.OMSCHRIJVING as OMSCHRIJ2_24_0_, dhzadminis0_.CLU_KODE as CLU3_24_0_, dhzadminis0_.NAAM_CONTACTPERSOON as NAAM4_24_0_, dhzadminis0_.ADRES as ADRES24_0_, dhzadminis0_.TELEFOONNUMMER as TELEFOON6_24_0_, dhzadminis0_.INDICATIE_HOOFDADM as INDICATIE7_24_0_ from DHZ_ADMINISTRATIES dhzadminis0_ where dhzadminis0_.KODE=? for update
10:44:22,844 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.DhzAdministratie: select dhzadminis0_.KODE as KODE0_, dhzadminis0_.OMSCHRIJVING as OMSCHRIJ2_24_0_, dhzadminis0_.CLU_KODE as CLU3_24_0_, dhzadminis0_.NAAM_CONTACTPERSOON as NAAM4_24_0_, dhzadminis0_.ADRES as ADRES24_0_, dhzadminis0_.TELEFOONNUMMER as TELEFOON6_24_0_, dhzadminis0_.INDICATIE_HOOFDADM as INDICATIE7_24_0_ from DHZ_ADMINISTRATIES dhzadminis0_ where dhzadminis0_.KODE=? for update nowait
10:44:22,860 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationResult: select examinatio0_.ID as ID0_, examinatio0_.ORIGIN as ORIGIN3_0_, examinatio0_.RESIT as RESIT3_0_, examinatio0_.SIGNATURE_FK as SIGNATURE4_3_0_, examinatio0_.EXPORT_FK as EXPORT5_3_0_, examinatio0_.STUDENT_FK as STUDENT6_3_0_, examinatio0_.OCCURRENCE_FK as OCCURRENCE7_3_0_ from PFX_EXAMINATION_RESULT examinatio0_ where examinatio0_.ID=?
10:44:22,860 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationResult: select examinatio0_.ID as ID0_, examinatio0_.ORIGIN as ORIGIN3_0_, examinatio0_.RESIT as RESIT3_0_, examinatio0_.SIGNATURE_FK as SIGNATURE4_3_0_, examinatio0_.EXPORT_FK as EXPORT5_3_0_, examinatio0_.STUDENT_FK as STUDENT6_3_0_, examinatio0_.OCCURRENCE_FK as OCCURRENCE7_3_0_ from PFX_EXAMINATION_RESULT examinatio0_ where examinatio0_.ID=?
10:44:22,860 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationResult: select examinatio0_.ID as ID0_, examinatio0_.ORIGIN as ORIGIN3_0_, examinatio0_.RESIT as RESIT3_0_, examinatio0_.SIGNATURE_FK as SIGNATURE4_3_0_, examinatio0_.EXPORT_FK as EXPORT5_3_0_, examinatio0_.STUDENT_FK as STUDENT6_3_0_, examinatio0_.OCCURRENCE_FK as OCCURRENCE7_3_0_ from PFX_EXAMINATION_RESULT examinatio0_ where examinatio0_.ID=? for update
10:44:22,860 DEBUG EntityLoader:95 - Static select for entity nl.uva.hum.hibernate.persistent.ExaminationResult: select examinatio0_.ID as ID0_, examinatio0_.ORIGIN as ORIGIN3_0_, examinatio0_.RESIT as RESIT3_0_, examinatio0_.SIGNATURE_FK as SIGNATURE4_3_0_, examinatio0_.EXPORT_FK as EXPORT5_3_0_, examinatio0_.STUDENT_FK as STUDENT6_3_0_, examinatio0_.OCCURRENCE_FK as OCCURRENCE7_3_0_ from PFX_EXAMINATION_RESULT examinatio0_ where examinatio0_.ID=? for update nowait
10:44:22,860 DEBUG OneToManyLoader:106 - Static select for one-to-many nl.uva.hum.hibernate.persistent.Subject.examinationOccurrences: select examinatio0_.SUBJECT_FK as SUBJECT7_1_, examinatio0_.ID as ID1_, examinatio0_.ID as ID0_, examinatio0_.EXAMINATION_NUMBER as EXAMINAT2_5_0_, examinatio0_.EXAMINATION_DATETIME as EXAMINAT3_5_0_, examinatio0_.EXPIRATION_DATETIME as EXPIRATION4_5_0_, examinatio0_.STUDYLOAD as STUDYLOAD5_0_, examinatio0_.DOCENT_FK as DOCENT6_5_0_, examinatio0_.SUBJECT_FK as SUBJECT7_5_0_ from PFX_EXAMINATION_OCCURRENCE examinatio0_ where examinatio0_.SUBJECT_FK=?
10:44:22,860 DEBUG OneToManyLoader:106 - Static select for one-to-many nl.uva.hum.hibernate.persistent.ExaminationOccurrence.examinationResults: select examinatio0_.OCCURRENCE_FK as OCCURRENCE7_1_, examinatio0_.ID as ID1_, examinatio0_.ID as ID0_, examinatio0_.ORIGIN as ORIGIN3_0_, examinatio0_.RESIT as RESIT3_0_, examinatio0_.SIGNATURE_FK as SIGNATURE4_3_0_, examinatio0_.EXPORT_FK as EXPORT5_3_0_, examinatio0_.STUDENT_FK as STUDENT6_3_0_, examinatio0_.OCCURRENCE_FK as OCCURRENCE7_3_0_ from PFX_EXAMINATION_RESULT examinatio0_ where examinatio0_.OCCURRENCE_FK=?
10:44:22,860 DEBUG OneToManyLoader:106 - Static select for one-to-many nl.uva.hum.hibernate.persistent.Administration.subjects: select subjects0_.ADMINISTRATION_FK as ADMINIST3_1_, subjects0_.ID as ID1_, subjects0_.ID as ID0_, subjects0_.ISIS_VAKKODE as ISIS2_2_0_, subjects0_.ADMINISTRATION_FK as ADMINIST3_2_0_ from PFX_SUBJECT subjects0_ where subjects0_.ADMINISTRATION_FK=?
10:44:22,922 DEBUG CollectionLoader:94 - Static select for collection nl.uva.hum.hibernate.persistent.AclImpl.entries: select entries0_.ACL_FK as ACL1_1_, entries0_.ACL_ENTRY_FK as ACL2_1_, aclentryim1_.ID as ID0_, aclentryim1_.ENTRY_TYPE as ENTRY2_10_0_, aclentryim1_.PRINCIPAL_FK as PRINCIPAL3_10_0_ from PFX_ATBL_ACL_ENTRIES entries0_ inner join PFX_ACL_ENTRY aclentryim1_ on entries0_.ACL_ENTRY_FK=aclentryim1_.ID where entries0_.ACL_FK=?
10:44:22,922 DEBUG OneToManyLoader:106 - Static select for one-to-many nl.uva.hum.hibernate.persistent.PrincipalImpl.signatures: select signatures0_.PRINCIPAL_FK as PRINCIPAL10_1_, signatures0_.ID as ID1_, signatures0_.ID as ID0_, signatures0_.GRADE as GRADE6_0_, signatures0_.STATUS as STATUS6_0_, signatures0_.TANCODE as TANCODE6_0_, signatures0_.TANCODE_NR as TANCODE5_6_0_, signatures0_.HASH as HASH6_0_, signatures0_.DATETIME as DATETIME6_0_, signatures0_.PREVIOUS_SIGNATURE_FK as PREVIOUS8_6_0_, signatures0_.RESULT_FK as RESULT9_6_0_, signatures0_.PRINCIPAL_FK as PRINCIPAL10_6_0_ from PFX_SIGNATURE signatures0_ where signatures0_.PRINCIPAL_FK=?
10:44:22,922 DEBUG OneToManyLoader:106 - Static select for one-to-many nl.uva.hum.hibernate.persistent.ExaminationResult.signatures: select signatures0_.RESULT_FK as RESULT9_1_, signatures0_.ID as ID1_, signatures0_.ID as ID0_, signatures0_.GRADE as GRADE6_0_, signatures0_.STATUS as STATUS6_0_, signatures0_.TANCODE as TANCODE6_0_, signatures0_.TANCODE_NR as TANCODE5_6_0_, signatures0_.HASH as HASH6_0_, signatures0_.DATETIME as DATETIME6_0_, signatures0_.PREVIOUS_SIGNATURE_FK as PREVIOUS8_6_0_, signatures0_.RESULT_FK as RESULT9_6_0_, signatures0_.PRINCIPAL_FK as PRINCIPAL10_6_0_ from PFX_SIGNATURE signatures0_ where signatures0_.RESULT_FK=?
10:44:22,938 DEBUG CollectionLoader:94 - Static select for collection nl.uva.hum.hibernate.persistent.PrincipalImpl.members: select members0_.PARENT_FK as PARENT1_1_, members0_.CHILD_FK as CHILD2_1_, principali1_.ID as ID0_, principali1_.TYPE as TYPE0_0_, principali1_.NAME as NAME0_0_, principali1_.DSN_KEY as DSN4_0_0_, principali1_.PASSWORD as PASSWORD0_0_, principali1_.METADATA as METADATA0_0_, principali1_.CREATION_DATETIME as CREATION7_0_0_, principali1_.EXPIRED_DATETIME as EXPIRED8_0_0_, principali1_.PROFILE_FK as PROFILE9_0_0_, principali1_.TYPE as TYPE0_ from PFX_ATBL_PRINCIPAL_PRINCIPAL members0_ inner join PFX_PRINCIPAL principali1_ on members0_.CHILD_FK=principali1_.ID where members0_.PARENT_FK=?
10:44:22,953 DEBUG CollectionLoader:94 - Static select for collection nl.uva.hum.hibernate.persistent.AclEntryImpl.permissions: select permission0_.ACL_ENTRY_FK as ACL1_1_, permission0_.PERMISSION_FK as PERMISSION2_1_, permission1_.ID as ID0_, permission1_.PERMISSION_NAME as PERMISSION2_4_0_ from PFX_ATBL_ACL_PERMISSIONS permission0_ inner join PFX_PERMISSION permission1_ on permission0_.PERMISSION_FK=permission1_.ID where permission0_.ACL_ENTRY_FK=?
10:44:22,953 DEBUG CollectionLoader:94 - Static select for collection nl.uva.hum.hibernate.persistent.PrincipalImpl.membership: select membership0_.CHILD_FK as CHILD2_1_, membership0_.PARENT_FK as PARENT1_1_, principali1_.ID as ID0_, principali1_.TYPE as TYPE0_0_, principali1_.NAME as NAME0_0_, principali1_.DSN_KEY as DSN4_0_0_, principali1_.PASSWORD as PASSWORD0_0_, principali1_.METADATA as METADATA0_0_, principali1_.CREATION_DATETIME as CREATION7_0_0_, principali1_.EXPIRED_DATETIME as EXPIRED8_0_0_, principali1_.PROFILE_FK as PROFILE9_0_0_, principali1_.TYPE as TYPE0_ from PFX_ATBL_PRINCIPAL_PRINCIPAL membership0_ inner join PFX_PRINCIPAL principali1_ on membership0_.PARENT_FK=principali1_.ID where membership0_.CHILD_FK=?
10:44:22,953 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
10:44:22,953 DEBUG SessionFactoryObjectFactory:76 - registered: 11926e2e05be75df0105be75ea290000 (unnamed)
10:44:22,953 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
10:44:22,953 DEBUG SessionFactoryImpl:262 - instantiated session factory
10:44:22,953 INFO SessionFactoryImpl:379 - Checking 0 named queries
10:44:23,000 DEBUG SessionImpl:250 - opened session at timestamp: 4604648910655488
10:44:23,016 DEBUG SessionImpl:829 - find: from Administration where ISIS_ADMINKODE = :administrationCode
10:44:23,016 DEBUG QueryParameters:224 - named parameters: {administrationCode=OKCA}
10:44:23,078 DEBUG QueryTranslatorImpl:207 - parse() - HQL: from nl.uva.hum.hibernate.persistent.Administration where ISIS_ADMINKODE = :administrationCode
10:44:23,110 DEBUG AST:223 - --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| \-[FROM] 'from'
| \-[RANGE] 'RANGE'
| \-[DOT] '.'
| +-[DOT] '.'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[IDENT] 'nl'
| | | | | \-[IDENT] 'uva'
| | | | \-[IDENT] 'hum'
| | | \-[IDENT] 'hibernate'
| | \-[IDENT] 'persistent'
| \-[IDENT] 'Administration'
\-[WHERE] 'where'
\-[EQ] '='
+-[IDENT] 'ISIS_ADMINKODE'
\-[COLON] ':'
\-[IDENT] 'administrationCode'

10:44:23,110 DEBUG ErrorCounter:72 - throwQueryException() : no errors
10:44:23,156 DEBUG HqlSqlBaseWalker:120 - query() << begin, level = 1
10:44:23,188 DEBUG FromElement:88 - FromClause{level=1} : nl.uva.hum.hibernate.persistent.Administration (no alias) -> administra0_
10:44:23,188 DEBUG HqlSqlBaseWalker:125 - query() : finishing up , level = 1
10:44:23,188 DEBUG HqlSqlWalker:331 - processQuery() : ( SELECT ( FromClause{level=1} PFX_ADMINISTRATION administra0_ ) ( where ( = ISIS_ADMINKODE ? ) ) )
10:44:23,203 DEBUG HqlSqlWalker:451 - Derived SELECT clause created.
10:44:23,203 DEBUG JoinProcessor:112 - Using FROM fragment [PFX_ADMINISTRATION administra0_]
10:44:23,203 DEBUG HqlSqlBaseWalker:128 - query() >> end, level = 1
10:44:23,219 DEBUG AST:193 - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (PFX_ADMINISTRATION)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'administra0_.ID as ID' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=PFX_ADMINISTRATION,tableAlias=administra0_,colums={,className=nl.uva.hum.hibernate.persistent.Administration}}}
| \-[SQL_TOKEN] SqlFragment: 'administra0_.ISIS_ADMINKODE as ISIS2_7_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[], fromElementByTableAlias=[administra0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'PFX_ADMINISTRATION administra0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=PFX_ADMINISTRATION,tableAlias=administra0_,colums={,className=nl.uva.hum.hibernate.persistent.Administration}}
\-[WHERE] SqlNode: 'where'
\-[EQ] SqlNode: '='
+-[IDENT] IdentNode: 'ISIS_ADMINKODE' {originalText=ISIS_ADMINKODE}
\-[NAMED_PARAM] SqlNode: '?'

10:44:23,219 DEBUG ErrorCounter:72 - throwQueryException() : no errors
10:44:23,235 DEBUG QueryTranslatorImpl:177 - HQL: from nl.uva.hum.hibernate.persistent.Administration where ISIS_ADMINKODE = :administrationCode
10:44:23,235 DEBUG QueryTranslatorImpl:178 - SQL: select administra0_.ID as ID, administra0_.ISIS_ADMINKODE as ISIS2_7_ from PFX_ADMINISTRATION administra0_ where ISIS_ADMINKODE=?
10:44:23,235 DEBUG ErrorCounter:72 - throwQueryException() : no errors
10:44:23,235 DEBUG AbstractBatcher:290 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
10:44:23,250 DEBUG ConnectionManager:296 - opening JDBC connection
10:44:23,250 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
10:44:23,250 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
10:44:23,250 DEBUG SQL:324 - select administra0_.ID as ID, administra0_.ISIS_ADMINKODE as ISIS2_7_ from PFX_ADMINISTRATION administra0_ where ISIS_ADMINKODE=?
Hibernate: select administra0_.ID as ID, administra0_.ISIS_ADMINKODE as ISIS2_7_ from PFX_ADMINISTRATION administra0_ where ISIS_ADMINKODE=?
10:44:23,250 DEBUG AbstractBatcher:378 - preparing statement
10:44:23,281 DEBUG QueryLoader:260 - bindNamedParameters() OKCA -> administrationCode [1]
10:44:23,281 DEBUG AbstractBatcher:306 - about to open ResultSet (open ResultSets: 0, globally: 0)
10:44:23,281 DEBUG Loader:405 - processing result set
10:44:23,281 DEBUG Loader:410 - result set row: 0
10:44:23,313 DEBUG Loader:828 - result row: EntityKey[nl.uva.hum.hibernate.persistent.Administration#3]
10:44:23,328 DEBUG Loader:978 - Initializing object from ResultSet: [nl.uva.hum.hibernate.persistent.Administration#3]
10:44:23,328 DEBUG BasicEntityPersister:1651 - Hydrating entity: [nl.uva.hum.hibernate.persistent.Administration#3]
10:44:23,328 DEBUG Loader:429 - done processing result set (1 rows)
10:44:23,344 DEBUG AbstractBatcher:313 - about to close ResultSet (open ResultSets: 1, globally: 1)
10:44:23,344 DEBUG AbstractBatcher:298 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
10:44:23,344 DEBUG AbstractBatcher:416 - closing statement
10:44:23,344 DEBUG Loader:528 - total objects hydrated: 1
10:44:23,344 DEBUG TwoPhaseLoad:96 - resolving associations for [nl.uva.hum.hibernate.persistent.Administration#3]
10:44:23,344 DEBUG CollectionLoadContext:141 - creating collection wrapper:[nl.uva.hum.hibernate.persistent.Administration.subjects#3]
10:44:23,360 DEBUG TwoPhaseLoad:167 - done materializing entity [nl.uva.hum.hibernate.persistent.Administration#3]
10:44:23,360 DEBUG PersistenceContext:789 - initializing non-lazy collections
10:44:23,375 DEBUG DefaultInitializeCollectionEventListener:42 - initializing collection [nl.uva.hum.hibernate.persistent.Administration.subjects#3]
10:44:23,375 DEBUG DefaultInitializeCollectionEventListener:47 - checkin


Top
 Profile  
 
 Post subject: Problem Solved
PostPosted: Tue Aug 16, 2005 7:09 am 
Newbie

Joined: Mon Aug 15, 2005 6:57 am
Posts: 7
Problem has been solved; somewhere in the code, there was an explicit session.close() statement that ruined everything.

Thanx for the questions anyway.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.