Home » Modeling » EMF » [Texo] getReferringObjects triggers exception
[Texo] getReferringObjects triggers exception [message #1129734] |
Tue, 08 October 2013 23:27 |
Mike Cooper Messages: 60 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 04:08 |
Martin Taal Messages: 5468 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 16:18 |
Mike Cooper Messages: 60 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 16:50 |
Martin Taal Messages: 5468 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 #1131927 is a reply to message #1131607] |
Thu, 10 October 2013 22:18 |
Martin Taal Messages: 5468 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
|
|
|
Goto Forum:
Current Time: Tue Sep 24 09:56:57 GMT 2024
Powered by FUDForum. Page generated in 0.03418 seconds
|