Hibernate version:
Spring/Hibernate 1.0.0.2

Hello All!

I am fairly new to NHibernate, but have used Hibernate for a bit now successfully. However, I haven't done a lot of logging. I am now trying to log NHibernate, and am seeing something I'm not sure is good. Can someone tell me if the following snippet from my log, which occurs where the Spring SessionFactory is getting created, is correct? If not, why would the same query be firing four times in a row for each query?

Thanks!


Debug level Hibernate log excerpt:
DEBUG 2007-05-02 14:04:47,352 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.User: SELECT user0_.UserID as UserID7_0_, user0_.DUZ as DUZ7_0_, user0_.FirstName as FirstName7_0_, user0_.LastName as LastName7_0_, user0_.SiteID as SiteID7_0_, user0_.SysAdmin as SysAdmin7_0_ FROM dbo.tUser user0_ WHERE user0_.UserID=?
DEBUG 2007-05-02 14:04:47,352 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.User: SELECT user0_.UserID as UserID7_0_, user0_.DUZ as DUZ7_0_, user0_.FirstName as FirstName7_0_, user0_.LastName as LastName7_0_, user0_.SiteID as SiteID7_0_, user0_.SysAdmin as SysAdmin7_0_ FROM dbo.tUser user0_ WHERE user0_.UserID=?
DEBUG 2007-05-02 14:04:47,352 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.User: SELECT user0_.UserID as UserID7_0_, user0_.DUZ as DUZ7_0_, user0_.FirstName as FirstName7_0_, user0_.LastName as LastName7_0_, user0_.SiteID as SiteID7_0_, user0_.SysAdmin as SysAdmin7_0_ FROM dbo.tUser user0_ WHERE user0_.UserID=?
DEBUG 2007-05-02 14:04:47,352 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.User: SELECT user0_.UserID as UserID7_0_, user0_.DUZ as DUZ7_0_, user0_.FirstName as FirstName7_0_, user0_.LastName as LastName7_0_, user0_.SiteID as SiteID7_0_, user0_.SysAdmin as SysAdmin7_0_ FROM dbo.tUser user0_ WHERE user0_.UserID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Site: SELECT site0_.SiteID as SiteID5_0_, site0_.Address1 as Address2_5_0_, site0_.Address2 as Address3_5_0_, site0_.City as City5_0_, site0_.FaciltyName as FaciltyN5_5_0_, site0_.Moniker as Moniker5_0_, site0_.Phone as Phone5_0_, site0_.SiteDomain as SiteDomain5_0_, site0_.SiteName as SiteName5_0_, site0_.State as State5_0_, site0_.VISNID as VISNID5_0_, site0_.ZipCode as ZipCode5_0_ FROM dbo.tSite site0_ WHERE site0_.SiteID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Site: SELECT site0_.SiteID as SiteID5_0_, site0_.Address1 as Address2_5_0_, site0_.Address2 as Address3_5_0_, site0_.City as City5_0_, site0_.FaciltyName as FaciltyN5_5_0_, site0_.Moniker as Moniker5_0_, site0_.Phone as Phone5_0_, site0_.SiteDomain as SiteDomain5_0_, site0_.SiteName as SiteName5_0_, site0_.State as State5_0_, site0_.VISNID as VISNID5_0_, site0_.ZipCode as ZipCode5_0_ FROM dbo.tSite site0_ WHERE site0_.SiteID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Site: SELECT site0_.SiteID as SiteID5_0_, site0_.Address1 as Address2_5_0_, site0_.Address2 as Address3_5_0_, site0_.City as City5_0_, site0_.FaciltyName as FaciltyN5_5_0_, site0_.Moniker as Moniker5_0_, site0_.Phone as Phone5_0_, site0_.SiteDomain as SiteDomain5_0_, site0_.SiteName as SiteName5_0_, site0_.State as State5_0_, site0_.VISNID as VISNID5_0_, site0_.ZipCode as ZipCode5_0_ FROM dbo.tSite site0_ WHERE site0_.SiteID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Site: SELECT site0_.SiteID as SiteID5_0_, site0_.Address1 as Address2_5_0_, site0_.Address2 as Address3_5_0_, site0_.City as City5_0_, site0_.FaciltyName as FaciltyN5_5_0_, site0_.Moniker as Moniker5_0_, site0_.Phone as Phone5_0_, site0_.SiteDomain as SiteDomain5_0_, site0_.SiteName as SiteName5_0_, site0_.State as State5_0_, site0_.VISNID as VISNID5_0_, site0_.ZipCode as ZipCode5_0_ FROM dbo.tSite site0_ WHERE site0_.SiteID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramUser: SELECT programuse0_.ProgramUserID as ProgramU1_2_0_, programuse0_.ProgramID as ProgramID2_0_, programuse0_.UserID as UserID2_0_, programuse0_.RoleID as RoleID2_0_, programuse0_.DateInactive as DateInac5_2_0_, programuse0_.Inactive as Inactive2_0_ FROM dbo.tProgramUser programuse0_ WHERE programuse0_.ProgramUserID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramUser: SELECT programuse0_.ProgramUserID as ProgramU1_2_0_, programuse0_.ProgramID as ProgramID2_0_, programuse0_.UserID as UserID2_0_, programuse0_.RoleID as RoleID2_0_, programuse0_.DateInactive as DateInac5_2_0_, programuse0_.Inactive as Inactive2_0_ FROM dbo.tProgramUser programuse0_ WHERE programuse0_.ProgramUserID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramUser: SELECT programuse0_.ProgramUserID as ProgramU1_2_0_, programuse0_.ProgramID as ProgramID2_0_, programuse0_.UserID as UserID2_0_, programuse0_.RoleID as RoleID2_0_, programuse0_.DateInactive as DateInac5_2_0_, programuse0_.Inactive as Inactive2_0_ FROM dbo.tProgramUser programuse0_ WHERE programuse0_.ProgramUserID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramUser: SELECT programuse0_.ProgramUserID as ProgramU1_2_0_, programuse0_.ProgramID as ProgramID2_0_, programuse0_.UserID as UserID2_0_, programuse0_.RoleID as RoleID2_0_, programuse0_.DateInactive as DateInac5_2_0_, programuse0_.Inactive as Inactive2_0_ FROM dbo.tProgramUser programuse0_ WHERE programuse0_.ProgramUserID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Visn: SELECT visn0_.VISNID as VISNID8_0_, visn0_.Description as Descript2_8_0_, visn0_.VISNName as VISNName8_0_ FROM dbo.tVISN visn0_ WHERE visn0_.VISNID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Visn: SELECT visn0_.VISNID as VISNID8_0_, visn0_.Description as Descript2_8_0_, visn0_.VISNName as VISNName8_0_ FROM dbo.tVISN visn0_ WHERE visn0_.VISNID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Visn: SELECT visn0_.VISNID as VISNID8_0_, visn0_.Description as Descript2_8_0_, visn0_.VISNName as VISNName8_0_ FROM dbo.tVISN visn0_ WHERE visn0_.VISNID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Visn: SELECT visn0_.VISNID as VISNID8_0_, visn0_.Description as Descript2_8_0_, visn0_.VISNName as VISNName8_0_ FROM dbo.tVISN visn0_ WHERE visn0_.VISNID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramSite: SELECT programsit0_.ProgramSiteID as ProgramS1_1_0_, programsit0_.ProgramID as ProgramID1_0_, programsit0_.SiteID as SiteID1_0_, programsit0_.LoadbyHL7 as LoadbyHL4_1_0_, programsit0_.OldAutoloader as OldAutol5_1_0_ FROM dbo.tProgramSite programsit0_ WHERE programsit0_.ProgramSiteID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramSite: SELECT programsit0_.ProgramSiteID as ProgramS1_1_0_, programsit0_.ProgramID as ProgramID1_0_, programsit0_.SiteID as SiteID1_0_, programsit0_.LoadbyHL7 as LoadbyHL4_1_0_, programsit0_.OldAutoloader as OldAutol5_1_0_ FROM dbo.tProgramSite programsit0_ WHERE programsit0_.ProgramSiteID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramSite: SELECT programsit0_.ProgramSiteID as ProgramS1_1_0_, programsit0_.ProgramID as ProgramID1_0_, programsit0_.SiteID as SiteID1_0_, programsit0_.LoadbyHL7 as LoadbyHL4_1_0_, programsit0_.OldAutoloader as OldAutol5_1_0_ FROM dbo.tProgramSite programsit0_ WHERE programsit0_.ProgramSiteID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramSite: SELECT programsit0_.ProgramSiteID as ProgramS1_1_0_, programsit0_.ProgramID as ProgramID1_0_, programsit0_.SiteID as SiteID1_0_, programsit0_.LoadbyHL7 as LoadbyHL4_1_0_, programsit0_.OldAutoloader as OldAutol5_1_0_ FROM dbo.tProgramSite programsit0_ WHERE programsit0_.ProgramSiteID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Program: SELECT program0_.ProgramID as ProgramID0_0_, program0_.Description as Descript2_0_0_, program0_.ProgramName as ProgramN3_0_0_ FROM dbo.tProgram program0_ WHERE program0_.ProgramID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Program: SELECT program0_.ProgramID as ProgramID0_0_, program0_.Description as Descript2_0_0_, program0_.ProgramName as ProgramN3_0_0_ FROM dbo.tProgram program0_ WHERE program0_.ProgramID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Program: SELECT program0_.ProgramID as ProgramID0_0_, program0_.Description as Descript2_0_0_, program0_.ProgramName as ProgramN3_0_0_ FROM dbo.tProgram program0_ WHERE program0_.ProgramID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Program: SELECT program0_.ProgramID as ProgramID0_0_, program0_.Description as Descript2_0_0_, program0_.ProgramName as ProgramN3_0_0_ FROM dbo.tProgram program0_ WHERE program0_.ProgramID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Role: SELECT role0_.RoleID as RoleID4_0_, role0_.Description as Descript2_4_0_, role0_.Role as Role4_0_, role0_.ShowRecord as ShowRecord4_0_ FROM dbo.tRole role0_ WHERE role0_.RoleID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Role: SELECT role0_.RoleID as RoleID4_0_, role0_.Description as Descript2_4_0_, role0_.Role as Role4_0_, role0_.ShowRecord as ShowRecord4_0_ FROM dbo.tRole role0_ WHERE role0_.RoleID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Role: SELECT role0_.RoleID as RoleID4_0_, role0_.Description as Descript2_4_0_, role0_.Role as Role4_0_, role0_.ShowRecord as ShowRecord4_0_ FROM dbo.tRole role0_ WHERE role0_.RoleID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.Role: SELECT role0_.RoleID as RoleID4_0_, role0_.Description as Descript2_4_0_, role0_.Role as Role4_0_, role0_.ShowRecord as ShowRecord4_0_ FROM dbo.tRole role0_ WHERE role0_.RoleID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramVISN: SELECT programvis0_.ProgramVISNID as ProgramV1_3_0_, programvis0_.ProgramID as ProgramID3_0_, programvis0_.VISNID as VISNID3_0_ FROM dbo.tProgramVISN programvis0_ WHERE programvis0_.ProgramVISNID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramVISN: SELECT programvis0_.ProgramVISNID as ProgramV1_3_0_, programvis0_.ProgramID as ProgramID3_0_, programvis0_.VISNID as VISNID3_0_ FROM dbo.tProgramVISN programvis0_ WHERE programvis0_.ProgramVISNID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramVISN: SELECT programvis0_.ProgramVISNID as ProgramV1_3_0_, programvis0_.ProgramID as ProgramID3_0_, programvis0_.VISNID as VISNID3_0_ FROM dbo.tProgramVISN programvis0_ WHERE programvis0_.ProgramVISNID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.ProgramVISN: SELECT programvis0_.ProgramVISNID as ProgramV1_3_0_, programvis0_.ProgramID as ProgramID3_0_, programvis0_.VISNID as VISNID3_0_ FROM dbo.tProgramVISN programvis0_ WHERE programvis0_.ProgramVISNID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.SpecialUser: SELECT specialuse0_.SpecialUserID as SpecialU1_6_0_, specialuse0_.SiteID as SiteID6_0_, specialuse0_.UserID as UserID6_0_, specialuse0_.ActiveDate as ActiveDate6_0_, specialuse0_.AllVHA as AllVHA6_0_, specialuse0_.CreatedByID as CreatedB6_6_0_, specialuse0_.DateAdded as DateAdded6_0_, specialuse0_.DateModified as DateModi8_6_0_, specialuse0_.DeactiveDate as Deactive9_6_0_, specialuse0_.ModifiedByID as Modifie10_6_0_, specialuse0_.ProgramID as ProgramID6_0_, specialuse0_.Reason as Reason6_0_, specialuse0_.RoleID as RoleID6_0_ FROM dbo.tSpecialUser specialuse0_ WHERE specialuse0_.SpecialUserID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.SpecialUser: SELECT specialuse0_.SpecialUserID as SpecialU1_6_0_, specialuse0_.SiteID as SiteID6_0_, specialuse0_.UserID as UserID6_0_, specialuse0_.ActiveDate as ActiveDate6_0_, specialuse0_.AllVHA as AllVHA6_0_, specialuse0_.CreatedByID as CreatedB6_6_0_, specialuse0_.DateAdded as DateAdded6_0_, specialuse0_.DateModified as DateModi8_6_0_, specialuse0_.DeactiveDate as Deactive9_6_0_, specialuse0_.ModifiedByID as Modifie10_6_0_, specialuse0_.ProgramID as ProgramID6_0_, specialuse0_.Reason as Reason6_0_, specialuse0_.RoleID as RoleID6_0_ FROM dbo.tSpecialUser specialuse0_ WHERE specialuse0_.SpecialUserID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.SpecialUser: SELECT specialuse0_.SpecialUserID as SpecialU1_6_0_, specialuse0_.SiteID as SiteID6_0_, specialuse0_.UserID as UserID6_0_, specialuse0_.ActiveDate as ActiveDate6_0_, specialuse0_.AllVHA as AllVHA6_0_, specialuse0_.CreatedByID as CreatedB6_6_0_, specialuse0_.DateAdded as DateAdded6_0_, specialuse0_.DateModified as DateModi8_6_0_, specialuse0_.DeactiveDate as Deactive9_6_0_, specialuse0_.ModifiedByID as Modifie10_6_0_, specialuse0_.ProgramID as ProgramID6_0_, specialuse0_.Reason as Reason6_0_, specialuse0_.RoleID as RoleID6_0_ FROM dbo.tSpecialUser specialuse0_ WHERE specialuse0_.SpecialUserID=?
DEBUG 2007-05-02 14:04:47,368 Entity.AbstractEntityLoader - Static select for entity gov.va.medora.framework.SpecialUser: SELECT specialuse0_.SpecialUserID as SpecialU1_6_0_, specialuse0_.SiteID as SiteID6_0_, specialuse0_.UserID as UserID6_0_, specialuse0_.ActiveDate as ActiveDate6_0_, specialuse0_.AllVHA as AllVHA6_0_, specialuse0_.CreatedByID as CreatedB6_6_0_, specialuse0_.DateAdded as DateAdded6_0_, specialuse0_.DateModified as DateModi8_6_0_, specialuse0_.DeactiveDate as Deactive9_6_0_, specialuse0_.ModifiedByID as Modifie10_6_0_, specialuse0_.ProgramID as ProgramID6_0_, specialuse0_.Reason as Reason6_0_, specialuse0_.RoleID as RoleID6_0_ FROM dbo.tSpecialUser specialuse0_ WHERE specialuse0_.SpecialUserID=?
DEBUG 2007-05-02 14:04:47,399 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.Visn.Sites: SELECT sites0_.VISNID as VISNID__1_, sites0_.SiteID as SiteID1_, sites0_.SiteID as SiteID5_0_, sites0_.Address1 as Address2_5_0_, sites0_.Address2 as Address3_5_0_, sites0_.City as City5_0_, sites0_.FaciltyName as FaciltyN5_5_0_, sites0_.Moniker as Moniker5_0_, sites0_.Phone as Phone5_0_, sites0_.SiteDomain as SiteDomain5_0_, sites0_.SiteName as SiteName5_0_, sites0_.State as State5_0_, sites0_.VISNID as VISNID5_0_, sites0_.ZipCode as ZipCode5_0_ FROM dbo.tSite sites0_ WHERE sites0_.VISNID=?
DEBUG 2007-05-02 14:04:47,399 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.Program.UsersForProgram: SELECT usersforpr0_.ProgramID as ProgramID__1_, usersforpr0_.ProgramUserID as ProgramU1_1_, usersforpr0_.ProgramUserID as ProgramU1_2_0_, usersforpr0_.ProgramID as ProgramID2_0_, usersforpr0_.UserID as UserID2_0_, usersforpr0_.RoleID as RoleID2_0_, usersforpr0_.DateInactive as DateInac5_2_0_, usersforpr0_.Inactive as Inactive2_0_ FROM dbo.tProgramUser usersforpr0_ WHERE usersforpr0_.ProgramID=?
DEBUG 2007-05-02 14:04:47,399 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.Role.ProgramUsers: SELECT programuse0_.RoleID as RoleID__1_, programuse0_.ProgramUserID as ProgramU1_1_, programuse0_.ProgramUserID as ProgramU1_2_0_, programuse0_.ProgramID as ProgramID2_0_, programuse0_.UserID as UserID2_0_, programuse0_.RoleID as RoleID2_0_, programuse0_.DateInactive as DateInac5_2_0_, programuse0_.Inactive as Inactive2_0_ FROM dbo.tProgramUser programuse0_ WHERE programuse0_.RoleID=?
DEBUG 2007-05-02 14:04:47,399 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.Program.SpecialUsers: SELECT specialuse0_.ProgramID as ProgramID__1_, specialuse0_.SpecialUserID as SpecialU1_1_, specialuse0_.SpecialUserID as SpecialU1_6_0_, specialuse0_.SiteID as SiteID6_0_, specialuse0_.UserID as UserID6_0_, specialuse0_.ActiveDate as ActiveDate6_0_, specialuse0_.AllVHA as AllVHA6_0_, specialuse0_.CreatedByID as CreatedB6_6_0_, specialuse0_.DateAdded as DateAdded6_0_, specialuse0_.DateModified as DateModi8_6_0_, specialuse0_.DeactiveDate as Deactive9_6_0_, specialuse0_.ModifiedByID as Modifie10_6_0_, specialuse0_.ProgramID as ProgramID6_0_, specialuse0_.Reason as Reason6_0_, specialuse0_.RoleID as RoleID6_0_ FROM dbo.tSpecialUser specialuse0_ WHERE specialuse0_.ProgramID=?
DEBUG 2007-05-02 14:04:47,415 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.User.ProgramsForUser: SELECT programsfo0_.UserID as UserID__1_, programsfo0_.ProgramUserID as ProgramU1_1_, programsfo0_.ProgramUserID as ProgramU1_2_0_, programsfo0_.ProgramID as ProgramID2_0_, programsfo0_.UserID as UserID2_0_, programsfo0_.RoleID as RoleID2_0_, programsfo0_.DateInactive as DateInac5_2_0_, programsfo0_.Inactive as Inactive2_0_ FROM dbo.tProgramUser programsfo0_ WHERE programsfo0_.UserID=?
DEBUG 2007-05-02 14:04:47,415 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.Program.ProgramSites: SELECT programsit0_.ProgramID as ProgramID__1_, programsit0_.ProgramSiteID as ProgramS1_1_, programsit0_.ProgramSiteID as ProgramS1_1_0_, programsit0_.ProgramID as ProgramID1_0_, programsit0_.SiteID as SiteID1_0_, programsit0_.LoadbyHL7 as LoadbyHL4_1_0_, programsit0_.OldAutoloader as OldAutol5_1_0_ FROM dbo.tProgramSite programsit0_ WHERE programsit0_.ProgramID=?
DEBUG 2007-05-02 14:04:47,415 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.Site.ProgramSites: SELECT programsit0_.SiteID as SiteID__1_, programsit0_.ProgramSiteID as ProgramS1_1_, programsit0_.ProgramSiteID as ProgramS1_1_0_, programsit0_.ProgramID as ProgramID1_0_, programsit0_.SiteID as SiteID1_0_, programsit0_.LoadbyHL7 as LoadbyHL4_1_0_, programsit0_.OldAutoloader as OldAutol5_1_0_ FROM dbo.tProgramSite programsit0_ WHERE programsit0_.SiteID=?
DEBUG 2007-05-02 14:04:47,415 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.User.SpecialUsers: SELECT specialuse0_.UserID as UserID__1_, specialuse0_.SpecialUserID as SpecialU1_1_, specialuse0_.SpecialUserID as SpecialU1_6_0_, specialuse0_.SiteID as SiteID6_0_, specialuse0_.UserID as UserID6_0_, specialuse0_.ActiveDate as ActiveDate6_0_, specialuse0_.AllVHA as AllVHA6_0_, specialuse0_.CreatedByID as CreatedB6_6_0_, specialuse0_.DateAdded as DateAdded6_0_, specialuse0_.DateModified as DateModi8_6_0_, specialuse0_.DeactiveDate as Deactive9_6_0_, specialuse0_.ModifiedByID as Modifie10_6_0_, specialuse0_.ProgramID as ProgramID6_0_, specialuse0_.Reason as Reason6_0_, specialuse0_.RoleID as RoleID6_0_ FROM dbo.tSpecialUser specialuse0_ WHERE specialuse0_.UserID=?
DEBUG 2007-05-02 14:04:47,415 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.Role.SpecialUsers: SELECT specialuse0_.RoleID as RoleID__1_, specialuse0_.SpecialUserID as SpecialU1_1_, specialuse0_.SpecialUserID as SpecialU1_6_0_, specialuse0_.SiteID as SiteID6_0_, specialuse0_.UserID as UserID6_0_, specialuse0_.ActiveDate as ActiveDate6_0_, specialuse0_.AllVHA as AllVHA6_0_, specialuse0_.CreatedByID as CreatedB6_6_0_, specialuse0_.DateAdded as DateAdded6_0_, specialuse0_.DateModified as DateModi8_6_0_, specialuse0_.DeactiveDate as Deactive9_6_0_, specialuse0_.ModifiedByID as Modifie10_6_0_, specialuse0_.ProgramID as ProgramID6_0_, specialuse0_.Reason as Reason6_0_, specialuse0_.RoleID as RoleID6_0_ FROM dbo.tSpecialUser specialuse0_ WHERE specialuse0_.RoleID=?
DEBUG 2007-05-02 14:04:47,415 Collection.OneToManyLoader - Static select for one-to-many gov.va.medora.framework.Site.Users: SELECT users0_.SiteID as SiteID__1_, users0_.UserID as UserID1_, users0_.UserID as UserID7_0_, users0_.DUZ as DUZ7_0_, users0_.FirstName as FirstName7_0_, users0_.LastName as LastName7_0_, users0_.SiteID as SiteID7_0_, users0_.SysAdmin as SysAdmin7_0_ FROM dbo.tUser users0_ WHERE users0_.SiteID=?
DEBUG 2007-05-02 14:04:47,415 Impl.SessionFactoryImpl - Instantiated session factory

