I am getting an inner exception of {"Line 1: Incorrect syntax near 'content0_'." }on the following HQL query:




However, this one works fine:



So, it fails when the ContentTypeId property shows up.

The two classes are mapped on a one-to-one basis with the PageMetadata object using the Content object's primary key as its own. The database is mapped so that page_metadata has its primary key set as a foreign key to content_id, which is the primary key of the "content" database table.

Without dragging people into the guts of these classes too much, has anyone seen this sort of "content0_" syntax error before? It seems like a strange format, I figured maybe somebody would have a quick fix for this.

Just as firing up a cigarette in a restaurant guarantees that your food will arrive, posting in a forum instantly makes one see one's error.

The query is missing an "and".

Sorry if you read this and I wasted your time :oops:

And remember to use parameters instead of manual HQL construction, it will make your queries more clear and eliminate the risk of SQL injection ;-)