[nhusers] Re: NullReferenceException from NHibernate.Burrow (can it cause OutofMemoryException?)

2010-01-22 Thread Jonas
To continue my ranting... we deployed an earlier version and a normal memory consumption is about 400Mb. Right now I'm thinking there might be a problem with some lazy loaded association. On 22 Jan, 08:13, Jonas jonas.ver...@gmail.com wrote: The out of memory exception starts when w3wp.exe is

Re: [nhusers] Re: Support for loading entities from Oracle Stored Procedure

2010-01-22 Thread Richard Brown (gmail)
Hi Dinesh, That's great you've got it working. I had originally tried to get it working with both providers, but fell at a few hurdles early on with the Microsoft Oracle client. In particular the parameters needing bound by name (having to match 'exactly' the name of the parameter to the

[nhusers] Re: Fwd: Enumerate entities and properties at runtime

2010-01-22 Thread Florian DREVET
I Fabio, No problem, I sent you a private message by error instead of a public one :) So I'm using Catsle Project IoC and a class named NHibernateSessionManager whose parts of this article : http://www.codeproject.com/KB/architecture/NHibernateBestPractices.aspx I'll try to expose the

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

2010-01-22 Thread graphicsxp
Hi, I need to write with the NH criteria API, the equivalent of this SQL query : SELECT DISTINCT dbo.BuzzGallery.Name, AVG(dbo.BuzzUserArt.Rating) AS EXPR1, dbo.BuzzGallery.Scrapped, dbo.BuzzGallery.DateCreated FROM dbo.BuzzGallery INNER JOIN dbo.BuzzGalleryArt ON

[nhusers] Re: Join with the same table

2010-01-22 Thread DanV
Hi Here's the HQL version, I don't really use Criteria so I can't tell how it'll be at point b) select a.ResourceKey, a.CultureName, a.ResourceSet, a.ResourceValue as defaultText, b.ResourceValue fromLocalization a, Localization b where a.id = b.id and a.resourceSet='blacklist/edit' and

[nhusers] Re: Mapping a table requires using [tableName] for reserved words??

2010-01-22 Thread DanV
Couldn't find it on NH reference but somewhere in NH in Action book it is specified that backticks should be used in this case. So in your mapping you should use smth like: table = `tablename` I guess this gives also portability over different DB engines. On Jan 21, 12:41 am, Mohamed Meligy

Re: [nhusers] Proxy Interfering With Property Setter / Getter

2010-01-22 Thread Richard Brown (gmail)
Actually it's not a bug ... it's just that the C# compiler is silently dropping the 'virtual' modifier on the mutator (changing it to protected should keep the 'virtual' modifier). Because the 'Total' property mutator is marked as private, the proxy is powerless to intercept it; I think your

Re: [nhusers] Re: Mapping a table requires using [tableName] for reserved words??

2010-01-22 Thread Tuna Toksoz
http://fabiomaulo.blogspot.com/2009/06/auto-quote-tablecolumn-names.html Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Fri, Jan 22, 2010 at 2:05 PM, DanV dan.programm...@gmail.com wrote:

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

2010-01-22 Thread Jason Meckley
your query is a projection, not entity retrieval, so there is no reason to set the distinct root entity transformer. If this data maps to a dto class than you can do this. [HQL] select new MyDto(b.Name, avg(u.Rating) as Expr1, b.Scrapped, b.DateCreated) fromBuzzGallery b join

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

2010-01-22 Thread graphicsxp
Hi, Thanks for helping. But I'm having issues with your code (Criteria part). At compiling : Error 1 'NHibernate.Criterion.Projections' does not contain a definition for 'List' Error 2 The best overloaded method match for 'NHibernate.Criterion.Order.Desc(string)' has some invalid arguments

[nhusers] Re: Mapping multiple parent relationships efficiently

