My Tools :
- Netbeans 8.x
- Hibernate plugin
- PHP my admin
I have 3 tables :
User ->>- many to many ->>- Userapp ->>- many to many ->>- Application
User have :
-
userId
-
userName
UserApp :
-
userId
-applicationId
Applicaiton :
-
applicationId
-
applicaitonName
HQL Query :
SELECT a.applicaitonName
FROM UserApp ua
LEFT JOIN Application a On ua.applicationId= a.applicationId
WHERE
ua.userId = ?
Error :
org.hibernate.hql.internal.ast.QuerySyntaxException: Userapp is not mapped [SELECT a.applicaitonName
FROM Userapp ua
LEFT JOIN Application a On ua.applicationId= a.applicationId
WHERE
ua.userId = 1]
at org.hibernate.hql.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.java:96)
at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:120)
How i proceed : - I created hibernate.cfg.xml - I created hibernate.reveng.xml - I created Hibernate Mapping Files and Pojors from database
When i create Hibernate Mapping Files and Pojors from database, it created 2 news object : Application and User. But not Userapp ... I have to create it manually ?
Here the hibernate.reveng.xml :
<hibernate-reverse-engineering>
<schema-selection match-catalog="allin"/>
<table-filter match-name="user"/>
<table-filter match-name="application"/>
<table-filter match-name="userapp"/>
</hibernate-reverse-engineering>
Thanks for your help !!
Aucun commentaire:
Enregistrer un commentaire