Re: [nhusers] using Future and multiple queries having same parametername

2010-01-24 Thread Richard Brown (gmail)
Hi Gauthier, I'm not aware of any workaround. If you have time, and don't find a workaround, it would be great if you could maybe put together a simple test case, and add the issue to JIRA. Thanks, Richard -- From: Gauthier Segay

[nhusers] ISessionFactory per database memory issues

2010-01-24 Thread Mike Smith
Hello, I am hoping you nHibernate gurus can help us with our problem! We are using nHibernate version 1.2.1.4000, have many databases with identical schemas, and per the standard recommendation we create a singleton Session Factory for each database. We have an ASP.Net application for the UI,

Re: [nhusers] ISessionFactory per database memory issues

2010-01-24 Thread Diego Mijelshon
If you have 120 databases, it seems to me like you should have a big server there... in which case 700MB is nothing. This is 2010, 1GB costs 20 bucks. Still... you might want to try with a single session factory and passing the IDbConnection to the OpenSessionMethod. And... you should really,

[nhusers] Re: ISessionFactory per database memory issues

2010-01-24 Thread Mike Smith
Hello Diego, Thank you for the reply. Apparently I did a poor job of searching the group and I apologize if I wasted peoples time. I did end up finding a few posts from Fabio where he recommended inheriting from DriverConnectionProvider and overriding the ConnectionString property so I'll give

[nhusers] Re: Help required for writing a query with NH criteria API

2010-01-24 Thread graphicsxp
Works like a treat ! Thanks a lot :) On 22 jan, 23:25, Jason Meckley jasonmeck...@gmail.com wrote:    property name=AverageRating formula=( SELECT         AVG(a.Rating) FROM            dbo.BuzzGalleryArt a                       INNER JOIN dbo.BuzzUserArt u ON a.BuzzUserArtID =

[nhusers] Table lock- associated with open session?

2010-01-24 Thread Dietrich
I've got a winforms production application that putting locks on three tables in my SQL 2005 server almost all day long. I have many forms in the system which use the same pattern, so what confuses me is that only one specific form seems to be causing these locks. When the form is opened, it

[nhusers] Query by entity name

2010-01-24 Thread Jason Dentler
Hi, I have a class: public class foo { public virtual long Id { get; set; } public virtual string Data1 { get; set; } public virtual Guid Revision { get; set; } // Equals and GetHashCode also implemented } with the following mappings: ?xml version=1.0 encoding=utf-8 ? hibernate-mapping

Re: [nhusers] Query by entity name

2010-01-24 Thread Fabio Maulo
ooohhh two entities with the same name of the class. The query should work as you are expecting, probably there is a bug related to the autoregistration... If you put those two entities in different namespace, is all working fine ? 2010/1/24 Jason Dentler jasondent...@gmail.com Hi, I have

Re: [nhusers] Query by entity name

2010-01-24 Thread Fabio Maulo
Jason... found the reason... You are querying one class spanned in two tables and that is the reason because NH is applying a UNION. Perhaps, and underling perhaps, the tag polymorphism=explicit and using the entity-name in the query can do the trick. 2010/1/24 Jason Dentler

[nhusers] Re: Query by entity name

2010-01-24 Thread Jason Dentler
The polymorphism=explicit trick only works when I make the second mapping for a new class FooAudit : Foo. I understand why it works this way now. This isn't a dead end. It just means I have to get the next feature working before this one will work. Thanks Fabio! Any tips for mapping to a dynamic

Re: [nhusers] Re: Query by entity name

2010-01-24 Thread Fabio Maulo
What you mean ? something like this ? http://fabiomaulo.blogspot.com/2008/10/less-than-few-is-gof.html or like this ? http://fabiomaulo.blogspot.com/2009/07/duck-typing-with-nhibernate.html http://fabiomaulo.blogspot.com/2009/07/duck-typing-with-nhibernate.htmlWhat you mean by mapping dynamic

[nhusers] NHibernate / FireBird any way to specify segment size and subtype in blob mapping?

2010-01-24 Thread theghost
Hi, I have a property mapping as follows: property name=Notes column=`Notes` type=Serializable / When I generate the database using GenerateSchemaCreationScrip I get blob of subtype 0 (binary) and segment size of 80. Is there any way to control these field properties via the mapping file when