Hello,
I'm attempting to do a joined-suclass and I get the following error:
10:18:30,354 WARN [JDBCExceptionReporter] SQL Error: 923, SQLState: 42000
10:18:30,354 ERROR [JDBCExceptionReporter] ORA-00923: FROM keyword not found where expected
Here are snippets (whole hbm is too long) from my hbm:
<hibernate-mapping>
Code:
<class
name="test.Person"
table="PERSON">
<id
name="personId"
type="java.lang.Long"
column="PERSON_ID">
<generator class="sequence">
<param name="sequence">PERSON_ID_SEQ</param>
</generator>
</id>
<!-- long list of properties -->
<joined-subclass
name="test.User"
table="USERS">
<key column="PERSON_ID"/>
</joined-subclass>
</class>
</hibernate-mapping>
Here is the sql generated by hibernate:
select user0_.PERSON_ID as PERSON_ID, user0_.PASSWORD as PASSWORD24_, user0_.COMMENTS as COMMENTS24_, user0_.TRAINING_COMPLETION_DT as TRAINING4_24_, user0_.USERNAME as USERNAME24_, user0_.REMOTE ACCESS as REMOTE A6_24_, user0_.CONFIDENTIALITY_AGREEMENT as CONFIDEN7_24_, user0_.LOGGED_ON as LOGGED_ON24_, user0_.ACTIVE as ACTIVE24_, user0_.BUSINESS_HOURS_ONLY as BUSINES10_24_, user0__1_.PERSON_FIRST_NAME as PERSON_F2_23_, user0__1_.PERSON_LAST_NAME as PERSON_L3_23_, user0__1_.PERSON_MIDDLE_NAME as PERSON_M4_23_, user0__1_.PERSON_SALUTATION as PERSON_S5_23_, user0__1_.PHONE_NUM as PHONE_NUM23_, user0__1_.FAX_NUM as FAX_NUM23_, user0__1_.EMAIL_ADDRESS as EMAIL_AD8_23_, user0__1_.WEB_ADDRESS as WEB_ADDR9_23_, user0__1_.STREET_ADDRESS as STREET_10_23_, user0__1_.CITY as CITY23_, user0__1_.COUNTY as COUNTY23_, user0__1_.POSTAL_CODE as POSTAL_13_23_, user0__1_.STATE as STATE23_, user0__1_.PHONE_EXT as PHONE_EXT23_ from USERS user0_, PERSON user0__1_ where user0_.PERSON_ID=user0__1_.PERSON_ID and ((user0_.USERNAME=? ))
I'm at a loss, if anybody knows what I'm doing wrong, I'd greatly appreciate the help.
Mike R.