I have a @ManyToOne Association that uses an @JoinTable with a name that has spaces. Normal @Table(name=...) and @Column(name=...) syntax allows this to work in a variety of ways ([Table Name],`Table Name`, and \"Table Name\"). None of these work and Hibernate throws a "Cannot find the expected secondary table" error. Attaching stacktrace.
If I create a view of the table with underscores, using wrapping characters are not required and the join works.
It should be noted that this works in 3.4.0.GA, the JBoss 5.1 default version. I've tried the versions listed and getting the same error.
4.2.18, SQLServer 2012