Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

Hi All - it appears that somehow i wiped out mu msg before i submitted. so here's my msg again:
looking for some help as it appears that i am getting a silent Nhibernate error. I am new to this so please bear with me. I am trying to load the product table from adventureworks on sql server 2005 into a very basic product object in an ASP.NET 3.5 web application running MVC. I get no errors when i run and nothing back from the DB. I enabled logging and here's the only thing i got:
2009-01-30 09:49:58,869 - opened session
2009-01-30 09:50:02,447 - after autocommit
2009-01-30 09:50:02,447 - transaction completion
2009-01-30 09:50:02,447 - transaction completed on session with on_close connection release mode; be sure to close the session to release ADO.Net resources!

Here's my mapping file:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
assembly="PMO.Core" namespace="PMO.Core">
<class name="Product" table="Product" schema="Production" optimistic-lock="none">


<id name="ID" column="ProductID" unsaved-value="0">
<generator class="identity" />
</id>


<property name="Name" column="Name" />

<property name="Number" column="ProductNumber" />

<!--
<many-to-one name="Supplier" column="SupplierID"
class="Supplier" />
<many-to-one name="Category" column="CategoryID"
class="Category" />
-->

</class>
</hibernate-mapping>


and here's my config file:

<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.connection_string">Integrated Security=SSPI;Initial Catalog=AdventureWorks;Persist Security Info=False;Data Source=AJUBRAN</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>

<property name="connection.release_mode">on_close</property>
<property name="show_sql">true</property>
<mapping assembly="PMO.Core"/>
</session-factory>



</hibernate-configuration>

Please let me know what code you'd like me to post.

Thanks a lot.

Have you set the log level to DEBUG ? And enable SQL output with show_sql="true" in the config.

The code where you load the products would be helpful.

yes i have both of these things enabled.

Here's the call:

List<Product> products = new ProductDao().LoadAll();

now the ProductDao class inherets from a generic DAO (ProductDAO : GenericDAO<Product> ) class which does the following:

public List<T> LoadAll() {
ICriteria criteria = Session.CreateCriteria(typeof(T));
return criteria.List<T>() as List<T>;
}

I did some stepping through the code and it appears that the criteria object above is throwing a "Method may only be called on a Type for which Type.IsGenericParameter is true." all over the place.

sounds like a generics issue? Thanks.

I have no idea ... can you post the stacktrace ? Is there a inner exception ?

ok...I switched the call to a simple Session.get(typeof(Product), 1) to see what happens and now i am getting a No persister for: PMO.Core.Product exception. So Nhibernate cant find my mapping files?

you got to be kidding me!
Just found out what's been holding me up all along: My mapping file was not configured with a Build Action = Embedded Resource!!
All good now.