MySQL & NHibernate. How fix the error: Column 'ReservedWord' does not belong to table ReservedWords?

Question

"I am getting a weird error when using NHibernate. And I don't know what is causing this error. I am new to the whole Visual Studio and NHibernate, but not to Hibernate. I used Hibernate in the past in Java projects.

Any help would be appreciated in pointing me where my error is.

I am using Visual Studio 2008 SP1 with Mysql 5.1.

Below is the code I am using. "

The full code and examples are posted here: https://forum.hibernate.org/viewtopic.php?f=25&t=997701

score 17 · Answer 1 · answered Jul 30 '09 at 03:12

FYI for any NHibernate/Fluent NHibernate newbies like myself, FCastellanos' solution worked for me as well (I got the error on Windows as well), and the Fluent NHibernate way to add that configuration is:

Fluently.Configure()
    ...
    .ExposeConfiguration(c => c.Properties.Add("hbm2ddl.keywords", "none"))
    ...
    .BuildSessionFactory()

score 10 · Answer 2 · edited Jan 28 '11 at 16:46

10

I got the same error but I'm using MySQL+NHibernate (2.1.0GA) + Mono (2.4) under Ubuntu and this link helped me, hope it works for you.

The key is to use this in session-factory

<property name="hbm2ddl.keywords">none</property>

https://forum.hibernate.org/viewtopic.php?f=25&t=997701

that was it :)

edited Jan 28 '11 at 16:46

Jeremy McGee

24,842
10
63
95

answered Jul 23 '09 at 05:27

fcastellanos

263
2
13

The poster on that forum states: "However this fix might cause unexpected problems.". I would still like to know what is causing this! – UpTheCreek Apr 27 '10 at 17:35

score 5 · Answer 3 · answered Oct 26 '09 at 15:31

This resolves the same error when using ActiveRecord for NHibernate. The relevant bit is key="hbm2ddl.keywords" value="none" and this goes in your web.config.

<activerecord isWeb="true">
    <config>
        <add key="connection.driver_class" value="NHibernate.Driver.MySqlDataDriver"/>
        <add key="dialect" value="NHibernate.Dialect.MySQLDialect"/>
        <add key="connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
        <add key="connection.connection_string_name" value="BrochureDb"/>
        <add key="proxyfactory.factory_class" value="NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle"/>
        <add key="hbm2ddl.keywords" value="none" />
    </config>
</activerecord>

score 3 · Accepted Answer · answered Jun 30 '09 at 12:37

My first guess is that NHibernate identifies a column and/or table name as a reserved word. Your class named "hibernate" could be a likely culprit but without more information about your error it's a bit hard to track down. Some suggestions:

try renaming the table and columns both in the database and config and give it a test
Download log4net (http://logging.apache.org/log4net/download.html) and check out https://www.hibernate.org/364.html to configure it for nhibernate. Set it to debug and dig into the log file and see the full information on the stacktrace/error you get.

score 2 · Answer 5 · edited Sep 30 '09 at 05:12

2

If doing it programmatically, you should do it as such:

cfg.SetProperty(NHibernate.Cfg.Environment.Hbm2ddlKeyWords, "none");

edited Sep 30 '09 at 05:12

sth

222,467
53
283
367

answered Sep 29 '09 at 08:58

Thanks for the solution, this solved my problem for Sybase SQL anywhere as well – Hainan Zhao Apr 24 '19 at 05:28

score 0 · Answer 6 · answered Aug 19 '09 at 21:34

I just hit this issue as well. I ended up doing this:

http://orbitalcoder.wordpress.com/2009/08/18/proposed-solution-for-the-nhibernate-exception-column-reserved-word-does-not-belong-to-table-reservedwords/

which is a code change to NHibernate, but worked for me.

MySQL & NHibernate. How fix the error: Column 'ReservedWord' does not belong to table ReservedWords?

6 Answers6

Linked