public int getRefCount(Object object) {
		String		m = "getRefCount";

		EntityManagerObjectStore objectStore;
		try {
			objectStore = getObjectStore();
		} catch (Exception e) {
			log.err(m, "Exception getting ObjectStore: %s", ExceptionUtil.getTrace(e));
			return -1;
		}

		/*
		 * Get max 2 references with containment refers (true)
		 */
		List<Object> referers = objectStore.getReferingObjects(object, 2, true);
		if (log.isDebugOn())
			log.debug(m, "Referers count=%d to class=<%s>", 
			          (referers != null) ? referers.size() : 0,
			                             object.getClass().getName());

		if (referers == null)
			return 0;

		return referers.size();
	}

2013-10-08 16:20:09,259 DEBUG [com.magnicomp.model.manager.common.ModelManagerCore] getObjectStore: Creating ObjectStore
2013-10-08 16:20:09,265 DEBUG [com.magnicomp.model.manager.common.ModelManagerCore] getObjectStore: Setting EntityManager in ObjectStore
2013-10-08 16:20:09,265 DEBUG [com.magnicomp.model.manager.common.ModelManagerCore] getObjectStore: ObjectStore ready
2013-10-08 16:20:09,911 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 0, SQLState: 07001
2013-10-08 16:20:09,911 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] No value specified for parameter 2
2013-10-08 16:20:09,918 ERROR [cruisedomo.admintool.Main] runCmd: Exception while running CLI: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: No value specified for parameter 2
  #0: org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
  #1: org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
  #2: org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
  #3: org.eclipse.emf.texo.server.store.BaseDao.getReferingObjects(BaseDao.java:276)
  #4: org.eclipse.emf.texo.server.store.EntityManagerObjectStore.getReferingObjects(EntityManagerObjectStore.java:304)
  #5: com.magnicomp.model.manager.common.ModelManagerCore.getRefCount(ModelManagerCore.java:187)
  #6: cruisedomo.model.tool.OrgScrubber.scrub(OrgScrubber.java:145)
  #7: cruisedomo.admintool.commands.CliOrgEntity.scrub(CliOrgEntity.java:665)
  #8: cruisedomo.admintool.commands.CliOrgEntity.run(CliOrgEntity.java:123)
  #9: com.magnicomp.admintool.AdminToolCore.runCmd(AdminToolCore.java:427)
  #10: com.magnicomp.admintool.AdminToolCore.run(AdminToolCore.java:597)
  #11: com.magnicomp.admintool.AdminToolCore.Main(AdminToolCore.java:295)
  #12: cruisedomo.admintool.Main.main(Main.java:92)
org.hibernate.exception.SQLGrammarException: No value specified for parameter 2
  #0: org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
  #1: org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  #2: org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
  #3: org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
  #4: org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
  #5: org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
  #6: com.sun.proxy.$Proxy27.executeQuery(Unknown Source)
  #7: org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
  #8: org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
  #9: org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
  #10: org.hibernate.loader.Loader.doQuery(Loader.java:899)
  #11: org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  #12: org.hibernate.loader.Loader.doList(Loader.java:2516)
  #13: org.hibernate.loader.Loader.doList(Loader.java:2502)
  #14: org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2332)
  #15: org.hibernate.loader.Loader.list(Loader.java:2327)
  #16: org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
  #17: org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
  #18: org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
  #19: org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
  #20: org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
  #21: org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
  #22: org.eclipse.emf.texo.server.store.BaseDao.getReferingObjects(BaseDao.java:276)
  #23: org.eclipse.emf.texo.server.store.EntityManagerObjectStore.getReferingObjects(EntityManagerObjectStore.java:304)
  #24: com.magnicomp.model.manager.common.ModelManagerCore.getRefCount(ModelManagerCore.java:187)
  #25: cruisedomo.model.tool.OrgScrubber.scrub(OrgScrubber.java:145)
  #26: cruisedomo.admintool.commands.CliOrgEntity.scrub(CliOrgEntity.java:665)
  #27: cruisedomo.admintool.commands.CliOrgEntity.run(CliOrgEntity.java:123)
  #28: com.magnicomp.admintool.AdminToolCore.runCmd(AdminToolCore.java:427)
  #29: com.magnicomp.admintool.AdminToolCore.run(AdminToolCore.java:597)
  #30: com.magnicomp.admintool.AdminToolCore.Main(AdminToolCore.java:295)
  #31: cruisedomo.admintool.Main.main(Main.java:92)
java.sql.SQLException: No value specified for parameter 2
  #0: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
  #1: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
  #2: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
  #3: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
  #4: com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2611)
  #5: com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2586)
  #6: com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2510)
  #7: com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2259)
  #8: com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
  #9: sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
  #10: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  #11: java.lang.reflect.Method.invoke(Method.java:601)
  #12: org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
  #13: org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
  #14: com.sun.proxy.$Proxy27.executeQuery(Unknown Source)
  #15: org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
  #16: org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
  #17: org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
  #18: org.hibernate.loader.Loader.doQuery(Loader.java:899)
  #19: org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  #20: org.hibernate.loader.Loader.doList(Loader.java:2516)
  #21: org.hibernate.loader.Loader.doList(Loader.java:2502)
  #22: org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2332)
  #23: org.hibernate.loader.Loader.list(Loader.java:2327)
  #24: org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
  #25: org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
  #26: org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
  #27: org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
  #28: org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
  #29: org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
  #30: org.eclipse.emf.texo.server.store.BaseDao.getReferingObjects(BaseDao.java:276)
  #31: org.eclipse.emf.texo.server.store.EntityManagerObjectStore.getReferingObjects(EntityManagerObjectStore.java:304)
  #32: com.magnicomp.model.manager.common.ModelManagerCore.getRefCount(ModelManagerCore.java:187)
  #33: cruisedomo.model.tool.OrgScrubber.scrub(OrgScrubber.java:145)
  #34: cruisedomo.admintool.commands.CliOrgEntity.scrub(CliOrgEntity.java:665)
  #35: cruisedomo.admintool.commands.CliOrgEntity.run(CliOrgEntity.java:123)
  #36: com.magnicomp.admintool.AdminToolCore.runCmd(AdminToolCore.java:427)
  #37: com.magnicomp.admintool.AdminToolCore.run(AdminToolCore.java:597)
  #38: com.magnicomp.admintool.AdminToolCore.Main(AdminToolCore.java:295)
  #39: cruisedomo.admintool.Main.main(Main.java:92)

