vendredi 8 mai 2015

Associative table - QuerySyntaxException: Userapp is not mapped - hibernate

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