Hibernate: Path expected for Join! exception for inner join

[vikas sharmaa]

There is one-to-one mapping between Game and Team tables.

I am getting "Path expected for Join!" exception on executing below inner join HQL query:

	session.createQuery("from Team t join Game gm");

Please find below the mapping files:

Team.hbm.xml

<hibernate-mapping>

	<class name="com.demo.model.Team" table="C_TEAM">

		<id name="teamId" type="long" column="TEAM_ID">
			<generator class="native" />
		</id>

		<property name="name" column="NAME" />

		<one-to-one name="game"
					class="com.demo.model.Game"
					property-ref="team" />

	</class>

</hibernate-mapping>

Game.hbm.xml

<hibernate-mapping>

	<class name="com.demo.model.Game" table="C_GAME">

		<id name="gameId" type="long" column="GAME_ID">
			<generator class="native" />
		</id>

		<property name="name" column="NAME" />

		<many-to-one name="team" class="com.demo.model.Team"
			column="TEAM_ID" cascade="save-update" unique="true" />

	</class>

</hibernate-mapping>

Team.java

public class Team {

	private Long teamId;
	private String name;

	private Game game;

// getters - setters

Game.java

public class Game {

	private Long gameId;
	private String name;

	private Team team;

// getters - setters

[vikas sharmaa]

ok i got it. the correct query is

session.createQuery("from Team t join t.game gm");