The problem is that even configuring on the hibernate.cfg.xml the tag:
<property name="hbm2ddl.keywords">auto-quote</property>
Or on the ExposeConfiguration method of Fluent NH, it seems doesn't work
for Oracle.
Oskar, do you have any suggestion?
Thank you.
On Tue, Jun 21, 2016 at 12:00 PM, Oskar Berggren <[email protected]>
wrote:
> The dialect specific quite character that NH will apply for you is found
> in the source code of each dialect.
>
> 2016-06-21 15:45 GMT+01:00 Felipe Oriani <[email protected]>:
>
>> Yes, I'm using Fluent NH to map, but to configure I have the
>> hibernate.cfg.xml and I load it and merge with fluent configuration. I do
>> it to keep the database configuration flexible to change. I know the
>> configuration is been added but with oracle here it is not working.
>>
>> I will try to change the convention name such as the post Paulo suggested.
>>
>> Oskar, is there any place I can find the quote character following the
>> database configured?
>>
>> Thank you
>>
>>
>>
>> On Tue, Jun 21, 2016 at 11:26 AM, Oskar Berggren <
>> [email protected]> wrote:
>>
>>> The NHibernate quote character is the backtick - NH will translate to
>>> suitable character for DB dialect.
>>>
>>> 2016-06-21 15:10 GMT+01:00 Felipe Oriani <[email protected]>:
>>>
>>>> Hello guys,
>>>>
>>>> I've developing a project with NHibernate and Oracle. We have a table
>>>> which has a column named Level and Level is a keyword used on oracle, which
>>>> we should escape with quotes to make a sql statement. I've looking how to
>>>> do it on NHibernate and I saw we have a configuration that we can add on
>>>> the hibernate.cfg.xml, like this tag:
>>>>
>>>> <property name="hbm2ddl.keywords">auto-quote</property>
>>>>
>>>> We saw it on the Fabio Maulo's blog
>>>> <http://fabiomaulo.blogspot.com.br/2009/06/auto-quote-tablecolumn-names.html>,
>>>> and we understand it should escape all the table/column names with quotes,
>>>> but it does not work fine to me. Instead "auto-quote" we also tried
>>>> "keywords" but we have gotten the same result.
>>>>
>>>> I know we can change our mapping and force to map the column name with
>>>> quotes, but it looks like a workaround for us. Is there any way to get the
>>>> column names escaped with quotes for the sql statements?
>>>>
>>>> Thank you.
>>>>
>>>> --
>>>> ______________________________________
>>>> Felipe B Oriani
>>>> [email protected]
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "nhusers" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>> To post to this group, send email to [email protected].
>>>> Visit this group at https://groups.google.com/group/nhusers.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "nhusers" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> To post to this group, send email to [email protected].
>>> Visit this group at https://groups.google.com/group/nhusers.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> ______________________________________
>> Felipe B Oriani
>> [email protected]
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "nhusers" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at https://groups.google.com/group/nhusers.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/nhusers.
> For more options, visit https://groups.google.com/d/optout.
>
--
______________________________________
Felipe B Oriani
[email protected]
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
