[nhusers] Re: Connection leak when ambient transaction aborts

Iain, connection leaks occur because the session is not properly disposed/closed. The current pattern I have been using with no problems is ISession session = OpenSessio(); try { using(var ts = new TransactionScope()) { ... ts.Complete(); } } finally { session.Dispose(); } On Apr 15,

[nhusers] Re: Connection leak when ambient transaction aborts

Norman, if you are using oracle, why are you using microsoft crippled implementation? I recommend you try the latest ODP.NET from oracle for better compatibility. Cubas, I thought distributed transactions (transactionscope) didn't need an explicit NHibernate/ADO transaction created, this should be

[nhusers] Re: NHibernate and .Net 4.0 compatibility issues

Thanks Tuna, Oskar is right I did not metioned any details but I just only want to get hints on existing and known compatibility problems. Your hint was very useful. Yes, we have experienced an exception calling old style Assembly.LoadFrom() method. Perhaps re-generating the WCF proxies by using th

[nhusers] Re: Error in named queries

That was about as much exception details as it gave. Here's the full call stack: Page_Init Exception: NHibernate.HibernateException: Errors in named queries: {Load.DeedInLieu.BusinessObjects.DeedInLieuNotes.SelectByDilId} at NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapp

Re: [nhusers] Error in named queries

You really should also give some of the exception details if you really want help. Also you are missing the Also it would improve debugging if you gave the actual sql statement being called by the named query rather the call to a stored procedure. Finally have you tried a named query using j

[nhusers] Error in named queries

I get an exception when I try to use a named query that returns two joined objects. The parent object mapping is: The child

Re: [nhusers] What NHIbernate inheritance mapping strategy to use

I don't think there's a rule of thumb... but common sense should help :-) One thing to consider is that you can use mixed mapping ( http://nhforge.org/doc/nh/en/index.html#inheritance-mixing-tableperclass-tablepersubclass), which might be a good fit for your case. Diego On Mon, May 17, 2010 a

Re: [nhusers] Many to many .... mapping trouble

You defined a ProductCategory class, but you're not using it... review your model and you'll find the error. Diego On Sat, May 15, 2010 at 04:35, Kris-I wrote: > Hello, > > I have trouble to set a basic many-to-many mapping file. Very classic, I > have a product, I have a category list and

Re: [nhusers] Nhibernate 3 / Trunk

https://nhibernate.svn.sourceforge.net/svnroot/nhibernate/trunk/ Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Mon, May 17, 2010 a

[nhusers] Nhibernate 3 / Trunk

Stupid questionwhere can I download ver. 3 / trunk? I have found a few links by googling but they are dead. There was also a link on how to build from the trunk, but that is dead as well. Does that exist somewhere else? -- You received this message because you are subscribed to the Google Gr

Re: [nhusers] NHibernate and .Net 4.0 compatibility issues

I remember there were some changes in reflection stuff, might be it, i mean it might be due to dynamic proxy frameworks. Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Mon, May 17, 2010 at 6:02 PM,

[nhusers] Re: Oracle Sequences and SQLite

I like the idea of using GUIDs, however, the DB is quite legacy and it was enough teeth pulling to get folks to agree to a surrogate key as it is. The key has to be a sequence, so my hands are tied there. Thanks for the suggestion, cc On May 17, 10:35 am, Jason Dentler wrote: > Your best option

Re: [nhusers] Oracle Sequences and SQLite

Your best option is probably to switch to a better POID generator: guid.comb is my favorite, though many people prefer hilo. On Mon, May 17, 2010 at 9:24 AM, Corey Coogan wrote: > Hi gang, > I'm using Oracle 10g and I'm working on getting DBA's to move > away from composite keys to surrogate

Re: [nhusers] NHibernate and .Net 4.0 compatibility issues

Your code fails, and you fail to mention how the call fails... :) What problems or exceptions are you seeing? Have you searched the list archives regarding .Net 4? There has been a number of posts lately, though I'm not sure at the moment how much info regarding the current state can be found. /O

[nhusers] Oracle Sequences and SQLite

Hi gang, I'm using Oracle 10g and I'm working on getting DBA's to move away from composite keys to surrogate keys. They have started the migration on a few tables for me, but I've since learned during development that the sequences are causing problems in SQLite. I typically use SQL Server a

[nhusers] NHibernate and .Net 4.0 compatibility issues

Hi all, We have a project written in Silverlight and WCF. The software is in two parts : Front-end and Back-end. I have upgraded both parts from .Net 3.5 to .Net 4.0. There is no compile error. It seems there is a problem when a call to NHibernate initiates from a WCF method. In better words, norm

[nhusers] Re: order by count

just spent several hours on this focusing on the order by count when in fact the culprit was the AND count which just needed to be a having count. schoolboy error :( On May 17, 1:56 pm, DannyT wrote: > I've the following hql creating a dto: > > Session.CreateQuery(@"select new JournalistSummar

[nhusers] order by count

I've the following hql creating a dto: Session.CreateQuery(@"select new JournalistSummaryDto(jo.Id, jo.Name, mo.Id, mo.Title, count(distinct it.Id), count(distinct me.Id)) from Item it inner join it.Journal

[nhusers] What NHIbernate inheritance mapping strategy to use

Hi there! I am at the moment using the "Table-per-subclass" inheritance mapping strategy. The system i'm building is using a baseclass and 5 different subclasses. So 6 tables all-in-all. Now I need to extend the system with new subclasses, so in total i've got 8. This is gonna lead to alot of joi

Re: [nhusers] Re: Eager fetching, collections and paging - a challenge :)

On Mon, May 17, 2010 at 8:28 AM, Dor Rotman wrote: > The many roundtrips overhead was decreased, although the batch query > overhead was increased. > In IT there is no magic ;) -- Fabio Maulo -- You received this message because you are subscribed to the Google Groups "nhusers" group. To pos

[nhusers] Re: Eager fetching, collections and paging - a challenge :)

Hi Jason, Glad to update that I finally had time between critical bugs to implement your suggestion, and at first impression, it looks like it helped quite a lot! The many roundtrips overhead was decreased, although the batch query overhead was increased. But still its seems the batch query overhea

[nhusers] Re: Connection leak when ambient transaction aborts

I’ve finally had chance to attempt to fix my original issue (see link) with the solution described by Diego to use both TransactionScope and BeginTransaction(). Unfortunately, with Oracle the following two test cases fail with Oracle exceptions as shown. (Both pass with SQL Server.) Any comments

Re: [nhusers] Re: FutureValue problem

i guess nobody works on mysql dialect, so it may not be at all working in the trunk. Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Mon, May 17, 2010 at 12:27 PM, Sosh wrote: > MySQLDialect --

[nhusers] Re: FutureValue problem

Update: I've tried switching to the MySQL5Dialect, and the problems goes away. So the issue is related only to the MySQLDialect. I don't think I'm going to be able to test this with the trunk in reasonable time - should I submit a bug report somewhere though? Thank you On May 16, 10:51 pm, Sosh