2013-10-09 09:15:15,374 INFO  [cruisedomo.model.tool.OrgScrubber] Removing unused Org <American Hawaii Cruises> dbid=929
2013-10-09 09:15:15,375 DEBUG [cruisedomo.model.manager.OrgEntityManager] delete: Delete OrgEntity dbid=929
2013-10-09 09:15:15,433 DEBUG [com.magnicomp.model.manager.common.EventLogger] EVENT: [Service=CruiseRater ServiceClass=cruisedomo.model.manager.OrgEntityManager Category=DataClass Op=Delete Result=null User=nulls] OrgEntity id=929 name=<American Hawaii Cruises>
2013-10-09 09:15:15,439 DEBUG [com.magnicomp.model.manager.EventManager] add: Adding Event dbid=null
Hibernate: select next_val as id_val from hibernate_sequence for update
Hibernate: update hibernate_sequence set next_val= ? where next_val=?
2013-10-09 09:15:15,685 DEBUG [com.magnicomp.model.manager.common.EventLogger] add: add finished
Hibernate: insert into Event (Created, dbVersion, Origin, Updated, Category, DataClass, T_Host, T_Level, Message, T_Operation, T_Result, Service, ServiceClass, T_Time, UserName, dbID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update Organization set Created=?, dbVersion=?, Origin=?, Updated=?, Abbreviation=?, T_Key=?, Name=?, OfficialWebSite=?, Parent=?, PrimaryAddress=?, WikipediaWebSite=?, AgencyInfo=?, T_Type=? where dbID=? and dbVersion=?
Hibernate: delete from WebSite where dbID=? and dbVersion=?
Hibernate: select builtvesse0_.OrgEntity_id as OrgEntity1_37_19_, builtvesse0_.Vessel_id as Vessel2_33_19_, vessel1_.dbID as dbID71_0_, vessel1_.Created as Created71_0_, vessel1_.dbVersion as dbVersion71_0_, vessel1_.Origin as Origin71_0_, vessel1_.Updated as Updated71_0_, vessel1_.BuildCost as BuildCost71_0_, vessel1_.Builder as Builder71_0_, vessel1_.BuilderYardNumber as BuilderY6_71_0_, vessel1_.CallSign as CallSign71_0_, vessel1_.CountryRegistryLabel as CountryR8_71_0_, vessel1_.CountryRegistryNumber as CountryR9_71_0_, vessel1_.DNVID as DNVID71_0_, vessel1_.Description as Descrip11_71_0_, vessel1_.Features as Features71_0_, vessel1_.FinalDisposition as FinalDi13_71_0_, vessel1_.HullNumber as HullNumber71_0_, vessel1_.IMO as IMO71_0_, vessel1_.T_Key as T16_71_0_, vessel1_.LloydsNumber as LloydsN17_71_0_, vessel1_.MMSI as MMSI71_0_, vessel1_.Name as Name71_0_, vessel1_.NameShort as NameShort71_0_, vessel1_.T_Operator as T34_71_0_, vessel1_.T_Owner as T35_71_0_, vessel1_.PortOfRegistry as PortOfR36_71_0_, vessel1_.PrimaryPicture as Primary37_71_0_, vessel1_.Route as Route71_0_, vessel1_.ScoreCard as ScoreCard71_0_, vessel1_.SortRankEnvironmental as SortRan22_71_0_, vessel1_.SortRankHealth as SortRan23_71_0_, vessel1_.SortRankOverall as SortRan24_71_0_, vessel1_.SortRankSafety as SortRan25_71_0_, vessel1_.Specification as Specifi39_71_0_, vessel1_.T_Status as T26_71_0_, vessel1_.StatusSummary as StatusS27_71_0_, vessel1_.T_Type as T28_71_0_, vessel1_.USCGDocNumber as USCGDoc29_71_0_, vessel1_.VIN as VIN71_0_, vessel1_.VesselClass as VesselC31_71_0_, currencyam2_.dbID as dbID17_1_, currencyam2_.Created as Created17_1_, currencyam2_.dbVersion as dbVersion17_1_, currencyam2_.Origin as Origin17_1_, currencyam2_.Updated as Updated17_1_, currencyam2_.Amount as Amount17_1_, currencyam2_.Currency as Currency17_1_, currency3_.dbID as dbID16_2_, currency3_.Created as Created16_2_, currency3_.dbVersion as dbVersion16_2_, currency3_.Origin as Origin16_2_, currency3_.Updated as Updated16_2_, currency3_.Name as Name16_2_, currency3_.Name3 as Name7_16_2_, currency3_.Symbol as Symbol16_2_, orgentity4_.dbID as dbID37_3_, orgentity4_.Created as Created37_3_, orgentity4_.dbVersion as dbVersion37_3_, orgentity4_.Origin as Origin37_3_, orgentity4_.Updated as Updated37_3_, orgentity4_.Abbreviation as Abbrevia7_37_3_, orgentity4_.T_Key as T8_37_3_, orgentity4_.Name as Name37_3_, orgentity4_.OfficialWebSite as Officia11_37_3_, orgentity4_.Parent as Parent37_3_, orgentity4_.PrimaryAddress as Primary13_37_3_, orgentity4_.WikipediaWebSite as Wikiped14_37_3_, orgentity4_.AgencyInfo as AgencyInfo37_3_, orgentity4_.T_Type as T10_37_3_, website5_.dbID as dbID79_4_, website5_.Created as Created79_4_, website5_.dbVersion as dbVersion79_4_, website5_.Origin as Origin79_4_, website5_.Updated as Updated79_4_, website5_.Title as Title79_4_, website5_.URL as URL79_4_, organizati6_.dbID as dbID37_5_, organizati6_.Created as Created37_5_, organizati6_.dbVersion as dbVersion37_5_, organizati6_.Origin as Origin37_5_, organizati6_.Updated as Updated37_5_, organizati6_.Abbreviation as Abbrevia7_37_5_, organizati6_.T_Key as T8_37_5_, organizati6_.Name as Name37_5_, organizati6_.OfficialWebSite as Officia11_37_5_, organizati6_.Parent as Parent37_5_, organizati6_.PrimaryAddress as Primary13_37_5_, organizati6_.WikipediaWebSite as Wikiped14_37_5_, organizati6_.AgencyInfo as AgencyInfo37_5_, organizati6_.T_Type as T10_37_5_, organizati6_.DTYPE as DTYPE37_5_, address7_.dbID as dbID3_6_, address7_.Created as Created3_6_, address7_.dbVersion as dbVersion3_6_, address7_.Origin as Origin3_6_, address7_.Updated as Updated3_6_, address7_.Address1 as Address6_3_6_, address7_.Address2 as Address7_3_6_, address7_.Address3 as Address8_3_6_, address7_.City as City3_6_, address7_.Country as Country3_6_, address7_.CountryState as Country15_3_6_, address7_.NickName as NickName3_6_, address7_.Person as Person3_6_, address7_.PostalCode as PostalCode3_6_, address7_.T_State as T12_3_6_, address7_.T_Type as T13_3_6_, website8_.dbID as dbID79_7_, website8_.Created as Created79_7_, website8_.dbVersion as dbVersion79_7_, website8_.Origin as Origin79_7_, website8_.Updated as Updated79_7_, website8_.Title as Title79_7_, website8_.URL as URL79_7_, agencyinfo9_.dbID as dbID4_8_, agencyinfo9_.Created as Created4_8_, agencyinfo9_.dbVersion as dbVersion4_8_, agencyinfo9_.Origin as Origin4_8_, agencyinfo9_.Updated as Updated4_8_, agencyinfo9_.HealthInspectionSatisfactoryScore as HealthIn6_4_8_, agencyinfo9_.HealthInspectionSatisfactoryScoreMaxPossible as HealthIn7_4_8_, orgentity10_.dbID as dbID37_9_, orgentity10_.Created as Created37_9_, orgentity10_.dbVersion as dbVersion37_9_, orgentity10_.Origin as Origin37_9_, orgentity10_.Updated as Updated37_9_, orgentity10_.Abbreviation as Abbrevia7_37_9_, orgentity10_.T_Key as T8_37_9_, orgentity10_.Name as Name37_9_, orgentity10_.OfficialWebSite as Officia11_37_9_, orgentity10_.Parent as Parent37_9_, orgentity10_.PrimaryAddress as Primary13_37_9_, orgentity10_.WikipediaWebSite as Wikiped14_37_9_, orgentity10_.AgencyInfo as AgencyInfo37_9_, orgentity10_.T_Type as T10_37_9_, orgentity11_.dbID as dbID37_10_, orgentity11_.Created as Created37_10_, orgentity11_.dbVersion as dbVersion37_10_, orgentity11_.Origin as Origin37_10_, orgentity11_.Updated as Updated37_10_, orgentity11_.Abbreviation as Abbrevia7_37_10_, orgentity11_.T_Key as T8_37_10_, orgentity11_.Name as Name37_10_, orgentity11_.OfficialWebSite as Officia11_37_10_, orgentity11_.Parent as Parent37_10_, orgentity11_.PrimaryAddress as Primary13_37_10_, orgentity11_.WikipediaWebSite as Wikiped14_37_10_, orgentity11_.AgencyInfo as AgencyInfo37_10_, orgentity11_.T_Type as T10_37_10_, orgentity12_.dbID as dbID37_11_, orgentity12_.Created as Created37_11_, orgentity12_.dbVersion as dbVersion37_11_, orgentity12_.Origin as Origin37_11_, orgentity12_.Updated as Updated37_11_, orgentity12_.Abbreviation as Abbrevia7_37_11_, orgentity12_.T_Key as T8_37_11_, orgentity12_.Name as Name37_11_, orgentity12_.OfficialWebSite as Officia11_37_11_, orgentity12_.Parent as Parent37_11_, orgentity12_.PrimaryAddress as Primary13_37_11_, orgentity12_.WikipediaWebSite as Wikiped14_37_11_, orgentity12_.AgencyInfo as AgencyInfo37_11_, orgentity12_.T_Type as T10_37_11_, picture13_.dbID as dbID49_12_, picture13_.Created as Created49_12_, picture13_.dbVersion as dbVersion49_12_, picture13_.Origin as Origin49_12_, picture13_.Updated as Updated49_12_, picture13_.Caption as Caption49_12_, picture13_.Format as Format49_12_, picture13_.Image as Image49_12_, picture13_.Name as Name49_12_, picture13_.SourceURL as SourceURL49_12_, scorecard14_.dbID as dbID62_13_, scorecard14_.Created as Created62_13_, scorecard14_.dbVersion as dbVersion62_13_, scorecard14_.Origin as Origin62_13_, scorecard14_.Updated as Updated62_13_, scorecard14_.Environmental as Environm6_62_13_, scorecard14_.Health as Health62_13_, scorecard14_.Overall as Overall62_13_, scorecard14_.Safety as Safety62_13_, scorecardi15_.dbID as dbID63_14_, scorecardi15_.Created as Created63_14_, scorecardi15_.dbVersion as dbVersion63_14_, scorecardi15_.Origin as Origin63_14_, scorecardi15_.Updated as Updated63_14_, scorecardi15_.Name as Name63_14_, scorecardi15_.T_Rank as T7_63_14_, scorecardi15_.RankMax as RankMax63_14_, scorecardi15_.Rating as Rating63_14_, scorecardi15_.RatingMax as RatingMax63_14_, scorecardi16_.dbID as dbID63_15_, scorecardi16_.Created as Created63_15_, scorecardi16_.dbVersion as dbVersion63_15_, scorecardi16_.Origin as Origin63_15_, scorecardi16_.Updated as Updated63_15_, scorecardi16_.Name as Name63_15_, scorecardi16_.T_Rank as T7_63_15_, scorecardi16_.RankMax as RankMax63_15_, scorecardi16_.Rating as Rating63_15_, scorecardi16_.RatingMax as RatingMax63_15_, scorecardi17_.dbID as dbID63_16_, scorecardi17_.Created as Created63_16_, scorecardi17_.dbVersion as dbVersion63_16_, scorecardi17_.Origin as Origin63_16_, scorecardi17_.Updated as Updated63_16_, scorecardi17_.Name as Name63_16_, scorecardi17_.T_Rank as T7_63_16_, scorecardi17_.RankMax as RankMax63_16_, scorecardi17_.Rating as Rating63_16_, scorecardi17_.RatingMax as RatingMax63_16_, scorecardi18_.dbID as dbID63_17_, scorecardi18_.Created as Created63_17_, scorecardi18_.dbVersion as dbVersion63_17_, scorecardi18_.Origin as Origin63_17_, scorecardi18_.Updated as Updated63_17_, scorecardi18_.Name as Name63_17_, scorecardi18_.T_Rank as T7_63_17_, scorecardi18_.RankMax as RankMax63_17_, scorecardi18_.Rating as Rating63_17_, scorecardi18_.RatingMax as RatingMax63_17_, vesselspec19_.dbID as dbID74_18_, vesselspec19_.Created as Created74_18_, vesselspec19_.dbVersion as dbVersion74_18_, vesselspec19_.Origin as Origin74_18_, vesselspec19_.Updated as Updated74_18_, vesselspec19_.Beam as Beam74_18_, vesselspec19_.CabinsTotal as CabinsTo7_74_18_, vesselspec19_.CrewTotal as CrewTotal74_18_, vesselspec19_.DeadWeightTonnage as DeadWeig9_74_18_, vesselspec19_.DecksTotal as DecksTotal74_18_, vesselspec19_.Draft as Draft74_18_, vesselspec19_.GrossRegisterTonnage as GrossRe12_74_18_, vesselspec19_.GrossTonnage as GrossTo13_74_18_, vesselspec19_.Height as Height74_18_, vesselspec19_.T_Length as T15_74_18_, vesselspec19_.NetTonnage as NetTonnage74_18_, vesselspec19_.PassengerTotal as Passeng17_74_18_, vesselspec19_.Propulsion as Propulsion74_18_, vesselspec19_.T_Range as T19_74_18_, vesselspec19_.SpeedMax as SpeedMax74_18_ from OrgEntity_BuiltVessels builtvesse0_ inner join Vessel vessel1_ on builtvesse0_.Vessel_id=vessel1_.dbID left outer join CurrencyAmount currencyam2_ on vessel1_.BuildCost=currencyam2_.dbID left outer join Currency currency3_ on currencyam2_.Currency=currency3_.dbID left outer join Organization orgentity4_ on vessel1_.Builder=orgentity4_.dbID left outer join WebSite website5_ on orgentity4_.OfficialWebSite=website5_.dbID left outer join Organization organizati6_ on orgentity4_.Parent=organizati6_.dbID left outer join Address address7_ on orgentity4_.PrimaryAddress=address7_.dbID left outer join WebSite website8_ on orgentity4_.WikipediaWebSite=website8_.dbID left outer join AgencyInfo agencyinfo9_ on orgentity4_.AgencyInfo=agencyinfo9_.dbID left outer join Organization orgentity10_ on vessel1_.T_Operator=orgentity10_.dbID left outer join Organization orgentity11_ on vessel1_.T_Owner=orgentity11_.dbID left outer join Organization orgentity12_ on vessel1_.PortOfRegistry=orgentity12_.dbID left outer join Picture picture13_ on vessel1_.PrimaryPicture=picture13_.dbID left outer join ScoreCard scorecard14_ on vessel1_.ScoreCard=scorecard14_.dbID left outer join ScoreCardItem scorecardi15_ on scorecard14_.Environmental=scorecardi15_.dbID left outer join ScoreCardItem scorecardi16_ on scorecard14_.Health=scorecardi16_.dbID left outer join ScoreCardItem scorecardi17_ on scorecard14_.Overall=scorecardi17_.dbID left outer join ScoreCardItem scorecardi18_ on scorecard14_.Safety=scorecardi18_.dbID left outer join VesselSpecification vesselspec19_ on vessel1_.Specification=vesselspec19_.dbID where builtvesse0_.OrgEntity_id=?
Hibernate: select registered0_.OrgEntity_id as OrgEntity1_37_19_, registered0_.Vessel_id as Vessel2_36_19_, vessel1_.dbID as dbID71_0_, vessel1_.Created as Created71_0_, vessel1_.dbVersion as dbVersion71_0_, vessel1_.Origin as Origin71_0_, vessel1_.Updated as Updated71_0_, vessel1_.BuildCost as BuildCost71_0_, vessel1_.Builder as Builder71_0_, vessel1_.BuilderYardNumber as BuilderY6_71_0_, vessel1_.CallSign as CallSign71_0_, vessel1_.CountryRegistryLabel as CountryR8_71_0_, vessel1_.CountryRegistryNumber as CountryR9_71_0_, vessel1_.DNVID as DNVID71_0_, vessel1_.Description as Descrip11_71_0_, vessel1_.Features as Features71_0_, vessel1_.FinalDisposition as FinalDi13_71_0_, vessel1_.HullNumber as HullNumber71_0_, vessel1_.IMO as IMO71_0_, vessel1_.T_Key as T16_71_0_, vessel1_.LloydsNumber as LloydsN17_71_0_, vessel1_.MMSI as MMSI71_0_, vessel1_.Name as Name71_0_, vessel1_.NameShort as NameShort71_0_, vessel1_.T_Operator as T34_71_0_, vessel1_.T_Owner as T35_71_0_, vessel1_.PortOfRegistry as PortOfR36_71_0_, vessel1_.PrimaryPicture as Primary37_71_0_, vessel1_.Route as Route71_0_, vessel1_.ScoreCard as ScoreCard71_0_, vessel1_.SortRankEnvironmental as SortRan22_71_0_, vessel1_.SortRankHealth as SortRan23_71_0_, vessel1_.SortRankOverall as SortRan24_71_0_, vessel1_.SortRankSafety as SortRan25_71_0_, vessel1_.Specification as Specifi39_71_0_, vessel1_.T_Status as T26_71_0_, vessel1_.StatusSummary as StatusS27_71_0_, vessel1_.T_Type as T28_71_0_, vessel1_.USCGDocNumber as USCGDoc29_71_0_, vessel1_.VIN as VIN71_0_, vessel1_.VesselClass as VesselC31_71_0_, currencyam2_.dbID as dbID17_1_, currencyam2_.Created as Created17_1_, currencyam2_.dbVersion as dbVersion17_1_, currencyam2_.Origin as Origin17_1_, currencyam2_.Updated as Updated17_1_, currencyam2_.Amount as Amount17_1_, currencyam2_.Currency as Currency17_1_, currency3_.dbID as dbID16_2_, currency3_.Created as Created16_2_, currency3_.dbVersion as dbVersion16_2_, currency3_.Origin as Origin16_2_, currency3_.Updated as Updated16_2_, currency3_.Name as Name16_2_, currency3_.Name3 as Name7_16_2_, currency3_.Symbol as Symbol16_2_, orgentity4_.dbID as dbID37_3_, orgentity4_.Created as Created37_3_, orgentity4_.dbVersion as dbVersion37_3_, orgentity4_.Origin as Origin37_3_, orgentity4_.Updated as Updated37_3_, orgentity4_.Abbreviation as Abbrevia7_37_3_, orgentity4_.T_Key as T8_37_3_, orgentity4_.Name as Name37_3_, orgentity4_.OfficialWebSite as Officia11_37_3_, orgentity4_.Parent as Parent37_3_, orgentity4_.PrimaryAddress as Primary13_37_3_, orgentity4_.WikipediaWebSite as Wikiped14_37_3_, orgentity4_.AgencyInfo as AgencyInfo37_3_, orgentity4_.T_Type as T10_37_3_, website5_.dbID as dbID79_4_, website5_.Created as Created79_4_, website5_.dbVersion as dbVersion79_4_, website5_.Origin as Origin79_4_, website5_.Updated as Updated79_4_, website5_.Title as Title79_4_, website5_.URL as URL79_4_, organizati6_.dbID as dbID37_5_, organizati6_.Created as Created37_5_, organizati6_.dbVersion as dbVersion37_5_, organizati6_.Origin as Origin37_5_, organizati6_.Updated as Updated37_5_, organizati6_.Abbreviation as Abbrevia7_37_5_, organizati6_.T_Key as T8_37_5_, organizati6_.Name as Name37_5_, organizati6_.OfficialWebSite as Officia11_37_5_, organizati6_.Parent as Parent37_5_, organizati6_.PrimaryAddress as Primary13_37_5_, organizati6_.WikipediaWebSite as Wikiped14_37_5_, organizati6_.AgencyInfo as AgencyInfo37_5_, organizati6_.T_Type as T10_37_5_, organizati6_.DTYPE as DTYPE37_5_, address7_.dbID as dbID3_6_, address7_.Created as Created3_6_, address7_.dbVersion as dbVersion3_6_, address7_.Origin as Origin3_6_, address7_.Updated as Updated3_6_, address7_.Address1 as Address6_3_6_, address7_.Address2 as Address7_3_6_, address7_.Address3 as Address8_3_6_, address7_.City as City3_6_, address7_.Country as Country3_6_, address7_.CountryState as Country15_3_6_, address7_.NickName as NickName3_6_, address7_.Person as Person3_6_, address7_.PostalCode as PostalCode3_6_, address7_.T_State as T12_3_6_, address7_.T_Type as T13_3_6_, website8_.dbID as dbID79_7_, website8_.Created as Created79_7_, website8_.dbVersion as dbVersion79_7_, website8_.Origin as Origin79_7_, website8_.Updated as Updated79_7_, website8_.Title as Title79_7_, website8_.URL as URL79_7_, agencyinfo9_.dbID as dbID4_8_, agencyinfo9_.Created as Created4_8_, agencyinfo9_.dbVersion as dbVersion4_8_, agencyinfo9_.Origin as Origin4_8_, agencyinfo9_.Updated as Updated4_8_, agencyinfo9_.HealthInspectionSatisfactoryScore as HealthIn6_4_8_, agencyinfo9_.HealthInspectionSatisfactoryScoreMaxPossible as HealthIn7_4_8_, orgentity10_.dbID as dbID37_9_, orgentity10_.Created as Created37_9_, orgentity10_.dbVersion as dbVersion37_9_, orgentity10_.Origin as Origin37_9_, orgentity10_.Updated as Updated37_9_, orgentity10_.Abbreviation as Abbrevia7_37_9_, orgentity10_.T_Key as T8_37_9_, orgentity10_.Name as Name37_9_, orgentity10_.OfficialWebSite as Officia11_37_9_, orgentity10_.Parent as Parent37_9_, orgentity10_.PrimaryAddress as Primary13_37_9_, orgentity10_.WikipediaWebSite as Wikiped14_37_9_, orgentity10_.AgencyInfo as AgencyInfo37_9_, orgentity10_.T_Type as T10_37_9_, orgentity11_.dbID as dbID37_10_, orgentity11_.Created as Created37_10_, orgentity11_.dbVersion as dbVersion37_10_, orgentity11_.Origin as Origin37_10_, orgentity11_.Updated as Updated37_10_, orgentity11_.Abbreviation as Abbrevia7_37_10_, orgentity11_.T_Key as T8_37_10_, orgentity11_.Name as Name37_10_, orgentity11_.OfficialWebSite as Officia11_37_10_, orgentity11_.Parent as Parent37_10_, orgentity11_.PrimaryAddress as Primary13_37_10_, orgentity11_.WikipediaWebSite as Wikiped14_37_10_, orgentity11_.AgencyInfo as AgencyInfo37_10_, orgentity11_.T_Type as T10_37_10_, orgentity12_.dbID as dbID37_11_, orgentity12_.Created as Created37_11_, orgentity12_.dbVersion as dbVersion37_11_, orgentity12_.Origin as Origin37_11_, orgentity12_.Updated as Updated37_11_, orgentity12_.Abbreviation as Abbrevia7_37_11_, orgentity12_.T_Key as T8_37_11_, orgentity12_.Name as Name37_11_, orgentity12_.OfficialWebSite as Officia11_37_11_, orgentity12_.Parent as Parent37_11_, orgentity12_.PrimaryAddress as Primary13_37_11_, orgentity12_.WikipediaWebSite as Wikiped14_37_11_, orgentity12_.AgencyInfo as AgencyInfo37_11_, orgentity12_.T_Type as T10_37_11_, picture13_.dbID as dbID49_12_, picture13_.Created as Created49_12_, picture13_.dbVersion as dbVersion49_12_, picture13_.Origin as Origin49_12_, picture13_.Updated as Updated49_12_, picture13_.Caption as Caption49_12_, picture13_.Format as Format49_12_, picture13_.Image as Image49_12_, picture13_.Name as Name49_12_, picture13_.SourceURL as SourceURL49_12_, scorecard14_.dbID as dbID62_13_, scorecard14_.Created as Created62_13_, scorecard14_.dbVersion as dbVersion62_13_, scorecard14_.Origin as Origin62_13_, scorecard14_.Updated as Updated62_13_, scorecard14_.Environmental as Environm6_62_13_, scorecard14_.Health as Health62_13_, scorecard14_.Overall as Overall62_13_, scorecard14_.Safety as Safety62_13_, scorecardi15_.dbID as dbID63_14_, scorecardi15_.Created as Created63_14_, scorecardi15_.dbVersion as dbVersion63_14_, scorecardi15_.Origin as Origin63_14_, scorecardi15_.Updated as Updated63_14_, scorecardi15_.Name as Name63_14_, scorecardi15_.T_Rank as T7_63_14_, scorecardi15_.RankMax as RankMax63_14_, scorecardi15_.Rating as Rating63_14_, scorecardi15_.RatingMax as RatingMax63_14_, scorecardi16_.dbID as dbID63_15_, scorecardi16_.Created as Created63_15_, scorecardi16_.dbVersion as dbVersion63_15_, scorecardi16_.Origin as Origin63_15_, scorecardi16_.Updated as Updated63_15_, scorecardi16_.Name as Name63_15_, scorecardi16_.T_Rank as T7_63_15_, scorecardi16_.RankMax as RankMax63_15_, scorecardi16_.Rating as Rating63_15_, scorecardi16_.RatingMax as RatingMax63_15_, scorecardi17_.dbID as dbID63_16_, scorecardi17_.Created as Created63_16_, scorecardi17_.dbVersion as dbVersion63_16_, scorecardi17_.Origin as Origin63_16_, scorecardi17_.Updated as Updated63_16_, scorecardi17_.Name as Name63_16_, scorecardi17_.T_Rank as T7_63_16_, scorecardi17_.RankMax as RankMax63_16_, scorecardi17_.Rating as Rating63_16_, scorecardi17_.RatingMax as RatingMax63_16_, scorecardi18_.dbID as dbID63_17_, scorecardi18_.Created as Created63_17_, scorecardi18_.dbVersion as dbVersion63_17_, scorecardi18_.Origin as Origin63_17_, scorecardi18_.Updated as Updated63_17_, scorecardi18_.Name as Name63_17_, scorecardi18_.T_Rank as T7_63_17_, scorecardi18_.RankMax as RankMax63_17_, scorecardi18_.Rating as Rating63_17_, scorecardi18_.RatingMax as RatingMax63_17_, vesselspec19_.dbID as dbID74_18_, vesselspec19_.Created as Created74_18_, vesselspec19_.dbVersion as dbVersion74_18_, vesselspec19_.Origin as Origin74_18_, vesselspec19_.Updated as Updated74_18_, vesselspec19_.Beam as Beam74_18_, vesselspec19_.CabinsTotal as CabinsTo7_74_18_, vesselspec19_.CrewTotal as CrewTotal74_18_, vesselspec19_.DeadWeightTonnage as DeadWeig9_74_18_, vesselspec19_.DecksTotal as DecksTotal74_18_, vesselspec19_.Draft as Draft74_18_, vesselspec19_.GrossRegisterTonnage as GrossRe12_74_18_, vesselspec19_.GrossTonnage as GrossTo13_74_18_, vesselspec19_.Height as Height74_18_, vesselspec19_.T_Length as T15_74_18_, vesselspec19_.NetTonnage as NetTonnage74_18_, vesselspec19_.PassengerTotal as Passeng17_74_18_, vesselspec19_.Propulsion as Propulsion74_18_, vesselspec19_.T_Range as T19_74_18_, vesselspec19_.SpeedMax as SpeedMax74_18_ from OrgEntity_RegisteredVessels registered0_ inner join Vessel vessel1_ on registered0_.Vessel_id=vessel1_.dbID left outer join CurrencyAmount currencyam2_ on vessel1_.BuildCost=currencyam2_.dbID left outer join Currency currency3_ on currencyam2_.Currency=currency3_.dbID left outer join Organization orgentity4_ on vessel1_.Builder=orgentity4_.dbID left outer join WebSite website5_ on orgentity4_.OfficialWebSite=website5_.dbID left outer join Organization organizati6_ on orgentity4_.Parent=organizati6_.dbID left outer join Address address7_ on orgentity4_.PrimaryAddress=address7_.dbID left outer join WebSite website8_ on orgentity4_.WikipediaWebSite=website8_.dbID left outer join AgencyInfo agencyinfo9_ on orgentity4_.AgencyInfo=agencyinfo9_.dbID left outer join Organization orgentity10_ on vessel1_.T_Operator=orgentity10_.dbID left outer join Organization orgentity11_ on vessel1_.T_Owner=orgentity11_.dbID left outer join Organization orgentity12_ on vessel1_.PortOfRegistry=orgentity12_.dbID left outer join Picture picture13_ on vessel1_.PrimaryPicture=picture13_.dbID left outer join ScoreCard scorecard14_ on vessel1_.ScoreCard=scorecard14_.dbID left outer join ScoreCardItem scorecardi15_ on scorecard14_.Environmental=scorecardi15_.dbID left outer join ScoreCardItem scorecardi16_ on scorecard14_.Health=scorecardi16_.dbID left outer join ScoreCardItem scorecardi17_ on scorecard14_.Overall=scorecardi17_.dbID left outer join ScoreCardItem scorecardi18_ on scorecard14_.Safety=scorecardi18_.dbID left outer join VesselSpecification vesselspec19_ on vessel1_.Specification=vesselspec19_.dbID where registered0_.OrgEntity_id=?
Hibernate: select ownedvesse0_.OrgEntity_id as OrgEntity1_37_19_, ownedvesse0_.Vessel_id as Vessel2_35_19_, vessel1_.dbID as dbID71_0_, vessel1_.Created as Created71_0_, vessel1_.dbVersion as dbVersion71_0_, vessel1_.Origin as Origin71_0_, vessel1_.Updated as Updated71_0_, vessel1_.BuildCost as BuildCost71_0_, vessel1_.Builder as Builder71_0_, vessel1_.BuilderYardNumber as BuilderY6_71_0_, vessel1_.CallSign as CallSign71_0_, vessel1_.CountryRegistryLabel as CountryR8_71_0_, vessel1_.CountryRegistryNumber as CountryR9_71_0_, vessel1_.DNVID as DNVID71_0_, vessel1_.Description as Descrip11_71_0_, vessel1_.Features as Features71_0_, vessel1_.FinalDisposition as FinalDi13_71_0_, vessel1_.HullNumber as HullNumber71_0_, vessel1_.IMO as IMO71_0_, vessel1_.T_Key as T16_71_0_, vessel1_.LloydsNumber as LloydsN17_71_0_, vessel1_.MMSI as MMSI71_0_, vessel1_.Name as Name71_0_, vessel1_.NameShort as NameShort71_0_, vessel1_.T_Operator as T34_71_0_, vessel1_.T_Owner as T35_71_0_, vessel1_.PortOfRegistry as PortOfR36_71_0_, vessel1_.PrimaryPicture as Primary37_71_0_, vessel1_.Route as Route71_0_, vessel1_.ScoreCard as ScoreCard71_0_, vessel1_.SortRankEnvironmental as SortRan22_71_0_, vessel1_.SortRankHealth as SortRan23_71_0_, vessel1_.SortRankOverall as SortRan24_71_0_, vessel1_.SortRankSafety as SortRan25_71_0_, vessel1_.Specification as Specifi39_71_0_, vessel1_.T_Status as T26_71_0_, vessel1_.StatusSummary as StatusS27_71_0_, vessel1_.T_Type as T28_71_0_, vessel1_.USCGDocNumber as USCGDoc29_71_0_, vessel1_.VIN as VIN71_0_, vessel1_.VesselClass as VesselC31_71_0_, currencyam2_.dbID as dbID17_1_, currencyam2_.Created as Created17_1_, currencyam2_.dbVersion as dbVersion17_1_, currencyam2_.Origin as Origin17_1_, currencyam2_.Updated as Updated17_1_, currencyam2_.Amount as Amount17_1_, currencyam2_.Currency as Currency17_1_, currency3_.dbID as dbID16_2_, currency3_.Created as Created16_2_, currency3_.dbVersion as dbVersion16_2_, currency3_.Origin as Origin16_2_, currency3_.Updated as Updated16_2_, currency3_.Name as Name16_2_, currency3_.Name3 as Name7_16_2_, currency3_.Symbol as Symbol16_2_, orgentity4_.dbID as dbID37_3_, orgentity4_.Created as Created37_3_, orgentity4_.dbVersion as dbVersion37_3_, orgentity4_.Origin as Origin37_3_, orgentity4_.Updated as Updated37_3_, orgentity4_.Abbreviation as Abbrevia7_37_3_, orgentity4_.T_Key as T8_37_3_, orgentity4_.Name as Name37_3_, orgentity4_.OfficialWebSite as Officia11_37_3_, orgentity4_.Parent as Parent37_3_, orgentity4_.PrimaryAddress as Primary13_37_3_, orgentity4_.WikipediaWebSite as Wikiped14_37_3_, orgentity4_.AgencyInfo as AgencyInfo37_3_, orgentity4_.T_Type as T10_37_3_, website5_.dbID as dbID79_4_, website5_.Created as Created79_4_, website5_.dbVersion as dbVersion79_4_, website5_.Origin as Origin79_4_, website5_.Updated as Updated79_4_, website5_.Title as Title79_4_, website5_.URL as URL79_4_, organizati6_.dbID as dbID37_5_, organizati6_.Created as Created37_5_, organizati6_.dbVersion as dbVersion37_5_, organizati6_.Origin as Origin37_5_, organizati6_.Updated as Updated37_5_, organizati6_.Abbreviation as Abbrevia7_37_5_, organizati6_.T_Key as T8_37_5_, organizati6_.Name as Name37_5_, organizati6_.OfficialWebSite as Officia11_37_5_, organizati6_.Parent as Parent37_5_, organizati6_.PrimaryAddress as Primary13_37_5_, organizati6_.WikipediaWebSite as Wikiped14_37_5_, organizati6_.AgencyInfo as AgencyInfo37_5_, organizati6_.T_Type as T10_37_5_, organizati6_.DTYPE as DTYPE37_5_, address7_.dbID as dbID3_6_, address7_.Created as Created3_6_, address7_.dbVersion as dbVersion3_6_, address7_.Origin as Origin3_6_, address7_.Updated as Updated3_6_, address7_.Address1 as Address6_3_6_, address7_.Address2 as Address7_3_6_, address7_.Address3 as Address8_3_6_, address7_.City as City3_6_, address7_.Country as Country3_6_, address7_.CountryState as Country15_3_6_, address7_.NickName as NickName3_6_, address7_.Person as Person3_6_, address7_.PostalCode as PostalCode3_6_, address7_.T_State as T12_3_6_, address7_.T_Type as T13_3_6_, website8_.dbID as dbID79_7_, website8_.Created as Created79_7_, website8_.dbVersion as dbVersion79_7_, website8_.Origin as Origin79_7_, website8_.Updated as Updated79_7_, website8_.Title as Title79_7_, website8_.URL as URL79_7_, agencyinfo9_.dbID as dbID4_8_, agencyinfo9_.Created as Created4_8_, agencyinfo9_.dbVersion as dbVersion4_8_, agencyinfo9_.Origin as Origin4_8_, agencyinfo9_.Updated as Updated4_8_, agencyinfo9_.HealthInspectionSatisfactoryScore as HealthIn6_4_8_, agencyinfo9_.HealthInspectionSatisfactoryScoreMaxPossible as HealthIn7_4_8_, orgentity10_.dbID as dbID37_9_, orgentity10_.Created as Created37_9_, orgentity10_.dbVersion as dbVersion37_9_, orgentity10_.Origin as Origin37_9_, orgentity10_.Updated as Updated37_9_, orgentity10_.Abbreviation as Abbrevia7_37_9_, orgentity10_.T_Key as T8_37_9_, orgentity10_.Name as Name37_9_, orgentity10_.OfficialWebSite as Officia11_37_9_, orgentity10_.Parent as Parent37_9_, orgentity10_.PrimaryAddress as Primary13_37_9_, orgentity10_.WikipediaWebSite as Wikiped14_37_9_, orgentity10_.AgencyInfo as AgencyInfo37_9_, orgentity10_.T_Type as T10_37_9_, orgentity11_.dbID as dbID37_10_, orgentity11_.Created as Created37_10_, orgentity11_.dbVersion as dbVersion37_10_, orgentity11_.Origin as Origin37_10_, orgentity11_.Updated as Updated37_10_, orgentity11_.Abbreviation as Abbrevia7_37_10_, orgentity11_.T_Key as T8_37_10_, orgentity11_.Name as Name37_10_, orgentity11_.OfficialWebSite as Officia11_37_10_, orgentity11_.Parent as Parent37_10_, orgentity11_.PrimaryAddress as Primary13_37_10_, orgentity11_.WikipediaWebSite as Wikiped14_37_10_, orgentity11_.AgencyInfo as AgencyInfo37_10_, orgentity11_.T_Type as T10_37_10_, orgentity12_.dbID as dbID37_11_, orgentity12_.Created as Created37_11_, orgentity12_.dbVersion as dbVersion37_11_, orgentity12_.Origin as Origin37_11_, orgentity12_.Updated as Updated37_11_, orgentity12_.Abbreviation as Abbrevia7_37_11_, orgentity12_.T_Key as T8_37_11_, orgentity12_.Name as Name37_11_, orgentity12_.OfficialWebSite as Officia11_37_11_, orgentity12_.Parent as Parent37_11_, orgentity12_.PrimaryAddress as Primary13_37_11_, orgentity12_.WikipediaWebSite as Wikiped14_37_11_, orgentity12_.AgencyInfo as AgencyInfo37_11_, orgentity12_.T_Type as T10_37_11_, picture13_.dbID as dbID49_12_, picture13_.Created as Created49_12_, picture13_.dbVersion as dbVersion49_12_, picture13_.Origin as Origin49_12_, picture13_.Updated as Updated49_12_, picture13_.Caption as Caption49_12_, picture13_.Format as Format49_12_, picture13_.Image as Image49_12_, picture13_.Name as Name49_12_, picture13_.SourceURL as SourceURL49_12_, scorecard14_.dbID as dbID62_13_, scorecard14_.Created as Created62_13_, scorecard14_.dbVersion as dbVersion62_13_, scorecard14_.Origin as Origin62_13_, scorecard14_.Updated as Updated62_13_, scorecard14_.Environmental as Environm6_62_13_, scorecard14_.Health as Health62_13_, scorecard14_.Overall as Overall62_13_, scorecard14_.Safety as Safety62_13_, scorecardi15_.dbID as dbID63_14_, scorecardi15_.Created as Created63_14_, scorecardi15_.dbVersion as dbVersion63_14_, scorecardi15_.Origin as Origin63_14_, scorecardi15_.Updated as Updated63_14_, scorecardi15_.Name as Name63_14_, scorecardi15_.T_Rank as T7_63_14_, scorecardi15_.RankMax as RankMax63_14_, scorecardi15_.Rating as Rating63_14_, scorecardi15_.RatingMax as RatingMax63_14_, scorecardi16_.dbID as dbID63_15_, scorecardi16_.Created as Created63_15_, scorecardi16_.dbVersion as dbVersion63_15_, scorecardi16_.Origin as Origin63_15_, scorecardi16_.Updated as Updated63_15_, scorecardi16_.Name as Name63_15_, scorecardi16_.T_Rank as T7_63_15_, scorecardi16_.RankMax as RankMax63_15_, scorecardi16_.Rating as Rating63_15_, scorecardi16_.RatingMax as RatingMax63_15_, scorecardi17_.dbID as dbID63_16_, scorecardi17_.Created as Created63_16_, scorecardi17_.dbVersion as dbVersion63_16_, scorecardi17_.Origin as Origin63_16_, scorecardi17_.Updated as Updated63_16_, scorecardi17_.Name as Name63_16_, scorecardi17_.T_Rank as T7_63_16_, scorecardi17_.RankMax as RankMax63_16_, scorecardi17_.Rating as Rating63_16_, scorecardi17_.RatingMax as RatingMax63_16_, scorecardi18_.dbID as dbID63_17_, scorecardi18_.Created as Created63_17_, scorecardi18_.dbVersion as dbVersion63_17_, scorecardi18_.Origin as Origin63_17_, scorecardi18_.Updated as Updated63_17_, scorecardi18_.Name as Name63_17_, scorecardi18_.T_Rank as T7_63_17_, scorecardi18_.RankMax as RankMax63_17_, scorecardi18_.Rating as Rating63_17_, scorecardi18_.RatingMax as RatingMax63_17_, vesselspec19_.dbID as dbID74_18_, vesselspec19_.Created as Created74_18_, vesselspec19_.dbVersion as dbVersion74_18_, vesselspec19_.Origin as Origin74_18_, vesselspec19_.Updated as Updated74_18_, vesselspec19_.Beam as Beam74_18_, vesselspec19_.CabinsTotal as CabinsTo7_74_18_, vesselspec19_.CrewTotal as CrewTotal74_18_, vesselspec19_.DeadWeightTonnage as DeadWeig9_74_18_, vesselspec19_.DecksTotal as DecksTotal74_18_, vesselspec19_.Draft as Draft74_18_, vesselspec19_.GrossRegisterTonnage as GrossRe12_74_18_, vesselspec19_.GrossTonnage as GrossTo13_74_18_, vesselspec19_.Height as Height74_18_, vesselspec19_.T_Length as T15_74_18_, vesselspec19_.NetTonnage as NetTonnage74_18_, vesselspec19_.PassengerTotal as Passeng17_74_18_, vesselspec19_.Propulsion as Propulsion74_18_, vesselspec19_.T_Range as T19_74_18_, vesselspec19_.SpeedMax as SpeedMax74_18_ from OrgEntity_OwnedVessels ownedvesse0_ inner join Vessel vessel1_ on ownedvesse0_.Vessel_id=vessel1_.dbID left outer join CurrencyAmount currencyam2_ on vessel1_.BuildCost=currencyam2_.dbID left outer join Currency currency3_ on currencyam2_.Currency=currency3_.dbID left outer join Organization orgentity4_ on vessel1_.Builder=orgentity4_.dbID left outer join WebSite website5_ on orgentity4_.OfficialWebSite=website5_.dbID left outer join Organization organizati6_ on orgentity4_.Parent=organizati6_.dbID left outer join Address address7_ on orgentity4_.PrimaryAddress=address7_.dbID left outer join WebSite website8_ on orgentity4_.WikipediaWebSite=website8_.dbID left outer join AgencyInfo agencyinfo9_ on orgentity4_.AgencyInfo=agencyinfo9_.dbID left outer join Organization orgentity10_ on vessel1_.T_Operator=orgentity10_.dbID left outer join Organization orgentity11_ on vessel1_.T_Owner=orgentity11_.dbID left outer join Organization orgentity12_ on vessel1_.PortOfRegistry=orgentity12_.dbID left outer join Picture picture13_ on vessel1_.PrimaryPicture=picture13_.dbID left outer join ScoreCard scorecard14_ on vessel1_.ScoreCard=scorecard14_.dbID left outer join ScoreCardItem scorecardi15_ on scorecard14_.Environmental=scorecardi15_.dbID left outer join ScoreCardItem scorecardi16_ on scorecard14_.Health=scorecardi16_.dbID left outer join ScoreCardItem scorecardi17_ on scorecard14_.Overall=scorecardi17_.dbID left outer join ScoreCardItem scorecardi18_ on scorecard14_.Safety=scorecardi18_.dbID left outer join VesselSpecification vesselspec19_ on vessel1_.Specification=vesselspec19_.dbID where ownedvesse0_.OrgEntity_id=?
Hibernate: select operatedve0_.OrgEntity_id as OrgEntity1_37_19_, operatedve0_.Vessel_id as Vessel2_34_19_, vessel1_.dbID as dbID71_0_, vessel1_.Created as Created71_0_, vessel1_.dbVersion as dbVersion71_0_, vessel1_.Origin as Origin71_0_, vessel1_.Updated as Updated71_0_, vessel1_.BuildCost as BuildCost71_0_, vessel1_.Builder as Builder71_0_, vessel1_.BuilderYardNumber as BuilderY6_71_0_, vessel1_.CallSign as CallSign71_0_, vessel1_.CountryRegistryLabel as CountryR8_71_0_, vessel1_.CountryRegistryNumber as CountryR9_71_0_, vessel1_.DNVID as DNVID71_0_, vessel1_.Description as Descrip11_71_0_, vessel1_.Features as Features71_0_, vessel1_.FinalDisposition as FinalDi13_71_0_, vessel1_.HullNumber as HullNumber71_0_, vessel1_.IMO as IMO71_0_, vessel1_.T_Key as T16_71_0_, vessel1_.LloydsNumber as LloydsN17_71_0_, vessel1_.MMSI as MMSI71_0_, vessel1_.Name as Name71_0_, vessel1_.NameShort as NameShort71_0_, vessel1_.T_Operator as T34_71_0_, vessel1_.T_Owner as T35_71_0_, vessel1_.PortOfRegistry as PortOfR36_71_0_, vessel1_.PrimaryPicture as Primary37_71_0_, vessel1_.Route as Route71_0_, vessel1_.ScoreCard as ScoreCard71_0_, vessel1_.SortRankEnvironmental as SortRan22_71_0_, vessel1_.SortRankHealth as SortRan23_71_0_, vessel1_.SortRankOverall as SortRan24_71_0_, vessel1_.SortRankSafety as SortRan25_71_0_, vessel1_.Specification as Specifi39_71_0_, vessel1_.T_Status as T26_71_0_, vessel1_.StatusSummary as StatusS27_71_0_, vessel1_.T_Type as T28_71_0_, vessel1_.USCGDocNumber as USCGDoc29_71_0_, vessel1_.VIN as VIN71_0_, vessel1_.VesselClass as VesselC31_71_0_, currencyam2_.dbID as dbID17_1_, currencyam2_.Created as Created17_1_, currencyam2_.dbVersion as dbVersion17_1_, currencyam2_.Origin as Origin17_1_, currencyam2_.Updated as Updated17_1_, currencyam2_.Amount as Amount17_1_, currencyam2_.Currency as Currency17_1_, currency3_.dbID as dbID16_2_, currency3_.Created as Created16_2_, currency3_.dbVersion as dbVersion16_2_, currency3_.Origin as Origin16_2_, currency3_.Updated as Updated16_2_, currency3_.Name as Name16_2_, currency3_.Name3 as Name7_16_2_, currency3_.Symbol as Symbol16_2_, orgentity4_.dbID as dbID37_3_, orgentity4_.Created as Created37_3_, orgentity4_.dbVersion as dbVersion37_3_, orgentity4_.Origin as Origin37_3_, orgentity4_.Updated as Updated37_3_, orgentity4_.Abbreviation as Abbrevia7_37_3_, orgentity4_.T_Key as T8_37_3_, orgentity4_.Name as Name37_3_, orgentity4_.OfficialWebSite as Officia11_37_3_, orgentity4_.Parent as Parent37_3_, orgentity4_.PrimaryAddress as Primary13_37_3_, orgentity4_.WikipediaWebSite as Wikiped14_37_3_, orgentity4_.AgencyInfo as AgencyInfo37_3_, orgentity4_.T_Type as T10_37_3_, website5_.dbID as dbID79_4_, website5_.Created as Created79_4_, website5_.dbVersion as dbVersion79_4_, website5_.Origin as Origin79_4_, website5_.Updated as Updated79_4_, website5_.Title as Title79_4_, website5_.URL as URL79_4_, organizati6_.dbID as dbID37_5_, organizati6_.Created as Created37_5_, organizati6_.dbVersion as dbVersion37_5_, organizati6_.Origin as Origin37_5_, organizati6_.Updated as Updated37_5_, organizati6_.Abbreviation as Abbrevia7_37_5_, organizati6_.T_Key as T8_37_5_, organizati6_.Name as Name37_5_, organizati6_.OfficialWebSite as Officia11_37_5_, organizati6_.Parent as Parent37_5_, organizati6_.PrimaryAddress as Primary13_37_5_, organizati6_.WikipediaWebSite as Wikiped14_37_5_, organizati6_.AgencyInfo as AgencyInfo37_5_, organizati6_.T_Type as T10_37_5_, organizati6_.DTYPE as DTYPE37_5_, address7_.dbID as dbID3_6_, address7_.Created as Created3_6_, address7_.dbVersion as dbVersion3_6_, address7_.Origin as Origin3_6_, address7_.Updated as Updated3_6_, address7_.Address1 as Address6_3_6_, address7_.Address2 as Address7_3_6_, address7_.Address3 as Address8_3_6_, address7_.City as City3_6_, address7_.Country as Country3_6_, address7_.CountryState as Country15_3_6_, address7_.NickName as NickName3_6_, address7_.Person as Person3_6_, address7_.PostalCode as PostalCode3_6_, address7_.T_State as T12_3_6_, address7_.T_Type as T13_3_6_, website8_.dbID as dbID79_7_, website8_.Created as Created79_7_, website8_.dbVersion as dbVersion79_7_, website8_.Origin as Origin79_7_, website8_.Updated as Updated79_7_, website8_.Title as Title79_7_, website8_.URL as URL79_7_, agencyinfo9_.dbID as dbID4_8_, agencyinfo9_.Created as Created4_8_, agencyinfo9_.dbVersion as dbVersion4_8_, agencyinfo9_.Origin as Origin4_8_, agencyinfo9_.Updated as Updated4_8_, agencyinfo9_.HealthInspectionSatisfactoryScore as HealthIn6_4_8_, agencyinfo9_.HealthInspectionSatisfactoryScoreMaxPossible as HealthIn7_4_8_, orgentity10_.dbID as dbID37_9_, orgentity10_.Created as Created37_9_, orgentity10_.dbVersion as dbVersion37_9_, orgentity10_.Origin as Origin37_9_, orgentity10_.Updated as Updated37_9_, orgentity10_.Abbreviation as Abbrevia7_37_9_, orgentity10_.T_Key as T8_37_9_, orgentity10_.Name as Name37_9_, orgentity10_.OfficialWebSite as Officia11_37_9_, orgentity10_.Parent as Parent37_9_, orgentity10_.PrimaryAddress as Primary13_37_9_, orgentity10_.WikipediaWebSite as Wikiped14_37_9_, orgentity10_.AgencyInfo as AgencyInfo37_9_, orgentity10_.T_Type as T10_37_9_, orgentity11_.dbID as dbID37_10_, orgentity11_.Created as Created37_10_, orgentity11_.dbVersion as dbVersion37_10_, orgentity11_.Origin as Origin37_10_, orgentity11_.Updated as Updated37_10_, orgentity11_.Abbreviation as Abbrevia7_37_10_, orgentity11_.T_Key as T8_37_10_, orgentity11_.Name as Name37_10_, orgentity11_.OfficialWebSite as Officia11_37_10_, orgentity11_.Parent as Parent37_10_, orgentity11_.PrimaryAddress as Primary13_37_10_, orgentity11_.WikipediaWebSite as Wikiped14_37_10_, orgentity11_.AgencyInfo as AgencyInfo37_10_, orgentity11_.T_Type as T10_37_10_, orgentity12_.dbID as dbID37_11_, orgentity12_.Created as Created37_11_, orgentity12_.dbVersion as dbVersion37_11_, orgentity12_.Origin as Origin37_11_, orgentity12_.Updated as Updated37_11_, orgentity12_.Abbreviation as Abbrevia7_37_11_, orgentity12_.T_Key as T8_37_11_, orgentity12_.Name as Name37_11_, orgentity12_.OfficialWebSite as Officia11_37_11_, orgentity12_.Parent as Parent37_11_, orgentity12_.PrimaryAddress as Primary13_37_11_, orgentity12_.WikipediaWebSite as Wikiped14_37_11_, orgentity12_.AgencyInfo as AgencyInfo37_11_, orgentity12_.T_Type as T10_37_11_, picture13_.dbID as dbID49_12_, picture13_.Created as Created49_12_, picture13_.dbVersion as dbVersion49_12_, picture13_.Origin as Origin49_12_, picture13_.Updated as Updated49_12_, picture13_.Caption as Caption49_12_, picture13_.Format as Format49_12_, picture13_.Image as Image49_12_, picture13_.Name as Name49_12_, picture13_.SourceURL as SourceURL49_12_, scorecard14_.dbID as dbID62_13_, scorecard14_.Created as Created62_13_, scorecard14_.dbVersion as dbVersion62_13_, scorecard14_.Origin as Origin62_13_, scorecard14_.Updated as Updated62_13_, scorecard14_.Environmental as Environm6_62_13_, scorecard14_.Health as Health62_13_, scorecard14_.Overall as Overall62_13_, scorecard14_.Safety as Safety62_13_, scorecardi15_.dbID as dbID63_14_, scorecardi15_.Created as Created63_14_, scorecardi15_.dbVersion as dbVersion63_14_, scorecardi15_.Origin as Origin63_14_, scorecardi15_.Updated as Updated63_14_, scorecardi15_.Name as Name63_14_, scorecardi15_.T_Rank as T7_63_14_, scorecardi15_.RankMax as RankMax63_14_, scorecardi15_.Rating as Rating63_14_, scorecardi15_.RatingMax as RatingMax63_14_, scorecardi16_.dbID as dbID63_15_, scorecardi16_.Created as Created63_15_, scorecardi16_.dbVersion as dbVersion63_15_, scorecardi16_.Origin as Origin63_15_, scorecardi16_.Updated as Updated63_15_, scorecardi16_.Name as Name63_15_, scorecardi16_.T_Rank as T7_63_15_, scorecardi16_.RankMax as RankMax63_15_, scorecardi16_.Rating as Rating63_15_, scorecardi16_.RatingMax as RatingMax63_15_, scorecardi17_.dbID as dbID63_16_, scorecardi17_.Created as Created63_16_, scorecardi17_.dbVersion as dbVersion63_16_, scorecardi17_.Origin as Origin63_16_, scorecardi17_.Updated as Updated63_16_, scorecardi17_.Name as Name63_16_, scorecardi17_.T_Rank as T7_63_16_, scorecardi17_.RankMax as RankMax63_16_, scorecardi17_.Rating as Rating63_16_, scorecardi17_.RatingMax as RatingMax63_16_, scorecardi18_.dbID as dbID63_17_, scorecardi18_.Created as Created63_17_, scorecardi18_.dbVersion as dbVersion63_17_, scorecardi18_.Origin as Origin63_17_, scorecardi18_.Updated as Updated63_17_, scorecardi18_.Name as Name63_17_, scorecardi18_.T_Rank as T7_63_17_, scorecardi18_.RankMax as RankMax63_17_, scorecardi18_.Rating as Rating63_17_, scorecardi18_.RatingMax as RatingMax63_17_, vesselspec19_.dbID as dbID74_18_, vesselspec19_.Created as Created74_18_, vesselspec19_.dbVersion as dbVersion74_18_, vesselspec19_.Origin as Origin74_18_, vesselspec19_.Updated as Updated74_18_, vesselspec19_.Beam as Beam74_18_, vesselspec19_.CabinsTotal as CabinsTo7_74_18_, vesselspec19_.CrewTotal as CrewTotal74_18_, vesselspec19_.DeadWeightTonnage as DeadWeig9_74_18_, vesselspec19_.DecksTotal as DecksTotal74_18_, vesselspec19_.Draft as Draft74_18_, vesselspec19_.GrossRegisterTonnage as GrossRe12_74_18_, vesselspec19_.GrossTonnage as GrossTo13_74_18_, vesselspec19_.Height as Height74_18_, vesselspec19_.T_Length as T15_74_18_, vesselspec19_.NetTonnage as NetTonnage74_18_, vesselspec19_.PassengerTotal as Passeng17_74_18_, vesselspec19_.Propulsion as Propulsion74_18_, vesselspec19_.T_Range as T19_74_18_, vesselspec19_.SpeedMax as SpeedMax74_18_ from OrgEntity_OperatedVessels operatedve0_ inner join Vessel vessel1_ on operatedve0_.Vessel_id=vessel1_.dbID left outer join CurrencyAmount currencyam2_ on vessel1_.BuildCost=currencyam2_.dbID left outer join Currency currency3_ on currencyam2_.Currency=currency3_.dbID left outer join Organization orgentity4_ on vessel1_.Builder=orgentity4_.dbID left outer join WebSite website5_ on orgentity4_.OfficialWebSite=website5_.dbID left outer join Organization organizati6_ on orgentity4_.Parent=organizati6_.dbID left outer join Address address7_ on orgentity4_.PrimaryAddress=address7_.dbID left outer join WebSite website8_ on orgentity4_.WikipediaWebSite=website8_.dbID left outer join AgencyInfo agencyinfo9_ on orgentity4_.AgencyInfo=agencyinfo9_.dbID left outer join Organization orgentity10_ on vessel1_.T_Operator=orgentity10_.dbID left outer join Organization orgentity11_ on vessel1_.T_Owner=orgentity11_.dbID left outer join Organization orgentity12_ on vessel1_.PortOfRegistry=orgentity12_.dbID left outer join Picture picture13_ on vessel1_.PrimaryPicture=picture13_.dbID left outer join ScoreCard scorecard14_ on vessel1_.ScoreCard=scorecard14_.dbID left outer join ScoreCardItem scorecardi15_ on scorecard14_.Environmental=scorecardi15_.dbID left outer join ScoreCardItem scorecardi16_ on scorecard14_.Health=scorecardi16_.dbID left outer join ScoreCardItem scorecardi17_ on scorecard14_.Overall=scorecardi17_.dbID left outer join ScoreCardItem scorecardi18_ on scorecard14_.Safety=scorecardi18_.dbID left outer join VesselSpecification vesselspec19_ on vessel1_.Specification=vesselspec19_.dbID where operatedve0_.OrgEntity_id=?
Hibernate: select subsidiari0_.Organization_Subsidiaries as Organiza1_37_6_, subsidiari0_.Subsidiaries_Organization as Subsidia2_39_6_, organizati1_.dbID as dbID37_0_, organizati1_.Created as Created37_0_, organizati1_.dbVersion as dbVersion37_0_, organizati1_.Origin as Origin37_0_, organizati1_.Updated as Updated37_0_, organizati1_.Abbreviation as Abbrevia7_37_0_, organizati1_.T_Key as T8_37_0_, organizati1_.Name as Name37_0_, organizati1_.OfficialWebSite as Officia11_37_0_, organizati1_.Parent as Parent37_0_, organizati1_.PrimaryAddress as Primary13_37_0_, organizati1_.WikipediaWebSite as Wikiped14_37_0_, organizati1_.AgencyInfo as AgencyInfo37_0_, organizati1_.T_Type as T10_37_0_, organizati1_.DTYPE as DTYPE37_0_, website2_.dbID as dbID79_1_, website2_.Created as Created79_1_, website2_.dbVersion as dbVersion79_1_, website2_.Origin as Origin79_1_, website2_.Updated as Updated79_1_, website2_.Title as Title79_1_, website2_.URL as URL79_1_, organizati3_.dbID as dbID37_2_, organizati3_.Created as Created37_2_, organizati3_.dbVersion as dbVersion37_2_, organizati3_.Origin as Origin37_2_, organizati3_.Updated as Updated37_2_, organizati3_.Abbreviation as Abbrevia7_37_2_, organizati3_.T_Key as T8_37_2_, organizati3_.Name as Name37_2_, organizati3_.OfficialWebSite as Officia11_37_2_, organizati3_.Parent as Parent37_2_, organizati3_.PrimaryAddress as Primary13_37_2_, organizati3_.WikipediaWebSite as Wikiped14_37_2_, organizati3_.AgencyInfo as AgencyInfo37_2_, organizati3_.T_Type as T10_37_2_, organizati3_.DTYPE as DTYPE37_2_, address4_.dbID as dbID3_3_, address4_.Created as Created3_3_, address4_.dbVersion as dbVersion3_3_, address4_.Origin as Origin3_3_, address4_.Updated as Updated3_3_, address4_.Address1 as Address6_3_3_, address4_.Address2 as Address7_3_3_, address4_.Address3 as Address8_3_3_, address4_.City as City3_3_, address4_.Country as Country3_3_, address4_.CountryState as Country15_3_3_, address4_.NickName as NickName3_3_, address4_.Person as Person3_3_, address4_.PostalCode as PostalCode3_3_, address4_.T_State as T12_3_3_, address4_.T_Type as T13_3_3_, website5_.dbID as dbID79_4_, website5_.Created as Created79_4_, website5_.dbVersion as dbVersion79_4_, website5_.Origin as Origin79_4_, website5_.Updated as Updated79_4_, website5_.Title as Title79_4_, website5_.URL as URL79_4_, agencyinfo6_.dbID as dbID4_5_, agencyinfo6_.Created as Created4_5_, agencyinfo6_.dbVersion as dbVersion4_5_, agencyinfo6_.Origin as Origin4_5_, agencyinfo6_.Updated as Updated4_5_, agencyinfo6_.HealthInspectionSatisfactoryScore as HealthIn6_4_5_, agencyinfo6_.HealthInspectionSatisfactoryScoreMaxPossible as HealthIn7_4_5_ from Organization_Subsidiaries subsidiari0_ inner join Organization organizati1_ on subsidiari0_.Subsidiaries_Organization=organizati1_.dbID left outer join WebSite website2_ on organizati1_.OfficialWebSite=website2_.dbID left outer join Organization organizati3_ on organizati1_.Parent=organizati3_.dbID left outer join Address address4_ on organizati3_.PrimaryAddress=address4_.dbID left outer join WebSite website5_ on organizati3_.WikipediaWebSite=website5_.dbID left outer join AgencyInfo agencyinfo6_ on organizati3_.AgencyInfo=agencyinfo6_.dbID where subsidiari0_.Organization_Subsidiaries=?
Hibernate: select organizati0_.dbID as dbID37_, organizati0_.Created as Created37_, organizati0_.dbVersion as dbVersion37_, organizati0_.Origin as Origin37_, organizati0_.Updated as Updated37_, organizati0_.Abbreviation as Abbrevia7_37_, organizati0_.T_Key as T8_37_, organizati0_.Name as Name37_, organizati0_.OfficialWebSite as Officia11_37_, organizati0_.Parent as Parent37_, organizati0_.PrimaryAddress as Primary13_37_, organizati0_.WikipediaWebSite as Wikiped14_37_, organizati0_.AgencyInfo as AgencyInfo37_, organizati0_.T_Type as T10_37_, organizati0_.DTYPE as DTYPE37_ from Organization organizati0_ where organizati0_.Parent=? limit ?
Hibernate: select organizati0_.dbID as dbID37_, organizati0_.Created as Created37_, organizati0_.dbVersion as dbVersion37_, organizati0_.Origin as Origin37_, organizati0_.Updated as Updated37_, organizati0_.Abbreviation as Abbrevia7_37_, organizati0_.T_Key as T8_37_, organizati0_.Name as Name37_, organizati0_.OfficialWebSite as Officia11_37_, organizati0_.Parent as Parent37_, organizati0_.PrimaryAddress as Primary13_37_, organizati0_.WikipediaWebSite as Wikiped14_37_, organizati0_.AgencyInfo as AgencyInfo37_, organizati0_.T_Type as T10_37_, organizati0_.DTYPE as DTYPE37_ from Organization organizati0_ where ? in (select subsidiari1_.Subsidiaries_Organization from Organization_Subsidiaries subsidiari1_ where organizati0_.dbID=subsidiari1_.Organization_Subsidiaries) limit ?
Hibernate: select incidentin0_.dbID as dbID25_, incidentin0_.Created as Created25_, incidentin0_.dbVersion as dbVersion25_, incidentin0_.Origin as Origin25_, incidentin0_.Updated as Updated25_, incidentin0_.Brief as Brief25_, incidentin0_.CasualtyReport as Casualt13_25_, incidentin0_.DetailsUrl as DetailsUrl25_, incidentin0_.IncidentDate as Incident8_25_, incidentin0_.InvestigatingAgency as Investi14_25_, incidentin0_.InvestigatingUnit as Investig9_25_, incidentin0_.Nature as Nature25_, incidentin0_.T_Role as T11_25_, incidentin0_.T_Type as T12_25_ from IncidentInvestigation incidentin0_ where incidentin0_.InvestigatingAgency=? limit ?
Hibernate: select activityre0_.dbID as dbID0_, activityre0_.Created as Created0_, activityre0_.dbVersion as dbVersion0_, activityre0_.Origin as Origin0_, activityre0_.Updated as Updated0_, activityre0_.ActivityDate as Activity6_0_, activityre0_.Agency as Agency0_, activityre0_.AgencyPort as AgencyPort0_, activityre0_.CaseNumber as CaseNumber0_, activityre0_.Description as Descript9_0_, activityre0_.HealthReport as HealthR13_0_, activityre0_.IncidentInvestigation as Inciden14_0_, activityre0_.T_Number as T10_0_, activityre0_.OperationControlInfo as Operati15_0_, activityre0_.T_Type as T11_0_ from ActivityReport activityre0_ where activityre0_.Agency=? limit ?
Hibernate: select healthinsp0_.dbID as dbID23_, healthinsp0_.Created as Created23_, healthinsp0_.dbVersion as dbVersion23_, healthinsp0_.Origin as Origin23_, healthinsp0_.Updated as Updated23_, healthinsp0_.Agency as Agency23_, healthinsp0_.T_Count as T6_23_, healthinsp0_.InspectionFrequencyDaysAverage as Inspecti7_23_, healthinsp0_.ItemsAverage as ItemsAve8_23_, healthinsp0_.ItemsCount as ItemsCount23_, healthinsp0_.ReportCountAverage as ReportC10_23_, healthinsp0_.ScoreAverage as ScoreAv11_23_, healthinsp0_.ScoreMaxPossible as ScoreMa12_23_, healthinsp0_.ScoreSatisfactory as ScoreSa13_23_ from HealthInspectionStat healthinsp0_ where healthinsp0_.Agency=? limit ?
Hibernate: select namerecord0_.dbID as dbID58_, namerecord0_.Created as Created58_, namerecord0_.dbVersion as dbVersion58_, namerecord0_.Origin as Origin58_, namerecord0_.Updated as Updated58_, namerecord0_.T_End as T7_58_, namerecord0_.Granularity as Granular8_58_, namerecord0_.T_Start as T9_58_, namerecord0_.Name as Name58_, namerecord0_.Organization as Organiz11_58_ from Record namerecord0_ where namerecord0_.DTYPE='NameRecord' and namerecord0_.Organization=? limit ?
Hibernate: select agencyinfo0_.dbID as dbID4_, agencyinfo0_.Created as Created4_, agencyinfo0_.dbVersion as dbVersion4_, agencyinfo0_.Origin as Origin4_, agencyinfo0_.Updated as Updated4_, agencyinfo0_.HealthInspectionSatisfactoryScore as HealthIn6_4_, agencyinfo0_.HealthInspectionSatisfactoryScoreMaxPossible as HealthIn7_4_ from AgencyInfo agencyinfo0_ where agencyinfo0_.dbID=? limit ?
2013-10-09 09:15:17,120 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 0, SQLState: 07001
2013-10-09 09:15:17,120 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] No value specified for parameter 2
2013-10-09 09:15:17,126 ERROR [cruisedomo.admintool.Main] runCmd: Exception while running CLI: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: No value specified for parameter 2
  #0: org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
  #1: org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
  #2: org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
  #3: org.eclipse.emf.texo.server.store.BaseDao.getReferingObjects(BaseDao.java:276)
  #4: org.eclipse.emf.texo.server.store.EntityManagerObjectStore.getReferingObjects(EntityManagerObjectStore.java:304)
  #5: com.magnicomp.model.manager.common.ModelManagerCore.getRefCount(ModelManagerCore.java:187)
  #6: cruisedomo.model.tool.OrgScrubber.scrub(OrgScrubber.java:145)
  #7: cruisedomo.admintool.commands.CliOrgEntity.scrub(CliOrgEntity.java:665)
  #8: cruisedomo.admintool.commands.CliOrgEntity.run(CliOrgEntity.java:123)
  #9: com.magnicomp.admintool.AdminToolCore.runCmd(AdminToolCore.java:427)
  #10: com.magnicomp.admintool.AdminToolCore.run(AdminToolCore.java:597)
  #11: com.magnicomp.admintool.AdminToolCore.Main(AdminToolCore.java:295)
  #12: cruisedomo.admintool.Main.main(Main.java:92)
