Guys,

A few days ago I posted this (it's long and boring):

http://forum.hibernate.org/viewtopic.ph ... highlight=

I had 38 views and ZERO answers!

Night after night I have tried to solve this issue and failed. I don't give up easily and I won't let this go. But I need help!

Because we are all so much better inside our IDEs than reading posts... I'm making the code available for auditing. It's here for download:

[code no longer available]

You will need Visual Studio 2005, SQL Server 2005, .NET 2.0 and NUnit 2.2.8.

The ZIP package contains everything you will need (except the software mentioned above), even the SQL Scripts. It's a no brainer! Just unzip it, compile it and run the NUnit tests (use the "Server.nunit file"). Make sure that you configure your database settings. They are on the "Server.nunit.config" file.

The NUnit file has two tests. They are identical. The million dollar questions is:

Why does one test fail and the other succeed?

Thank for reading this.

Regards.

John

I'm not sure how to break this to you but...

You spelled "user_customer_id" wrong in your SQL (you have "user_costumer_id")

The logs were clear:

Server.UnitTest.DataAccess.CustomersDAOTest.FindAll : NHibernate.ADOException : could not initialize collection: [Server.DataAccess.Model.Customer.Users#8]
----> System.Data.SqlClient.SqlException : Invalid column name 'user_customer_id'.
Invalid column name 'user_customer_id'.

I kept looking for problems on the code. Never on the Database.
I sure learned a few things today.
Thanks! You saved my day.
Case closed.

John

yeah, it happens all the time. You just needed another set of eyes