Hibernate version: 3.0.2

How do you call createQuery when a legacy table name contains a space. A SQL Server database table name is "dbo.Poll C". I am using the alias m. createQuery will not work when the table name has a space before the "C".

I tried the following but none work:

Query q = session.createQuery("from dbo.Message t inner join dbo.Poll C m on t.ID = m.MessageId");

Query q = session.createQuery("from dbo.Message t inner join 'dbo.Poll C' m on t.ID = m.MessageId");

Query q = session.createQuery("from dbo.Message t inner join dbo.'Poll C' m on t.ID = m.MessageId");

Query q = session.createQuery("from dbo.Message t inner join dbo.[Poll C] m on t.ID = m.MessageId");

Query q = session.createQuery("from dbo.Message t inner join dbo.\"Poll C\" m on t.ID = m.MessageId");

Query q = session.createQuery("from dbo.Message t inner join dbo.%Poll C% m on t.ID = m.MessageId");

Query q = session.createQuery("from dbo.Message t inner join dbo.Poll_C m on t.ID = m.MessageId");

Query q = session.createQuery("from dbo.Message t inner join dbo.Poll C m on t.ID = m.MessageId");

How do I escape the space in the table name?

Name and version of the database you are using: SQL Server 2005 Express Edition

Thank you.

use HQL and use the class name in the query

I had no idea what the above answer actually meant during my first few days using hibernate. So, to add, in order to escape the table name, use

@Table(name = "`comment`")

on the offending class, but then use the class's name ("Comment" in this case) in your queries-