[nhusers] Lazy loading and static/no proxy

2009-05-28 Thread dnagir
Hi, Is it possible to have lazy loading without generating Proxy classes at runtime? Also, guys, maybe you know anything about static proxy? Ayende did implement some bits a long time ago (poor Man, he was doing it late in the night) but since than I cannot see anybody using it. I don't even

[nhusers] Re: 2.1.0 Alpha 3

2009-05-28 Thread Kris-I
http://nhforge.org/blogs/nhibernate/archive/2009/05/24/nhibernate-2-1-0alpha3.aspx Can you say from where you read that 2.1.0Alpha3 was released ? Please end here the link. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[nhusers] Nhibernate query from 2 tables

2009-05-28 Thread Viki
Hi, I am doing query from 2 table using join. config = new NHibernate.Cfg.Configuration(); config.AddAssembly(typeof(CSTS.Main.CashPosting).Assembly); factory = config.BuildSessionFactory(); session = factory.OpenSession(); query = session.CreateQuery(FROM

[nhusers] Re: Help with optimizing loading of associations

2009-05-28 Thread Thomas Koch
Hi Nick - thanks for the suggestion. :-) Alas, it does not really work. I get a combinatorial explosion of the rows returned due to the use of multiple joins in the select. I need some way of instructing NHibernate to load the data using multiple selects, but to send them over the wire in the

[nhusers] Exception of type 'Antlr.Runtime.EarlyExitException'

2009-05-28 Thread Mitjast
I have created some HQL's for Nhiberante 2.1.0 Alpha2 example Select new SomeClass(k.Ident, Sum(k.Qty),Max(k.ProductName)) From OrderItem k Group by k.Ident Order by sum(k.Qty) desc Work's fine!! Nhiberante 2.1.0 Alpha3 Release notes. * Antlr3.Runtime.dll is required . The same class

[nhusers] Upsert for NHibernate

2009-05-28 Thread ian
How do we go about doing insert into table(...) values() on duplicate key update ... ? I assume this can't be done by SaveOrUpdate because it doesn't update even if I assign the Id property. Anyone help? Thanks! --~--~-~--~~~---~--~~ You received this message

[nhusers] Re: Nhibernate query from 2 tables

2009-05-28 Thread Mitjast
If you are trying to do HQL you should use join like this. FROM CashPosting C INNER JOIN c.FundGroup as F where other wise you can use session.CreateSQLQuery(Select * FROM CashPosting C INNER JOIN FundGroup F On C.Acct_Cd=F.Acct.Cd WHERE F.Acct_Grp_Cd='ASPRUI') hope i helped you. On

[nhusers] Powerdesigner and NHibernate

2009-05-28 Thread Girling Márquez
Hello everybody, I'm a NHibernate's new user. I'm working on research of new technologies for a system to develop in an environment. NETs. My question is directed to the following, I'm using PowerDesigner (versions 12 and 15) for the design of conceptual models, physical and object-oriented. This

[nhusers] Re: Nhibernate query from 2 tables

2009-05-28 Thread Vikas Singh
What would we return type here if we have list IListCSTS.Main.CashPosting cashpostlist = query.ListCSTS.Main.CashPosting(); On May 28, 5:01 pm, Mitjast mitja.studni...@gmail.com wrote: If you are trying to do HQL you should use join like this. FROM CashPosting C INNER JOIN c.FundGroup as F

[nhusers] Re: Exception of type 'Antlr.Runtime.EarlyExitException'

2009-05-28 Thread Mitjast
I digged and tested, looked at the source code of Nhibernate 2.1.0 Alpha3 and found my mistake. I'm using Nhibernate.mapping.Attributes to generate hbm files dynamicly, mistake was that i was using too old version. Changed it to new aplha release, fixed import class for hql object used rename

[nhusers] Re: Nhibernate query from 2 tables

2009-05-28 Thread Mitjast
If you use HQL it would be CashPosting... If you use SQL then it would be Listobjects, you should manualy convert them in to CashPosting. On 28 maj, 11:06, Vikas Singh vikas.jehana...@gmail.com wrote: What would we return type here if we have list IListCSTS.Main.CashPosting cashpostlist =

[nhusers] Leeking memory

