We have an extensive object graph consisting of a User Object, Credited Achievements and Achievement records. We are saving the User object on the http Session. When we obtain the User object from the http Session and "reattach" using lock(object, LockMode.READ) all Achievement records associated with the User object are being updated (version number increased only) even though no data has been changed between http requests. Can you please review our mapping files and let me know what may be the source of this problem? Thanks in advance.

Hibernate version: 3.1

Mapping documents: find at end of posting

Code between sessionFactory.openSession() and session.close():



Full stack trace of any exception that occurs:

Name and version of the database you are using:

RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

JDBC driver: Oracle JDBC driver, version: 10.1.0.4.2

Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)


The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

[quote]2006-11-20 15:23:39,755 INFO (org.hibernate.cfg.HbmBinder:2276) - Mapping collection: gov.llnl.eit.stats.model.User.creditedLeadershipPositions -> CREDITED_ACHIEVEMENTS
2006-11-20 15:23:39,755 INFO (org.hibernate.cfg.HbmBinder:2276) - Mapping collection: gov.llnl.eit.stats.model.User.creditedOtherLeadershipServices -> CREDITED_ACHIEVEMENTS
2006-11-20 15:23:39,755 INFO (org.hibernate.cfg.HbmBinder:2276) - Mapping collection: gov.llnl.eit.stats.model.User.creditedLlnlReports -> CREDITED_ACHIEVEMENTS
2006-11-20 15:23:39,755 INFO (org.hibernate.cfg.HbmBinder:2276) - Mapping collection: gov.llnl.eit.stats.model.User.creditedPatentsCopyrights -> CREDITED_ACHIEVEMENTS
2006-11-20 15:23:39,755 INFO (org.hibernate.cfg.HbmBinder:2276) - Mapping collection: gov.llnl.eit.stats.model.User.creditedParticipationAdvisoryPeerCapacity -> CREDITED_ACHIEVEMENTS
2006-11-20 15:23:39,755 INFO (org.hibernate.cfg.HbmBinder:2276) - Mapping collection: gov.llnl.eit.stats.model.User.creditedConfWorkshopsOrg -> CREDITED_ACHIEVEMENTS
2006-11-20 15:23:39,755 INFO (org.hibernate.cfg.HbmBinder:2276) - Mapping collection: gov.llnl.eit.stats.model.User.creditedHighlights -> CREDITED_ACHIEVEMENTS
2006-11-20 15:23:39,771 INFO (org.hibernate.cfg.Configuration:1035) - processing association property references
2006-11-20 15:23:39,771 INFO (org.hibernate.cfg.Configuration:1057) - processing foreign key constraints
2006-11-20 15:23:40,302 INFO (org.hibernate.util.NamingHelper:26) - JNDI InitialContext properties:{}
2006-11-20 15:23:40,302 INFO (org.hibernate.connection.DatasourceConnectionProvider:61) - Using datasource: jdbc/StatsDS
2006-11-20 15:23:40,364 INFO (org.hibernate.cfg.SettingsFactory:77) - RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
2006-11-20 15:23:40,364 INFO (org.hibernate.cfg.SettingsFactory:78) - JDBC driver: Oracle JDBC driver, version: 10.1.0.4.2
2006-11-20 15:23:40,411 INFO (org.hibernate.dialect.Dialect:103) - Using dialect: org.hibernate.dialect.Oracle9Dialect
2006-11-20 15:23:40,442 INFO (org.hibernate.transaction.TransactionFactoryFactory:31) - Using default transaction strategy (direct JDBC transactions)
2006-11-20 15:23:40,458 INFO (org.hibernate.transaction.TransactionManagerLookupFactory:33) - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:125) - Automatic flush during beforeCompletion(): disabled
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:129) - Automatic session close at end of transaction: disabled
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:136) - JDBC batch size: 15
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:139) - JDBC batch updates for versioned data: disabled
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:144) - Scrollable result sets: enabled
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:152) - JDBC3 getGeneratedKeys(): disabled
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:160) - Connection release mode: auto
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:187) - Default batch fetch size: 1
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:191) - Generate SQL with comments: disabled
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:195) - Order SQL updates by primary key: disabled
2006-11-20 15:23:40,458 INFO (org.hibernate.cfg.SettingsFactory:338) - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2006-11-20 15:23:40,474 INFO (org.hibernate.hql.ast.ASTQueryTranslatorFactory:21) - Using ASTQueryTranslatorFactory
2006-11-20 15:23:40,474 INFO (org.hibernate.cfg.SettingsFactory:203) - Query language substitutions: {}
2006-11-20 15:23:40,474 INFO (org.hibernate.cfg.SettingsFactory:209) - Second-level cache: enabled
2006-11-20 15:23:40,474 INFO (org.hibernate.cfg.SettingsFactory:213) - Query cache: disabled
2006-11-20 15:23:40,474 INFO (org.hibernate.cfg.SettingsFactory:325) - Cache provider: org.hibernate.cache.NoCacheProvider
2006-11-20 15:23:40,474 INFO (org.hibernate.cfg.SettingsFactory:228) - Optimize cache for minimal puts: disabled
2006-11-20 15:23:40,474 INFO (org.hibernate.cfg.SettingsFactory:237) - Structured second-level cache entries: disabled
2006-11-20 15:23:40,489 INFO (org.hibernate.cfg.SettingsFactory:264) - Statistics: disabled
2006-11-20 15:23:40,489 INFO (org.hibernate.cfg.SettingsFactory:268) - Deleted entity synthetic identifier rollback: disabled
2006-11-20 15:23:40,489 INFO (org.hibernate.cfg.SettingsFactory:283) - Default entity-mode: pojo
2006-11-20 15:23:40,552 INFO (org.hibernate.impl.SessionFactoryImpl:153) - building session factory
2006-11-20 15:23:46,552 INFO (org.hibernate.impl.SessionFactoryObjectFactory:82) - Not binding factory to JNDI, no JNDI name configured
2006-11-20 15:23:46,567 INFO (org.hibernate.impl.SessionFactoryImpl:353) - Checking 0 named HQL queries
2006-11-20 15:23:46,567 INFO (org.hibernate.impl.SessionFactoryImpl:373) - Checking 0 named SQL queries
2006-11-20 15:23:46,614 DEBUG (gov.llnl.eit.stats.util.hibernate.HibernateUtil:48) - New Hibernate Session has been opened.
2006-11-20 15:23:46,630 DEBUG (gov.llnl.eit.stats.util.hibernate.HibernateUtil:81) - begin Hibernate transaction
2006-11-20 15:23:46,630 DEBUG (gov.llnl.eit.stats.util.hibernate.HibernateUtil:50) - Get existing Hibernate Session.
2006-11-20 15:23:46,989 DEBUG (org.hibernate.SQL:346) - select user0_.USER_ID as USER1_10_, user0_.VERSION as VERSION10_, user0_.oun as oun10_, user0_.PER_ID_NO as PER4_10_, user0_.FIRST_NAME as FIRST5_10_, user0_.MIDDLE_INITIAL as MIDDLE6_10_, user0_.LAST_NAME as LAST7_10_, user0_.AUTHOR_FLAG as AUTHOR8_10_, user0_.TERMINATION_DATE as TERMINAT9_10_, user0_.LAST_LOGIN_DATE as LAST10_10_, user0_.ACHIEVEMENT_UPDATE_DATE as ACHIEVE11_10_, user0_.ISI_DOWNLOAD_FLAG as ISI12_10_, user0_.PAYROLL_ID as PAYROLL13_10_, user0_.GROUP_ID as GROUP14_10_ from USERS user0_ where user0_.oun=?
2006-11-20 15:23:47,021 DEBUG (org.hibernate.SQL:346) - select payroll0_.PAYROLL_ID as PAYROLL1_6_0_, payroll0_.VERSION as VERSION6_0_, payroll0_.ACCOUNT_NUMBER as ACCOUNT3_6_0_, payroll0_.DIVISION_ID as DIVISION4_6_0_, payroll0_.START_DATE as START5_6_0_, payroll0_.END_DATE as END6_6_0_ from PAYROLLS payroll0_ where payroll0_.PAYROLL_ID=?
2006-11-20 15:23:47,036 DEBUG (org.hibernate.SQL:346) - select division0_.ORGANIZATION_ID as ORGANIZA1_5_0_, division0_.VERSION as VERSION5_0_, division0_.name as name5_0_, division0_.abbreviation as abbrevia5_5_0_, division0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS division0_ where division0_.ORGANIZATION_ID=? and division0_.ORGANIZATION_TYPE='DIV'
2006-11-20 15:23:47,052 DEBUG (org.hibernate.SQL:346) - select department0_.ORGANIZATION_ID as ORGANIZA1_5_0_, department0_.VERSION as VERSION5_0_, department0_.name as name5_0_, department0_.abbreviation as abbrevia5_5_0_, department0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS department0_ where department0_.ORGANIZATION_ID=? and department0_.ORGANIZATION_TYPE='DEPT'
2006-11-20 15:23:47,067 DEBUG (org.hibernate.SQL:346) - select directorat0_.ORGANIZATION_ID as ORGANIZA1_5_0_, directorat0_.VERSION as VERSION5_0_, directorat0_.name as name5_0_, directorat0_.abbreviation as abbrevia5_5_0_ from ORGANIZATIONS directorat0_ where directorat0_.ORGANIZATION_ID=? and directorat0_.ORGANIZATION_TYPE='DIR'
2006-11-20 15:23:47,130 DEBUG (org.hibernate.SQL:346) - select creditedac0_.AUTHOR_ID as AUTHOR4_1_, creditedac0_.CREDITED_ACHIEVEMENT_ID as CREDITED1_1_, creditedac0_.CREDITED_ACHIEVEMENT_ID as CREDITED1_4_0_, creditedac0_.version as version4_0_, creditedac0_.AUTHOR_ID as AUTHOR4_4_0_, creditedac0_.AUTHOR_PAYROLL_ID as AUTHOR5_4_0_, creditedac0_.APPROVER_ID as APPROVER6_4_0_, creditedac0_.APPROVE_DATE as APPROVE7_4_0_, creditedac0_.AUTHOR_REVIEWED_FLAG as AUTHOR8_4_0_, creditedac0_.ACHIEVEMENT_ID as ACHIEVEM9_4_0_, creditedac0_.DELETED_FLAG as DELETED10_4_0_, creditedac0_.FIRST_AUTHOR_FLAG as FIRST11_4_0_, creditedac0_.TYPE as TYPE4_0_ from CREDITED_ACHIEVEMENTS creditedac0_ where creditedac0_.DELETED_FLAG = 'N' and creditedac0_.AUTHOR_ID=?
2006-11-20 15:23:48,505 DEBUG (org.hibernate.SQL:346) - select education0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, education0_.version as version0_0_, education0_.CREATE_DATE as CREATE4_0_0_, education0_.MODIFY_DATE as MODIFY5_0_0_, education0_.LOCK_FLAG as LOCK6_0_0_, education0_.ORPHAN_FLAG as ORPHAN7_0_0_, education0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, education0_.MIGRATION_ID as MIGRATION9_0_0_, education0_.CREATOR_ID as CREATOR10_0_0_, education0_.MODIFIER_ID as MODIFIER11_0_0_, education0_.university as university0_0_, education0_.city as city0_0_, education0_.state as state0_0_, education0_.country_id as country38_0_0_, education0_.START_DATE_TYP as START43_0_0_, education0_.END_DATE_TYP as END44_0_0_, education0_.degree as degree0_0_, education0_.DEGREE_DATE_TYP as DEGREE46_0_0_, education0_.thesis as thesis0_0_ from ACHIEVEMENTS education0_ where education0_.ACHIEVEMENT_ID=? and education0_.TYPE='Education'
2006-11-20 15:23:48,567 DEBUG (org.hibernate.SQL:346) - select workhistor0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, workhistor0_.version as version0_0_, workhistor0_.CREATE_DATE as CREATE4_0_0_, workhistor0_.MODIFY_DATE as MODIFY5_0_0_, workhistor0_.LOCK_FLAG as LOCK6_0_0_, workhistor0_.ORPHAN_FLAG as ORPHAN7_0_0_, workhistor0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, workhistor0_.MIGRATION_ID as MIGRATION9_0_0_, workhistor0_.CREATOR_ID as CREATOR10_0_0_, workhistor0_.MODIFIER_ID as MODIFIER11_0_0_, workhistor0_.NAME as NAME0_0_, workhistor0_.city as city0_0_, workhistor0_.state as state0_0_, workhistor0_.country_id as country38_0_0_, workhistor0_.JOB_TITLE as JOB48_0_0_, workhistor0_.START_DATE_TYP as START43_0_0_, workhistor0_.END_DATE_TYP as END44_0_0_ from ACHIEVEMENTS workhistor0_ where workhistor0_.ACHIEVEMENT_ID=? and workhistor0_.TYPE='WorkHistory'
2006-11-20 15:23:48,583 DEBUG (org.hibernate.SQL:346) - select nationalac0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, nationalac0_.version as version0_0_, nationalac0_.CREATE_DATE as CREATE4_0_0_, nationalac0_.MODIFY_DATE as MODIFY5_0_0_, nationalac0_.LOCK_FLAG as LOCK6_0_0_, nationalac0_.ORPHAN_FLAG as ORPHAN7_0_0_, nationalac0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, nationalac0_.MIGRATION_ID as MIGRATION9_0_0_, nationalac0_.CREATOR_ID as CREATOR10_0_0_, nationalac0_.MODIFIER_ID as MODIFIER11_0_0_, nationalac0_.academy_id as academy49_0_0_, nationalac0_.START_DATE_TYP as START43_0_0_, nationalac0_.TITLE as TITLE0_0_, nationalac0_.ACHIEVEMENT_ID as formula4_0_, nationalac0_.ACADEMY_ID as formula5_0_ from ACHIEVEMENTS nationalac0_ where nationalac0_.ACHIEVEMENT_ID=? and nationalac0_.TYPE='NationalAcademyElection'
2006-11-20 15:23:48,599 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,599 DEBUG (org.hibernate.SQL:346) - select academies0_.SELECTION_LIST_ENTRY_ID as SELECTION1_20_0_, academies0_.VERSION as VERSION20_0_, academies0_.ENTRY_NAME as ENTRY4_20_0_ from SELECTION_LIST_ENTRIES academies0_ where academies0_.SELECTION_LIST_ENTRY_ID=? and academies0_.SELECTION_LIST_ENTRY_TYPE='Academies'
2006-11-20 15:23:48,614 DEBUG (org.hibernate.SQL:346) - select societyfel0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, societyfel0_.version as version0_0_, societyfel0_.CREATE_DATE as CREATE4_0_0_, societyfel0_.MODIFY_DATE as MODIFY5_0_0_, societyfel0_.LOCK_FLAG as LOCK6_0_0_, societyfel0_.ORPHAN_FLAG as ORPHAN7_0_0_, societyfel0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, societyfel0_.MIGRATION_ID as MIGRATION9_0_0_, societyfel0_.CREATOR_ID as CREATOR10_0_0_, societyfel0_.MODIFIER_ID as MODIFIER11_0_0_, societyfel0_.society_id as society50_0_0_, societyfel0_.START_DATE_TYP as START43_0_0_, societyfel0_.TITLE as TITLE0_0_, societyfel0_.ACHIEVEMENT_ID as formula6_0_, societyfel0_.SOCIETY_ID as formula7_0_ from ACHIEVEMENTS societyfel0_ where societyfel0_.ACHIEVEMENT_ID=? and societyfel0_.TYPE='SocietyFellowship'
2006-11-20 15:23:48,630 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,646 DEBUG (org.hibernate.SQL:346) - select societies0_.SELECTION_LIST_ENTRY_ID as SELECTION1_20_0_, societies0_.VERSION as VERSION20_0_, societies0_.ENTRY_NAME as ENTRY4_20_0_ from SELECTION_LIST_ENTRIES societies0_ where societies0_.SELECTION_LIST_ENTRY_ID=? and societies0_.SELECTION_LIST_ENTRY_TYPE='Societies'
2006-11-20 15:23:48,646 DEBUG (org.hibernate.SQL:346) - select externalaw0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, externalaw0_.version as version0_0_, externalaw0_.CREATE_DATE as CREATE4_0_0_, externalaw0_.MODIFY_DATE as MODIFY5_0_0_, externalaw0_.LOCK_FLAG as LOCK6_0_0_, externalaw0_.ORPHAN_FLAG as ORPHAN7_0_0_, externalaw0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, externalaw0_.MIGRATION_ID as MIGRATION9_0_0_, externalaw0_.CREATOR_ID as CREATOR10_0_0_, externalaw0_.MODIFIER_ID as MODIFIER11_0_0_, externalaw0_.award_type_id as award51_0_0_, externalaw0_.external_award_id as external52_0_0_, externalaw0_.external_granting_org_id as external53_0_0_, externalaw0_.AUTHORS_1 as AUTHORS14_0_0_, externalaw0_.AUTHORS_2 as AUTHORS15_0_0_, externalaw0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, externalaw0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, externalaw0_.START_DATE_TYP as START43_0_0_, externalaw0_.COMMENTS as COMMENTS0_0_, externalaw0_.ACHIEVEMENT_ID as formula8_0_, externalaw0_.award_type_id as formula9_0_, externalaw0_.ACHIEVEMENT_ID as formula10_0_, externalaw0_.external_award_id as formula11_0_, externalaw0_.ACHIEVEMENT_ID as formula12_0_, externalaw0_.external_granting_org_id as formula13_0_ from ACHIEVEMENTS externalaw0_ where externalaw0_.ACHIEVEMENT_ID=? and externalaw0_.TYPE='ExternalAward'
2006-11-20 15:23:48,708 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,724 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,724 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,724 DEBUG (org.hibernate.SQL:346) - select externalaw0_.SELECTION_LIST_ENTRY_ID as SELECTION1_20_0_, externalaw0_.VERSION as VERSION20_0_, externalaw0_.ENTRY_NAME as ENTRY4_20_0_ from SELECTION_LIST_ENTRIES externalaw0_ where externalaw0_.SELECTION_LIST_ENTRY_ID=? and externalaw0_.SELECTION_LIST_ENTRY_TYPE='External Awards'
2006-11-20 15:23:48,739 DEBUG (org.hibernate.SQL:346) - select llnlaward0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, llnlaward0_.version as version0_0_, llnlaward0_.CREATE_DATE as CREATE4_0_0_, llnlaward0_.MODIFY_DATE as MODIFY5_0_0_, llnlaward0_.LOCK_FLAG as LOCK6_0_0_, llnlaward0_.ORPHAN_FLAG as ORPHAN7_0_0_, llnlaward0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, llnlaward0_.MIGRATION_ID as MIGRATION9_0_0_, llnlaward0_.CREATOR_ID as CREATOR10_0_0_, llnlaward0_.MODIFIER_ID as MODIFIER11_0_0_, llnlaward0_.llnl_award_id as llnl55_0_0_, llnlaward0_.AWARD_LEVEL as AWARD56_0_0_, llnlaward0_.DIRECTORATE as DIRECTO57_0_0_, llnlaward0_.DEPARTMENT as DEPARTMENT0_0_, llnlaward0_.DIVISION as DIVISION0_0_, llnlaward0_.START_DATE_TYP as START43_0_0_, llnlaward0_.COMMENTS as COMMENTS0_0_, llnlaward0_.AUTHORS_1 as AUTHORS14_0_0_, llnlaward0_.AUTHORS_2 as AUTHORS15_0_0_, llnlaward0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, llnlaward0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, llnlaward0_.ACHIEVEMENT_ID as formula14_0_, llnlaward0_.llnl_award_id as formula15_0_ from ACHIEVEMENTS llnlaward0_ where llnlaward0_.ACHIEVEMENT_ID=? and llnlaward0_.TYPE='LlnlAward'
2006-11-20 15:23:48,755 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,771 DEBUG (org.hibernate.SQL:346) - select llnlawards0_.SELECTION_LIST_ENTRY_ID as SELECTION1_20_0_, llnlawards0_.VERSION as VERSION20_0_, llnlawards0_.ENTRY_NAME as ENTRY4_20_0_ from SELECTION_LIST_ENTRIES llnlawards0_ where llnlawards0_.SELECTION_LIST_ENTRY_ID=? and llnlawards0_.SELECTION_LIST_ENTRY_TYPE='LLNL Awards'
2006-11-20 15:23:48,771 DEBUG (org.hibernate.SQL:346) - select llnlreport0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, llnlreport0_.version as version0_0_, llnlreport0_.CREATE_DATE as CREATE4_0_0_, llnlreport0_.MODIFY_DATE as MODIFY5_0_0_, llnlreport0_.LOCK_FLAG as LOCK6_0_0_, llnlreport0_.ORPHAN_FLAG as ORPHAN7_0_0_, llnlreport0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, llnlreport0_.MIGRATION_ID as MIGRATION9_0_0_, llnlreport0_.CREATOR_ID as CREATOR10_0_0_, llnlreport0_.MODIFIER_ID as MODIFIER11_0_0_, llnlreport0_.title as title0_0_, llnlreport0_.CLASSIFICATION_ID as CLASSIF72_0_0_, llnlreport0_.SPONSOR_ID as SPONSOR65_0_0_, llnlreport0_.SPONSOR_DETAILS as SPONSOR73_0_0_, llnlreport0_.AUTHORS_1 as AUTHORS14_0_0_, llnlreport0_.AUTHORS_2 as AUTHORS15_0_0_, llnlreport0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, llnlreport0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, llnlreport0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, llnlreport0_.UCRL_NUMBER as UCRL25_0_0_, llnlreport0_.LADS_DOC_NUMBER as LADS26_0_0_, llnlreport0_.LDRD_ENABLED_FLAG as LDRD32_0_0_, llnlreport0_.LDRD_FUNDED_FLAG as LDRD33_0_0_, llnlreport0_.ACHIEVEMENT_ID as formula44_0_, llnlreport0_.CLASSIFICATION_ID as formula45_0_, llnlreport0_.ACHIEVEMENT_ID as formula46_0_, llnlreport0_.SPONSOR_ID as formula47_0_ from ACHIEVEMENTS llnlreport0_ where llnlreport0_.ACHIEVEMENT_ID=? and llnlreport0_.TYPE='LlnlReport'
2006-11-20 15:23:48,802 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,802 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,802 DEBUG (org.hibernate.SQL:346) - select book0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, book0_.version as version0_0_, book0_.CREATE_DATE as CREATE4_0_0_, book0_.MODIFY_DATE as MODIFY5_0_0_, book0_.LOCK_FLAG as LOCK6_0_0_, book0_.ORPHAN_FLAG as ORPHAN7_0_0_, book0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, book0_.MIGRATION_ID as MIGRATION9_0_0_, book0_.CREATOR_ID as CREATOR10_0_0_, book0_.MODIFIER_ID as MODIFIER11_0_0_, book0_.BOOK_TYPE_ID as BOOK60_0_0_, book0_.AUTHORS_1 as AUTHORS14_0_0_, book0_.AUTHORS_2 as AUTHORS15_0_0_, book0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, book0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, book0_.title as title0_0_, book0_.editors as editors0_0_, book0_.publisher as publisher0_0_, book0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, book0_.CITY as CITY0_0_, book0_.STATE as STATE0_0_, book0_.country_id as country38_0_0_, book0_.description as descrip62_0_0_, book0_.pages as pages0_0_, book0_.UCRL_NUMBER as UCRL25_0_0_, book0_.LADS_DOC_NUMBER as LADS26_0_0_, book0_.ISBN as ISBN0_0_, book0_.LDRD_ENABLED_FLAG as LDRD32_0_0_, book0_.LDRD_FUNDED_FLAG as LDRD33_0_0_, book0_.ACHIEVEMENT_ID as formula16_0_, book0_.BOOK_TYPE_ID as formula17_0_ from ACHIEVEMENTS book0_ where book0_.ACHIEVEMENT_ID=? and book0_.TYPE='Book'
2006-11-20 15:23:48,849 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,864 DEBUG (org.hibernate.SQL:346) - select conference0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, conference0_.version as version0_0_, conference0_.CREATE_DATE as CREATE4_0_0_, conference0_.MODIFY_DATE as MODIFY5_0_0_, conference0_.LOCK_FLAG as LOCK6_0_0_, conference0_.ORPHAN_FLAG as ORPHAN7_0_0_, conference0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, conference0_.MIGRATION_ID as MIGRATION9_0_0_, conference0_.CREATOR_ID as CREATOR10_0_0_, conference0_.MODIFIER_ID as MODIFIER11_0_0_, conference0_.PEER_REVIEWED_FLAG as PEER34_0_0_, conference0_.title as title0_0_, conference0_.AUTHORS_1 as AUTHORS14_0_0_, conference0_.AUTHORS_2 as AUTHORS15_0_0_, conference0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, conference0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, conference0_.NAME as NAME0_0_, conference0_.CITY as CITY0_0_, conference0_.STATE as STATE0_0_, conference0_.country_id as country38_0_0_, conference0_.CONFERENCE_DATE_TYP as CONFERENCE39_0_0_, conference0_.SCIENTIFIC_PUBLICATION_ID as SCIENTIFIC19_0_0_, conference0_.VOLUME as VOLUME0_0_, conference0_.PAGES as PAGES0_0_, conference0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, conference0_.UCRL_NUMBER as UCRL25_0_0_, conference0_.LADS_DOC_NUMBER as LADS26_0_0_, conference0_.PUBLISHER as PUBLISHER0_0_, conference0_.WEB_SITE as WEB41_0_0_, conference0_.ISI_FLAG as ISI28_0_0_, conference0_.ISI_ID as ISI29_0_0_, conference0_.CITED_REF_COUNT as CITED30_0_0_, conference0_.CITED_COUNT as CITED31_0_0_, conference0_.LDRD_ENABLED_FLAG as LDRD32_0_0_, conference0_.LDRD_FUNDED_FLAG as LDRD33_0_0_, conference0_.ACHIEVEMENT_ID as formula2_0_, conference0_.SCIENTIFIC_PUBLICATION_ID as formula3_0_ from ACHIEVEMENTS conference0_ where conference0_.ACHIEVEMENT_ID=? and conference0_.TYPE='ConferenceProceedingArticle'
2006-11-20 15:23:48,880 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,880 DEBUG (org.hibernate.SQL:346) - select newsrelate0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, newsrelate0_.version as version0_0_, newsrelate0_.CREATE_DATE as CREATE4_0_0_, newsrelate0_.MODIFY_DATE as MODIFY5_0_0_, newsrelate0_.LOCK_FLAG as LOCK6_0_0_, newsrelate0_.ORPHAN_FLAG as ORPHAN7_0_0_, newsrelate0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, newsrelate0_.MIGRATION_ID as MIGRATION9_0_0_, newsrelate0_.CREATOR_ID as CREATOR10_0_0_, newsrelate0_.MODIFIER_ID as MODIFIER11_0_0_, newsrelate0_.title as title0_0_, newsrelate0_.PUBLICATION_TYPE_ID as PUBLICA64_0_0_, newsrelate0_.AUTHORS_1 as AUTHORS14_0_0_, newsrelate0_.AUTHORS_2 as AUTHORS15_0_0_, newsrelate0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, newsrelate0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, newsrelate0_.NAME as NAME0_0_, newsrelate0_.PAGES as PAGES0_0_, newsrelate0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, newsrelate0_.UCRL_NUMBER as UCRL25_0_0_, newsrelate0_.LADS_DOC_NUMBER as LADS26_0_0_, newsrelate0_.ISI_FLAG as ISI28_0_0_, newsrelate0_.ISI_ID as ISI29_0_0_, newsrelate0_.CITED_REF_COUNT as CITED30_0_0_, newsrelate0_.CITED_COUNT as CITED31_0_0_, newsrelate0_.LDRD_ENABLED_FLAG as LDRD32_0_0_, newsrelate0_.LDRD_FUNDED_FLAG as LDRD33_0_0_, newsrelate0_.ACHIEVEMENT_ID as formula18_0_, newsrelate0_.PUBLICATION_TYPE_ID as formula19_0_ from ACHIEVEMENTS newsrelate0_ where newsrelate0_.ACHIEVEMENT_ID=? and newsrelate0_.TYPE='NewsRelatedArticle'
2006-11-20 15:23:48,896 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,896 DEBUG (org.hibernate.SQL:346) - select externalre0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, externalre0_.version as version0_0_, externalre0_.CREATE_DATE as CREATE4_0_0_, externalre0_.MODIFY_DATE as MODIFY5_0_0_, externalre0_.LOCK_FLAG as LOCK6_0_0_, externalre0_.ORPHAN_FLAG as ORPHAN7_0_0_, externalre0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, externalre0_.MIGRATION_ID as MIGRATION9_0_0_, externalre0_.CREATOR_ID as CREATOR10_0_0_, externalre0_.MODIFIER_ID as MODIFIER11_0_0_, externalre0_.title as title0_0_, externalre0_.description as descrip62_0_0_, externalre0_.SPONSOR_ID as SPONSOR65_0_0_, externalre0_.publisher as publisher0_0_, externalre0_.REPORT_NUMBER as REPORT66_0_0_, externalre0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, externalre0_.ACHIEVEMENT_ID as formula20_0_, externalre0_.SPONSOR_ID as formula21_0_ from ACHIEVEMENTS externalre0_ where externalre0_.ACHIEVEMENT_ID=? and externalre0_.TYPE='ExternalReportContribution'
2006-11-20 15:23:48,911 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,911 DEBUG (org.hibernate.SQL:346) - select abstract0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, abstract0_.version as version0_0_, abstract0_.CREATE_DATE as CREATE4_0_0_, abstract0_.MODIFY_DATE as MODIFY5_0_0_, abstract0_.LOCK_FLAG as LOCK6_0_0_, abstract0_.ORPHAN_FLAG as ORPHAN7_0_0_, abstract0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, abstract0_.MIGRATION_ID as MIGRATION9_0_0_, abstract0_.CREATOR_ID as CREATOR10_0_0_, abstract0_.MODIFIER_ID as MODIFIER11_0_0_, abstract0_.title as title0_0_, abstract0_.SCIENTIFIC_PUBLICATION_ID as SCIENTIFIC19_0_0_, abstract0_.AUTHORS_1 as AUTHORS14_0_0_, abstract0_.AUTHORS_2 as AUTHORS15_0_0_, abstract0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, abstract0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, abstract0_.VOLUME as VOLUME0_0_, abstract0_.PAGES as PAGES0_0_, abstract0_.REPORT_NUMBER as REPORT66_0_0_, abstract0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, abstract0_.UCRL_NUMBER as UCRL25_0_0_, abstract0_.LADS_DOC_NUMBER as LADS26_0_0_, abstract0_.ISI_FLAG as ISI28_0_0_, abstract0_.ISI_ID as ISI29_0_0_, abstract0_.CITED_REF_COUNT as CITED30_0_0_, abstract0_.CITED_COUNT as CITED31_0_0_, abstract0_.ACHIEVEMENT_ID as formula22_0_, abstract0_.SCIENTIFIC_PUBLICATION_ID as formula23_0_ from ACHIEVEMENTS abstract0_ where abstract0_.ACHIEVEMENT_ID=? and abstract0_.TYPE='Abstract'
2006-11-20 15:23:48,927 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,974 DEBUG (org.hibernate.SQL:346) - select invitedtal0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, invitedtal0_.version as version0_0_, invitedtal0_.CREATE_DATE as CREATE4_0_0_, invitedtal0_.MODIFY_DATE as MODIFY5_0_0_, invitedtal0_.LOCK_FLAG as LOCK6_0_0_, invitedtal0_.ORPHAN_FLAG as ORPHAN7_0_0_, invitedtal0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, invitedtal0_.MIGRATION_ID as MIGRATION9_0_0_, invitedtal0_.CREATOR_ID as CREATOR10_0_0_, invitedtal0_.MODIFIER_ID as MODIFIER11_0_0_, invitedtal0_.title as title0_0_, invitedtal0_.NAME as NAME0_0_, invitedtal0_.PRESENTED_AT_ID as PRESENTED67_0_0_, invitedtal0_.city as city0_0_, invitedtal0_.state as state0_0_, invitedtal0_.country_id as country38_0_0_, invitedtal0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, invitedtal0_.UCRL_NUMBER as UCRL25_0_0_, invitedtal0_.LADS_DOC_NUMBER as LADS26_0_0_, invitedtal0_.AUTHORS_1 as AUTHORS14_0_0_, invitedtal0_.AUTHORS_2 as AUTHORS15_0_0_, invitedtal0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, invitedtal0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, invitedtal0_.LDRD_ENABLED_FLAG as LDRD32_0_0_, invitedtal0_.LDRD_FUNDED_FLAG as LDRD33_0_0_, invitedtal0_.ACHIEVEMENT_ID as formula24_0_, invitedtal0_.PRESENTED_AT_ID as formula25_0_ from ACHIEVEMENTS invitedtal0_ where invitedtal0_.ACHIEVEMENT_ID=? and invitedtal0_.TYPE='InvitedTalk'
2006-11-20 15:23:48,989 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:48,989 DEBUG (org.hibernate.SQL:346) - select externalpa0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, externalpa0_.version as version0_0_, externalpa0_.CREATE_DATE as CREATE4_0_0_, externalpa0_.MODIFY_DATE as MODIFY5_0_0_, externalpa0_.LOCK_FLAG as LOCK6_0_0_, externalpa0_.ORPHAN_FLAG as ORPHAN7_0_0_, externalpa0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, externalpa0_.MIGRATION_ID as MIGRATION9_0_0_, externalpa0_.CREATOR_ID as CREATOR10_0_0_, externalpa0_.MODIFIER_ID as MODIFIER11_0_0_, externalpa0_.title as title0_0_, externalpa0_.NAME as NAME0_0_, externalpa0_.PRESENTED_TO_ID as PRESENTED68_0_0_, externalpa0_.PRESENTED_IN_ID as PRESENTED69_0_0_, externalpa0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, externalpa0_.UCRL_NUMBER as UCRL25_0_0_, externalpa0_.LADS_DOC_NUMBER as LADS26_0_0_, externalpa0_.AUTHORS_1 as AUTHORS14_0_0_, externalpa0_.AUTHORS_2 as AUTHORS15_0_0_, externalpa0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, externalpa0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, externalpa0_.ACHIEVEMENT_ID as formula26_0_, externalpa0_.PRESENTED_TO_ID as formula27_0_, externalpa0_.ACHIEVEMENT_ID as formula28_0_, externalpa0_.PRESENTED_IN_ID as formula29_0_ from ACHIEVEMENTS externalpa0_ where externalpa0_.ACHIEVEMENT_ID=? and externalpa0_.TYPE='ExternalPartyBriefing'
2006-11-20 15:23:49,036 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,036 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,052 DEBUG (org.hibernate.SQL:346) - select otherprese0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, otherprese0_.version as version0_0_, otherprese0_.CREATE_DATE as CREATE4_0_0_, otherprese0_.MODIFY_DATE as MODIFY5_0_0_, otherprese0_.LOCK_FLAG as LOCK6_0_0_, otherprese0_.ORPHAN_FLAG as ORPHAN7_0_0_, otherprese0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, otherprese0_.MIGRATION_ID as MIGRATION9_0_0_, otherprese0_.CREATOR_ID as CREATOR10_0_0_, otherprese0_.MODIFIER_ID as MODIFIER11_0_0_, otherprese0_.title as title0_0_, otherprese0_.PRESENTED_TO_ID as PRESENTED68_0_0_, otherprese0_.NAME as NAME0_0_, otherprese0_.city as city0_0_, otherprese0_.state as state0_0_, otherprese0_.AUTHORS_1 as AUTHORS14_0_0_, otherprese0_.AUTHORS_2 as AUTHORS15_0_0_, otherprese0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, otherprese0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, otherprese0_.country_id as country38_0_0_, otherprese0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, otherprese0_.UCRL_NUMBER as UCRL25_0_0_, otherprese0_.LADS_DOC_NUMBER as LADS26_0_0_, otherprese0_.ACHIEVEMENT_ID as formula30_0_, otherprese0_.PRESENTED_TO_ID as formula31_0_ from ACHIEVEMENTS otherprese0_ where otherprese0_.ACHIEVEMENT_ID=? and otherprese0_.TYPE='OtherPresentation'
2006-11-20 15:23:49,099 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,130 DEBUG (org.hibernate.SQL:346) - select confworksh0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, confworksh0_.version as version0_0_, confworksh0_.CREATE_DATE as CREATE4_0_0_, confworksh0_.MODIFY_DATE as MODIFY5_0_0_, confworksh0_.LOCK_FLAG as LOCK6_0_0_, confworksh0_.ORPHAN_FLAG as ORPHAN7_0_0_, confworksh0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, confworksh0_.MIGRATION_ID as MIGRATION9_0_0_, confworksh0_.CREATOR_ID as CREATOR10_0_0_, confworksh0_.MODIFIER_ID as MODIFIER11_0_0_, confworksh0_.title as title0_0_, confworksh0_.CONFERENCE_OR_WORKSHOP as CONFERENCE80_0_0_, confworksh0_.city as city0_0_, confworksh0_.state as state0_0_, confworksh0_.country_id as country38_0_0_, confworksh0_.START_DATE_TYP as START43_0_0_, confworksh0_.organizer_role_id as organizer81_0_0_, confworksh0_.WEB_SITE as WEB41_0_0_, confworksh0_.ACHIEVEMENT_ID as formula52_0_, confworksh0_.organizer_role_id as formula53_0_ from ACHIEVEMENTS confworksh0_ where confworksh0_.ACHIEVEMENT_ID=? and confworksh0_.TYPE='ConfWorkshopsOrg'
2006-11-20 15:23:49,146 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,146 DEBUG (org.hibernate.SQL:346) - select bookeditor0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, bookeditor0_.version as version0_0_, bookeditor0_.CREATE_DATE as CREATE4_0_0_, bookeditor0_.MODIFY_DATE as MODIFY5_0_0_, bookeditor0_.LOCK_FLAG as LOCK6_0_0_, bookeditor0_.ORPHAN_FLAG as ORPHAN7_0_0_, bookeditor0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, bookeditor0_.MIGRATION_ID as MIGRATION9_0_0_, bookeditor0_.CREATOR_ID as CREATOR10_0_0_, bookeditor0_.MODIFIER_ID as MODIFIER11_0_0_, bookeditor0_.BOOK_TYPE_ID as BOOK60_0_0_, bookeditor0_.title as title0_0_, bookeditor0_.AUTHORS_1 as AUTHORS14_0_0_, bookeditor0_.AUTHORS_2 as AUTHORS15_0_0_, bookeditor0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, bookeditor0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, bookeditor0_.publisher as publisher0_0_, bookeditor0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, bookeditor0_.ACHIEVEMENT_ID as formula32_0_, bookeditor0_.BOOK_TYPE_ID as formula33_0_ from ACHIEVEMENTS bookeditor0_ where bookeditor0_.ACHIEVEMENT_ID=? and bookeditor0_.TYPE='BookEditor'
2006-11-20 15:23:49,177 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,177 DEBUG (org.hibernate.SQL:346) - select editorialr0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, editorialr0_.version as version0_0_, editorialr0_.CREATE_DATE as CREATE4_0_0_, editorialr0_.MODIFY_DATE as MODIFY5_0_0_, editorialr0_.LOCK_FLAG as LOCK6_0_0_, editorialr0_.ORPHAN_FLAG as ORPHAN7_0_0_, editorialr0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, editorialr0_.MIGRATION_ID as MIGRATION9_0_0_, editorialr0_.CREATOR_ID as CREATOR10_0_0_, editorialr0_.MODIFIER_ID as MODIFIER11_0_0_, editorialr0_.SCIENTIFIC_PUBLICATION_ID as SCIENTIFIC19_0_0_, editorialr0_.EDITORIAL_ROLES_ID as EDITORIAL70_0_0_, editorialr0_.START_DATE_TYP as START43_0_0_, editorialr0_.END_DATE_TYP as END44_0_0_, editorialr0_.ACHIEVEMENT_ID as formula34_0_, editorialr0_.SCIENTIFIC_PUBLICATION_ID as formula35_0_, editorialr0_.ACHIEVEMENT_ID as formula36_0_, editorialr0_.EDITORIAL_ROLES_ID as formula37_0_ from ACHIEVEMENTS editorialr0_ where editorialr0_.ACHIEVEMENT_ID=? and editorialr0_.TYPE='EditorialRole'
2006-11-20 15:23:49,224 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,239 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,239 DEBUG (org.hibernate.SQL:346) - select refereedjo0_.SCIENTIFIC_PUBLICATION_ID as SCIENTIFIC1_19_0_, refereedjo0_.VERSION as VERSION19_0_, refereedjo0_.NAME as NAME19_0_, refereedjo0_.ABBREVIATION as ABBREVIA5_19_0_, refereedjo0_.IMPACT_FACTOR as IMPACT6_19_0_, refereedjo0_.SHUNT_TYPE as SHUNT7_19_0_ from SCIENTIFIC_PUBLICATIONS refereedjo0_ where refereedjo0_.SCIENTIFIC_PUBLICATION_ID=? and refereedjo0_.PUBLICATION_TYPE='RefereedJournal'
2006-11-20 15:23:49,239 DEBUG (org.hibernate.SQL:346) - select editorialr0_.SELECTION_LIST_ENTRY_ID as SELECTION1_20_0_, editorialr0_.VERSION as VERSION20_0_, editorialr0_.ENTRY_NAME as ENTRY4_20_0_ from SELECTION_LIST_ENTRIES editorialr0_ where editorialr0_.SELECTION_LIST_ENTRY_ID=? and editorialr0_.SELECTION_LIST_ENTRY_TYPE='Editorial Roles'
2006-11-20 15:23:49,255 DEBUG (org.hibernate.SQL:346) - select leadership0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, leadership0_.version as version0_0_, leadership0_.CREATE_DATE as CREATE4_0_0_, leadership0_.MODIFY_DATE as MODIFY5_0_0_, leadership0_.LOCK_FLAG as LOCK6_0_0_, leadership0_.ORPHAN_FLAG as ORPHAN7_0_0_, leadership0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, leadership0_.MIGRATION_ID as MIGRATION9_0_0_, leadership0_.CREATOR_ID as CREATOR10_0_0_, leadership0_.MODIFIER_ID as MODIFIER11_0_0_, leadership0_.SOCIETY_ID as SOCIETY50_0_0_, leadership0_.SOCIETY_DIVISION_ID as SOCIETY71_0_0_, leadership0_.EDITORIAL_ROLES_ID as EDITORIAL70_0_0_, leadership0_.NAME as NAME0_0_, leadership0_.START_DATE_TYP as START43_0_0_, leadership0_.END_DATE_TYP as END44_0_0_, leadership0_.ACHIEVEMENT_ID as formula38_0_, leadership0_.SOCIETY_ID as formula39_0_, leadership0_.ACHIEVEMENT_ID as formula40_0_, leadership0_.SOCIETY_DIVISION_ID as formula41_0_, leadership0_.ACHIEVEMENT_ID as formula42_0_, leadership0_.EDITORIAL_ROLES_ID as formula43_0_ from ACHIEVEMENTS leadership0_ where leadership0_.ACHIEVEMENT_ID=? and leadership0_.TYPE='LeadershipPosition'
2006-11-20 15:23:49,271 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,286 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,286 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,286 DEBUG (org.hibernate.SQL:346) - select societies0_.SELECTION_LIST_ENTRY_ID as SELECTION1_20_0_, societies0_.VERSION as VERSION20_0_, societies0_.ENTRY_NAME as ENTRY4_20_0_ from SELECTION_LIST_ENTRIES societies0_ where societies0_.SELECTION_LIST_ENTRY_ID=? and societies0_.SELECTION_LIST_ENTRY_TYPE='Societies'
2006-11-20 15:23:49,286 DEBUG (org.hibernate.SQL:346) - select societycom0_.SELECTION_LIST_ENTRY_ID as SELECTION1_20_0_, societycom0_.VERSION as VERSION20_0_, societycom0_.ENTRY_NAME as ENTRY4_20_0_ from SELECTION_LIST_ENTRIES societycom0_ where societycom0_.SELECTION_LIST_ENTRY_ID=? and societycom0_.SELECTION_LIST_ENTRY_TYPE='Society/Committee Roles'
2006-11-20 15:23:49,317 DEBUG (org.hibernate.SQL:346) - select participat0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, participat0_.version as version0_0_, participat0_.CREATE_DATE as CREATE4_0_0_, participat0_.MODIFY_DATE as MODIFY5_0_0_, participat0_.LOCK_FLAG as LOCK6_0_0_, participat0_.ORPHAN_FLAG as ORPHAN7_0_0_, participat0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, participat0_.MIGRATION_ID as MIGRATION9_0_0_, participat0_.CREATOR_ID as CREATOR10_0_0_, participat0_.MODIFIER_ID as MODIFIER11_0_0_, participat0_.ORGANIZATION_TYPE_ID as ORGANIZ77_0_0_, participat0_.NAME as NAME0_0_, participat0_.NAME_TYPE as NAME78_0_0_, participat0_.COMMITTEE_PROPOSAL_ROLE_ID as COMMITTEE79_0_0_, participat0_.START_DATE_TYP as START43_0_0_, participat0_.END_DATE_TYP as END44_0_0_, participat0_.ACHIEVEMENT_ID as formula48_0_, participat0_.ORGANIZATION_TYPE_ID as formula49_0_, participat0_.ACHIEVEMENT_ID as formula50_0_, participat0_.COMMITTEE_PROPOSAL_ROLE_ID as formula51_0_ from ACHIEVEMENTS participat0_ where participat0_.ACHIEVEMENT_ID=? and participat0_.TYPE='ParticipationAdvisoryPeerCapacity'
2006-11-20 15:23:49,349 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,349 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,364 DEBUG (org.hibernate.SQL:346) - select advisoryro0_.SELECTION_LIST_ENTRY_ID as SELECTION1_20_0_, advisoryro0_.VERSION as VERSION20_0_, advisoryro0_.ENTRY_NAME as ENTRY4_20_0_ from SELECTION_LIST_ENTRIES advisoryro0_ where advisoryro0_.SELECTION_LIST_ENTRY_ID=? and advisoryro0_.SELECTION_LIST_ENTRY_TYPE='Advisory Roles'
2006-11-20 15:23:49,364 DEBUG (org.hibernate.SQL:346) - select otherleade0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, otherleade0_.version as version0_0_, otherleade0_.CREATE_DATE as CREATE4_0_0_, otherleade0_.MODIFY_DATE as MODIFY5_0_0_, otherleade0_.LOCK_FLAG as LOCK6_0_0_, otherleade0_.ORPHAN_FLAG as ORPHAN7_0_0_, otherleade0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, otherleade0_.MIGRATION_ID as MIGRATION9_0_0_, otherleade0_.CREATOR_ID as CREATOR10_0_0_, otherleade0_.MODIFIER_ID as MODIFIER11_0_0_, otherleade0_.description as descrip62_0_0_, otherleade0_.START_DATE_TYP as START43_0_0_, otherleade0_.END_DATE_TYP as END44_0_0_ from ACHIEVEMENTS otherleade0_ where otherleade0_.ACHIEVEMENT_ID=? and otherleade0_.TYPE='OtherLeadershipService'
2006-11-20 15:23:49,380 DEBUG (org.hibernate.SQL:346) - select patentcopy0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, patentcopy0_.version as version0_0_, patentcopy0_.CREATE_DATE as CREATE4_0_0_, patentcopy0_.MODIFY_DATE as MODIFY5_0_0_, patentcopy0_.LOCK_FLAG as LOCK6_0_0_, patentcopy0_.ORPHAN_FLAG as ORPHAN7_0_0_, patentcopy0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, patentcopy0_.MIGRATION_ID as MIGRATION9_0_0_, patentcopy0_.CREATOR_ID as CREATOR10_0_0_, patentcopy0_.MODIFIER_ID as MODIFIER11_0_0_, patentcopy0_.title as title0_0_, patentcopy0_.PATENT_OR_COPYRIGHT as PATENT74_0_0_, patentcopy0_.status as status0_0_, patentcopy0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, patentcopy0_.PATENT_COPYRIGHT_NUMBER as PATENT75_0_0_, patentcopy0_.ilno as ilno0_0_, patentcopy0_.AUTHORS_1 as AUTHORS14_0_0_, patentcopy0_.AUTHORS_2 as AUTHORS15_0_0_, patentcopy0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, patentcopy0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_ from ACHIEVEMENTS patentcopy0_ where patentcopy0_.ACHIEVEMENT_ID=? and patentcopy0_.TYPE='PatentCopyright'
2006-11-20 15:23:49,380 DEBUG (org.hibernate.SQL:346) - select highlight0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, highlight0_.version as version0_0_, highlight0_.CREATE_DATE as CREATE4_0_0_, highlight0_.MODIFY_DATE as MODIFY5_0_0_, highlight0_.LOCK_FLAG as LOCK6_0_0_, highlight0_.ORPHAN_FLAG as ORPHAN7_0_0_, highlight0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, highlight0_.MIGRATION_ID as MIGRATION9_0_0_, highlight0_.CREATOR_ID as CREATOR10_0_0_, highlight0_.MODIFIER_ID as MODIFIER11_0_0_, highlight0_.description as descrip62_0_0_, highlight0_.award_type_id as award51_0_0_, highlight0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, highlight0_.WEB_SITE as WEB41_0_0_, highlight0_.COMMENTS as COMMENTS0_0_, highlight0_.ACHIEVEMENT_ID as formula54_0_, highlight0_.award_type_id as formula55_0_ from ACHIEVEMENTS highlight0_ where highlight0_.ACHIEVEMENT_ID=? and highlight0_.TYPE='Highlight'
2006-11-20 15:23:49,396 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,396 DEBUG (org.hibernate.SQL:346) - select highlightt0_.SELECTION_LIST_ENTRY_ID as SELECTION1_20_0_, highlightt0_.VERSION as VERSION20_0_, highlightt0_.ENTRY_NAME as ENTRY4_20_0_ from SELECTION_LIST_ENTRIES highlightt0_ where highlightt0_.SELECTION_LIST_ENTRY_ID=? and highlightt0_.SELECTION_LIST_ENTRY_TYPE='Highlight'
2006-11-20 15:23:49,396 DEBUG (org.hibernate.SQL:346) - select refereedjo0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, refereedjo0_.version as version0_0_, refereedjo0_.CREATE_DATE as CREATE4_0_0_, refereedjo0_.MODIFY_DATE as MODIFY5_0_0_, refereedjo0_.LOCK_FLAG as LOCK6_0_0_, refereedjo0_.ORPHAN_FLAG as ORPHAN7_0_0_, refereedjo0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, refereedjo0_.MIGRATION_ID as MIGRATION9_0_0_, refereedjo0_.CREATOR_ID as CREATOR10_0_0_, refereedjo0_.MODIFIER_ID as MODIFIER11_0_0_, refereedjo0_.status as status0_0_, refereedjo0_.EPRINT_FLAG as EPRINT13_0_0_, refereedjo0_.AUTHORS_1 as AUTHORS14_0_0_, refereedjo0_.AUTHORS_2 as AUTHORS15_0_0_, refereedjo0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, refereedjo0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, refereedjo0_.title as title0_0_, refereedjo0_.SCIENTIFIC_PUBLICATION_ID as SCIENTIFIC19_0_0_, refereedjo0_.VOLUME as VOLUME0_0_, refereedjo0_.PAGES as PAGES0_0_, refereedjo0_.ISSUE as ISSUE0_0_, refereedjo0_.ARTICLE_NUM as ARTICLE23_0_0_, refereedjo0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, refereedjo0_.UCRL_NUMBER as UCRL25_0_0_, refereedjo0_.LADS_DOC_NUMBER as LADS26_0_0_, refereedjo0_.IMPORTANCE_FACTOR as IMPORTANCE27_0_0_, refereedjo0_.ISI_FLAG as ISI28_0_0_, refereedjo0_.ISI_ID as ISI29_0_0_, refereedjo0_.CITED_REF_COUNT as CITED30_0_0_, refereedjo0_.CITED_COUNT as CITED31_0_0_, refereedjo0_.LDRD_ENABLED_FLAG as LDRD32_0_0_, refereedjo0_.LDRD_FUNDED_FLAG as LDRD33_0_0_, refereedjo0_.ACHIEVEMENT_ID as formula0_0_, refereedjo0_.SCIENTIFIC_PUBLICATION_ID as formula1_0_ from ACHIEVEMENTS refereedjo0_ where refereedjo0_.ACHIEVEMENT_ID=? and refereedjo0_.TYPE='RefereedJournalArticle'
2006-11-20 15:23:49,442 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,442 DEBUG (org.hibernate.SQL:346) - select externalpa0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, externalpa0_.version as version0_0_, externalpa0_.CREATE_DATE as CREATE4_0_0_, externalpa0_.MODIFY_DATE as MODIFY5_0_0_, externalpa0_.LOCK_FLAG as LOCK6_0_0_, externalpa0_.ORPHAN_FLAG as ORPHAN7_0_0_, externalpa0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, externalpa0_.MIGRATION_ID as MIGRATION9_0_0_, externalpa0_.CREATOR_ID as CREATOR10_0_0_, externalpa0_.MODIFIER_ID as MODIFIER11_0_0_, externalpa0_.title as title0_0_, externalpa0_.NAME as NAME0_0_, externalpa0_.PRESENTED_TO_ID as PRESENTED68_0_0_, externalpa0_.PRESENTED_IN_ID as PRESENTED69_0_0_, externalpa0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, externalpa0_.UCRL_NUMBER as UCRL25_0_0_, externalpa0_.LADS_DOC_NUMBER as LADS26_0_0_, externalpa0_.AUTHORS_1 as AUTHORS14_0_0_, externalpa0_.AUTHORS_2 as AUTHORS15_0_0_, externalpa0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, externalpa0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, externalpa0_.ACHIEVEMENT_ID as formula26_0_, externalpa0_.PRESENTED_TO_ID as formula27_0_, externalpa0_.ACHIEVEMENT_ID as formula28_0_, externalpa0_.PRESENTED_IN_ID as formula29_0_ from ACHIEVEMENTS externalpa0_ where externalpa0_.ACHIEVEMENT_ID=? and externalpa0_.TYPE='ExternalPartyBriefing'
2006-11-20 15:23:49,442 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,458 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,458 DEBUG (org.hibernate.SQL:346) - select refereedjo0_.ACHIEVEMENT_ID as ACHIEVEM1_0_0_, refereedjo0_.version as version0_0_, refereedjo0_.CREATE_DATE as CREATE4_0_0_, refereedjo0_.MODIFY_DATE as MODIFY5_0_0_, refereedjo0_.LOCK_FLAG as LOCK6_0_0_, refereedjo0_.ORPHAN_FLAG as ORPHAN7_0_0_, refereedjo0_.DOWNLOAD_DATE as DOWNLOAD8_0_0_, refereedjo0_.MIGRATION_ID as MIGRATION9_0_0_, refereedjo0_.CREATOR_ID as CREATOR10_0_0_, refereedjo0_.MODIFIER_ID as MODIFIER11_0_0_, refereedjo0_.status as status0_0_, refereedjo0_.EPRINT_FLAG as EPRINT13_0_0_, refereedjo0_.AUTHORS_1 as AUTHORS14_0_0_, refereedjo0_.AUTHORS_2 as AUTHORS15_0_0_, refereedjo0_.AUTHOR_ORGS_1 as AUTHOR16_0_0_, refereedjo0_.AUTHOR_ORGS_2 as AUTHOR17_0_0_, refereedjo0_.title as title0_0_, refereedjo0_.SCIENTIFIC_PUBLICATION_ID as SCIENTIFIC19_0_0_, refereedjo0_.VOLUME as VOLUME0_0_, refereedjo0_.PAGES as PAGES0_0_, refereedjo0_.ISSUE as ISSUE0_0_, refereedjo0_.ARTICLE_NUM as ARTICLE23_0_0_, refereedjo0_.PUBLISH_DATE_TYP as PUBLISH24_0_0_, refereedjo0_.UCRL_NUMBER as UCRL25_0_0_, refereedjo0_.LADS_DOC_NUMBER as LADS26_0_0_, refereedjo0_.IMPORTANCE_FACTOR as IMPORTANCE27_0_0_, refereedjo0_.ISI_FLAG as ISI28_0_0_, refereedjo0_.ISI_ID as ISI29_0_0_, refereedjo0_.CITED_REF_COUNT as CITED30_0_0_, refereedjo0_.CITED_COUNT as CITED31_0_0_, refereedjo0_.LDRD_ENABLED_FLAG as LDRD32_0_0_, refereedjo0_.LDRD_FUNDED_FLAG as LDRD33_0_0_, refereedjo0_.ACHIEVEMENT_ID as formula0_0_, refereedjo0_.SCIENTIFIC_PUBLICATION_ID as formula1_0_ from ACHIEVEMENTS refereedjo0_ where refereedjo0_.ACHIEVEMENT_ID=? and refereedjo0_.TYPE='RefereedJournalArticle'
2006-11-20 15:23:49,458 DEBUG (org.hibernate.SQL:346) - select otherselec0_.ACHIEVEMENT_ID as ACHIEVEM1_29_0_, otherselec0_.OTHER_ID as OTHER2_29_0_, otherselec0_.VERSION as VERSION29_0_, otherselec0_.NAME as NAME29_0_ from OTHER_SELECTION_LIST_VALUES otherselec0_ where otherselec0_.ACHIEVEMENT_ID=? and otherselec0_.OTHER_ID=?
2006-11-20 15:23:49,536 DEBUG (org.hibernate.SQL:346) - select attachment0_.ACHIEVEMENT_ID as ACHIEVEM2_1_, attachment0_.ATTACHMENT_ID as ATTACHMENT1_1_, attachment0_.ATTACHMENT_ID as ATTACHMENT1_27_0_, attachment0_.ACHIEVEMENT_ID as ACHIEVEM2_27_0_, attachment0_.FILENAME as FILENAME27_0_ from ATTACHMENT attachment0_ where attachment0_.ACHIEVEMENT_ID=?
2006-11-20 15:23:49,677 DEBUG (org.hibernate.SQL:346) - select myadminist0_.USER_ID as USER1_1_, myadminist0_.ADMIN_ID as ADMIN2_1_, myadminist0_.USER_ID as USER1_16_0_, myadminist0_.ADMIN_ID as ADMIN2_16_0_, myadminist0_.oun as oun16_0_, myadminist0_.FORMAL_NAME as FORMAL4_16_0_ from ADMINISTRATORS_VIEW myadminist0_ where myadminist0_.USER_ID=? order by myadminist0_.FORMAL_NAME asc
2006-11-20 15:23:49,692 DEBUG (org.hibernate.SQL:346) - select authorized0_.EDITOR_ID as EDITOR1_1_, authorized0_.AUTHOR_ID as AUTHOR2_1_, authorized0_.MATRIX_FLAG as MATRIX3_1_, authorized0_.PROXY_FLAG as PROXY4_1_, authorized0_.EDITOR_ID as EDITOR1_15_0_, authorized0_.AUTHOR_ID as AUTHOR2_15_0_, authorized0_.MATRIX_FLAG as MATRIX3_15_0_, authorized0_.PROXY_FLAG as PROXY4_15_0_, authorized0_.oun as oun15_0_, authorized0_.FORMAL_NAME as FORMAL6_15_0_, authorized0_.DIR_ABBREVIATION as DIR7_15_0_ from EDITORS_AUTHORS_VIEW authorized0_ where authorized0_.EDITOR_ID=? order by authorized0_.FORMAL_NAME asc
2006-11-20 15:23:50,005 DEBUG (org.hibernate.SQL:346) - select reportgrou0_.USER_ID as USER4_1_, reportgrou0_.RPT_GRP_ID as RPT1_1_, reportgrou0_.RPT_GRP_ID as RPT1_17_0_, reportgrou0_.VERSION as VERSION17_0_, reportgrou0_.NAME as NAME17_0_, reportgrou0_.USER_ID as USER4_17_0_ from REPORT_GROUPINGS reportgrou0_ where reportgrou0_.USER_ID=? order by reportgrou0_.NAME ASC
2006-11-20 15:23:50,005 DEBUG (org.hibernate.SQL:346) - select department0_.PARENT_ORGANIZATION_ID as PARENT6_1_, department0_.ORGANIZATION_ID as ORGANIZA1_1_, department0_.ORGANIZATION_ID as ORGANIZA1_5_0_, department0_.VERSION as VERSION5_0_, department0_.name as name5_0_, department0_.abbreviation as abbrevia5_5_0_, department0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS department0_ where department0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,021 DEBUG (org.hibernate.SQL:346) - select divisions0_.PARENT_ORGANIZATION_ID as PARENT6_1_, divisions0_.ORGANIZATION_ID as ORGANIZA1_1_, divisions0_.ORGANIZATION_ID as ORGANIZA1_5_0_, divisions0_.VERSION as VERSION5_0_, divisions0_.name as name5_0_, divisions0_.abbreviation as abbrevia5_5_0_, divisions0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS divisions0_ where divisions0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,021 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,036 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,036 DEBUG (org.hibernate.SQL:346) - select divisions0_.PARENT_ORGANIZATION_ID as PARENT6_1_, divisions0_.ORGANIZATION_ID as ORGANIZA1_1_, divisions0_.ORGANIZATION_ID as ORGANIZA1_5_0_, divisions0_.VERSION as VERSION5_0_, divisions0_.name as name5_0_, divisions0_.abbreviation as abbrevia5_5_0_, divisions0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS divisions0_ where divisions0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,036 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,036 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,036 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,052 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,052 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,052 DEBUG (org.hibernate.SQL:346) - select divisions0_.PARENT_ORGANIZATION_ID as PARENT6_1_, divisions0_.ORGANIZATION_ID as ORGANIZA1_1_, divisions0_.ORGANIZATION_ID as ORGANIZA1_5_0_, divisions0_.VERSION as VERSION5_0_, divisions0_.name as name5_0_, divisions0_.abbreviation as abbrevia5_5_0_, divisions0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS divisions0_ where divisions0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,067 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,067 DEBUG (org.hibernate.SQL:346) - select divisions0_.PARENT_ORGANIZATION_ID as PARENT6_1_, divisions0_.ORGANIZATION_ID as ORGANIZA1_1_, divisions0_.ORGANIZATION_ID as ORGANIZA1_5_0_, divisions0_.VERSION as VERSION5_0_, divisions0_.name as name5_0_, divisions0_.abbreviation as abbrevia5_5_0_, divisions0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS divisions0_ where divisions0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,067 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,083 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,083 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,083 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,083 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,083 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,099 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,099 DEBUG (org.hibernate.SQL:346) - select groups0_.PARENT_ORGANIZATION_ID as PARENT6_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_1_, groups0_.ORGANIZATION_ID as ORGANIZA1_5_0_, groups0_.VERSION as VERSION5_0_, groups0_.name as name5_0_, groups0_.abbreviation as abbrevia5_5_0_, groups0_.PARENT_ORGANIZATION_ID as PARENT6_5_0_ from ORGANIZATIONS groups0_ where groups0_.PARENT_ORGANIZATION_ID=?
2006-11-20 15:23:50,114 INFO (gov.llnl.eit.stats.servlet.UserFilter:47) - nazario1 logging in
2006-11-20 15:23:50,114 INFO (gov.llnl.eit.stats.servlet.UserFilter:48) - setting User Privileges for nazario1
2006-11-20 15:23:50,114 DEBUG (org.hibernate.SQL:346) - select assignedro0_.USER_ID as USER5_1_, assignedro0_.ASSIGNED_ROLE_ID as ASSIGNED1_1_, assignedro0_.ASSIGNED