Spring/Hibernate web.config snippet

<spring>
....
<d:dbProvider id="MedoraFrameworkDb" provider="System.Data.SqlClient" connectionString="Data Source=****;Database=****;User ID=****;Password=****;Trusted_Connection=False"/>

<object id="medoraFrameworkSessionFactory" type="Spring.Data.NHibernate.LocalSessionFactoryObject, Spring.Data.NHibernate12">
<property name="dbProvider" ref="MedoraFrameworkDb"/>
<property name="HibernateProperties">
<dictionary>
<entry key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
<entry key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect"/>
<entry key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver"/>
</dictionary>
</property>
<property name="MappingResources">
<list>
<value>~/src/main/resources/xml/hibernate/MedoraFrmwk/Program.hbm.xml</value>
<value>~/src/main/resources/xml/hibernate/MedoraFrmwk/ProgramSite.hbm.xml</value>
<value>~/src/main/resources/xml/hibernate/MedoraFrmwk/ProgramUser.hbm.xml</value>
<value>~/src/main/resources/xml/hibernate/MedoraFrmwk/ProgramVISN.hbm.xml</value>
<value>~/src/main/resources/xml/hibernate/MedoraFrmwk/Role.hbm.xml</value>
<value>~/src/main/resources/xml/hibernate/MedoraFrmwk/Site.hbm.xml</value>
<value>~/src/main/resources/xml/hibernate/MedoraFrmwk/SpecialUser.hbm.xml</value>
<value>~/src/main/resources/xml/hibernate/MedoraFrmwk/User.hbm.xml</value>
<value>~/src/main/resources/xml/hibernate/MedoraFrmwk/Visn.hbm.xml</value>
</list>
</property>
</object>
</objects>
</spring>