org.hibernate.exception.SQLGrammarException: No value specified for parameter 2
  #0: org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
  #1: org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  #2: org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
  #3: org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
  #4: org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
  #5: org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
  #6: com.sun.proxy.$Proxy27.executeQuery(Unknown Source)
  #7: org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
  #8: org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
  #9: org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
  #10: org.hibernate.loader.Loader.doQuery(Loader.java:899)
  #11: org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  #12: org.hibernate.loader.Loader.doList(Loader.java:2516)
  #13: org.hibernate.loader.Loader.doList(Loader.java:2502)
  #14: org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2332)
  #15: org.hibernate.loader.Loader.list(Loader.java:2327)
  #16: org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
  #17: org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
  #18: org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
  #19: org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
  #20: org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
  #21: org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
  #22: org.eclipse.emf.texo.server.store.BaseDao.getReferingObjects(BaseDao.java:276)
  #23: org.eclipse.emf.texo.server.store.EntityManagerObjectStore.getReferingObjects(EntityManagerObjectStore.java:304)
  #24: com.magnicomp.model.manager.common.ModelManagerCore.getRefCount(ModelManagerCore.java:187)
  #25: cruisedomo.model.tool.OrgScrubber.scrub(OrgScrubber.java:145)
  #26: cruisedomo.admintool.commands.CliOrgEntity.scrub(CliOrgEntity.java:665)
  #27: cruisedomo.admintool.commands.CliOrgEntity.run(CliOrgEntity.java:123)
  #28: com.magnicomp.admintool.AdminToolCore.runCmd(AdminToolCore.java:427)
  #29: com.magnicomp.admintool.AdminToolCore.run(AdminToolCore.java:597)
  #30: com.magnicomp.admintool.AdminToolCore.Main(AdminToolCore.java:295)
  #31: cruisedomo.admintool.Main.main(Main.java:92)
