Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [Texo] getReferringObjects triggers exception
[Texo] getReferringObjects triggers exception [message #1129734] Tue, 08 October 2013 19:27 Go to next message
Mike Cooper is currently offline Mike Cooper
Messages: 45
Registered: February 2011
Member
Martin,

I'm hitting an exception when I use Texo (20131004...) to get the
count of references to an object.

Here's the method the triggers the exception:

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();
	}


And here is the full exception:

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)


Re: [Texo] getReferringObjects triggers exception [message #1129912 is a reply to message #1129734] Wed, 09 October 2013 00:08 Go to previous messageGo to next message
Martin Taal is currently offline Martin Taal
Messages: 5300
Registered: July 2009
Senior Member
Hi Mike,
It seems the error occurs in the SQL generated by Hibernate. Can you see what sql query gets generated also? To check
what this parameter 2 actually is.

Btw, the Texo jars are available on search.maven.org.

gr. Martin

On 10/09/2013 01:27 AM, Mike Cooper wrote:
> Martin,
>
> I'm hitting an exception when I use Texo (20131004...) to get the
> count of references to an object.
>
> Here's the method the triggers the exception:
>
>
> 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();
> }
>
>
> And here is the full exception:
>
>
> 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)
>
>
>


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org
Re: [Texo] getReferringObjects triggers exception [message #1130492 is a reply to message #1129912] Wed, 09 October 2013 12:18 Go to previous messageGo to next message
Mike Cooper is currently offline Mike Cooper
Messages: 45
Registered: February 2011
Member
Here is the trace with sql statements enabled:

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)

Re: [Texo] getReferringObjects triggers exception [message #1130515 is a reply to message #1130492] Wed, 09 October 2013 12:50 Go to previous messageGo to next message
Martin Taal is currently offline Martin Taal
Messages: 5300
Registered: July 2009
Senior Member
Seems to be the limit parameter, can you debug and see what the maxResults value is in the BaseDao.getReferingObjects
method?

This part:
if (maxResult > 0) {
qry.setMaxResults(maxResult);
}

gr. Martin

On 10/09/2013 06:18 PM, Mike Cooper wrote:
> Here is the trace with sql statements enabled:
>
>
> 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.prox
Re: [Texo] getReferringObjects triggers exception [message #1131607 is a reply to message #1130515] Thu, 10 October 2013 13:26 Go to previous messageGo to next message
Mike Cooper is currently offline Mike Cooper
Messages: 45
Registered: February 2011
Member
I did a debug session and maxResult is always 2. That's the value I am passing to getReferingObjects() as arg#2.

I tried changing the value to 10 but it had no effect.

Re: [Texo] getReferringObjects triggers exception [message #1131927 is a reply to message #1131607] Thu, 10 October 2013 18:18 Go to previous message
Martin Taal is currently offline Martin Taal
Messages: 5300
Registered: July 2009
Senior Member
Hi Mike,
Hmm I don't understand what/why it fails. Looking better at the log, it seems to fail here:
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

So on a query for specific object (see dbID=?), these queries normally don't need a limit parameter as only one is
expected. I am not sure where this query is fired from.

The only thing I can think of is if you do more debugging to see where the above query is coming from, why it is being
fired and why it has a limit parameter.

gr. Martin

On 10/10/2013 07:26 PM, Mike Cooper wrote:
> I did a debug session and maxResult is always 2. That's the value I am passing to getReferingObjects() as arg#2.
>
> I tried changing the value to 10 but it had no effect.
>
>


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org
So
Previous Topic:Generating code for NesC language
Next Topic:Avoid Collections.unmodifiableList generation
Goto Forum:
  


Current Time: Thu Apr 17 05:52:35 EDT 2014

Powered by FUDForum. Page generated in 0.02578 seconds