Nhibernate :Could not compile the mapping document .hbm.xml

Question

//xml file

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
                   namespace="ContactDomain"
                   assembly="ContactDomain">

  <class name="Contact" table="tbl_contact">

    <id name="ContactId" column="contact_id" type="int">
      <generator class="identity"></generator>
    </id>

    <property name="FirstName"  column="first_name" type="String"/>
    <property name="LastName"   column="last_name"  type="String"/>
    <property name="Email"      column="email"      type="String"/>
    <property name="Telephone"  column="telephone"  type="String"/>
  </class>
</hibernate-mapping>

//web.config

<configSections>

        <section
          name="nhibernate"
          type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
    />
    </configSections>

    <nhibernate>
        <add
          key="hibernate.connection.provider"
          value="NHibernate.Connection.DriverConnectionProvider"
    />
        <add
          key="hibernate.dialect"
          value="NHibernate.Dialect.MsSql2000Dialect"
    />
        <add
          key="hibernate.connection.driver_class"
          value="NHibernate.Driver.SqlClientDriver"
    />
        <add
          key="hibernate.connection.connection_string"
          value="Data Source=myServer;Initial Catalog=myDatabase;Persist Security Info=True;User ID=myDbUsername;"
    />
    </nhibernate>

//Save button

    NHibernate.Cfg.Configuration config = new NHibernate.Cfg.Configuration();

    config.AddAssembly("ContactDomain");

    NHibernate.ISessionFactory factory = config.BuildSessionFactory();

    NHibernate.ISession session = factory.OpenSession();

    NHibernate.ITransaction transaction = session.BeginTransaction();


    // create contact
    Contact contact = new Contact();
    contact.FirstName = txtFirstName.Text;
    contact.LastName = txtLastName.Text;
    contact.Email = txtEmail.Text;
    contact.Telephone = txtTelephone.Text;

    // Tell NHibernate that this object should be saved
    session.Save(contact);

    // commit all of the changes to the DB and close the ISession
    transaction.Commit();
    session.Close();

Are you tried to look at InnerException for more information about the error? — danyolgiax, Jun 06 '11 at 07:58
InnerException :Could not find the dialect in the configuration — user754461, Jun 06 '11 at 08:00
Can you post the WHOLE of the HBM file and not just the inner bits. Also we probably dont need web.config — Rippo, Jun 06 '11 at 08:58
No I'm using sql server 2008 , sorry I'm new with Nhibernate, the whole hbm file is posted but I don't know how to make all the file appear! — user754461, Jun 06 '11 at 09:19

score 0 · Accepted Answer · answered Jun 06 '11 at 09:51

By the looks of it your web.config is not configured properly, so please look at my example below.

    <configSections>
        <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate"/>
    </configSections>

    <connectionStrings>
        <add name="db" connectionString="Server=...;Database=...;Trusted_Connection=SSPI;"/>
    </connectionStrings>

<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>

    <property name="proxyfactory.factory_class">
        NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle
    </property>

    <property name="dialect">
        NHibernate.Dialect.MsSql2008Dialect, NHibernate
    </property>

    <property name="connection.connection_string_name">db</property>

</session-factory>
</hibernate-configuration>

I have got a new error on this line NHibernate.ISessionFactory factory = config.BuildSessionFactory(); unable to load proxy factory — user754461, Jun 06 '11 at 10:11
You need to reference the dll's which can be found in the download zip \required_For_LazyLoading\Castle\*.dll — Rippo, Jun 06 '11 at 13:27

Nhibernate :Could not compile the mapping document .hbm.xml

1 Answers1