2009-05-28 Thread Waqar Sadiq
We have a custom adapter written for BizTalk. The adapter accepts incoming messages, and uses our framework to write data out to the oracle database using NHibernate. We are actually using Spring.Net 1.2 with NHibernate 2.0.1. As part of writing data to the database, we check to see if it

[nhusers] Re: Leeking memory

2009-05-28 Thread Tuna Toksoz
string queryStr = string.Format(from Member m, VirtualCard v where v.IpCode = m.IpCode and v.LoyaltyIdNumber = '{0}', loyaltyIDNumber); If you use this like this, you'll have different cached query execution plans for different ids. Try using parameters instead

[nhusers] Re: Leeking memory

2009-05-28 Thread Tuna Toksoz
In that case you don't have to recycle it, just use parameters instead of hql concatenation. Exactly the same way you should do in SQL Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Thu, May 28,

[nhusers] Re: Leeking memory

2009-05-28 Thread Tuna Toksoz
This also exists in 2.0.1 verison of NH. Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Thu, May 28, 2009 at 3:18 PM, Tuna Toksoz tehl...@gmail.com wrote: In that case you don't have to recycle

[nhusers] Re: Leeking memory

2009-05-28 Thread Waqar Sadiq
I will try Tuna's suggestion. Unfortunately, we are limited to the NHibernate version that is supported by Spring.Net GA version :-( On May 28, 7:16 am, Eric Kepes eke...@gmail.com wrote: And the query plan cache keeps growing in 2.0.1. We ran into this problem, as described by RasmusKL here

[nhusers] Re: Leeking memory

2009-05-28 Thread Waqar Sadiq
I am running some more tests and puttint a using statement around the session made a huge difference as well. using (ISession session = CurrentSession) { .. } On May 28, 7:22 am, Waqar Sadiq sadiq.wa...@gmail.com wrote: I will try Tuna's suggestion.  Unfortunately, we are limited to the

[nhusers] Re: Leeking memory

