Hi,

I'm using NHibernate 1.2.1.4000 and SQL Server 2005 as db.

I'm mapping three objects with relation between them but I still have this message in log that I don't understand.

Could you explain me what does this mean (especially this sentence : NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 57 for the table ADR_Province province0_ with (updlock, rowlock)) ?

Thanks by advance.

PS: I couldn't post all data required, if you need more details, do not hesitate to ask me.

2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 407 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 207 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 107 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 57 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 31 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 27 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 25 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 23 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 21 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 19 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 17 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 15 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 13 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 11 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID=?
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 407 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 207 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 107 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 57 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 31 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 27 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 25 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 23 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 21 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 19 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 17 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 15 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 13 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 11 for the table ADR_Province province0_
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID in (?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ WHERE province0_.ID=?
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 407 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 207 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 107 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 57 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 31 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 27 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 25 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 23 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 21 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 19 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 17 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 15 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 13 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 11 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID=?
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 407 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 207 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 107 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 57 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 31 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 27 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 25 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 23 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 21 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 19 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 17 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 15 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 13 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 11 for the table ADR_Province province0_ with (updlock, rowlock)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID in (?, ?)
2008-03-12 18:35:27,659 [5268] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Entreprise.Province: SELECT province0_.ID as ID0_0_, province0_.Libelle as Libelle0_0_ FROM ADR_Province province0_ with (updlock, rowlock) WHERE province0_.ID=?

Thats nHibernates log output during configuration of the SessionFactory

So it's normal and i do not have to worry about, right ?

[Sorry mistake, I posted twice]

Hi,

didn't find your second posting.

When generating the select-statement for a mapped class the number of elements the statement will have is not counted correct. The where-part and the order-by-part are counted fixed as 3 elements for such queries but it seems they may consist of more and should be counted dynamically.

You may check this in SqlSelectBuilder.ToSqlString () in NHibernate\src\NHibernate-src\src\NHibernate\SqlCommand .

By this the select-query generation is a bit slower because space for the uncounted elements has to be reallocated. As this seems only be done once for each mapped class it shouldn't decrease performance very much.

Kind regards,

TomH