I don't understand this one. It appears that something is going wrong with the SQL Generation:
Stack Trace with SQL:
008:53:58,937 INFO [STDOUT] Hibernate: select _roles0_.role_id as role_id__, _roles0_.USER_PROFILE_ID as USER_PRO4___, _roles0_.role_id as role_id0_, _roles0_.role_type_id as role_typ2_0_, _roles0_.user_profile_id as user_pro3_0_ from ROLE _roles0_ where _roles0_.USER_PROFILE_ID=?
08:53:58,953 WARN [JDBCExceptionReporter] SQL Error: 911, SQLState: 42000
08:53:58,953 ERROR [JDBCExceptionReporter] ORA-00911: invalid character
Mapping File:
<set
name="_roles"
lazy="false"
inverse="true"
cascade="all-delete-orphan"
sort="unsorted"
>
<key
column="USER_PROFILE_ID"
>
</key>
<one-to-many
class="com.dood.userprofile.Role"
/>
</set>
Rest of Stack Trace:
08:53:58,953 ERROR [JDBCExceptionReporter] could not initialize collection: [com.dood.userprofile.UserProfile._roles#61]
java.sql.SQLException: ORA-00911: invalid character
This example follows what Hibernate in Action states should be done and the database schema was generated from my hibernate mapping files. Any ideas?
|