NHibernate 1.2.0.GA and MySql 5.0 connection dialect error

rs103 · **Joined:** Thu Aug 30, 2007 1:36 pm **Posts:** 3

I am unable to connect to MySql. My environment is Visual 2005, MySql 5.0, NHibernate 1.2.0.GA

I have followed all the steps in quick start/other examples
and also the http://www.hibernate.org/362.849.html

I get this error

Code:

Line 23:          {
Line 24:             Configuration config = new Configuration();
Line 25:             config.AddAssembly("NHibernateASPSample.Domain");
Line 26:             _sessionFactory = config.BuildSessionFactory();
Line 27:             if (_sessionFactory == null)


Source File: c:\NCBISearch\NHibernateASPSample\App_Code\SessionHelper.cs    Line: 25

Stack Trace:

[HibernateException: The dialect was not set. Set the property hibernate.dialect.]
   NHibernate.Dialect.Dialect.GetDialect() +127
   NHibernate.Dialect.Dialect.GetDialect(IDictionary props) +82
   NHibernate.Cfg.Configuration.AddValidatedDocument(XmlDocument doc, String name) +26

My Config file is below

Code:

 <configSections>
    <section name="nhibernate" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate"/>
  </configSections>

  <nhibernate>
    <add key="hibernate.connection.provider"
      value="NHibernate.Connection.DriverConnectionProvider" />

    <add key="hibernate.dialect"
         value="NHibernate.Dialect.MySQL5Dialect" />
(also tried with MySqlDialect)
 
    <add key="hibernate.connection.driver_class"
         value="NHibernate.Driver.MySqlDataDriver" />

    <add key="hibernate.connection.connection_string" 
         value="Server..."/>
  </nhibernate>

Can someone help.

Thanks.

karlchu · **Posted:** Thu Aug 30, 2007 4:30 pm

The dialet class is NHibernate.Dialect.MySQLDialect. Note all-caps SQL and no "5".

rs103 · **Joined:** Thu Aug 30, 2007 1:36 pm **Posts:** 3

Thanks. I tried that. It does not work

The docs suggest to use the NHibernate.Dialect.MySQLDialect for MySQL 3 or 4
and for MySQL 5
NHibernate.Dialect.MySQL5Dialect

Any ideas.

Thanks.

karlchu · **Posted:** Thu Aug 30, 2007 5:06 pm

Ah... upon closer look, you are mixing the old style of configuration (using the <nhibernate> section) and the new style (using the hibernate.cfg.xml file). Change your config section to this:

Code:

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

The new style is implemented in the current trunk, it is not part of 1.2GA.

rs103 · **Joined:** Thu Aug 30, 2007 1:36 pm **Posts:** 3

Thanks it worked :)