java.sql.SQLException: No value specified for parameter 2
  #0: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
  #1: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
  #2: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
  #3: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
  #4: com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2611)
  #5: com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2586)
  #6: com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2510)
  #7: com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2259)
  #8: com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
  #9: sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
  #10: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  #11: java.lang.reflect.Method.invoke(Method.java:601)
  #12: org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
  #13: org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
  #14: com.sun.proxy.$Proxy27.executeQuery(Unknown Source)
  #15: org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
  #16: org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
  #17: org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
  #18: org.hibernate.loader.Loader.doQuery(Loader.java:899)
  #19: org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  #20: org.hibernate.loader.Loader.doList(Loader.java:2516)
  #21: org.hibernate.loader.Loader.doList(Loader.java:2502)
  #22: org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2332)
  #23: org.hibernate.loader.Loader.list(Loader.java:2327)
  #24: org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
  #25: org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
  #26: org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
  #27: org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
  #28: org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
  #29: org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
  #30: org.eclipse.emf.texo.server.store.BaseDao.getReferingObjects(BaseDao.java:276)
  #31: org.eclipse.emf.texo.server.store.EntityManagerObjectStore.getReferingObjects(EntityManagerObjectStore.java:304)
  #32: com.magnicomp.model.manager.common.ModelManagerCore.getRefCount(ModelManagerCore.java:187)
  #33: cruisedomo.model.tool.OrgScrubber.scrub(OrgScrubber.java:145)
  #34: cruisedomo.admintool.commands.CliOrgEntity.scrub(CliOrgEntity.java:665)
  #35: cruisedomo.admintool.commands.CliOrgEntity.run(CliOrgEntity.java:123)
  #36: com.magnicomp.admintool.AdminToolCore.runCmd(AdminToolCore.java:427)
  #37: com.magnicomp.admintool.AdminToolCore.run(AdminToolCore.java:597)
  #38: com.magnicomp.admintool.AdminToolCore.Main(AdminToolCore.java:295)
  #39: cruisedomo.admintool.Main.main(Main.java:92)