Friends,
When i do this:
select m.name, dm.name
from com.MasterTable as m join com.DetailAndMaster as dm
i get this:
outer or full join must be followed by path expression
Anybody could help me? Does this work or not?
My config files are in the end of this e-mail.
att, Paulo Marcio
Config files:
hibernate.properties
hibernate.cglib.use_reflection_optimizer=false
hibernate.cgf.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration
DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd";>
<hibernate-configuration>
<session-factory>
<property
name="connection.driver_class">org.firebirdsql.jdbc.FBDriver</property>
<property
name="connection.url">jdbc:firebirdsql://localhost/c:/StrutsHibernateExample/db/HIBERNATE.GDB</property>
<property name="connection.username">sysdba</property>
<property name="connection.password">masterkey</property>
<property name="connection.pool_size">5</property>
<property name="dbcp.maxActive">100</property>
<property name="dbcp.whenExhaustedAction">1</property>
<property name="dbcp.maxWait">120000</property>
<property name="dbcp.maxIdle">10</property>
<property name="dbcp.ps.maxActive">100</property>
<property name="dbcp.ps.whenExhaustedAction">1</property>
<property name="dbcp.ps.maxWait">120000</property>
<property name="dbcp.ps.maxIdle">10</property>
<property
name="dialect">net.sf.hibernate.dialect.FirebirdDialect</property>
<property name="show_sql">true</property>
<property
name="cglib.use_reflection_optimizer">false</property>
<!-- Mapping files -->
<mapping resource="com/MasterTable.hbm.xml"/>
<mapping resource="com/DetailAndMasterTable.hbm.xml"/>
<mapping resource="com/DetailTable.hbm.xml"/>
</session-factory>
</hibernate-configuration>
MasterTable.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD
2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd";>
<hibernate-mapping>
<class name="com.MasterTable" table="MASTER">
<id name="id" column="ID" type="java.lang.Long">
<generator class="native"/>
</id>
<property name="name" column="NAME" type="java.lang.String"
length="5" not-null="true"/>
<set name="detail" inverse="true" lazy="true">
<key column="ID"/>
<one-to-many class="com.MasterAndDetail"/>
</set>
</class>
</hibernate-mapping>
DetailAndMasterTable.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD
2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd";>
<hibernate-mapping>
<class name="DetailAndMasterTable" table="DETAIL_MASTER">
<id name="id" column="ID" type="java.lang.Long">
<generator class="native"/>
</id>
<property name="name" column="NAME" type="java.lang.String"
length="30" not-null="true"/>
<many-to-one name="master" class="com.MasterTable">
<column name="id" />
</many-to-one>
<set name="detail" lazy="true" inverse="true" cascade="delete">
<key column="ID"/>
<one-to-many class="com.DetailTable"/>
</set>
</class>
</hibernate-mapping>
DetailTable2.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD
2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd";>
<hibernate-mapping>
<class name="com.DetailTable" table="DETAIL">
<id name="id" column="ID" type="java.lang.Long">
<generator class="native"/>
</id>
<property name="name" column="NAME" type="java.lang.String"
length="5" not-null="true"/>
<many-to-one name="master" class="com.DetailAndMaster">
<column name="id" />
</many-to-one>
</class>
</hibernate-mapping>
