These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 7 posts ] 
  Previous topic | Next topic 
Author Message
fan194
 Post subject: Incorrect child records when quering
PostPosted: Thu Feb 05, 2009 3:55 am 
Newbie

Joined: Wed Feb 04, 2009 10:24 am
Posts: 3
Hi,

I've encounter problems fetching child records from a parent/child-relationship. Both the parent and the child information are being stored in separate db tables. I use SQL server 2000, 2005 (it doesn't matter in this case). I recieve the correct amount of child records BUT all the records are the same! (Seems like hibernate thinks it's not necessary to fetch all child rows since they all have the same parent_id...)
I've get the same problem, wether I use <bag> or not in the mappning files. From the dump below, I send an plain SQL statment, but it doesn't matter that either I've noticed.

A dump from the log file follows...

Any ideas, anyone!?
/Fredrik

2009-02-04 14:31:31,562 INFO 10 NHibernate.Cfg.Environment - NHibernate 2.0.1.4000 (2.0.1.4000)
2009-02-04 14:31:31,625 INFO 10 NHibernate.Cfg.Environment - Bytecode provider name : null
2009-02-04 14:31:31,640 INFO 10 NHibernate.Cfg.Configuration - Mapping resource: Common.Entity.entTyrMatningsTyp.hbm.xml
2009-02-04 14:31:31,671 INFO 10 NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-02-04 14:31:32,968 INFO 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapping class: Common.Entity.entTyrMatningsTyp -> TYR_MATNINGSTYP
2009-02-04 14:31:33,000 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TMA_ID -> TMA_ID, type: Int32
2009-02-04 14:31:33,015 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TMA_Name -> TMA_Name, type: String
2009-02-04 14:31:33,015 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TMA_TABLE -> TMA_TABLE, type: String
2009-02-04 14:31:33,031 INFO 10 NHibernate.Cfg.Configuration - Mapping resource: Common.Entity.entTyrTunnel.hbm.xml
2009-02-04 14:31:33,031 INFO 10 NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-02-04 14:31:33,031 INFO 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapping class: Common.Entity.entTyrTunnel -> TYR_TUNNEL
2009-02-04 14:31:33,031 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TTN_ID -> TTN_ID, type: Int32
2009-02-04 14:31:33,031 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TTN_Namn -> TTN_Namn, type: String
2009-02-04 14:31:33,031 INFO 10 NHibernate.Cfg.Configuration - Mapping resource: Common.Entity.entTyrGvrVal.hbm.xml
2009-02-04 14:31:33,031 INFO 10 NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-02-04 14:31:33,046 INFO 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapping class: Common.Entity.entTyrGvrVal -> TYR_GVR_VAL
2009-02-04 14:31:33,046 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TGV_TGRID -> TGV_TGRID, type: Int32
2009-02-04 14:31:33,046 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TGV_GvrLopnr -> TGV_GvrLopnr, type: String
2009-02-04 14:31:33,046 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TGV_Datum -> TGV_Datum, type: DateTime
2009-02-04 14:31:33,046 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TGV_Niva -> TGV_Niva, type: Int32
2009-02-04 14:31:33,046 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: Grundvatten -> TGV_TGRID, type: Common.Entity.entTyrGrundvatten
2009-02-04 14:31:33,046 INFO 10 NHibernate.Cfg.Configuration - Mapping resource: Common.Entity.entTyrGrundvatten.hbm.xml
2009-02-04 14:31:33,062 INFO 10 NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-02-04 14:31:33,078 INFO 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapping class: Common.Entity.entTyrGrundvatten -> TYR_GRUNDVATTEN
2009-02-04 14:31:33,078 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TGR_ID -> TGR_ID, type: Int32
2009-02-04 14:31:33,078 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: TGR_Namn -> TGR_Namn, type: String
2009-02-04 14:31:33,093 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped property: GvrValList, type: System.Collections.Generic.IList`1[[Common.Entity.entTyrGvrVal, Common.Entity, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]](Common.Entity.entTyrGrundvatten.GvrValList)
2009-02-04 14:31:33,093 INFO 10 NHibernate.Cfg.Configuration - checking mappings queue
2009-02-04 14:31:33,093 INFO 10 NHibernate.Cfg.Configuration - processing one-to-many association mappings
2009-02-04 14:31:33,093 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Second pass for collection: Common.Entity.entTyrGrundvatten.GvrValList
2009-02-04 14:31:33,093 INFO 10 NHibernate.Cfg.XmlHbmBinding.Binder - mapping collection: Common.Entity.entTyrGrundvatten.GvrValList -> TYR_GVR_VAL
2009-02-04 14:31:33,093 DEBUG 10 NHibernate.Cfg.XmlHbmBinding.Binder - Mapped collection key: TGV_TGRID, one-to-many: Common.Entity.entTyrGvrVal
2009-02-04 14:31:33,093 INFO 10 NHibernate.Cfg.Configuration - processing one-to-one association property references
2009-02-04 14:31:33,093 INFO 10 NHibernate.Cfg.Configuration - processing foreign key constraints
2009-02-04 14:31:33,109 DEBUG 10 NHibernate.Cfg.Configuration - resolving reference to class: Common.Entity.entTyrGrundvatten
2009-02-04 14:31:33,140 INFO 10 NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-02-04 14:31:33,140 INFO 10 NHibernate.Exceptions.SQLExceptionConverterFactory - Using dialect defined converter
2009-02-04 14:31:33,140 INFO 10 NHibernate.Connection.ConnectionProviderFactory - Initializing connection provider: NHibernate.Connection.DriverConnectionProvider
2009-02-04 14:31:33,140 INFO 10 NHibernate.Connection.ConnectionProvider - Configuring ConnectionProvider
2009-02-04 14:31:33,156 INFO 10 NHibernate.Cfg.SettingsFactory - Transaction factory: NHibernate.Transaction.AdoNetTransactionFactory
2009-02-04 14:31:33,156 INFO 10 NHibernate.Cfg.SettingsFactory - Optimize cache for minimal puts: False
2009-02-04 14:31:33,156 INFO 10 NHibernate.Cfg.SettingsFactory - Connection release mode: auto
2009-02-04 14:31:33,156 INFO 10 NHibernate.Cfg.SettingsFactory - Default batch fetch size: 1
2009-02-04 14:31:33,156 INFO 10 NHibernate.Cfg.SettingsFactory - echoing all SQL to stdout
2009-02-04 14:31:33,156 INFO 10 NHibernate.Cfg.SettingsFactory - Statistics: disabled
2009-02-04 14:31:33,156 INFO 10 NHibernate.Cfg.SettingsFactory - Query translator: NHibernate.Hql.Classic.ClassicQueryTranslatorFactory
2009-02-04 14:31:33,156 INFO 10 NHibernate.Cfg.SettingsFactory - Query language substitutions: {}
2009-02-04 14:31:33,156 INFO 10 NHibernate.Cfg.SettingsFactory - cache provider: NHibernate.Cache.NoCacheProvider, NHibernate, Version=2.0.1.4000, Culture=neutral, PublicKeyToken=aa95f207798dfdb4
2009-02-04 14:31:33,171 DEBUG 10 NHibernate.Cfg.SettingsFactory - Wrap result sets: disabled
2009-02-04 14:31:33,171 INFO 10 NHibernate.Cfg.SettingsFactory - Batcher factory: NHibernate.AdoNet.NonBatchingBatcherFactory, NHibernate, Version=2.0.1.4000, Culture=neutral, PublicKeyToken=aa95f207798dfdb4
2009-02-04 14:31:33,171 INFO 10 NHibernate.Cfg.SettingsFactory - Named query checking : enabled
2009-02-04 14:31:33,171 INFO 10 NHibernate.Impl.SessionFactoryImpl - building session factory
2009-02-04 14:31:33,171 DEBUG 10 NHibernate.Impl.SessionFactoryImpl - instantiating session factory with properties: {use_reflection_optimizer=False, bytecode.provider=null, connection.provider=NHibernate.Connection.DriverConnectionProvider, dialect=NHibernate.Dialect.MsSql2005Dialect, connection.driver_class=NHibernate.Driver.SqlClientDriver, connection.connection_string=Server=(local);Trusted_Connection=true;initial catalog=nHibernate;, show_sql=true}
2009-02-04 14:31:33,265 DEBUG 10 NHibernate.Tuple.Entity.AbstractEntityTuplizer - No custom accessors found for entity: Common.Entity.entTyrMatningsTyp
2009-02-04 14:31:33,265 DEBUG 10 NHibernate.Tuple.Entity.AbstractEntityTuplizer - No custom accessors found for entity: Common.Entity.entTyrMatningsTyp
2009-02-04 14:31:33,296 DEBUG 10 NHibernate.Tuple.Entity.AbstractEntityTuplizer - No custom accessors found for entity: Common.Entity.entTyrTunnel
2009-02-04 14:31:33,296 DEBUG 10 NHibernate.Tuple.Entity.AbstractEntityTuplizer - No custom accessors found for entity: Common.Entity.entTyrTunnel
2009-02-04 14:31:33,296 DEBUG 10 NHibernate.Tuple.Entity.AbstractEntityTuplizer - No custom accessors found for entity: Common.Entity.entTyrGvrVal
2009-02-04 14:31:33,296 DEBUG 10 NHibernate.Tuple.Entity.AbstractEntityTuplizer - No custom accessors found for entity: Common.Entity.entTyrGvrVal
2009-02-04 14:31:33,296 DEBUG 10 NHibernate.Tuple.Entity.AbstractEntityTuplizer - No custom accessors found for entity: Common.Entity.entTyrGrundvatten
2009-02-04 14:31:33,296 DEBUG 10 NHibernate.Tuple.Entity.AbstractEntityTuplizer - No custom accessors found for entity: Common.Entity.entTyrGrundvatten
2009-02-04 14:31:33,328 DEBUG 10 NHibernate.Persister.Collection.ICollectionPersister - Static SQL for collection: Common.Entity.entTyrGrundvatten.GvrValList
2009-02-04 14:31:33,328 DEBUG 10 NHibernate.Persister.Collection.ICollectionPersister - Row insert: UPDATE TYR_GVR_VAL SET TGV_TGRID = ? WHERE TGV_TGRID = ?
2009-02-04 14:31:33,343 DEBUG 10 NHibernate.Persister.Collection.ICollectionPersister - Row delete: UPDATE TYR_GVR_VAL SET TGV_TGRID = null WHERE TGV_TGRID = ? AND TGV_TGRID = ?
2009-02-04 14:31:33,343 DEBUG 10 NHibernate.Persister.Collection.ICollectionPersister - One-shot delete: UPDATE TYR_GVR_VAL SET TGV_TGRID = null WHERE TGV_TGRID = ?
2009-02-04 14:31:33,343 DEBUG 10 NHibernate.Impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
2009-02-04 14:31:33,343 DEBUG 10 NHibernate.Impl.SessionFactoryObjectFactory - registered: 8681f63404f34015b18f27131705d7db(unnamed)
2009-02-04 14:31:33,343 INFO 10 NHibernate.Impl.SessionFactoryObjectFactory - no name configured
2009-02-04 14:31:33,375 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Static SQL for entity: Common.Entity.entTyrTunnel
2009-02-04 14:31:33,375 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Version select: SELECT TTN_ID FROM TYR_TUNNEL WHERE TTN_ID = ?
2009-02-04 14:31:33,375 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Snapshot select: SELECT enttyrtunn_.TTN_ID, enttyrtunn_.TTN_Namn as TTN2_1_ FROM TYR_TUNNEL enttyrtunn_ WHERE enttyrtunn_.TTN_ID=?
2009-02-04 14:31:33,375 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Insert 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,375 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Update 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,375 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Delete 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrTunnel: SELECT enttyrtunn0_.TTN_ID as TTN1_1_0_, enttyrtunn0_.TTN_Namn as TTN2_1_0_ FROM TYR_TUNNEL enttyrtunn0_ WHERE enttyrtunn0_.TTN_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrTunnel: SELECT enttyrtunn0_.TTN_ID as TTN1_1_0_, enttyrtunn0_.TTN_Namn as TTN2_1_0_ FROM TYR_TUNNEL enttyrtunn0_ WHERE enttyrtunn0_.TTN_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrTunnel: SELECT enttyrtunn0_.TTN_ID as TTN1_1_0_, enttyrtunn0_.TTN_Namn as TTN2_1_0_ FROM TYR_TUNNEL enttyrtunn0_ with (updlock, rowlock) WHERE enttyrtunn0_.TTN_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrTunnel: SELECT enttyrtunn0_.TTN_ID as TTN1_1_0_, enttyrtunn0_.TTN_Namn as TTN2_1_0_ FROM TYR_TUNNEL enttyrtunn0_ with (updlock, rowlock) WHERE enttyrtunn0_.TTN_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrTunnel: SELECT enttyrtunn0_.TTN_ID as TTN1_1_0_, enttyrtunn0_.TTN_Namn as TTN2_1_0_ FROM TYR_TUNNEL enttyrtunn0_ with (updlock, rowlock) WHERE enttyrtunn0_.TTN_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entity Common.Entity.entTyrTunnel: SELECT enttyrtunn0_.TTN_ID as TTN1_1_0_, enttyrtunn0_.TTN_Namn as TTN2_1_0_ FROM TYR_TUNNEL enttyrtunn0_ WHERE enttyrtunn0_.TTN_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on entity Common.Entity.entTyrTunnel: SELECT enttyrtunn0_.TTN_ID as TTN1_1_0_, enttyrtunn0_.TTN_Namn as TTN2_1_0_ FROM TYR_TUNNEL enttyrtunn0_ WHERE enttyrtunn0_.TTN_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Static SQL for entity: Common.Entity.entTyrGrundvatten
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Version select: SELECT TGR_ID FROM TYR_GRUNDVATTEN WHERE TGR_ID = ?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Snapshot select: SELECT enttyrgrun_.TGR_ID, enttyrgrun_.TGR_Namn as TGR2_3_ FROM TYR_GRUNDVATTEN enttyrgrun_ WHERE enttyrgrun_.TGR_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Insert 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Update 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Delete 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGrundvatten: SELECT enttyrgrun0_.TGR_ID as TGR1_3_0_, enttyrgrun0_.TGR_Namn as TGR2_3_0_ FROM TYR_GRUNDVATTEN enttyrgrun0_ WHERE enttyrgrun0_.TGR_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGrundvatten: SELECT enttyrgrun0_.TGR_ID as TGR1_3_0_, enttyrgrun0_.TGR_Namn as TGR2_3_0_ FROM TYR_GRUNDVATTEN enttyrgrun0_ WHERE enttyrgrun0_.TGR_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGrundvatten: SELECT enttyrgrun0_.TGR_ID as TGR1_3_0_, enttyrgrun0_.TGR_Namn as TGR2_3_0_ FROM TYR_GRUNDVATTEN enttyrgrun0_ with (updlock, rowlock) WHERE enttyrgrun0_.TGR_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGrundvatten: SELECT enttyrgrun0_.TGR_ID as TGR1_3_0_, enttyrgrun0_.TGR_Namn as TGR2_3_0_ FROM TYR_GRUNDVATTEN enttyrgrun0_ with (updlock, rowlock) WHERE enttyrgrun0_.TGR_ID=?
2009-02-04 14:31:33,406 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGrundvatten: SELECT enttyrgrun0_.TGR_ID as TGR1_3_0_, enttyrgrun0_.TGR_Namn as TGR2_3_0_ FROM TYR_GRUNDVATTEN enttyrgrun0_ with (updlock, rowlock) WHERE enttyrgrun0_.TGR_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entity Common.Entity.entTyrGrundvatten: SELECT enttyrgrun0_.TGR_ID as TGR1_3_1_, enttyrgrun0_.TGR_Namn as TGR2_3_1_, gvrvallist1_.TGV_TGRID as TGV1_3_, gvrvallist1_.TGV_TGRID as TGV1_2_0_, gvrvallist1_.TGV_GvrLopnr as TGV2_2_0_, gvrvallist1_.TGV_Datum as TGV3_2_0_, gvrvallist1_.TGV_Niva as TGV4_2_0_ FROM TYR_GRUNDVATTEN enttyrgrun0_ left outer join TYR_GVR_VAL gvrvallist1_ on enttyrgrun0_.TGR_ID=gvrvallist1_.TGV_TGRID WHERE enttyrgrun0_.TGR_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on entity Common.Entity.entTyrGrundvatten: SELECT enttyrgrun0_.TGR_ID as TGR1_3_1_, enttyrgrun0_.TGR_Namn as TGR2_3_1_, gvrvallist1_.TGV_TGRID as TGV1_3_, gvrvallist1_.TGV_TGRID as TGV1_2_0_, gvrvallist1_.TGV_GvrLopnr as TGV2_2_0_, gvrvallist1_.TGV_Datum as TGV3_2_0_, gvrvallist1_.TGV_Niva as TGV4_2_0_ FROM TYR_GRUNDVATTEN enttyrgrun0_ left outer join TYR_GVR_VAL gvrvallist1_ on enttyrgrun0_.TGR_ID=gvrvallist1_.TGV_TGRID WHERE enttyrgrun0_.TGR_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Static SQL for entity: Common.Entity.entTyrGvrVal
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Version select: SELECT TGV_TGRID FROM TYR_GVR_VAL WHERE TGV_TGRID = ?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Snapshot select: SELECT enttyrgvrv_.TGV_TGRID, enttyrgvrv_.TGV_GvrLopnr as TGV2_2_, enttyrgvrv_.TGV_Datum as TGV3_2_, enttyrgvrv_.TGV_Niva as TGV4_2_, enttyrgvrv_.TGV_TGRID as TGV1_2_ FROM TYR_GVR_VAL enttyrgvrv_ WHERE enttyrgvrv_.TGV_TGRID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Insert 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Update 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Delete 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGvrVal: SELECT enttyrgvrv0_.TGV_TGRID as TGV1_2_1_, enttyrgvrv0_.TGV_GvrLopnr as TGV2_2_1_, enttyrgvrv0_.TGV_Datum as TGV3_2_1_, enttyrgvrv0_.TGV_Niva as TGV4_2_1_, enttyrgrun1_.TGR_ID as TGR1_3_0_, enttyrgrun1_.TGR_Namn as TGR2_3_0_ FROM TYR_GVR_VAL enttyrgvrv0_ left outer join TYR_GRUNDVATTEN enttyrgrun1_ on enttyrgvrv0_.TGV_TGRID=enttyrgrun1_.TGR_ID WHERE enttyrgvrv0_.TGV_TGRID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGvrVal: SELECT enttyrgvrv0_.TGV_TGRID as TGV1_2_1_, enttyrgvrv0_.TGV_GvrLopnr as TGV2_2_1_, enttyrgvrv0_.TGV_Datum as TGV3_2_1_, enttyrgvrv0_.TGV_Niva as TGV4_2_1_, enttyrgrun1_.TGR_ID as TGR1_3_0_, enttyrgrun1_.TGR_Namn as TGR2_3_0_ FROM TYR_GVR_VAL enttyrgvrv0_ left outer join TYR_GRUNDVATTEN enttyrgrun1_ on enttyrgvrv0_.TGV_TGRID=enttyrgrun1_.TGR_ID WHERE enttyrgvrv0_.TGV_TGRID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGvrVal: SELECT enttyrgvrv0_.TGV_TGRID as TGV1_2_0_, enttyrgvrv0_.TGV_GvrLopnr as TGV2_2_0_, enttyrgvrv0_.TGV_Datum as TGV3_2_0_, enttyrgvrv0_.TGV_Niva as TGV4_2_0_ FROM TYR_GVR_VAL enttyrgvrv0_ with (updlock, rowlock) WHERE enttyrgvrv0_.TGV_TGRID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGvrVal: SELECT enttyrgvrv0_.TGV_TGRID as TGV1_2_0_, enttyrgvrv0_.TGV_GvrLopnr as TGV2_2_0_, enttyrgvrv0_.TGV_Datum as TGV3_2_0_, enttyrgvrv0_.TGV_Niva as TGV4_2_0_ FROM TYR_GVR_VAL enttyrgvrv0_ with (updlock, rowlock) WHERE enttyrgvrv0_.TGV_TGRID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrGvrVal: SELECT enttyrgvrv0_.TGV_TGRID as TGV1_2_0_, enttyrgvrv0_.TGV_GvrLopnr as TGV2_2_0_, enttyrgvrv0_.TGV_Datum as TGV3_2_0_, enttyrgvrv0_.TGV_Niva as TGV4_2_0_ FROM TYR_GVR_VAL enttyrgvrv0_ with (updlock, rowlock) WHERE enttyrgvrv0_.TGV_TGRID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entity Common.Entity.entTyrGvrVal: SELECT enttyrgvrv0_.TGV_TGRID as TGV1_2_0_, enttyrgvrv0_.TGV_GvrLopnr as TGV2_2_0_, enttyrgvrv0_.TGV_Datum as TGV3_2_0_, enttyrgvrv0_.TGV_Niva as TGV4_2_0_ FROM TYR_GVR_VAL enttyrgvrv0_ WHERE enttyrgvrv0_.TGV_TGRID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on entity Common.Entity.entTyrGvrVal: SELECT enttyrgvrv0_.TGV_TGRID as TGV1_2_0_, enttyrgvrv0_.TGV_GvrLopnr as TGV2_2_0_, enttyrgvrv0_.TGV_Datum as TGV3_2_0_, enttyrgvrv0_.TGV_Niva as TGV4_2_0_ FROM TYR_GVR_VAL enttyrgvrv0_ WHERE enttyrgvrv0_.TGV_TGRID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Static SQL for entity: Common.Entity.entTyrMatningsTyp
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Version select: SELECT TMA_ID FROM TYR_MATNINGSTYP WHERE TMA_ID = ?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Snapshot select: SELECT enttyrmatn_.TMA_ID, enttyrmatn_.TMA_Name as TMA2_0_, enttyrmatn_.TMA_TABLE as TMA3_0_ FROM TYR_MATNINGSTYP enttyrmatn_ WHERE enttyrmatn_.TMA_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Insert 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Update 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Delete 0: NHibernate.SqlCommand.SqlCommandInfo
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrMatningsTyp: SELECT enttyrmatn0_.TMA_ID as TMA1_0_0_, enttyrmatn0_.TMA_Name as TMA2_0_0_, enttyrmatn0_.TMA_TABLE as TMA3_0_0_ FROM TYR_MATNINGSTYP enttyrmatn0_ WHERE enttyrmatn0_.TMA_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrMatningsTyp: SELECT enttyrmatn0_.TMA_ID as TMA1_0_0_, enttyrmatn0_.TMA_Name as TMA2_0_0_, enttyrmatn0_.TMA_TABLE as TMA3_0_0_ FROM TYR_MATNINGSTYP enttyrmatn0_ WHERE enttyrmatn0_.TMA_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrMatningsTyp: SELECT enttyrmatn0_.TMA_ID as TMA1_0_0_, enttyrmatn0_.TMA_Name as TMA2_0_0_, enttyrmatn0_.TMA_TABLE as TMA3_0_0_ FROM TYR_MATNINGSTYP enttyrmatn0_ with (updlock, rowlock) WHERE enttyrmatn0_.TMA_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrMatningsTyp: SELECT enttyrmatn0_.TMA_ID as TMA1_0_0_, enttyrmatn0_.TMA_Name as TMA2_0_0_, enttyrmatn0_.TMA_TABLE as TMA3_0_0_ FROM TYR_MATNINGSTYP enttyrmatn0_ with (updlock, rowlock) WHERE enttyrmatn0_.TMA_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for entity Common.Entity.entTyrMatningsTyp: SELECT enttyrmatn0_.TMA_ID as TMA1_0_0_, enttyrmatn0_.TMA_Name as TMA2_0_0_, enttyrmatn0_.TMA_TABLE as TMA3_0_0_ FROM TYR_MATNINGSTYP enttyrmatn0_ with (updlock, rowlock) WHERE enttyrmatn0_.TMA_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entity Common.Entity.entTyrMatningsTyp: SELECT enttyrmatn0_.TMA_ID as TMA1_0_0_, enttyrmatn0_.TMA_Name as TMA2_0_0_, enttyrmatn0_.TMA_TABLE as TMA3_0_0_ FROM TYR_MATNINGSTYP enttyrmatn0_ WHERE enttyrmatn0_.TMA_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Entity.AbstractEntityLoader - Static select for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on entity Common.Entity.entTyrMatningsTyp: SELECT enttyrmatn0_.TMA_ID as TMA1_0_0_, enttyrmatn0_.TMA_Name as TMA2_0_0_, enttyrmatn0_.TMA_TABLE as TMA3_0_0_ FROM TYR_MATNINGSTYP enttyrmatn0_ WHERE enttyrmatn0_.TMA_ID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Loader.Collection.OneToManyLoader - Static select for one-to-many Common.Entity.entTyrGrundvatten.GvrValList: SELECT gvrvallist0_.TGV_TGRID as TGV1_1_, gvrvallist0_.TGV_TGRID as TGV1_2_0_, gvrvallist0_.TGV_GvrLopnr as TGV2_2_0_, gvrvallist0_.TGV_Datum as TGV3_2_0_, gvrvallist0_.TGV_Niva as TGV4_2_0_ FROM TYR_GVR_VAL gvrvallist0_ WHERE gvrvallist0_.TGV_TGRID=?
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Impl.SessionFactoryImpl - Instantiated session factory
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Impl.SessionFactoryImpl - Checking 0 named HQL queries
2009-02-04 14:31:33,421 DEBUG 10 NHibernate.Impl.SessionFactoryImpl - Checking 0 named SQL queries
2009-02-04 14:31:33,437 DEBUG 10 NHibernate.Impl.SessionImpl - opened session
2009-02-04 14:31:33,468 DEBUG 10 NHibernate.Loader.Custom.Sql.SQLCustomQuery - starting processing of sql query [SELECT top 10 TGV_TGRID,TGV_GvrLopnr,TGV_Datum,TGV_Niva FROM TYR_GVR_VAL Where TGV_TGRID=1 Order by TGV_Datum, TGV_TGRID, TGV_GvrLopnr,TGV_Niva]
2009-02-04 14:31:33,468 DEBUG 10 NHibernate.Loader.Custom.Sql.SQLQueryReturnProcessor - mapping alias [entTyrGvrVal] to entity-suffix [0_]
2009-02-04 14:31:33,500 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Opened new IDbCommand, open IDbCommands: 1
2009-02-04 14:31:33,500 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Building an IDbCommand object for the SqlString: SELECT top 10 TGV_TGRID,TGV_GvrLopnr,TGV_Datum,TGV_Niva FROM TYR_GVR_VAL Where TGV_TGRID=1 Order by TGV_Datum, TGV_TGRID, TGV_GvrLopnr,TGV_Niva
2009-02-04 14:31:33,500 INFO 10 NHibernate.Loader.Loader - SELECT top 10 TGV_TGRID,TGV_GvrLopnr,TGV_Datum,TGV_Niva FROM TYR_GVR_VAL Where TGV_TGRID=1 Order by TGV_Datum, TGV_TGRID, TGV_GvrLopnr,TGV_Niva
2009-02-04 14:31:33,500 DEBUG 10 NHibernate.Connection.DriverConnectionProvider - Obtaining IDbConnection from Driver
2009-02-04 14:31:33,750 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Opened IDataReader, open IDataReaders: 1
2009-02-04 14:31:33,750 DEBUG 10 NHibernate.Loader.Loader - processing result set
2009-02-04 14:31:33,750 DEBUG 10 NHibernate.Loader.Loader - result set row: 0
2009-02-04 14:31:33,765 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,765 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,765 DEBUG 10 NHibernate.Loader.Loader - Initializing object from DataReader: [Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Hydrating entity: [Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.StringType - returning '0' as column: TGV_GvrLopnr
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.DateTimeType - returning '1978-10-18' as column: TGV_Datum
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '15' as column: TGV_Niva
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result set row: 1
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result set row: 2
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result set row: 3
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result set row: 4
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result set row: 5
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result set row: 6
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result set row: 7
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result set row: 8
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result set row: 9
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Type.Int32Type - returning '1' as column: TGV_TGRID
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - done processing result set (10 rows)
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Driver.NHybridDataReader - running NHybridDataReader.Dispose()
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Closed IDataReader, open IDataReaders :0
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Closed IDbCommand, open IDbCommands: 0
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.AdoNet.ConnectionManager - aggressively releasing database connection
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Connection.ConnectionProvider - Closing connection
2009-02-04 14:31:33,781 DEBUG 10 NHibernate.Loader.Loader - total objects hydrated: 1
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Engine.TwoPhaseLoad - resolving associations for [Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Event.Default.DefaultLoadEventListener - loading entity: [Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Event.Default.DefaultLoadEventListener - attempting to resolve: [Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Event.Default.DefaultLoadEventListener - object not resolved in any cache: [Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Fetching entity: [Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Loader.Loader - loading entity: [Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Opened new IDbCommand, open IDbCommands: 1
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Building an IDbCommand object for the SqlString: SELECT enttyrgrun0_.TGR_ID as TGR1_3_0_, enttyrgrun0_.TGR_Namn as TGR2_3_0_ FROM TYR_GRUNDVATTEN enttyrgrun0_ WHERE enttyrgrun0_.TGR_ID=?
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Type.Int32Type - binding '1' to parameter: 0
2009-02-04 14:31:33,796 INFO 10 NHibernate.Loader.Loader - SELECT enttyrgrun0_.TGR_ID as TGR1_3_0_, enttyrgrun0_.TGR_Namn as TGR2_3_0_ FROM TYR_GRUNDVATTEN enttyrgrun0_ WHERE enttyrgrun0_.TGR_ID=@p0
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Connection.DriverConnectionProvider - Obtaining IDbConnection from Driver
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Opened IDataReader, open IDataReaders: 1
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Loader.Loader - processing result set
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Loader.Loader - result set row: 0
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Loader.Loader - result row: EntityKey[Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Loader.Loader - Initializing object from DataReader: [Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Persister.Entity.AbstractEntityPersister - Hydrating entity: [Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,796 DEBUG 10 NHibernate.Type.StringType - returning '002-1' as column: TGR2_3_0_
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.Loader.Loader - done processing result set (1 rows)
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.Driver.NHybridDataReader - running NHybridDataReader.Dispose()
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Closed IDataReader, open IDataReaders :0
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.AdoNet.AbstractBatcher - Closed IDbCommand, open IDbCommands: 0
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.AdoNet.ConnectionManager - aggressively releasing database connection
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.Connection.ConnectionProvider - Closing connection
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.Loader.Loader - total objects hydrated: 1
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.Engine.TwoPhaseLoad - resolving associations for [Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.Engine.Loading.LoadContexts - creating collection wrapper:[Common.Entity.entTyrGrundvatten.GvrValList#1]
2009-02-04 14:31:33,812 DEBUG 10 NHibernate.Engine.TwoPhaseLoad - done materializing entity [Common.Entity.entTyrGrundvatten#1]
2009-02-04 14:31:33,828 DEBUG 10 NHibernate.Loader.Loader - done entity load
2009-02-04 14:31:33,828 DEBUG 10 NHibernate.Engine.TwoPhaseLoad - done materializing entity [Common.Entity.entTyrGvrVal#1]
2009-02-04 14:31:33,828 DEBUG 10 NHibernate.Engine.StatefulPersistenceContext - initializing non-lazy collections
2009-02-04 14:31:33,828 DEBUG 10 NHibernate.AdoNet.ConnectionManager - after autocommit
2009-02-04 14:31:33,828 DEBUG 10 NHibernate.Impl.SessionImpl - transaction completion
2009-02-04 14:31:33,828 DEBUG 10 NHibernate.AdoNet.ConnectionManager - aggressively releasing database connection
2009-02-04 14:31:33,828 DEBUG 10 NHibernate.Event.Default.DefaultEvictEventListener - evicting [Common.Entity.entTyrGvrVal]
Top
 Profile  
 
wolli
 Post subject:
PostPosted: Thu Feb 05, 2009 4:12 am 
Expert
Expert

Joined: Thu Dec 14, 2006 5:57 am
Posts: 1185
Location: Zurich, Switzerland
Can you post the mapping files and the query ?

_________________
--Wolfgang

Top
 Profile  
 
fan194
 Post subject:
PostPosted: Thu Feb 05, 2009 5:21 am 
Newbie

Joined: Wed Feb 04, 2009 10:24 am
Posts: 3
Here it is..

Parent:
<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping namespace="Common.Entity" assembly="Common.Entity" xmlns="urn:nhibernate-mapping-2.2">
<class name="entTyrGrundvatten" lazy="false" table="TYR_GRUNDVATTEN">
<id
name="TGR_ID"
column="TGR_ID">
<generator class="assigned" />
</id>
<property name="TGR_Namn" column="TGR_Namn" />
<bag name="GvrValList" cascade="all">
<key column="TGV_TGRID"/>
<one-to-many class="entTyrGvrVal"/>
</bag>

</class>
</hibernate-mapping>

Child:
<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping namespace="Common.Entity" assembly="Common.Entity" xmlns="urn:nhibernate-mapping-2.2">
<class name="entTyrGvrVal" lazy="false" table="TYR_GVR_VAL">
<id
name="TGV_TGRID"
column="TGV_TGRID">
<generator class="assigned" />
</id>
<property name="TGV_GvrLopnr" column="TGV_GvrLopnr" />
<property name="TGV_Datum" column="TGV_Datum" />
<property name="TGV_Niva" column="TGV_Niva" />
<many-to-one name="Grundvatten" class="entTyrGrundvatten" column="TGV_TGRID"/>

</class>
</hibernate-mapping>


Little example, code snippet (with some hardcoded values):

IList<entTyrGvrVal> lstGvrValues;

using (DataAccessManager objDaMgr = new DataAccessManager())
{
//lstGvrValues = objDaMgr.findById<entTyrGvrVal>("TGV_TGRID", 1);

lstGvrValues = objDaMgr.RetrieveBySQL<entTyrGvrVal>("SELECT top 10 TGV_TGRID,TGV_GvrLopnr,TGV_Datum,TGV_Niva FROM TYR_GVR_VAL Where TGV_TGRID=1 Order by TGV_Datum, TGV_TGRID, TGV_GvrLopnr,TGV_Niva", true);

}

/Fredrik
Top
 Profile  
 
wolli
 Post subject:
PostPosted: Thu Feb 05, 2009 5:34 am 
Expert
Expert

Joined: Thu Dec 14, 2006 5:57 am
Posts: 1185
Location: Zurich, Switzerland
You're mapping the parent id to the child id ... that allows only one child. You need a separate column and property for the parent id.

_________________
--Wolfgang

Top
 Profile  
 
fan194
 Post subject:
PostPosted: Thu Feb 05, 2009 6:21 am 
Newbie

Joined: Wed Feb 04, 2009 10:24 am
Posts: 3
Hmm...I don't quite follow. Do you mean I have to add this to the child-mapfile?
Could you write an example to enlight me..

/fredrik
Top
 Profile  
 
wolli
 Post subject:
PostPosted: Thu Feb 05, 2009 6:40 am 
Expert
Expert

Joined: Thu Dec 14, 2006 5:57 am
Posts: 1185
Location: Zurich, Switzerland
Yes, you need a parent id in the child mapping. Have a look here:

http://nhforge.org/doc/nh/en/index.html#example-parentchild

_________________
--Wolfgang

Top
 Profile  
 
wolli
 Post subject:
PostPosted: Thu Feb 05, 2009 6:42 am 
Expert
Expert

Joined: Thu Dec 14, 2006 5:57 am
Posts: 1185
Location: Zurich, Switzerland
And you probably run into some more problems with the assigned ids. Have a closer look at 18.4 in the url I posted before.

_________________
--Wolfgang

Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 7 posts ] 

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.