0 Replies Latest reply on Aug 29, 2005 4:23 PM by Cesar Ruiz

    WARN  [JDBCExceptionReporter] SQL Warning: 17110, SQLState:

    Cesar Ruiz Newbie

      Hibernate version:2.1.6

      Code between sessionFactory.openSession() and session.close():
      objlSession.createQuery("SELECT compte, sum(mouvement.montant) FROM Compte compte left join compte.mouvements mouvement WHERE compte.exercice.id = ? GROUP BY compte.id, compte.numero, compte.gele, compte.intitule, compte.type, compte.param, compte.lettrable, compte.compteCentraliseur, compte.exercice ORDER BY compte.numero");

      Full stack trace of any exception that occurs:
      15:07:21,642 WARN [JDBCExceptionReporter] SQL Warning: 17110, SQLState: null
      15:07:21,643 WARN [JDBCExceptionReporter] Warning: execution completed with warning

      Name and version of the database you are using:Oracle 9iR2 ( AMD64)


      I have a problem using JDBC with Hibernate2 on JBoss 3.2.7, it seems some SQL Commands like"left join" generate SQL Warnings.

      Did someone have any idea ?