Hi All,

Im new to NHibernate. I am getting an bad sql error while executing the HQL. This is due to the select query generated from the HQL does not include double quotes for the table name.Basically my oracle database tables are created using double quotes.
Ex: Create Table "Customer"
So to retrieve the data we need to write the select query as follows.
Select * from "Customer";
But the generated HQL does not include double quotes to the table.
How can i achieve this HQL?Are there any properties that i need to set in mapping files?

Please help me in this.

Thanks,
Sai

Hi,

are the double quotes really part of your table names?
(Is the length of your "Customer" table-name really 10, or is it 8?)

If yes, then that is definitely not standard usage of Oracle,
and you definitely avoid table names including double quotes,
because this most probably don't creates only problems to hibernate...

Yes the double quotes are part of table name. Is there any way where i can handle these quotes in NHibernate.

Regards,
Sai

Get rid of the double quotes being part of the table name!
You will not only have problems with hibernate, also with other tools such as sql-tools you will run into troubles.
Use standard naming conventions for table-names.(Standard naming don't includes double quotes as suitable character.)