Hi

I try to use hibernate.adonet.batch_size for batched inserts

something like

while {
Obj o = new Obj();
session.Save(o);
}
session.Flush();


but every single call of session.Save runs a SQL-insert in the database

any ideas???

Are you using SQL Server ? Because it's only supported currently

yes. sql server 2005

Actually, I can't really say whether it's working for me either.

The documentation is pretty brief:
http://www.hibernate.org/hib_docs/nhibe ... ch-updates

I wonder if you need to call 'Save' or 'Update' on each object to get this to work? Or am I missing something?

Take a look in your log4net log for nHibernate is it infact the BatcherImpl that is running the queries?

Where do you have your configurationsettings?

Hi,

I can see that BatcherImpl is doing something ;-)

But then again, I'm not sure precisely, what batching is supposed to be doing?

01:22:40.352 [6] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister - Updating entity: [Bla.DomainModel.Bla.Account#15]
01:22:40.352 [6] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister - Existing version: 19 -> New Version: 20
01:22:40.352 [6] DEBUG NHibernate.Impl.BatcherImpl - Opened new IDbCommand, open IDbCommands: 1
01:22:40.352 [6] DEBUG NHibernate.Impl.BatcherImpl - Building an IDbCommand object for the SqlString: UPDATE Account SET Version = ?, Name = ?, Baskets = ?, Amount = ?, Fee = ?, Interest = ?, Closed = ?, Out = ?, Loan = ?, Tra = ?, EntityID = ?, AdviserID = ?, Interest = ? WHERE id = ? AND Version = ?
01:22:40.352 [6] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister - Dehydrating entity: [Bla.DomainModel.Bla.Account#15]
01:22:40.352 [6] DEBUG NHibernate.Type.Int32Type - binding '20' to parameter: 0
01:22:40.352 [6] DEBUG NHibernate.Type.StringType - binding '004' to parameter: 1
01:22:40.352 [6] DEBUG NHibernate.Type.Int32Type - binding '38' to parameter: 2
01:22:40.352 [6] DEBUG NHibernate.Type.DecimalType - binding '150000.0000' to parameter: 3
01:22:40.352 [6] DEBUG NHibernate.Type.DecimalType - binding '-0.0250' to parameter: 4
01:22:40.352 [6] DEBUG NHibernate.Type.DecimalType - binding '-0.1390' to parameter: 5
01:22:40.352 [6] DEBUG NHibernate.Type.BooleanType - binding 'True' to parameter: 6
01:22:40.352 [6] DEBUG NHibernate.Type.BooleanType - binding 'False' to parameter: 7
01:22:40.352 [6] DEBUG NHibernate.Type.DecimalType - binding '176066.6200' to parameter: 8
01:22:40.352 [6] DEBUG NHibernate.Type.Int32Type - binding '8' to parameter: 9
01:22:40.352 [6] DEBUG NHibernate.Type.Int32Type - binding '15' to parameter: 10
01:22:40.352 [6] DEBUG NHibernate.Type.Int32Type - binding '16' to parameter: 11
01:22:40.352 [6] DEBUG NHibernate.Type.Int32Type - binding '5' to parameter: 12
01:22:40.352 [6] DEBUG NHibernate.Type.Int32Type - binding '15' to parameter: 13
01:22:40.352 [6] DEBUG NHibernate.Type.Int32Type - binding '19' to parameter: 14
01:22:40.352 [6] DEBUG NHibernate.SQL - UPDATE Account SET Version = @p0, Name = @p1, Baskets = @p2, Subscription= @p3, Fee = @p4, Interest = @p5, Closed = @p6, Par = @p7, Loan = @p8, Tra = @p9, EntityID = @p10, AdviserID = @p11, Interest = @p12 WHERE id = @p13 AND Version = @p14; @p0 = '20', @p1 = '004', @p2 = '38', @p3 = '150000.0000', @p4 = '-0.0250', @p5 = '-0.1390', @p6 = 'True', @p7 = 'False', @p8 = '176066.6200', @p9 = '8', @p10 = '15', @p11 = '16', @p12 = '5', @p13 = '15', @p14 = '19'
01:22:40.368 [6] DEBUG NHibernate.Impl.BatcherImpl - Closed IDbCommand, open IDbCommands: 0

It doesn't work for me either... I'm using NHibernate 1.2

Can't seem to get it to work either...anyone had any joy with this?

Jason

Maybe it works even though you might think it doesn't?
http://groups.google.com/group/nhusers/ ... db66f62a39

At least for me it work perfectly fine.