2010-01-22 Thread Boz
Whoops, the key columns in the mapping should be NodeId, not ChildId. Sorry Boz On Jan 22, 2:44 pm, Boz jjkbosw...@yahoo.com wrote: Hi, I'm an nHibernate novice at the moment, and have been advised to post here from the Fluent group to see if you guys can suggest an efficient mapping or

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

2010-01-22 Thread Jason Meckley
I wrote the syntax off the top of my head, so there will be errors in the query. the essence of it is there. Lastly, I don't want to create another dto. Would that be ok if I add a 'average' property to my BuzzGallery class, and instead of returning a list of MyDto, I return a list of BuzzGallery

Re: [nhusers] Informix, Serial Column, and OleDbDriver

2010-01-22 Thread Diego Mijelshon
Adding the column sizes to the mapping might help. However, you should be using the Informix driver. Here's a sample config: property name=connection.providerNHibernate.Connection.DriverConnectionProvider/property property name=connection.connection_stringHost={informix host

[nhusers] Re: Informix, Serial Column, and OleDbDriver

2010-01-22 Thread jprid64
Thanks, Diego. I tried the Informix driver and can now perform the insert. Extending my test program, I am trying to wrap the insert inside a distributed transaction using a TransactionScope object. If I don't create the TransactionScope object with EnterpriseServicesInteropOption.Full, the insert

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

2010-01-22 Thread graphicsxp
Going the formula road seems to be the right thing to do. However, I can't figure out how to do it. I'm almost there but not quite. Here's my formula : hibernate-mapping xmlns=urn:nhibernate-mapping-2.2 class name=BuzzArt.BuzzGallery, BuzzArt table=BuzzGallery where=Scrapped=0 id name=Id

[nhusers] Re: Support for loading entities from Oracle Stored Procedure

2010-01-22 Thread Dinesh
Richard, I thought i could get away with binding by name limitation by making sure that all my procedures has a standard predetermined name for the Ref Cursor variable, however the major roadblock for me was that NHibernate is generating parameter names newly and ignoring the ones given in the

Re: [nhusers] Re: Mapping a table requires using [tableName] for reserved words??

2010-01-22 Thread Mohamed Meligy
Very nice. Thanks a lot both guys. Regards, -- Mohamed Meligy Senior Developer, Team Lead Backup (.Net Technologies - TDG - Applications) Injazat Data Systems P.O. Box: 8230 Abu Dhabi, UAE. Phone: +971 2 6992700 Direct: +971 2 4045385 Mobile: +971 50 2623624, +971 55 2017 621 E-mail:

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

2010-01-22 Thread Jason Meckley
property name=AverageRating formula=( SELECT AVG(a.Rating) FROMdbo.BuzzGalleryArt a INNER JOIN dbo.BuzzUserArt u ON a.BuzzUserArtID = u.BuzzUserArtID INNER JOIN dbo.BuzzGallery g ON a.BuzzGalleryID = g.BuzzGalleryID WHERE

[nhusers] Re: Informix, Serial Column, and OleDbDriver

2010-01-22 Thread jprid64
Creating the TransactionScope object within the NHibernate session (rather than the reverse) fixes my problem. On Jan 22, 11:15 am, jprid64 john.pride...@gmail.com wrote: Thanks, Diego. I tried the Informix driver and can now perform the insert. Extending my test program, I am trying to wrap

Re: [nhusers] Cascade save on child collections...

2010-01-22 Thread Diego Mijelshon
You say that both sides are mapped but I don't see the reference from Vehile to Person. Once you have that, setting Inverse and Cascade All on the Person side should do the trick. Diego On Fri, Jan 22, 2010 at 21:57, Eric J. Peters erpet...@gmail.com wrote: Hi- I'm sure this is a

[nhusers] Re: NHibernate ProxyGenerators - Update to Support 2.1.2?

2010-01-22 Thread Sam Kimmel
Fabio, thanks for pointing me in the right direction. Between your help with telling me about needing to recompile the NHibernate.ByteCode.Castle library with Castle Dynamic Proxy 2.2, and the help from some users over in the Castle user group I was able to get everything up and running in Medium