2009-05-28 Thread Tuna Toksoz
using (ISession session = CurrentSession) { CurrentSession is a prop returning the same instance ? Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Thu, May 28, 2009 at 3:25 PM, Waqar Sadiq

[nhusers] Re: Leeking memory

2009-05-28 Thread Waqar Sadiq
As I mentioned, we are usign Spring.Net. Our data access objects derive from Spring's HibernateDaoSupport object. Here is the code for CurrentSession get property. public ISession CurrentSession { get { ISession session = null;

[nhusers] Re: Leeking memory

2009-05-28 Thread Tuna Toksoz
OK OK I got it. Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Thu, May 28, 2009 at 3:36 PM, Waqar Sadiq sadiq.wa...@gmail.com wrote: As I mentioned, we are usign Spring.Net. Our data access

[nhusers] Re: Upsert for NHibernate

2009-05-28 Thread John Rayner
Use a stored proc. On May 28, 6:59 am, ian ian.esca...@gmail.com wrote: How do we go about doing insert into table(...) values() on duplicate key update ... ? I assume this can't be done by SaveOrUpdate because it doesn't update even if I assign the Id property. Anyone help? Thanks!

[nhusers] Re: Leeking memory

2009-05-28 Thread Fabio Maulo
How use an IoC and wire all application to it.(possible title for a blog post). 2009/5/28 Waqar Sadiq sadiq.wa...@gmail.com As I mentioned, we are usign Spring.Net. Our data access objects derive from Spring's HibernateDaoSupport object. Here is the code for CurrentSession get property.

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Fabio Maulo
And which is the problem ?That is a normal environment. 2009/5/28 Mark Nijhof mark.nij...@gmail.com Hi, Cross posted to both NHibernate and Fluent NHibernate as I don't know where this should be done. Is there a way specify the culture settings to be used by NHibernate without relying

[nhusers] Re: Nhibernate.Search

2009-05-28 Thread cws
Nice! Tried it out in the NHibernate.Search test project. First using FuzzyQuery class before I read your answer and then with ~ and the criteria API. It seems to work great. Here is a link about linq and lucene with kind of a quicksheet to queries. http://www.codeplex.com/linqtolucene You

[nhusers] Re: Nhibernate.Search

2009-05-28 Thread cws
Wayne, nice! Tried it out in the NHibernate.Search test project. First using FuzzyQuery class before I read your answer and then with ~ and the criteria API. It seems to work great. Here is a link about linq and lucene with kind of a quicksheet to queries. http://www.codeplex.com/linqtolucene

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Mark Nijhof
Hi Fabio, I was asking for my college, he is having the following specific issue (and I was worried because we will be in the same situation): -- We currently use SQL Server 2005 with collation Danish_Norwegian_CI_AS and the web server executing queries has its regional date settings set to

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Fabio Maulo
are you using strings injection instead parameters ? 2009/5/28 Mark Nijhof mark.nij...@gmail.com Hi Fabio, I was asking for my college, he is having the following specific issue (and I was worried because we will be in the same situation): -- We currently use SQL Server 2005 with

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Mark Nijhof
Sorry that only applies to the mappings of course. We are using Linq to access the data and regular save for saving. On Thu, May 28, 2009 at 8:13 PM, Mark Nijhof mark.nij...@gmail.com wrote: We are using Fluent NHibernate, that is why I cross posted, I am not sure where the issue might be.

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Fabio Maulo
2009/5/28 Mark Nijhof mark.nij...@gmail.com Sorry that only applies to the mappings of course. We are using Linq to access the data and regular save for saving. can you send the SQL log ? -- Fabio Maulo --~--~-~--~~~---~--~~ You received this message

[nhusers] Re: Proxy Detection

2009-05-28 Thread Fabio Maulo
NHibernate.NHibernateUtil 2009/5/28 chris bikk...@gmail.com hi, I have an object with a lazy collection. I want to evict the object from my session, but while evicted I need to check the collection to see if it was initialised while the object was in the session. When i do a if

[nhusers] LINQ2NHibernate and Aggregates

2009-05-28 Thread Chris Nicola
I was wondering if it is possible to do simple sums and groupings with Linq2Nhibernate without returning the entire result set first using .ToList(); My scenario: I have a table of accounts, and for each and every account I would like to get a sum of transactions from three different tables. In

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Fabio Maulo
as you can see something/somebody is injecting strings instead use parameters; that is the problem. 2009/5/28 Mark Nijhof mark.nij...@gmail.com Hi Fabio, SELECT this_.Id as Id37_1_, this_.FromDate as FromDate37_1_, this_.ToDate as ToDate37_1_, this_.Comment as Comment37_1_,

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Tuna Toksoz
NHibernate: SELECT this_.EmployeeID as EmployeeID17_0_, this_.Address as Address17_0_, this_.BirthDate as BirthDate17_0_, this_.City as City17_0_, this_.Country as Country17_0_, this_.Extension as Extension17_0_, this_.FirstName as FirstName17_0_, this_.HireDate as HireDate17_0_, this_.HomePhone

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Mark Nijhof
What version should we use? On Thu, May 28, 2009 at 9:29 PM, Tuna Toksoz tehl...@gmail.com wrote: NHibernate: SELECT this_.EmployeeID as EmployeeID17_0_, this_.Address as Address17_0_, this_.BirthDate as BirthDate17_0_, this_.City as City17_0_, this_.Country as Country17_0_,  this_.Extension 

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Mark Nijhof
Thanks guys, Will look into it more tomorrow, appreciate all the quick help. Maybe it is something completely different as your and mine query seem to generate the same date format. -Mark On Thu, May 28, 2009 at 9:41 PM, Tuna Toksoz tehl...@gmail.com wrote: The trunk and very early

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Tuna Toksoz
Let me set the thread culture and see. Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Thu, May 28, 2009 at 10:52 PM, Mark Nijhof mark.nij...@gmail.com wrote: Thanks guys, Will look into it

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Fabio Maulo
Tuna, You should check what happen when the value come from a property or a method of a object used as criteria.Take a look to req.FromDate probably req is a custom class used to hold query info. 2009/5/28 Tuna Toksoz tehl...@gmail.com The trunk and very early revisions of linq trunk worked in

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Mark Nijhof
req is indeed a custom class for holding criteria information, property is a normal datetime type. -Mark On Thu, May 28, 2009 at 9:59 PM, Tuna Toksoz tehl...@gmail.com wrote: As long as the object used in parameter is a constant, its value is evaluated and used as constant            

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Fabio Maulo
Moment... we are forgetting something...@mark Which NH-Linq version are you using ? I know that is a difficult question but try to download and recompile the trunk of NH-Linq 2009/5/28 Tuna Toksoz tehl...@gmail.com As long as the object used in parameter is a constant, its value is evaluated

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Mark Nijhof
I am not at the work machine so I can't reproduce but it is the version that comes with Fluent NHibernate v.0.1.0.447 so it is a little while back I tried to see if I could still download that but the link was not available anymore. Rebuilding will not be a big issue, but cannot do anything more

[nhusers] Getting NHibernate to stop checking for stale children when not cascading updates

2009-05-28 Thread darrell.jo...@ris.lane.or.us
Is there any way to disable checking for stale child records when we are not cascading updates? That may seem an odd question, but we’re using NHibernate to build hierarchies on retrieval and the security design we’re working from calls for updates to happen for only a single level of the

[nhusers] Re: Setting culture settings for DateTime

2009-05-28 Thread Jon Arild Tørresdal
Hi Fabio, I’m the guy actually experiencing this problem J Here’s the SQL: SELECT this_.Id as Id37_1_, this_.FromDate as FromDate37_1_, this_.ToDate as ToDate37_1_, this_.Comment as Comment37_1_, this_.CustomerInfo as Customer5_37_1_, externalsy1_.Id as Id12_0_, externalsy1_.Code as Code12_0_,

[nhusers] Re: Lazy loading and static/no proxy

2009-05-28 Thread Dmitiry Nagirnyak
Thanks. It's a good option. But what I really don't like with proxies is that I cannot rely on casting operations with them. So I would rather prefer to have classes in my code to support lazy loading. I suppose I can achive this by writing some additional code in setters/getters. Has anybody

[nhusers] Re: 2.1.0 Alpha 3

2009-05-28 Thread Shane C
Uhm.. I didn't. I went to find the latest download on SourceForge because I wanted access=backfield support and noticed that Alpha3 was listed there. Here is a hint. If you don't want people to download something don't put it on the official download site maybe? On May 27, 1:27 pm, Fabio

[nhusers] Re: 2.1.0 Alpha 3

2009-05-28 Thread Shane C
Sorry but I have to agree with Stuart. Failing fast is a very good (and in this case EASY) practice. The Oracle dialect exists which means people will use it without knowing that it isn't actually an Oracle dialect. On May 28, 8:14 am, Fabio Maulo fabioma...@gmail.com wrote: If you read the

[nhusers] Re: Lazy loading and static/no proxy

2009-05-28 Thread Shane C
Just out of curiosity why would you want this? Is it a concern over performance or something else? On May 28, 12:40 am, dnagir dna...@gmail.com wrote: Hi, Is it possible to have lazy loading without generating Proxy classes at runtime? Also, guys, maybe you know anything about static

[nhusers] Could not compile the mapping document

2009-05-28 Thread Viki
Hi, I am getting error message Could not compile the mapping document, below is mapping document. Before connecting the both table it was working fine. ?xml version=1.0 encoding=utf-8 ? !-- Generated by MoreGen 5-Feb-2009 02:28:36 -- hibernate-mapping xmlns=urn:nhibernate-mapping-2.2

[nhusers] return type as Ilist of SqlQuery

2009-05-28 Thread Viki
Hi, I am doing join in sql query and returning in Ilist., how can we return list in this query. config = new NHibernate.Cfg.Configuration(); config.AddAssembly(typeof(CSTS.Main.CashPosting).Assembly); factory = config.BuildSessionFactory(); session = factory.OpenSession(); IList cash = new

[nhusers] Linq

2009-05-28 Thread Craig van Nieuwkerk
I am using the old linq provider for nHibernate and waiting patiently for the new one to come out. I am sure it will save me much pain. Anyway, I have a problem with the code below as it generates a Object reference not set to an instance of an object. The line c.Disciplines.Any(d =

[nhusers] Re: 2.1.0 Alpha 3

2009-05-28 Thread Fabio Maulo
2009/5/28 Shane C shanecourtri...@gmail.com Uhm.. I didn't. I went to find the latest download on SourceForge because I wanted access=backfield support and noticed that Alpha3 was listed there. Here is a hint. If you don't want people to download something don't put it on the official